Moving Mambo

keliix06 · #1 04-08-2005, 10:11 AM

There are a lot of posts around Mambo land asking how to move your Mambo site. Today I will explain how to move your Mambo site from one host to another, however this same method can be used to move Mambo from a local install to a server or from one folder on your server to another.

Step 1: Download all files from your server to your computer. Be sure to keep the folder structure.

Step 2: Create a database backup using a tool like phpMyAdmin and save it to your computer.

Step 3: Upload all files from your computer to you new server. Remember to set the appropriate permissions.

Step 4: Create a database on your new server and upload your backup using phpMyAdmin.

Step 5: Change all relevant lines in configuration.php. These lines should include: $mosConfig_host, $mosConfig_user, $mosConfig_password, $mosConfig_db, $mosConfig_absolute_path, $mosConfig_live_site and $mosConfig_cache_path.

Your new Mambo site should now be up and running. Enjoy!

ufo · #2 04-14-2005, 06:48 AM

Something that you sould do if you have a big database:

-Try to backup your database in small steps (more smaller files) because if you have a big database it could give you errors (or timeouts) on uploading it to the new server.
-For the people using TFS 4 Mambo please note that the table "IP to country" is really BIG so you must back it up separatly and when injecting into MySQL try to make smaller parts about 5-6000 queries.

elysianhosting · #3 07-10-2005, 04:38 AM

I'd also like to add my experiences. I moved a site from a sub directory to the root directory using a simple mv command. In my case the .htaccess wasn't moved, and so I got strange problems with the menu links not working. Just be wary of that

gtg · #4 07-22-2005, 07:38 PM

the same has just happened to me . uploaded .htaccess file and everything is working fine.
thanks

zalun · #5 10-22-2005, 10:01 AM

I have a problem with moving mambo from mysql 4.0.20 to 5.0

mysqldump to file wich I send to PHPMyAdmin.

This query

Code:

--
-- Table structure for table `mos_components`
--
CREATE TABLE mos_components(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
name varchar( 50 ) NOT NULL default '',
link varchar( 255 ) NOT NULL default '',
menuid int( 11 ) unsigned NOT NULL default '0',
parent int( 11 ) unsigned NOT NULL default '0',
admin_menu_link varchar( 255 ) NOT NULL default '',
admin_menu_alt varchar( 255 ) NOT NULL default '',
OPTION varchar( 50 ) NOT NULL default '',
ordering int( 11 ) NOT NULL default '0',
admin_menu_img varchar( 255 ) NOT NULL default '',
iscore tinyint( 4 ) NOT NULL default '0',
params text NOT NULL ,
PRIMARY KEY ( id )
) TYPE = MYISAM

returns an error:

Code:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'option varchar(50) NOT NULL default '',
  ordering int(11) NOT N

It looks like on new database I cannot use field with the name "option" ...

please help

A2BHOSTING · #6 11-06-2005, 03:20 PM

good tutorial!

keliix06 · #7 11-06-2005, 07:19 PM

Quote:

Originally Posted by zalun

I have a problem with moving mambo from mysql 4.0.20 to 5.0

mysqldump to file wich I send to PHPMyAdmin.

This query

Code:

--
-- Table structure for table `mos_components`
--
CREATE TABLE mos_components(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
name varchar( 50 ) NOT NULL default '',
link varchar( 255 ) NOT NULL default '',
menuid int( 11 ) unsigned NOT NULL default '0',
parent int( 11 ) unsigned NOT NULL default '0',
admin_menu_link varchar( 255 ) NOT NULL default '',
admin_menu_alt varchar( 255 ) NOT NULL default '',
OPTION varchar( 50 ) NOT NULL default '',
ordering int( 11 ) NOT NULL default '0',
admin_menu_img varchar( 255 ) NOT NULL default '',
iscore tinyint( 4 ) NOT NULL default '0',
params text NOT NULL ,
PRIMARY KEY ( id )
) TYPE = MYISAM

returns an error:

Code:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'option varchar(50) NOT NULL default '',
  ordering int(11) NOT N

It looks like on new database I cannot use field with the name "option" ...

please help

OPTION is a reserved phrase in MySQL. if you change

Code:

OPTION

to

Code:

'OPTION'

It should work for you. You will probably run in to problems with mos_content.fulltext as well.

Mr.Dontknowmuch · #8 11-07-2005, 10:11 AM

Yes this is very helpful, but I'm a little confused on how to back up my database. I'm using xampp, but when I go to phpadmin, I dont see an option to back up the database. Does anyone know how to do this in PhpMyAdmin? thank you.

Mr.DKM

Mr.Dontknowmuch · #9 11-09-2005, 03:31 PM

I guess I'm stuck at step 4. I dont know how to upload the database in phpMyAdmin on yahoo. I also dont know how to back it up on my machine.

We're getting there though. Thanks again.

Mr.DontKnowMuch

Mr.Dontknowmuch · #10 11-11-2005, 10:33 AM

anyone? gosh i just need to get this installed on the yahoo server. I dont know how to do it and there's nothing in yahoo about mambo. I just need to get it installed. I go to my ftp and open up http://www.demarccreations.com/insta...n/install1.php

this finally takes me to installation of mambo.

thing is i'm not sure what to enter here. It keeps saying I have incorrect user name or password. thanks.

Mr.DKM