Moving a database from local to c5host
Permalink
I like to develop my site locally and then push all the files up to the host server.
Now that I'm hosting more often with c5 I realize it's a bad practice to drop the entire database and import an entirely new one (lose the Server Support tab in the dashboard, for instance).
Can anyone suggest the proper way to move a local database to the c5 server so that vital information on the c5 side is not lost?
Thanks!
Now that I'm hosting more often with c5 I realize it's a bad practice to drop the entire database and import an entirely new one (lose the Server Support tab in the dashboard, for instance).
Can anyone suggest the proper way to move a local database to the c5 server so that vital information on the c5 side is not lost?
Thanks!
I appreciate your response, Oli.
(not sure who marked it as an answer, though... I didn't, and unless I miss the message it doesn't really answer my question)
I contacted c5 about this and they recommend pulling down the database from the c5host site and developing on that. Then you can export/import it back up with no harm done.
If you *must* overwrite the c5host database with your local non-c5host version then you can reinstall the server support tab by going to /dashboard/install/install_package/server_support
Then you can uncomment the define('MSM_ACCOUNT_TOKEN',.... line in your config/site.php file to ensure that your paid account is recognized.
You'll also need to deal with the SALT token (and database connection variables) in config/site.php. The c5 recommendation is to use a switch or if/else conditional to change between your local and c5host settings. Such as:
Hope all that helps somebody!
(not sure who marked it as an answer, though... I didn't, and unless I miss the message it doesn't really answer my question)
I contacted c5 about this and they recommend pulling down the database from the c5host site and developing on that. Then you can export/import it back up with no harm done.
If you *must* overwrite the c5host database with your local non-c5host version then you can reinstall the server support tab by going to /dashboard/install/install_package/server_support
Then you can uncomment the define('MSM_ACCOUNT_TOKEN',.... line in your config/site.php file to ensure that your paid account is recognized.
You'll also need to deal with the SALT token (and database connection variables) in config/site.php. The c5 recommendation is to use a switch or if/else conditional to change between your local and c5host settings. Such as:
$hostname = $_SERVER['HTTP_HOST']; switch(trim(strtolower($hostname))) { ....
Hope all that helps somebody!
Oli