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 vote183 views1 answer
Transaction database with php
SQL
0 vote198 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote122 views1 answer
Check if due date is less than todays date sql
SQL
0 vote165 views1 answer
Take sql dump in to file
SQL
2 votes161 views1 answer
Sql server check for value in multiple columns
SQL
0 vote186 views1 answer
Get only one row in mysql
SQL
1 vote163 views1 answer
Show table columns
SQL
0 vote179 views1 answer
Oracle sql all days except weekends
SQL
1 vote171 views3 answers
Mysql disable foreign keys check
SQL
0 vote195 views1 answer
Postgre query date
SQL