Return to logram and open phpMyAdmin. The location varies from software to software, and if you are unsure where to find it, refer to the appropriate documentation. In create a new database phpMyAdmin, click the new button on the left menu to create a new database. Male create a new database and start. Under create database, enter the database name of the previously recorded source site, and then click create. The
The default value of the collision drop-down box is no problem in most cases, but if problems occur in the future, please reverse track and try this step again, and select uft8\u bin instead of uft8\u bin. Before importing an existing database, you must create an empty new database. Create new database user now creates a new database for the backup test site, so you must create a user for that site. Previously WP config. The test site for backup will not work without creating the same database user as recorded in the PHP file. However, assign one of the existing users to the database and assign WP config later. You can update the PHP file. The
If you think this will be easier, click Edit permissions for selected existing users. On the next page, select all permissions, then select the new database created under permissions > database, and then click move. If you do not want to edit the core file, you can add a new user. After the database is successfully created, when the new database is highlighted on the left, click the permissions tab, and then click the add user link. After creating a new database, click the permissions tab to create users for the database. Before the next page, WP config. Enter the user name and password recorded in the PHP file. Ensure that the third check box in the user database is the only check box selected for all authorizations in the database. Must be selected by default. The
If this option is not displayed, it means that the new database is not selected in the menu before clicking the link to add a new user. Please try the selected database again. Then click the select all box under global permissions, and then click move at the bottom of the page. Male select the check box to select all permissions. Otherwise, the site will not work. If a message appears at the top indicating that the database backup import user has been successfully created, click new database in the menu, and then click the import tab. Click Select file, and then select backup database on your computer. All default settings are OK, but the file. If the SQL does not end. Sql Zip or. Sql Select the gzip format, and then select the correct format in the format drop-down box. The
After selecting the file, click the move button. After creating a new database and user name, you can import the database backup. File upload the database backup has been imported at this time, and the file on the site must now be uploaded. Copy the uncompressed files to the folder where the test site is located. This is usually different from most local environments where programs are created, so if you are not sure where the test site is on your computer, refer to the appropriate documentation. You can also view the links in the first part of this article. For a single installation of WordPress, all settings must be completed. Enter localhost in the browser to view the site. If it still does not work, check the software documentation for a valid link. The
If you have multiple sites installed, there is a final step before you visit the local site to test the WordPress backup. In the folder of the local test site
