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

4 votes254 views1 answer
Mysql ip address
SQL
22 votes289 views3 answers
Year format in date mysql
SQL
0 vote313 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote262 views1 answer
Postgresql alter column nullable
SQL
6 votes276 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote268 views1 answer
Django mssql backend
SQL
0 vote274 views1 answer
How to check which table has data in mysql
SQL
0 vote240 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote256 views1 answer
Mysql_union
SQL
0 vote259 views1 answer
Add column in sql server ubuntu
SQL