Auto Backup: restoring a file

5 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: May 26, 2011   (RSS)

Re: [gversion] Auto Backup: restoring a file

By Jason - May 26, 2011

Hi Greg,

We use TABLE_PREFIX to allow you to have more than 1 CMS Builder installation use the same database without data getting mixed up between the two. By default, the table prefix is cms_. You can find out what you table prefix is by looking at General Settings.

The backup script creates a file that is only meant to be restored through CMS Builder in General Settings. This is the recommended way of restoring your CMS Builder databases.

Is there a reason why you need to restore this directly through phpMyAdmin?

Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Auto Backup: restoring a file

By gversion - May 26, 2011

Hi Jason,

Thanks for the response.

I didn't realise I could restore via the cmsAdmin area...

I was using phpMyAdmin in order to test that the data was being backed up correctly. I wanted to perform a test restore so I created a brand new database (as I didn't want to overwrite anything) and then imported the backup file.

So are you saying that I can restore the backup file on my **LIVE WEBSITE** using the cmsAdmin control panel and the MySQL data won't get overwritten because the restored files will have a different table prefix?

Thanks for clarifying :)

Regards,
Greg

Re: [gversion] Auto Backup: restoring a file

By Jason - May 26, 2011

Hi Greg,

Your table prefix doesn't change. You only have 1 table prefix for each installation. CMS Builder takes care of handling the table prefix, so it isn't something you need to worry about.

However, if you do a restore through CMS Builder, you WILL overwrite all of the data currently stored for that installation. The restore script first empties out your tables, then re-populates them with the data in the backup file.

If you log into CMS Builder, go to General Settings, you'll see a section with a list of your current backup files. You can select 1 and hit restore to restore that data.

Hope this helps clarify.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Auto Backup: restoring a file

By gversion - May 26, 2011

Hi Jason,

Very useful to know. Thanks so much for explaining how that works.

Regards,
Greg