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 vote262 views1 answer
Grant access on table in oracle
SQL
0 vote305 views1 answer
Distance calculator from lat long sql query
SQL
6 votes332 views2 answers
Oracle undotbs usage
SQL
2 votes282 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote257 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote232 views1 answer
Now() -1 mysql
SQL
0 vote265 views1 answer
Safe mysql
SQL
2 votes283 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote269 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
10 votes280 views1 answer
Oracle dependencies table
SQL