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

25 votes356 views1 answer
Mysql grant all privileges to a user
SQL
0 vote363 views1 answer
Sql alter column name sql server
SQL
0 vote369 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote369 views1 answer
Oracle cpu metric
SQL
0 vote358 views1 answer
Sql value exists in column
SQL
2 votes358 views1 answer
Mysql increment value by 1 in update
SQL
0 vote341 views3 answers
Sql select statements
SQL
0 vote300 views1 answer
Mysql convert column to uppercase
SQL
3 votes375 views1 answer
Oracle list privileges
SQL
0 vote362 views1 answer
Sql select all records from all tables where not empty
SQL