MySQL: Cloning a MySQL database on the same MySql instance

As the manual says in Copying Databases you can pipe the dump directly into the mysql client:

mysqldump db_name | mysql new_db_name

If you’re using MyISAM you could copy the files, but I wouldn’t recommend it. It’s a bit dodgy.

Integrated from various good other answers

Both mysqldump and mysql commands accept options for setting connection details (and much more), like:

mysqldump -u <user name> --password=<pwd> <original db> | mysql -u <user name> -p <new db>

Also, if the new database is not existing yet, you have to create it beforehand (e.g. with echo "create database new_db_name" | mysql -u <dbuser> -p).

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. How do I restore a dump file from mysqldump?
  4. How do I quickly rename a MySQL database (change schema name)?
  5. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  6. Create a new database with MySQL Workbench
  7. How to get size of mysql database?
  8. 1052: Column ‘id’ in field list is ambiguous
  9. 1052: Column ‘id’ in field list is ambiguous
  10. difference between primary key and unique key
  11. How to create a foreign key in phpmyadmin
  12. importing a CSV into phpmyadmin
  13. How to check if mysql database exists
  14. Is there a Profiler equivalent for MySql?
  15. How to do a batch insert in MySQL
  16. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  17. Data is not constantly loading from custom wordpress table
  18. What’s a good strategy for planning WordPress DB growth?
  19. How do I load a sql.gz file to my database? (importing)
  20. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  21. Export Pervasive to MySQL (C#)
  22. MySQL SELECT increment counter
  23. what does “/index.php?admin/admin_dashboard” in my url mean
  24. How to join two tables by multiple columns in SQL?
  25. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  26. mysqladmin: connect to server at ‘localhost’ failed
  27. mysql update multiple columns with same now()
  28. Usage of MySQL’s “IF EXISTS”
  29. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  30. MySQL equivalent of DECODE function in Oracle
  31. How to copy a row and insert in same table with a autoincrement field in MySQL?
  32. CAST to DECIMAL in MySQL
  33. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  34. MySql – HAVING vs WHERE 
  35. How to stop mysqld
  36. WordPress site migration – icons missing
  37. WordPress Database lost auto increment
  38. Slow wp_term_relationships query
  39. Optimize Multiple Taxonomy Term MySQL Query?
  40. How to use “TRUNCATE TABLE” MySQL statement?
  41. WordPress MySQL & PHP Performance
  42. What specific database privileges does WordPress need?
  43. Slow SQL_CALC_FOUND_ROWS Query
  44. How is the data stored in the database?
  45. Using source control with WordPress
  46. Updating User Meta with SQL Query
  47. How do I write this SQL statement for Posts written in last 24 hours?
  48. wpdb prepare syntax
  49. How to run this SQL query of wp_terms database
  50. WooCommerce – Query for ordered products
  51. How to find if a post with custom_field == X exists?
  52. How to change post format from Aside to Image for all posts?
  53. How to add and SQL query of posts only published
  54. Slow Mysql Queries
  55. can database and media folder be moved to a different drive?
  56. Manually removing revision post types
  57. Select Multiple meta_value from WP DB; Single Query
  58. Is it possible to split database tables using HyperDB?
  59. What happens if I overwrite the current wp_options table with a backup from a week ago?
  60. writing inner join in wpdb
  61. Unknown collation when I import a dump from an existing site into a development database?
  62. PHP script can’t connect to Database on port 3307
  63. How to Mirror WordPress database from Remote server to Local server
  64. Is MariaDB’s Aria storage engine suitable for WordPress?
  65. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  66. How do I query wp_options for expired transient pairs with MySQL commands?
  67. Automatic switch to backup database on fail
  68. How to translate this mySQL query to $wpdb query
  69. Separate DB by yearly archive of WordPress
  70. WordPress running SQL query to update database from form
  71. How to fix database error duplicate entry
  72. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  73. Update MySQL query so that it functions again
  74. Alternative functions for mysql_free_result and mysql_ping in wordpress functions
  75. Why this query is not showing any result on wordpresss home page?
  76. Query posts by custom taxonomy and sort by post_modified
  77. WordPress $wpdb get posts from category and sort by custom meta
  78. Trouble running $wpdb->query() with last_insert_id
  79. External wpdb connections in different plugins on single page
  80. Array Formation Issue
  81. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  82. wp_usermeta – Read from database, but save function broken
  83. How to get product order by two custom taxonomy in wordpress
  84. Having problem creating local instance of wordpress site
  85. WordPress $wpdb no result
  86. Integrating Custom Database with WordPress
  87. Please help! I have a problem with getting wordpress databas
  88. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  89. edit_user_created_user hook – using to update Groups
  90. Bulk find & replace on WordPress posts/pages (minus image paths)
  91. WordPress database problem wp_posts, primary key
  92. Improving performance of SQL sub-queries in WordPress
  93. Missing latest posts and options after DB migration via phpMyAdmin
  94. Saving custom term value to the database in new table
  95. “MySQL server has gone away” since update to 3.8
  96. MYSQL Join on meta key value?
  97. Complicated MySQL Query
  98. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  99. How can I delete the options from DB when the plugin is deleted?
  100. Batch Replace URLs in WordPress Database

Leave a Comment