Restore MySQL database by uploading db files?

Question

so I have a little problem. Okay a huge problem.

We had problems with our Ubuntu Precise server and our /usr directory was removed. This means that all commands related to mysql stopped working as well as phpmyadmin. However, in the /var/lib/mysql directory you can find all of our databases.

To simply state my question, is it possible to just copy that /var/lib/mysql directory over to a new install of our server and they will be there? I would normally just use phpmyadmin to backup or various other commands however mysql commands will not run.

Will this work? How much information will be missing?

Or of course is there a safe way to backup all databases without having phpmyadmin or mysql commands on the server.

Best regards and many thanks, JJ

Copy this directory is a [alternative to dumping][1]. [1]: stackoverflow.com/questions/2482491/… — Tiago P.
– Tiago P., Commented May 8, 2013 at 1:24

Jack · Accepted Answer · 2013-05-07 23:38:58Z

1

Yes, you can copy db files and all will work fine with the same MySQL version.

To get a consistent backup, stop the server or lock and flush the tables.

edited May 7, 2013 at 23:38

answered May 7, 2013 at 23:32

Jack

1,9221 gold badge19 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Restore MySQL database by uploading db files?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related