It makes no sense to mention how important it is. You can use or manually execute the plug-in. For the latter, use the FTP client to save all word press files and follow the steps below to save the site database. When the phpMyAdmin panel opens, the database tab is displayed. Select the database for the site, and then click OK all to select all files. Male then click export in the top menu, select SQL as the format, and then click move. The site database was saved successfully. The
Male tip: there may be more databases on the phpMyAdmin tag. You may not know which database is the website database. In this case, WP config. Navigate to the PHP file and search for the following lines: Definition (\
3. database optimization and recovery this is a useful and basic work. Select database, check all files, and then select optimize \/ restore from the drop-down menu. Repair and patch the table, and optimize the tool to defragment the table to improve the loading speed of the site. 4. one of the worst nightmares for WordPress administrators who disable the plug-in is that they cannot access the dashboard. Disabling all plug-ins may fix the problem. However, if you cannot access the dashboard, you cannot disable the plug-in. In this case, go to the phpMyAdmin tool to view the site’s database. The
Browse to the wp_options table and click. Male active_plugins contains many projects. Clicking Edit displays a new panel containing the text area where the plug-in is installed. Male delete all and add the following information: a: 0:{} 5 If you cannot access the reset password dashboard, you must reset the password. In addition, it is best to make changes at any time. You can select the database and edit the wp_users table, and then use the phpMyAdmin tool to operate. Click Browse to display a list of users. Click the person who needs to reset the password, go to the user_pass field, and change the function type to MD5. Replace the old password in the values area with the new password. The
Completed. New password set! 6. you can change the user name directly from the change user name site database. Review the wp_users table (see the previous section), and then click the user name you want to change. Simply replace the user_login value with the new user name. Mastering the closing word press database is not for beginners, but it is really not the exclusive right of developers. Even if you are not an encoder, you can learn how to operate the word press database. These are just a few tricks to entice you to try it. In general, you can do more with your site’s database. Don’t forget to back up your site. The
Would you like to learn more about the WordPress database? Is it interesting to learn how to use phpMyAdmin to perform various tasks? Please share your thoughts!
