Now you have your website to be transferred to dedicated server with plenty of privileges to appreciate. It is high time to celebrate your website improvement, but it is also necessary to take into account all the issues that may occur during your switch.
Even if you upgrade with the same hosting company to a dedicated server, to make such a switch can be a problem. Let’s make it easier with the following tips provided.
Upgrade Your Hosting Plan Easily
First of all, you need to back up all your website files and MySQL databases. Use FTP to back up website files and take advantage of phpMyAdmin to back up databases. Just log in to phpMyAdmin → select a database → click export. The expert page appear and you need to choose “Save as File”, “Compression None” and then go. Thus, your database will be dumped to the download file on the hard drive.
When your server is set up you need to create a new database. Just login to your database section through the control panel and choose this option. That’s all. With cPanel control panel you can name your new database as your dumped databases as well as to create a blank database with new username and name. There is no a big deal, actually.
Tips to Move MySQL/MSSQL Databases for New Host
As soon as you set up a new database on your dedicated server, go to MySQL database dump on your hard drive (database.sql). Then open it as a text file. There you will see something like this:
– phpMyAdmin SQL Dump — version 2.6.4-pl3 — – Host: dbxxx.hostname.co.uk — Generation Time: May 19, 2011 at 07:57 PM — Server version: 5.0.67 — PHP Version: 4.3.10 — – Database: `dbxxxxxxxx` –
CREATE DATABASE `dbxxxxxxxx` DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
USE dbxxxxxxxx;
It just instructs phpMyAdmin to create a database and tables. Your task is to change dbxxxxxxxx for your new database name.
As we have already had a database we can erase such section as:
CREATE DATABASE `dbxxxxxxxx` DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
USE dbxxxxxxxx;
If it can’t be done, trying to import the file you will be informed with an error message that says a database is already exists.
At the end the file should look like this:
– phpMyAdmin SQL Dump — version 2.6.4-pl3 — – Host: dbxxx.hostname.co.uk — Generation Time: May 19, 2011 at 07:57 PM — Server version: 5.0.67 — PHP Version: 4.3.10 — – Database: `dbxxxxxxxx` –
Now you need to perform the following:
Save the sql file → open phpAdmin → select a new database → open up the sql window → select Import Files → choose file → go to the updated database.sql file → click Go.
You new database that includes the tables from an old database be populated after a short pause.
A new database is ready to work, but your website doesn’t know about the name changing. Amend the connection data in your site to reflect the details of your new database. Just change the following details:
Host – As a rule, this becomes localhost when moving to a dedicated server
User- Database- Password-
At last you can upload your files to your new server via FTP. Wait till DNS settings are updated and enjoy your site moved to dedicated hosting.