Migrating WordPress can be a tedious process. In particular, migrating a web site to a new server requires multiple steps and may take a long time. But the most difficult thing is to move the MySQL database. Especially in the case of a specific size, ing the database from the old server and uploading it to the new location can test patience. In addition, phpMyAdmin often has unexpected problems, such as timeouts and other errors. In addition, you must replace all references to a location on the site in MySQL statements or search and replace scripts with the new location. The
It is not surprising that this is one of the most disliked word press related activities for both users and developers. But what if there was a tool that could easily create a process to migrate a WordPress database by clicking a few buttons? At this stage, what can dramatically reduce time and energy? Well, WP migrate DB Pro is the tool. What is WP migrate DB pro and what is its function? As can be seen from the name, WP migrate DB Pro by delicious brands is an advanced word press plug-in that helps move word press databases from one location to another. The
Provide top-level advice on WordPress. Fans of the plug-in include Pippin Williamson of Pippin plug-in, Chris coyer of CSS tricks and Carrie DILS, developer of geneis. Why do you deserve that reputation? Unclear. WP migrate DB Pro usually deletes 95% of the word press database migration related data. With WP migrate DB pro, you can synchronize directly between two sites instead of ing the database to the hard disk and uploading it again. The
That is, the plug-in can push the word press database from one site to another or decompress it to another site. In addition, replace the URL and file path of the old location with the new home page of the database. These features are powerful tools to move the word press website from the development environment to the actual environment and keep the updated version on the hard disk. Does that sound interesting? Let’s look under the hat. Before installing the WP migrate DB Pro usage plug-in, you must ensure that the environment meets the following requirements: The latest or the second latest version of WordPress PHP 5.2.4 or above MySQL 5.0 Apache 2+ or nginx 1.4+ (it is likely to run on other php\/mysql web servers, but it is not officially supported) browsers based on Firefox and WebKit, such as chrome or safari. Internet Explorer is not supported. After installation, you can find it in the tools section of the WordPress backend. The plug-in does not generate its own menu items, which is already a plus sign in my book. The
The WP migrate DB Pro can perform three main functions: Export the database of the current site (the free version is limited to this function), import the database from other sites and replace the current database. Push the current database to another location and overwrite the database found in it. Let’s look at each section to better understand the process. To export the site database from the backup database, simply select file export from the plug-in menu. You can also choose to compress the file gzip to save space and time. The
If you plan to use the backed up database for another site, look for the site URL and file path
And replace fields. The plug-in is automatically replaced during export. This is different from other methods mentioned above, such as writing scripts or MySQL statements, which greatly saves time. After that, you can configure the tables that must be included in the export. You can back up or select at the same time. In addition, you can exclude specific post types from the backup that are not required by the new site. Other settings include: Change guid (globally unique identifier – important for RSS feeds) to exclude spam comments (why copy?) Temporarily exclude items (temporarily cached data) to make the database compatible with previous versions of MySQL
After selection, you can save or directly execute the current migration profile for future use. Click the big blue button to start exporting. When you are finished now, you only need to wait for the success message. Is it easy to get here? The WordPress database push and pool export functions themselves are very useful, but there are other plug-ins that can be implemented. What is really interesting is that the database is migrated directly between two different word press sites. This section applies only to the advanced version, not the free version of WP migrate pro. The
The function of pushing and importing WordPress database is the reason why the plug-in can be found on almost all WordPress websites I am responsible for. To take full advantage of this, you must first connect to two web sites for database migration. On the settings page, you can find the private keys that allow sites to recognize and accept requests from each other. To perform a database migration on a web site, you must always add a key on the remote web site. In addition, the website that is pushed or decompressed must also select the corresponding box in the settings. Quick note for local environment: cannot push from real-time installation to local installation. WP migrate DB Pro does not have proper permissions on the hard disk. However, you can easily import a database from a live installation into your local environment, so there is no problem. The
Return to the migration section. Now select whether to push the database or release the database. If you want to continue, you will be prompted to enter the private key of other websites. Doing so applies general options, such as exporting databases. Select the tables to be migrated, exclude specific post types, etc. Another option for push and pool requests is to choose whether to send information about which plug-ins are open and closed. Therefore, if this is important, select this check box. Male (in the setting, to speed up the process, you can completely disable the migration of specific plug-ins.) The
In addition, you can choose to let WP migrate DB Pro save a copy of the existing database first to prevent problems before synchronization and the need to return to the previous version. In addition, if you have media file attachments (described in detail below), the plug-in also provides multiple synchronization options for these files. If satisfied, the rest will be the same as the export. Just click the button and see the progress bar move to the right. Then, you just need to create a new login for the web site that changed the database. One thing you particularly like about this plug-in is its simplicity and intuitiveness. Even inexperienced users who are clear about everything should not encounter too many problems. The
If you want to view the operation of the whole process, you can view it in this video. The main functions of WP migrate DB Pro are enough to enter my top 10, but there are a few points that make the pointer very compact,
