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 vote208 views1 answer
How to print mysql query of codeigniter query builder
SQL
23 votes206 views1 answer
How remove column in mysql
SQL
0 vote259 views1 answer
Query only first letter string
SQL
0 vote165 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote192 views1 answer
Sql remove last x char
SQL
0 vote232 views1 answer
Add week ending date sql server
SQL
0 vote214 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote217 views1 answer
Mysql date equals to current_date plus days
SQL
6 votes227 views6 answers
Rename column postgres
SQL
0 vote180 views1 answer
Sqlite3 not commit
SQL