The method of clearing phpmyadmin database

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

1. Use phpmyadmin tool to delete mysql database tables in batch

Delete using the phpmyadmin database management tool, which is a traditional method, and you can do it in any php virtual host. The following is an introduction to the operation:

Log in to phpmyadmin. Select your mysql database name to enter-click structure-select the data table you want to delete-select delete in the "option" to perform the delete table operation.

Second, use php script to complete batch deletion

Find a piece of php code from the Internet, which can also help us to delete it quickly. If you are "sensitive" to phpmyadmin tools, you can use the following ways to quickly delete mysql database tables.

After the following code is copied to notepad, there are several issues you should pay attention to during the configuration process:

1. Configure your mysql database information correctly. You can directly consult your space merchant to get this.

2. Set the database table prefix to be deleted correctly, which is very important. If you fill in the table incorrectly, the operation will be wrong. Please be sure to confirm your database table prefix. You can query the database table prefix in phpmyadmin. It usually starts with xx_.

Once set up, save this code as a .php file (such as 51php.php) and upload it to the site root of your space (public_html). After uploading, you can delete it by directly using the domain name / 51php.php.

Thank you for reading! This is the end of this article on "how to clear the phpmyadmin database". 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 for more people to see!