How to duplicate MySQL database

346360 pts.
Tags:
Database
MySQL
MySQL Database
Would it be possible for me to duplicate my entire MySQL database on a Linux server? I already know I can export / import but the database has over 25 MB so it's not the best solution. Can I use "MySQLdump" or just directly duplicate the database files?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

In
that case, you can bypass phpMyAdmin completely using the command line shell,
which is much more reliable to create duplicate data in mysql server.

For
example, if you have a database called customers that you want to copy to
new_customers, then first you have to create a “database dump” file
using:

mysqldump
-u customers -p customers > customers.dump

Then
you have log in to the control panel and create the new MySQL database and run
this command to import the dump file, specifying the login details for the new
database:

mysql
-u new_customers -p new_customers < customers.dump

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following