Shulou(Shulou.com)06/02 Report--

Today, I will talk to you about how to delete the files of the virtual host database, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

To delete the files of the virtual host database, you need to operate in the database management, one is to empty them all, and the other is to go to the database server and delete them separately.

1. Entry mode of virtual host database

The virtual host database can be accessed from the center of the virtual host control panel.

2. Clear the virtual host database

In the database management interface, we have backup, recovery, repair, emptying and other operations, one of which can empty all the data in the database.

When operating this function, please be sure to back up the data in advance, so as to avoid having no way to restore it after emptying.

3. Delete a single file

To delete a single file, from the database management interface, click "manage MySQL database (UTF-8 version)" or "manage MySQL database (GB2312 version)". Here is the Linux virtual host as an example.

Click enter, you can come to the database server. Select the table stored by the virtual host user name, and you can see all kinds of database tables. For example, the wp_posts table uses the article and page data tables generated by the WordPress website system.

The table structure is as follows:

Field name type comment IDbigint (20) article IDpost_authorbigint (20) article author IDpost_datedatetime article release date post_date_gmtdatetime article release GMT post_contentlongtext article content post_titletext article title post_excerpttext article abstract post_statusvarchar (20) article status comment_statusvarchar (20) comment status ping_statusvarchar (20) whether pingpost_passwordvarchar (255) article password post_namevarchar (200) article name To_pingtextpingedtext this article is recorded by pingback history post_modifieddatetime article last modified time post_modified_gmtdatetime article last modified Greenwich mean time post_content_filteredlongtext article content filtering post_parentbigint (20) article parent article guidvarchar (20) an address of each article menu_orderint (11) post_typevarchar (20) indicates article type post_mime_typevarchar (100) indicates article type comment_countbigint (20) number of article comments

We can use these tags to retrieve articles that need to be deleted.

When operating in the database server, remember to be careful. Before deleting, modifying and other operations, remember to back up first, so as to avoid data loss or confusion caused by operational errors.

After reading the above, do you have any further understanding of how to delete the files in the virtual host database? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.