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.

Some Manual Query in Magento 2

Change Product ID Magento 2 Change Magento 2 is on Manu Bulk
Shuvankar Paul
8 sec read

A Cook Book of Magento 2 Xml

Magento 2 Xml used Locations Configuration Files All those xml are used in component etc folder module.xml – Module Declaration events.xml – Modules Event...
Shuvankar Paul
8 sec read

Some Necessary Article For Frontend Developer

Font Sizing Guide https://haltersweb.github.io/Accessibility/font-sizing-and-contrast.html Photoshop Letter Spacing https://benmarshall.me/convert-photoshop-letter-spacing-to-css/#photoshop-to-letter-spacing-css-converter Photoshop to Letter Spacing CSS Converter : https://codepen.io/bmarshall511/pen/yxJQwJ/
Shuvankar Paul
6 sec read

Leave a Reply

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