Preventing Wipeout when changing VPS host

[noobsai]

how can i prevent my server from wipe out when i change my VPS host.. the host im on now is bit lag and i want to transfer it

but i dont know what to do to prevent any loss of items or wipeout

[Petey Pablo]

just back up your sql database. xD

[noobsai]

no idea on how to do backup hahaha

sry still noob

[trenx]

You just need to save your emulator folder.

Then with the details of your sql backup the database, or in case you cant access use mysql ssh commands to make a dump.

mysqldump -u [user] -p [database_name] > [backupfile].dump

Its not hard as it sounds

[JayPee]

That is the command you will use if your using Linux with no GUI.

mysqldump -u [user] -p[password] [database_name] > [backupfile].sql

but if your using Windows and you have phpmyadmin or MySQL Workbench, you just need to find Export.

[noobsai]

the host is linux with phpmyadmin

[Asura]

Hi noobsai,

Log in with PuTTY and type what trenx had already mentioned...

mysqldump -u USERNAME -p, --password=PASSWORD DATABASE_NAME > FILE_NAME.sql

Then just use WinSCP and transfer the file over to your computer. Also, a reminder... every name is CaSe-SeNsiTiVe.

Edited March 10, 2012 by Asura

[Lighta]

you also have export option on pvpmyadmin but command line easier and faster (and export was like being zombie for huge db)

once you have your .sql, transfert it to the new host and insert it to you new db like that :

mysql -u [user] -p[password] [database_name] < [backupfile].sql

There was also option to do it all in 1 line command but well would be the same as we do here.

[noobsai]

okay thanks for the help guys i will be trying this