instructions for exporting CMSB database
Hi. Could someone at Interactive Tools please provide me with the latest step-by-step instructions for exporting for download a CMS Builder database from within the PHPMyAdmin 'Export' interface?
The detailed instructions I have titled "Moving CMS Builder to New Server" seem to refer to an older version of PHPMyAdmin. The options appear to be worded slightly different in my current version of PHPMyAdmin (v4.6.6.) and I want to be sure I have everything right.
I haven't used phpMyAdmin in some time but I think the generic instructions for exporting a MySQL database should work:
Because it's an export, you should be able to safely try multiple times without risk.
Which version of CMSB are you using and what are you trying to accomplish?
I understand how to initiate an export from within phpMyAdmin, but want to be sure I have all custom export settings indicated as needed for CMSB.
I'm going off of older instructions provided on this forum post, that I've printed as a reference for so many years:
These older instructions stated that we should:
Add DROP / TABLE / VIEW / PROCEDURE / FUNCTION
... but that is not set by default if I simply choose to "Quick" export instead of "Custom" in phpMyAdmin, so I'm wondering what that new instruction set should look like now.
What I'm trying to accomplish is to export anything that could ever potentially restore a given CMSB install in terms of backup needs as well as download the database to install for local testing.
Are you using an older version of CMSB? Because the newer versions have a database backup feature built in under: Admin > Backup?
If you're just going from CMSB to CMSB, the easiest is to use the builtin backup and restore files. The files are straight MySQL with the exception that they have that placeholder #TABLE_PREFIX# to represent the MySQL table prefix (which may be different on different servers).
If you want to manually import those backup files, you can just replace #TABLE_PREFIX# with cms_ and it should work fine.
The other option is just to do a generic backup and restore through phpMySQLAdmin. So long as the MySQL table prefixes match the database prefix that was entered when CMSB was installed then they should appear.
Hope that helps! Let me know any other questions.
Dave, your tip on renaming the prefix was what I needed.
What was happening is that the prefix assigned to the exported database was not automatically assigned by phpMyAdmin when I imported it, so I did need to replace the #TABLE_PREFIX# with cmsb_ (This is a version 3.08, so I added 'b' to the prefix.)
Appreciate your help!