Geek Answers Handbook

How to export MYSQL database tables from one server to another

How to export and import MYSQL databases, selected tables (not all) from one computer to another?

amuses

+3
source share
2 answers

mysqldump [options] db_name [tables] and then load them using mysql -u root -p <backup.sql

Or rsync / var / lib / mysql / ...

+4
source

I use the MySQL Administrator , it allows you to backup / export interactively to a file (and restore from a file). From the command line what @Aif said. If you are concerned about the atomicity / consistent state of the database, first run LOCK TABLES and then UNLOCK TABLES.

0

More articles:


All Articles