The method of clearing phpmyadmin database

This article is about how to clean the phpmyadmin database. Xiao Bian thinks it is quite practical, so share it for everyone to make a reference. Let's follow the editor and have a look.

Method 1: Check the data table through PhpMyAdmin and delete it manually

This is a traditional method, manually check and delete:

Log in PhpMyAdmin, select your mysql database name to enter> Click Structure> Select the database table you want to delete

Move to the bottom, select Delete in "Selected Items" to execute the delete table operation. As shown below:

This method is purely manual, more reliable and visible. However, it is relatively slow. For example, Phpcms v9 will have more than 100 headers. If you check it, you need to check it softly, so you can't achieve the purpose of batch.

Method 2: Batch deletion through database statements.

Before using this method, it is strongly recommended to back up the entire database. As for how to backup? Don't you? Leave a comment below this article.

Specific method: copy the following php execution statement, save it as sql.php file (pay attention to configuring database name, password and data header), upload it to website and directory through ftp, and run it.

Thank you for reading! About the method of clearing phpmyadmin database to share here, I hope the above content can be of some help to everyone, so that everyone can learn more knowledge. If you think the article is good, you can share it so that more people can see it!