Duplicate a MySQL database
Ever thought of duplicating a database for some random reason (no judging) ?! ... well here's how to do it :
mysqldump -u username –p -d [database_name] > database.sql
mysql -u username -p
create database [database_name]
mysql -u username -p new_database < database
Written by Zakaria Braksa
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Mysql
Authors
Related Tags
#mysql
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#