Duplicate Entire MySQL Database

database, linux, mysql

Solution

First create the duplicate database:

CREATE DATABASE duplicateddb;

Make sure the user and permissions are all in place and:

 mysqldump -u admin -p originaldb | mysql -u backup -pPassword duplicateddb;

Problem

Is it possible to duplicate an entire MySQL database on a Linux server ? I know I can use export and import but the original database is > 25MB so that's not ideal. Is it possible using Mysqldump or by directly duplicating the database files?

Original source

Related problems