February 14, 2010 in Classic self-hosted technical help
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?
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.
This topic is now archived and is closed to further replies.
Started 2 hours ago
Started February 20
Started Thursday at 04:55 PM