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

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