Jump to content
The Uniform Server Community

Proper Way To Backup MySQL


Recommended Posts

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.




Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...