noobsai Posted March 10, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 70 Reputation: 0 Joined: 02/05/12 Last Seen: February 17 Share Posted March 10, 2012 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 Quote Link to comment Share on other sites More sharing options...
Petey Pablo Posted March 10, 2012 Group: Members Topic Count: 152 Topics Per Day: 0.03 Content Count: 569 Reputation: 11 Joined: 11/24/11 Last Seen: March 7, 2022 Share Posted March 10, 2012 just back up your sql database. xD Quote Link to comment Share on other sites More sharing options...
noobsai Posted March 10, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 70 Reputation: 0 Joined: 02/05/12 Last Seen: February 17 Author Share Posted March 10, 2012 no idea on how to do backup hahaha sry still noob Quote Link to comment Share on other sites More sharing options...
trenx Posted March 10, 2012 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 43 Reputation: 4 Joined: 03/06/12 Last Seen: June 11, 2022 Share Posted March 10, 2012 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 Quote Link to comment Share on other sites More sharing options...
JayPee Posted March 10, 2012 Group: Members Topic Count: 47 Topics Per Day: 0.01 Content Count: 633 Reputation: 78 Joined: 11/14/11 Last Seen: September 20, 2017 Share Posted March 10, 2012 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. Quote Link to comment Share on other sites More sharing options...
noobsai Posted March 10, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 70 Reputation: 0 Joined: 02/05/12 Last Seen: February 17 Author Share Posted March 10, 2012 the host is linux with phpmyadmin Quote Link to comment Share on other sites More sharing options...
Asura Posted March 10, 2012 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 707 Reputation: 168 Joined: 01/26/12 Last Seen: February 7, 2014 Share Posted March 10, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Lighta Posted March 11, 2012 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 737 Reputation: 216 Joined: 11/29/11 Last Seen: December 20, 2020 Share Posted March 11, 2012 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. Quote Link to comment Share on other sites More sharing options...
noobsai Posted March 12, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 70 Reputation: 0 Joined: 02/05/12 Last Seen: February 17 Author Share Posted March 12, 2012 okay thanks for the help guys i will be trying this Quote Link to comment Share on other sites More sharing options...
Question
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
Link to comment
Share on other sites
8 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.