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 vote168 views1 answer
Sql contains vs like
SQL
1 vote172 views1 answer
Sql order by where condition
SQL
-1 vote185 views1 answer
Mysql extract days
SQL
5 votes172 views1 answer
Oracle get foreign keys on table
SQL
0 vote183 views1 answer
Docker open terminal mysql server
SQL
10 votes152 views1 answer
Oracle dependency
SQL
0 vote159 views1 answer
Online sql testing tool
SQL
8 votes177 views3 answers
SQL column name
SQL
5 votes164 views2 answers
Oracle timestamp to date
SQL
0 vote165 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL