This is one of the biggest and regularly unforeseen issues confronted by website admins doing the change to committed facilitating, notwithstanding while updating 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 move down all your site documents 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 after that go. Your database will then be dumped to the download record on your hard drive. 

Once your server is setup you ought to logon explore to your database area of your control board and make another database, on the off chance that you are utilizing c-board you will be permitted to name your database (the simplest alternative 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 great deal of inconvenience.

When you have set up your new database on your devoted 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 – variant 2.6.4-pl3 – Host: dbxxx.hostname.co.uk – Generation Time: May 15, 2009 at 07:57 PM – Server adaptation: 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 delete the accompanying area:

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

Utilize dbxxxxxxxx;

Inability to do this will bring about a mistake message educating you that the database as of now exists when you endeavor to import the document.

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 variant: 5.0.67 – PHP Version: 4.3.10 – Database: `dbxxxxxxxx` –

Spare the sql record, open up phpMyAdmin select your new database open up the sql window, select import documents at that point pick record, explore to the refreshed database.sql record and snap go. After a short delay 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 alter the association information in your site to mirror your new database points of interest.