How To Migrate Mysql Database

Table of contents:

How To Migrate Mysql Database
How To Migrate Mysql Database

Video: How To Migrate Mysql Database

Video: How To Migrate Mysql Database
Video: How to Migrate MySql database to Sql Server "EASY" 2024, May
Anonim

When developing sites, the information storage function is usually transferred to the mysql database. If you are creating a similar site that will need the same database, you do not need to re-create a copy of the database.

How to migrate mysql database
How to migrate mysql database

Instructions

Step 1

You can transfer the database using the Dumper program. Find this gadget through your browser and download it to your computer's hard drive. You will receive a link to the archive that you need to unpack using the archiver program. Be sure to check the downloaded files with an antivirus program, as the likelihood of infecting your personal computer with various malicious codes is very likely.

Step 2

Find the sxd folder in the unpacked files and copy it to the server where your site is located. This can be done through the administration panel or through the server communication program in which you developed the site. If you can't find the folder yourself, you can use the built-in search on the server. Click on the "Search" button and enter the request of interest.

Step 3

Go to the site whose database you want to copy by adding the path to the sxd folder to the link. Enter your username and password for access, and you will be taken to the database management section using the Dumper utility. Click on "Import", then "Run" and save the resulting archive to the hard drive of your computer.

Step 4

Go to the site where you want to transfer the database. Also copy the utility folder to the site files, as indicated in point 2. Go to the backup folder and load the database dump obtained in the previous point into this section. Then go to the sxd section and select "Export". Specify the database that you want to add and click on the "Run" button.

Step 5

This utility supports any database and works fairly quickly without burdening the user with unnecessary functionality. If you do not want to use third-party utilities, export the database through PhpMyAdmin.

Recommended: