Database deleted in error

5 posts by 2 authors in: Forums > CMS Builder
Last Post: September 23, 2016   (RSS)

By tCote - September 16, 2016

Have an issue where a cms database was deleted in error with database actually being gone. While trying to access any page I get "MySQL Error: Access denied for user '*****_scaledat'@'localhost' to database '******_cms'"

The information schema is present as Basic Auto template was used. I also have backups that were created from the admin section and all site files are still present. Only the database itself was deleted. How would I go about restoring this mess? 

By Damon - September 16, 2016

Hi,

Here are the steps to restore:

  1. Delete /cmsb/data/isInstalled.php file
    • This file indicates the software has been installed. Removing it will cause the software to re-display the installation screen.

  2. Run program installation - Go to /cmsb/admin.php with your web browser.
  • Enter MySQL details. These will probably appear by default but you will need to enter the MySQL password.
  • Click on the "Restore from Backup" tab and select the backup file you create (it should be at the top).
  • Click "Restore" and then confirm you can login to the CMS.

That's it. Let me know if you have any questions or issues.

Thanks!

Cheers,
Damon Edis - interactivetools.com

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

By Damon - September 23, 2016

Hi,

Yes, you will need to create a new database and use that. 

In the /data/schema/ folder of CMS Builder there are schema files for each Section Editor (table) that sets the field names. So when you reinstall CMS Builder using the new database, CMS Builder will automatically re-create all the fields and settings you had before. Then the last step is restoring the data.

Let me know if you have any other questions.

Cheers,
Damon Edis - interactivetools.com

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

By tCote - September 23, 2016

Backup and running. Thanks for the help. Very much appreciated.