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

3 votes387 views6 answers
DB::table('users')->get();
SQL
2 votes369 views2 answers
Calculate percentage in sql
SQL
4 votes324 views1 answer
Oracle error compilation line
SQL
0 vote362 views1 answer
SQL check if record exist
SQL
0 vote371 views1 answer
Mysql url
SQL
0 vote324 views1 answer
Mysql into outfile with headers
SQL
0 vote322 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote317 views1 answer
Sql select non unique
SQL
3 votes350 views2 answers
Create schema postgres
SQL
0 vote363 views2 answers
While mysql
SQL