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.

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

Create Multiple Channel on YouTube Under Same Account

Can we create multiple channel under same account? Yes! It’s very simple just need go for the next couple of images, you can do...
Shuvankar Paul
32 sec read

Leave a Reply

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