Shuvankar Paul Software Engineer, Strativ AB Magento eCommerce Website Development, Website Development Using Php and HTML and Cross-Platform application development using Appcelerator.

Some Necessary MySQL task you need to know

29 sec read

Cloning a MySQL database to Another DB

For details official documentation Copying MySQL Databases

First you need to create a DB where the clone will happen

CREATE DATABASE clone_db;

Cloning a MySQL database on the same MySql instance

Now for mysqldump and mysql import same command

mysqldump -u user_name --password=user_password original_db | mysql -u user_name -p clone_db

Here
original_db will be replace with the main db table
& clone_db will be the db where the db will clone

Note : after hitting with this command it will ask you the password again and just give the same password, and it will work.

For Example :

CREATE DATABASE employee_directory_new;

mysqldump -u root --password=1234 employee_directory | mysql -u root -p employee_directory_new

Cloning a MySQL database on the another MySql instance

Shuvankar Paul Software Engineer, Strativ AB Magento eCommerce Website Development, Website Development Using Php and HTML and Cross-Platform application development using Appcelerator.

MySQL or MariaDB Mysqldump Single, Multiple & All Database…

According to MySQL official Documentation : The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original...
Shuvankar Paul
41 sec read

The websites that you can keep in your reading…

Global Technology Market Analyst Firm https://www.canalys.com
Shuvankar Paul
1 sec read

Common Magento 2 XML Related Issue

Magento 2 Layout not Updated on Fronted Note : If you don’t found any logical error then, there will be a issue like when...
Shuvankar Paul
20 sec read

Leave a Reply

Your email address will not be published. Required fields are marked *