Clone a database (MySQL)

Usually:

mysqldump db_name_old | mysql db_name_new

When --routines & --force are needed:

mysqldump --routines --force bron_db_naam | mysql doel_db_naam

Details:

• You can use the export of one database directly as an import for the other database: The name of the source database is not hard-coded in the export file
• The target database must already exist
• This example assumes you don't need to provide login credentials - Thanks to .my.cnf
• The export file is not placed in the file system in the meantime. Useful!
• The source database will of course continue to exist. If you want to rename a database, you must delete the source database afterwards
• This doesn't work for large databases - I suspect.

Note: I have the impression that the switch --comments is missing. This way you will lose comments in sprocs. You can also fix this via .my.cnf.

See also

• .my.cnf
• Database-export (MySQL)
• Tabel kopiëren naar een andere database (MySQL)