Joomla! Discussion Forums

You should backup all of your data, especially your mySQL database, before attempting this. Instructions for backing up your database with phpMyAdmin are in the next post. Nothing should go wrong, but if it does - you can restore the database to its current state easily.

Ok, here's how you use phpMyAdmin and Mambo's included SQL file to upgrade:

  1. open phpMyAdmin
  2. choose the database where Mambo resides in the top left corner's pull-down menu
  3. choose the SQL tab in the top of the right frame
  4. in the "Location of the textfile" area, choose Browse...
  5. in the popup window, browse to the .sql file that is included with the Mambo upgrade
  6. hit the Go button!

I guess you might want instructions on this, too. You can do this with domain management packages like Cpanel but here are the instructions for backing up your Mambo database to your local computer with phpMyAdmin:

  1. open phpMyAdmin
  2. choose the database where Mambo resides in the top left corner's pull-down menu
  3. choose the Export tab in the top of the right frame
  4. in the "Export" area, choose the "Select All" text link
  5. check the checkbox next to the "Save as File" area
  6. hit the Go button!
  7. Save the resulting .sql file to your computer

I did a research a while back and it looks like you have to check some additional boxes (in phpMyAdmin) when you do this backup. Otherwise things might go wrong when importing.

Read here - http://www.mambers.com/archive/index.php/t-11896.html

To have a complete thread here, I have quoted the original concerns in the post hazman refered to:

