Dedicated Servers – Moving Your MySql Databases to a Dedicated Server

This is one of the biggest and regularly unexpected issues confronted by website admins doing the change to committed facilitating, notwithstanding while overhauling with a similar web facilitating organization we will concentrate on the utilization of phpMyAdmin. Dumps forum

Before doing the change to committed facilitating you ought to clearly go down all your site records and your databases. The previous should be possible by means of FTP however your databases ought to be “dumped” utilizing phpMyAdmin this can be accomplished by signing on to phpMyAdmin choosing your database and clicking send out, you will then be taken to the fare page and should choose ‘spare as document’ ‘pressure none’ and afterward go. Your database will then be dumped to the download document on your hard drive. 

Once your server is setup you ought to logon explore to your database segment of your control board and make another database, in the event that you are utilizing c-board you will be permitted to name your database (the simplest choice is to name it the same as your dumped database) if not then you will make another clear database with an alternate name and username, this is not an issue but rather is the thing that causes individuals a ton of inconvenience.

When you have set up your new database on your committed server you should explore to your MySql database dump on your hard drive (database.sql), open it as a content record and you will be given something which starts this way:

– phpMyAdmin SQL Dump – rendition 2.6.4-pl3 – Host: dbxxx.hostname.co.uk – Generation Time: May 15, 2009 at 07:57 PM – Server form: 5.0.67 – PHP Version: 4.3.10 – Database: `dbxxxxxxxx` –

Make DATABASE `dbxxxxxxxx` DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;

Utilize dbxxxxxxxx;

This is teaching phpMyAdmin to make the database and tables, you ought to supplant dbxxxxxxxx with your new database name and since we as of now have a database we can eradicate the accompanying area:

Make DATABASE `dbxxxxxxxx` DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;

Utilize dbxxxxxxxx;

Inability to do this will bring about a blunder message advising you that the database as of now exists when you attempt to import the record.

You ought to be left with a document which resembles this:

– phpMyAdmin SQL Dump – form 2.6.4-pl3 – Host: dbxxx.hostname.co.uk – Generation Time: May 15, 2009 at 07:57 PM – Server rendition: 5.0.67 – PHP Version: 4.3.10 – Database: `dbxxxxxxxx` –

Spare the sql document, open up phpMyAdmin select your new database open up the sql window, select import records at that point pick document, explore to the refreshed database.sql document and snap go. After a short respite your new database will be populated with the tables from old database.

Your new database is prepared to go, however your site does not know it has been renamed. You now need to change the association information in your site to mirror your new database points of interest.