ShadowIllusion Posted September 9, 2011 Report Share Posted September 9, 2011 If I stopped the MySQL Service, then copy the entire /data folder in /usr/local/mysql, is it the right thing to do? This action is assuming that I have the same exact version of mysql in your uniserver Quote Link to comment Share on other sites More sharing options...
BobS Posted September 12, 2011 Report Share Posted September 12, 2011 Not really, although you may luck out. There are many apps that put path-related info in the DB, such as WordPress. While these can often be repaired with phpMyAdmin edits, it's still not the "right" way. There are two much more portable methods. Since version 5.3-Nano there is a Database Backup function built in to The Uniform Server. Look at the Wiki page http://wiki.uniformserver.com/index.php/5....Database_Backup for details. It create a text-based SQL file. You can also use phpMyAdmin to do a DB Extract to create the same type of SQL file. Both methods have the option to compress this text file in order to save space (as I recall). Since the output is a text file, you have the option to edit the text fields of the problem records as required. This can also allow you to change from InnoDB structure to MyISAM, if need be. Regards,BobS Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.