[QUOTE=gateone]Backups of databases with phpMyAdmin can be done by going to the "Export" tab, select all DB tables (by clicking on "Select All" in the Export pane, choose SQL as format, in the SQL options choose "Structure" and maybe also "Add Drop Table" and "Add If Not Exist" to the already selected "Add Auto_Increment value and "Encolse table and flied names with backqutes. This will make sure you can easily write back a database if necessary without first deleting the existing one. In the Data-section, click "Complete inserts" and "Extended inserts" to guarantee that not only the DB structure but also its content is downloaded. Also choose "Use hexadecimal for binary fields". Usually, Mambo does not really use binary fields so much as far as I know (as images e.g. are not stored in the DB directly but in the server's file system with only the path to the image in the DB. To be 100% certain however, leave it clicked on. This option will transfor binary data into ASCII and thus prevent any data losses for binary files like images. Next click in "Safe as file" to make phpMyAdmin safe the file on your computer instead of displaying it in the web browser. If you like, you can also compress the file before downloading - which is good on a slow connection with large DBs.

To put a downloaded DB back on the server and replace a (maybe corrupted or faultly deleted DB, just hit the SQL button, choose "Import files", select the DB backup file on your machine and upload it! If you have downloaded your backup copy with "Add Drop Tabel" and "Add If Not Exist", the script will automatically delete existing older tables and overwrite them with the backup version. If you missed this part, you might first need to delete the table(s) before trying to play back in the backup file, as phpMyAdmin will otherwise give you a warning that the table already existed and could not be overwritten.

If you only want to play back a certain table, you can open the downloaded backup file in a text editor (don't use Word for this!!! - Notepad.exe on Windows, or BBEdit or Simple Text on Mac, Kate on KDE Linux, VI on Unix usually is a good choice. Have a look: you will very quickly understand the semantics of the SQL file and be able to just grab a certain part of the file and tranfer it by copy paste into the SQL command entry form of phpMyAdmin.[/QUOTE]

Hi have tried all this with some non *ambo data (external information). Goes well making the backup but I run into trouble when Trying to restore these data into another database where I need them to be to do some component developement. Can't restore. The PHPAdmin just stops/never restores them. Not onlly with my host also in MSAS.
I don't knowwhat is wrong? Databasepermissions or something?

Anyone with an answer or solution to that?

Would be a great help....

Norgaard

drop same table.. and dont forget backup first.. then u edit lah what u need to add into the table.. just choose what is never u add before

sorry my bad english.. indonesian   here

Well,found the problem. Maybe the information could be of help to others. My database file was more than 6000 lines with a lot of item information as well. After reducing it and split it into more files with a maximum of 1000 lines in them it worked like a dream.
I believe this is a phpAdmin matter. 

Best regards from Norgaard

I have encountered the same problem with large data sets using phpMyAdmin.

I use Eskuel a lot now. Does not seem to have the same limits on size.

Hmm i just had to put in my 2 cts there http://www.mambers.com/editpost.php?do= ... t&p=151215

[QUOTE=gateone]click "Complete inserts" and "Extended inserts" to guarantee that not only the DB structure but also its content is downloaded. [/QUOTE]

I was using community builder with a lot of data.

When using extended inserts i could not import my database. I had php memory exceeded and php execution time exceeded.
Since i have root access i temp set the limits to 512MB memory (have 1g) and 3600 seconds timeout.. (for a 2.8ghz machine).
I tried importing on the command line: mysql < db.sql -u username -p password but that failed on a error on my CB table.

So this all didn't work. In desperation i called in outside support, costing me many euros.
What this mysql guru did was painstakingly manually convert my extended export to a more 'normal' export.

What i learned is that extended exports does a lot of data in big chunks and it repeats queries a lot to fill in the data, costing that many times the memory..

Anyway i learned to not use extended inserts..

My suggestion: to be safe.. make two, one with extended and one without

mmmm.. if you have root access... why not to backup Mysql data with tar.gz?? (or even cp -a)...

depending on your setup... it could be something like /var/lib/mysql/dbname , then a simple

would do the trick!

(actually... I use something very similar to do backups of all  DBs in my server, and restoring any of them takes no pain

of course, you need to have access to the server with enough permissions! (root will suffice  )

cheers!
Marcos

Cheers!
Marcos

Quick Question,

I just created a new mambo site in 4.5.2, I understand how to either convert from 4.5.2 to joomla 1.0.3.
My question/problem is the following:

Problem I am having in mambo:
The admin section has been acting weird in both IE and firefox, I can't apply or save any changes.

Questions:
1)Since it's early in the site dev., should I just make everything from scratch again in Joomla?
2)Is it possible that the issues I'm having above have little to nothing to do with the sql DB, and if so, then can I just work off the same mambo DB or copy it? I am a novice regarding DB and files that can be copied in the Joomla/mambo space.

Silly question- I DL the tar and zip file of the joomla 1.0.3 files, now how do I execute the install of this? Ironically, I understand how to install it manually but not how to get the installer to run.

Side question
3)If I want to run the same site on mambo and joomla, can you share the DB, or how does one update or copy indo to that DB if it's not shared.
Thanks

Here's something else to remember:

If you use phpmyadmin (2.6.3-pl1 in my case) to rename your database it does not seem to transfer user privileges over to the renamed database - when I renamed my database from Mambo to Joomla, my mysql user ('mbuser') was still left with permissions to 'Mambo' and so when I tried to go to my 'new' site I was told it was unavailable. It was easy to fix this problem but it had me scratching my head for a short while.

NK

The not saving is normally a problem on the PC you are working on. Norton or Zonealarm firewalls are, for example, both known for this behaviour.

You can migrate from Mambo 4.5.2.3, this is no problem. I do recommend to always create backups of data and database before starting any big updates. Just copy all files from the Joomla install over the Mambo install and you should be fine. The core team recommends upgrades like this: http://help.joomla.org/.

When you upgrade, you don't need the installer, you can copy the files and directories in one go. I wouldn't recommend using the same database for two sites. Mambo/Jooma were not designed for this.

Hi,

How did you easily solve this permissions problem, as I think that's what I'm having. I think either something in an index or admin or config file is not directing either allowing me access or somehow there's a user acct. privilege that I've been refused. I am logging in as the super admin. and not seeing lots of features, but I think this is access issues.

I will backup my stuff and I will give the joomla overlay a try.

Does anyone know how to delete php sessions in the DB and anything related steps to debug the admin access issues I'm having?

One other silly question, is there anyway I can just copy a table or copy some of the work I've done from my mambo DB and then start fresh in joomla and with that DB?
Thanks

It is no problem to export one or more tables with PHPMysqladmin, and them inport them in a new install (without sample data). This is only valid for a new install though. If it is a merge between existing sites, you would have to take care with the 'id' fields of tables, since the value of these columns are automatically created when an item is added to a table.

So I'm fed up with Mambo.

I'm running Mambo 4.5.3, there's a handful of ways to install joomla but I just want to be clear.
I want to keep my existing DB, can I just overlay the joomla 1.0.3 Full package onto my mambo dir? or must I do the conversion or something else?

I just want to be clear, if you're keeping your DB, I couldn't find one straight answer on how to do this.

If I may there should be a FAQ of how to install Joomla if you have x,y,z OS, if you are doing it from scratch, if you are already running mambo version x, etc.

There is always the preferred way at http://help.joomla.org. This is a safe procedure. You can also just do the overlay of files. There is only a small sql update for the administrator backend (in the /installation/sql directory). It is advisable to do a testupgrade on a local machine, and make sure you have backups of both database and data before starting.

Is there anyway I can completely uninstall mambo and cleaning install joomla, then use the DB I had setup in mambo? I only know the way which involves some one creating a new DB each time you install. I've had an issue with mambo, so anything that is not a fresh install will not solve this problem.

Yes, is possible. Install Joomla, it uses another default prefix for table names than Mambo. Install all external components and modules you were using on Mambo as well (without changing configuration). Change the mosconfig_db and mosconfig_dbprefix in configuration.php, changing it to the Mambo database. Last, you should run the little update .sql script which can be found in your /installation/sql directory.

Hey,

It's late in the US for me, but should I just create a dummy DB and then redirect in the config.php? It sounds like I have to make a fake DB or unused DB.

I think I can handle what you wrote, I'll let you know. I assume the sql script takes all mos_DB lines and converts them to jos_db
Thanks
Jules

Basically yes, it will be a dummy database after installation. When you are happy, it can be deleted again. The .sql script is needed for changing the administrator template from the default Mambo one to the default Joomla one. Your tables will keep mos_ as a prefix. This is not a problem though, the prefix is optional. If you want to change mos_ to jos_ you would have to rename the tables. One of the ways this can be done is to create a complete export with PHPMysqladmin, change all references to mos_ to jos_ with a decent text editor, and import the tables again. Again, this isn't needed though.

Hi Toney,

Can mambo and joomla both use the same DB at the same time? I'm not really interested in doing that, but I was curious as to what the options are.
Thanks
I'll let you know how the fresh install goes, I'm doing it now.

Well, I guess I'm starting from scratch cause removing mambo and installing joomla didn't help anything.

To be clear- I unzipped joomla into htdocs\joomla, when bringing up my browser this did not give access to it, I have no clue why.
Also, when I removed the htdocs\mambo dir, and then replaced it with the brand new joomla 1.0.3 zip, it did not bring up the install screen, it just went right into the site.

So my question and I apologize if this is silly and stupid, but I don't understand what happened. Why can't I install joomla in htdocs/any_folder?
Why was I unable to install Joomla in htdocs\joomla? It just went to my site?

The mystery issue in admin is still there, when you log into the admin section, no icons for components, etc. load. So is it even worth my time to try and move some info from the DB to the new joomla I can't install?

Perhaps the most important question- what would you do? I don't quite understand how apache and sql work in this, but basically I'm willing to uninstall mambo and the DB I had. I'd start from scratch with joomla, trouble is, I'm not even sure I can do that right now, since I couldn't get the install screen to come up.

I suspect there is a way as Tonie said to me, that I can keep my DB and install joomla to use it. Though as I mentioned here, some bug appears to be in the original site I have. The bug appears to want to direct the admin. section to administrator/administrator, a sub folder that does not exist. Does anyone have a clue as to what .php file or DB line might be able to be changed? Because if the bug was fixed, the whole reinstall and new DB could be avoided.

Sorry this was long, I hope someone can answer these questions or tell me what are common sense options here.
Thanks

For the first option, that is most likely to be an Apache setting. If you look around in the Apache.conf httpd.conf, you will probably see a few entries with mambo in it. These will be something like permission settings for Apache.

I don't know anough (read: haven't seen it) about the administrator/administrator to form a good opinion on that. I have never seen a problem like that on the forum so far. If it indeed a bug in your site, it is a question where it is. If it is file-based, Joomla will fix it. If the bug is in the table in a database somewhere, it will still be there after upgrading.

You wrote.

Also, when I removed the htdocs\mambo dir, and then replaced it with the brand new joomla 1.0.3 zip, it did not bring up the install screen, it just went right into the site.

I have had this happen too when uploading Joomla stuff. Just delete the configuration file, and make a new configuration.php after you install. The install won't happen if there is a configuration.php in the root of the joomla web, and shared servers see it there.

Ok, here's how you use phpMyAdmin and Mambo's included SQL file to upgrade:

  1. open phpMyAdmin
  2. choose the database where Mambo resides in the top left corner's pull-down menu
  3. choose the SQL tab in the top of the right frame
  4. in the "Location of the textfile" area, choose Browse...
  5. in the popup window, browse to the .sql file that is included with the Mambo upgrade
  6. hit the Go button!
[/quote]

Unfortunatly, when I follow these instructions and run the sql included in the /instalation dir I get the following error message:

SQL query:
UPDATE `mos_templates_menu` SET `template` = 'joomla_admin' WHERE `template` = 'mambo_admin_blue' AND `client_id` = '1' LIMIT 1

MySQL said:
#1062 - Duplicate entry 'joomla_admin-0' for key 1

What should I do?  Should I remove something?  Right now I don't know what happened but my old mambo (in a different directory) has many of the icons duplicated.  I don't know what I did to get this to happen but is is quite hideous and annoying.  Can't log into the joomla admin page cause I can't run the script.  i have a feeling that after I get this worked out I will find that there is a problem with the database that causes a bunch of stuff in the admin section to get duplicated (although the site looks fine).

Would greatly appreciate some help:

Thanks;
eric.
http://www.shatteredpictures.com
http://www.dashdotslash.com

This is similar to bigjules problem, but the site is a year old. I made backups of the Mambo files and the mySQL database. I then simply overlaid the "Joomla_1.0.8-Stable-Full_Package Folder" files. When I came across a directory where the server wouldn't let me load, then I deleted the files as well as the directory. Then I began the upload again from there. Some of these were the com_content and com_typed content in administrator and components.

Now I'm looking at a problem where the I have lost the front page (totally blank) and any content pages..., but I do have the pages of components like newsfeeds and googlemaps showing just fine. Also the admin seems to be fine.

Is there a fix for this the way it is now or should I just try to remove the Joomla and go back to my old Mambo version and do a better job of upgrading this site to Joomla? Any ideas?

Thanks.

J. R.

hi there,
I've tried inserting the sql dbase using the instruction above and also change the templates, but when I see my page, it's not displaying my content.
FYI I'm converting from 4.5.2 directly to 1.0.8

Cheers,
Harry

Whoa! i thought i was the only one doing this, may I add though that you will need the following query to pull off this kind of back-up



More like snapshooting a DB, the most reliable method (but requires root access) and works across platforms. Im switching dbs between fedora and wink3  and this is the path i follow most of the time.