How can I not use phpMyAdmin to transfer a database? Does it sound impossible. However, with some other tools, this can be achieved. Now we will introduce how to transfer your data without using phpMyAdmin with a third-party software: MySQL-Front. You only need to follow the following three steps to complete the data transfer: phpmyadmin
How can I not use phpMyAdmin to transfer a database? Does it sound impossible. However, with some other tools, this can be achieved.
Now we will introduce how to transfer your data without using phpMyAdmin with a third-party software: MySQL-Front.
You only need to follow the three steps below to complete the complex task of transferring data.
1. Where can I download this software?
Download the MySQL-Front software and install it. :
Http://zsj.cz/mysqlfront/MySQL-Front_Setup.exe
Or
Http://www.mysql-front.de/pub/MySQL-Front_Setup.exe (this is the official site)
The installation process is not detailed. Note that this software can only be used for free for 30 days. However, it seems that some Chinese websites can download crack versions. Please search for them by yourself.
2. How to connect to your database?
First, you must log on to the control panel of your space. for CPanel, go to "mysql database". for DirectAdmin, go to "Mysql Menu, you can see "Access Hosts:" (You also need to click your database in DirectAdmin to see "Access Hosts ", please add such a "%" name in "Access Hosts" to indicate that any IP address can be connected to your database. Then you need to open MySQL-Front and create a new task. fill in your host domain name in the "pay-as-you-go" column. Be sure not to include "http: // www ", port 3306 is used. this is a mySQL-specific port. enter your username and password in the "check-in" column and connect to the Port. You should be able to see your database on the left of mySQL-Front. Finally, it is the work of dumping and dumping.
3. How to pour out and import?
First, highlight refers to the database you want to pour out, and then click "archives"> "output"> "SQL file" to name it at will. then you can plant the entire database to a local location, use mySQL-Front to connect to a new space and change "output" to "input". Note that you should create a new blank database in the new space, then, import the data.
I personally haven't officially used the above method. I just thought it was such a usage after reading this software. please try it for the user who needs to transfer the space. after the successful operation, please change "%" from Access
Host deletion, because it may also be a potential danger, so that others can connect to your database, it may delete your database.
Pay for a mySQL-Front, and their main site is http://www.mysqlfront.de
