Solutions to some common problems during WordPress migration: wordpress migration. Solutions to some common problems during WordPress migration: wordpress migration 1. import database prompts that the data table already exists. Take host provider-host 91 used by Zhou Liang's blog as an example, provides solutions to some common problems during WordPress migration.
1. import database prompts that the data table already exists
Taking host provider-host 91 used by Zhou Liang's blog as an example, phpMyAdmin is provided. to import a database, you only need to conveniently select a database and import it. Although the method is simple, the prompt database XXX table has existed may be displayed. This problem may occur because the website files were uploaded to the host space during the previous transfer and the website was installed once. as a result, a new database and a new data table were created, this results in duplicate data tables when the database is re-imported. The solution is to delete the XXX table with the prompt and re-import it.
2. layout disorder after website files and data are uploaded successfully
First, we need to check whether the PHP version of the website is correctly set. for WordPress, PHP version 5.3 or 5.4 is generally used. if it is 5.2, it is a problem that may lead to chaotic website layout. Take host 91 used by Zhou Liang's blog as an example. log on to the control panel and change it to version 5.3 at select php version.
If the modified PHP version still does not take effect, we need to check whether the file loading path of the website file is correct. Right-click the browser and choose review elements to view the website loading status. you may find that many files are not loaded, looking at the access path, we will find that the website access path is inconsistent with the website File loading path, so we need to connect to the database of the website, modify the path for loading the website data file in the options table in the database to be consistent with the website access path.
If the modified PHP version still does not take effect, we need to check whether the file loading path of the website file is correct. Right-click the browser and choose review elements to view the website loading status. you may find that many files are not loaded, looking at the access path, we will find that the website access path is inconsistent with the website File loading path, so we need to connect to the database of the website, modify the path for loading the website data file in the options table in the database to be consistent with the website access path.
3. Blank access page
Log on to the WordPress background and check whether the corresponding topic has been uploaded before the migration website is enabled. If no previous topic is found, you need to re-add the topic or re-upload the topic in wp-content/themes on the control panel, and then enable the topic in the WordPress background theme management office.
4. some functions of the website cannot be used
Log on to the WordPress background, plug-in management-install plug-ins, and check whether all the website plug-ins are enabled. enable the plug-ins corresponding to the website functions.
5. the website homepage is accessible. if other options are clicked, no response is returned or error 404 is displayed.
Log on to the host space control panel and go to the file management office to view hidden files and check whether. htaccess has correct content. Generally, the content of the initialized. htaccess file is:
# BEGIN WordPress
RewriteEngine OnRewriteBase /WP/RewriteRule ^index\.php$ - [L]RewriteCond %{REQUEST_FILENAME} !-fRewriteCond %{REQUEST_FILENAME} !-dRewriteRule . /WP/index.php [L]
# END WordPress
If you have set redirection or static links, you also need to add the same content as the previous website.
PS: Recommended plug-in backup method
WordPress Move is a very good website backup and restoration plug-in. it supports one-click full backup of all files and databases of the entire website and one-click restoration. you can also send backup files to other host spaces through FTP, achieve website migration. The backup package of this plug-in is very intelligent, and each compressed package can be decompressed separately.
After the plug-in is enabled, go to Settings> WordPress Move to set the FTP information of the remote backup host, and the maximum volume of each database package and file package.
Then go to the tool> Backup Manager to back up the database. you can back up the database separately or on the entire site. Backup files are stored in the backup directory under this plug-in. Therefore, before backup, make sure that you have enough space on your host to store backup files.
After the backup, access tool> Migration Assistant has three functions available:
Change domain name-you can change the domain name of the current website, which will replace the old domain names in the database in batches;
Migration-you can send the backup files and databases to the remote host space (that is, the FTP set above). before using this function, install WordPress and WordPress Move in the remote host space, and set the FTP remote backup path to the backup directory under the plug-in. after the backup file is sent, you can access the WordPress Move of the remote host space and restore it through the "Restore" function, so that the website can be migrated.
Restore-you can select a backup file from the backup directory to restore the file.
Search WordPress Move on the background plug-in installation page to install the plug-in online.
Tip 1. import database prompts that the data table already exists. Take host provider-host 91 used by Zhou Liang's blog as an example...