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 vote314 views1 answer
Opensuse start MySQL
SQL
0 vote316 views1 answer
Drop column from table if exist on live server mysql
SQL
14 votes349 views2 answers
Oracle limit rows
SQL
0 vote321 views1 answer
Python mysql executemany
SQL
0 vote320 views1 answer
Sql decode
SQL
0 vote319 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote317 views1 answer
Components/Fields of Internal Table
SQL
1 vote319 views1 answer
How to drop function in sql
SQL
0 vote334 views1 answer
Mysql check if lowercase
SQL
2 votes367 views2 answers
Select sqlite3.OperationalError: no such column:
SQL