How to backup mysql databases
Posted on 2014-12-24
My MySQL is currently installed in C:\xampp\mysql.
I tried backing up just C:\xampp\mysql\data, which is where all the database data is contained. But when I copied that directory to a new installation of MySQL on another computer, it couldn't see the databases at all. I had to create the database names, and then restore a mysqldump file for everything to be match the state of the original installation.
I am looking for a one-step restoration process that would make any MySQL installation match the state of the original installation. Can anyone help me do this?