HowTo: Transfer content between sites via MySQL

[drmikecrowe]

OK, I've gotten this down so this works very well for me. To transfer just the website content between a development site and a production site, I use the following to create a SQL update file:

Code: Select all

mysqldump --opt DATABASE_NAME cms_content cms_content_props cms_content_props_seq cms_content_seq cms_crossref cms_css cms_css_assoc cms_css_seq cms_htmlblobs cms_htmlblobs_seq cms_module_templates cms_templates cms_templates_seq cms_userplugins cms_userplugins_seq > update.sql

Now, by importing update.sql in my production site, I can instantly transfer just the core content between sites.

[rooon]

Hi,

Backup/Transfer Made Simple

A friendly way to backup or transfer the database:

1. Download MySqlDumper (www.mysqldumper.net)
2. Upload the files to a folder and browse to this folder.
3. Enter your language and database config (CMSMS: config.php).

In the email section of the configuration you can enter your emailadres. Now you'll get the backup as an attachment in an email.

Live is so simple

[Wishbone]

He's not talking about transferring the entire database.. Only the content.

[rooon]

With some simple clicks you can select the tables you want, and it works on any server, even those with limited permissions