Moving a database from one server to another is not as difficult as it might seem to a beginner in solving this problem. It is enough to use the "correct" utilities and carefully review all the settings.
Instructions
Step 1
As a rule, the data of registered users is stored in a specially created database. Therefore, to move users from one server to another, it is enough to export the database and place it on a new server. Go to Phpmyadmin on the old server. Select the required database with information about registered users and go to the "Export" tab in the top panel of the interface.
Step 2
Select the required tables from the database, or click the "Check all" button. Pay attention to the column titled "SQL Options" - there should be a checkmark next to "Structure" and "Add Auto Increment". Also, the "Full Insert" field should be checked, and opposite the Export type is the INSERT command.
Step 3
If the exported database is large, you can archive it to speed up the process. To do this, click on the "Compression" column and select a parameter convenient for you. Remember that in this case, when transferring user data to another server, you must first unzip the file.
Step 4
Click the "Go" button and wait for your database to download to your computer. When this happens, go to the Phpmyadmin panel on the new server and click on the SQL item. By clicking the "Browse" button in this section, select the database already downloaded to your computer. Wait while the file is uploaded to the server.
Step 5
However, you cannot transfer users who are registered as administrators on the server, while retaining their privileges and settings in this way. To solve this problem, use the dbForge Studio for MySQL utility (there is a Russian version). Install the program, open it and establish a connection to the Mysql server. In the "Explorer" window, select the required database.
Step 6
In the "Databases" menu, select "Security Manager" and in the window that opens, select all users. In the window that opens, click Generate DDL. A wizard window will open, in which you need to click "Next". Turn on saving user privileges and click "Start". As a result, you will get a script that can be used in any SQL editor to transfer users to the new server.
