Copy database mysql

Mariadb clone database to another name

// if you didnt create the target db, do it:
mysql -u your_user -p

> CREATE DATABASE the_db_cloned_name;
> SHOW DATABASES

// then check if it is created and so you're ready to proceed
mysqldump -u your_user -p the_db_name > /directory/file_name.sql
mysql -u your_user -p the_db_cloned_name < /directory/file_name.sql

Source: mysqltutorial.org

Copy database mysql

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

Source: stackoverflow.com

Similar codes

0 vote147 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote139 views1 answer
Create table database in psql
SQL
3 votes85 views2 answers
Mysql sum with condition
SQL
-1 vote132 views1 answer
Pl/sql how to delete a trigger
SQL
15 votes142 views6 answers
Psql
SQL
1 vote133 views2 answers
String to date postgres
SQL
0 vote133 views1 answer
Date datatype in livesql
SQL
0 vote178 views1 answer
Sql pivot table
SQL
0 vote123 views1 answer
Phpmyadmin mysql conflict
SQL
1 vote142 views1 answer
Incompatible sql_mode=only_full_group_by
SQL