The method of uploading large Database on phpmyadmin

This article is about how phpmyadmin uploads large databases. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Phpmyadmin is a very convenient mysql database management tool, can be used to manage mysql database, import, export and so on.

Phpmyadmin has a problem when importing mysql. If the database file to be imported is large, the import will fail. Here is a method to import an mysql database of any size, as follows:

1. Upload the SQL file of the database to the root directory of the website through FTP

2. Under the root directory of the website, create the file import.php.

3. Access the import.php in the browser. Suppose your website domain name is www.a.com, then access the http://www.a.com/import.php in the browser. As soon as the browser accesses the import.php file, the data will be imported.

4. After the import, the word "import ok" will appear on the screen.

The import.php file is as follows:

Where root represents the database user name, mypassword represents the password of root, database represents the name of the database to be imported, and a.sql represents the file name of the database file, which is the unzipped file. These variables can be modified according to the actual situation.

Thank you for reading! This is the end of this article on "the method of uploading a large database by phpmyadmin". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!