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 tCote - September 23, 2016

I am going to assume I need to create the database once again in Cpanel. As I stated it was completely removed. Also the Information Schema is present and  shows in MyPhpAdmin. 

By tCote - September 23, 2016

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