Jump to content

Switch over

Recommended Posts

Hi All, im now about to move the whole site over from my old host to my VPS but wondering how i go about it and how i move the databases over?

I have moved all my files via ftp over so the files should be there but i assume i need to move the db also?

Link to comment
Share on other sites

Dump the database and zip it up. FTP it to the new server. Unzip and import it to a new db. Set up the config with the new database info.

Log in to your shell account and dump the database:

mysqldump -u<username> -p<password> > /path/to/dump/db/databse.sql

Change <username> to your mysql username. Change <password> to your mysql password. Change /path/to/dump/db/databse.sql to path you want to save the dump. Compress the file.

tar -cvf mysql.tar /path/to/dump/db/databse.sql 

Now download the compressed file and upload it to your new server. On the new server decompress the file:

tar -xvf mysql.tar

Then use mysql to import the database into the new database on the new server. First create the db:

mysqladmin -u<username> -p<password> > create <database-name>

Once the databse is created you import the mysql dump that you extracted.

mysql -u<username> -p<password> <database-name> < /path/to/extracted/db/databse.sql

That should do it.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...