Jump to content

[Solved] Mysql Database Restore Request


DAKSH101

Recommended Posts

I was facing mysql error, so I thought about dropping tables and restoring the mysql database from the backup I took using softaculous.

But after dropping tables I am not able to restore the database. It seems the backup has less amount of data than it originally should be.

Could you please restore my database?

username:mng4

server:stevie

database:sviceDbX

Link to comment
Share on other sites

If the backup was created after the recent crash, the InnoDB tables in your database will be missing from your backup. A lot of them were lost in the recent crash (again).

 

Not sure what the odds of us having a backup are, so I'll escalate this for you. Note though that we don't make backups for user data regularly, we may not have anything to restore. Routine backups of databases should be made through cPanel or PhpMyAdmin, and it is the user's responsibility to make them.

 

Once you get this fixed, I would recommend converting the database tables to MyISAM so this won't happen again.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...