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?
Are you using an older version of CMSB? Because the newer versions have a database backup feature built in under: Admin > Backup?
Example in question is a 3.08 version. I'm using the database backup feature you indicated, which creates a downloadable file such as:
Importing that downloaded backup into phpMyAdmin on my local machine, I see the following which initially looks like a success message, but then shows an error:
Import has been successfully finished, 49 queries executed. (www.mydomain.com-v3.08-20170620-135718.sql.php)
Error SQL query:
DROP TABLE IF EXISTS `#TABLE_PREFIX#__accesslist`
MySQL said: Documentation
#1046 - No database selected
So with that I'm not sure if all is right.
I'll admit I'm new to working locally with database files, so I apologize if I've overlooked something obvious.
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!