There is no command in MySQL to copy a database. One method to copy a database is as follows;

1. Create a new empty database.
2. Export the source database using mysqldump.
3. Import the database to the new empty database created in step 1 above.

(See Linux CLI: MySQL Database Backup & Restore article for mysqldump usage).

Alternatively, phpMyAdmin can be used for small databases. More often-than-not, databases exceed size limits imposed by phpMyAdmin forcing CLI use or another method.

• Add New
• Search
• RSS

Comments (0)

Write comment

Your Contact Details:

Name:

Email: do not notifynotify Gravatar enabled

Website:

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.