How to Move a WordPress Database from Myphp to Website Folder
Your website is probably the best representation of what you are about. It showcases your work, educates your target audience and allows them to connect with you on a personal level. Having a clean and orderly database that houses all of your content is a key component to making your website work harder. Whether you are just starting out or have been blogging for a while, this article will tell you exactly how to move a WordPress database from Myphp to the folder of your choice.
Importing Data Into WordPress
Before we begin moving the database, let us take the time to import some content into WordPress. The best way to get started is to use a tool like WordPress Importer to create a skeleton site. This tool generates a completely blank WordPress instance that you can use to begin creating your actual content. One of the best things about this tool is that it allows you to connect one or more databases to it. In this case, we will use MySQL & SQLite to connect to a local database and then migrate it over to WordPress. Once importing is complete, navigate to your new WordPress dashboard and you will see all of the content that you just imported.
Installing The WP Importer Plugin
To use the WordPress importer tool, you will need the WordPress importer plugin. This plugin is available for free on the WordPress plugin repository. Once you have installed the plugin, log in to your WordPress dashboard and click on the gear icon in the upper right corner to access the plugin settings. From here you can change the name of your blog and connect it to a MySQL database that you already have stored on your computer. When you are done, click on the Plugins button in the WordPress dashboard to view all of your installed plugins.
Rerouting The WordPress Database
If you are using a host that provides you with a database that is separate from your wordpress installation, then you can proceed to the next step. If you are using the default host that comes with WordPress, then you will have to reroute the WordPress database. There are a couple of different methods to doing this. The first and the most convenient way is to use a service like Mochi Media. This service provides you with a database replica that you can use to migrate your WordPress content over to. In the case of this tutorial, we will be using a tool called Myphp to connect to our local SQLite database and then import our content into the WordPress dashboard.
Using Myphp To Migrate The WordPress Database
Mochi Media also provides you with a tool called Myphp that can be used to connect to your local SQLite database and then reroute all of the content to your WordPress installation. To use this tool, navigate to
- the folder of your choice on your computer
- Myphp downloads
- then enter the password that you use to login to SQLite in the next window
- and click on Connect.
In the next window that opens up, you will see all of the tables and the data in them. If everything goes well, you should end up with a fully functioning WordPress site with all of the content that you just migrated from your SQLite database. Before exporting, you can take this opportunity to adjust the permalinks if you have altered them from the default settings and delete any unnecessary posts or pages if you have created them during the process.
Exporting Data From WordPress To SQLite
If you are using a service like Mochi Media to move your WordPress content, then you can simply export the entire content of your blog over to your SQLite database using a tool like MywpExporter. This tool allows you to connect to your WordPress database and then download all of the content into a single CSV or XLS file that can be imported into your SQLite database. You can download this file to your computer and then use a tool like MySQL Importer to load it into your SQLite database. Once your entire database is loaded, you can proceed to the next step.
If you are not using a service to move your blog, then you can do this manually by using a tool like MywpExporter as well. This tool allows you to connect to your WordPress database and download all of the content into a single CSV or XLS file that you can then move to the folder of your choice on your computer. In the next step, you will use a tool like MySQL Importer to load the data into SQLite database. You can then repeat this process for any additional WordPress databases that you have stored on your computer. When loading multiple databases, you should take the time to reorder the columns in the order that they appear in your CSV or XLS file. This will make importing the content easier for you when you are importing the file into SQLite.
Cleaning Up After The Process
When you are done using the WordPress importer plugin, you should take the time to remove all of the temporary content that you created during the data migration process. In most cases, this can be done by simply deleting the records in the database that you used to create the dummy blog during the import process. Once this is done, your WordPress site will be completely clean and you can begin using it for the content that you need.
If you are using a host that provides you with a tool that allows you to shrink your SQLite database, then you can simply delete this database and recreate it with a size that you need. When doing this, you should set the max size to 1GB or 2GB to prevent overflow issues when importing content. Once this limit is reached, you will start to see some warnings pop up during the import process to alert you that your database is about to overflow. When this happens, you will need to stop the export process and remove some of the content before continuing. Once you are back to a size that you can fit all of the content in, you can export the data again.
As stated earlier, your website is your best representation of what you are about. When you are developing or designing your website, it is important to keep this in mind. When you are choosing a web host for your website, make sure that they offer a data migration service. With this service, you can move all of the content from one database to another without having to reestablish your entire website from scratch. This process is called Database Migrations and can be a convenient way to test the performance of various hosting providers without the risks involved with going live.