• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MySQL backup question

I

iroast

Golden Member
If the entire data dir is backuped daily, is restoring a database just a matter of dumping the database from tape back to the data dir?

 
I believe that works just fine if you are using the MyISAM storage engine, but if you are you using some of the other ones like InnoDB I believe there are some other steps you have to take care of.

I personally use a script that dumps my data to .sql files then zips them up and writes them to a tape. For a ~70gb databse this take around 2 hours.
 
Thank you. What are the steps I would have to take to restore a db if I am using the InnoDB storage engine?
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top