copy database mysql

1// if you didnt create the target db, do it:
2mysql -u your_user -p
3
4> CREATE DATABASE the_db_cloned_name;
5> SHOW DATABASES
6
7// then check if it is created and so you're ready to proceed
8mysqldump -u your_user -p the_db_name > /directory/file_name.sql
9mysql -u your_user -p the_db_cloned_name < /directory/file_name.sql

1mysqldump -u root -p db_caweb | mysql -u root -p root db_caweb_23012021;
2