Not Just Paranoid

Another site by Pete Maynard

Restoring MySQL from data files

MySQL stores all its data in the following location

/var/lib/mysql/<database>

Simply make a copy of these files and you have a backup, when restoring make sure its owned by mysql.

18 Feb 2012 | Tags ( backup MySQL Restore )

Website Last Updated on 15 Sep 2023 (CC BY-SA 4.0)

This site uses JQuery and nanogallery2 hosted by jsdelivr.net
for the Flickr photo feed and GoatCounter for user insights.