This article will show you how to migrate your WordPress website hosting from your existing one to your 123-reg VPS.
Exporting and Importing your WordPress database
Important: It is advised that you upgrade your existing WordPress site to the latest version before exporting your data to avoid any potential version issues when importing your data into your new WordPress installation on your VPS.
First you must ensure that you use an FTP Client (such as Filezilla) to download a copy of your files from your Hosting package. Then you will have to download your database from your hosting package.
Login to your Shared Hosting package. Use the MySQL Databases button from the Web Tools section. This will open up the list of your MySQL databases.
Select the Database you would like to export and then click the Manage button. This will open the database manager.
Click the Export tab at the top of the window.
Use the preset settings, ensuring that the SQL file type is selected. Click Go to complete the process.
Open your wp-config file in a text editor such as Notepad. The wp-config file is one of the files that you will have downloaded via FTP earlier in the process. There will be a section at the top of the document that denotes your MySQL Settings. Within these settings you will need to change the MySQL hostname to "localhost", so that the server does not start looking for a Host that doesn't exist.
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'a__wordp_ ressdb2345');
/** MySQL database username */
/** MySQL database password */
/** MySQL hostname */
You will then need to create a database in your server control panel, using the DB Name, DB User and DB Password that is in the wp-config file. You need to make sure you enter these accurately to ensure that this works correctly.
You then need to access the Webadmin section of your server control panel to open up PHPMyadmin. From here, upload the .sql database that you downloaded earlier.