Page 1 of 1
HowTo: Transfer content between sites via MySQL
Posted: Sun May 05, 2013 4:10 pm
by 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.
Re: HowTo: Transfer content between sites via MySQL
Posted: Fri May 10, 2013 11:14 am
by 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
Re: HowTo: Transfer content between sites via MySQL
Posted: Fri May 10, 2013 1:48 pm
by Wishbone
He's not talking about transferring the entire database.. Only the content.
Re: HowTo: Transfer content between sites via MySQL
Posted: Fri May 10, 2013 4:26 pm
by rooon
With some simple clicks you can select the tables you want, and it works on
any server, even those with limited permissions
