mysql copy database to another database code example

Example 1: copy database mysql

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

Example 2: copy db from one server to another mysql

mysqldump -uuser -ppassword myDatabase | mysql -hremoteserver -uremoteuser -premoteserverpassword