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

1 vote162 views1 answer
Login to database mysql terminal
SQL
1 vote184 views1 answer
Mysql column start with string
SQL
0 vote306 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote188 views1 answer
Add sqlcmd to path linux
SQL
0 vote172 views1 answer
Odd record sql query
SQL
0 vote175 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote187 views1 answer
Delete first row in sql
SQL
0 vote277 views1 answer
Print hello world in plsql
SQL
0 vote163 views2 answers
Update information in a mysql column
SQL
8 votes170 views2 answers
Between operator
SQL