Jump to content
  • 0

Migration VPS to VPS

Valor

Asked by Valor,

 Share

Question

Valor Poring

Valor

Posted
  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  72
  • Reputation:   28
  • Joined:  12/21/16
  • Last Seen:  
Posted

can anyone provide me link or  guide txt how to do save n easy way migration VPS to VPS for ragnarok server? Basicly i have almost zero knowledge about this, currently im using Putty SSH and Filezilla FTP only, no cpanel, vps has unpublished rathena server database, website(empty), and forum(empty) in it. what important thing to note and what changes necesary on migration. (client xml , patch, etc). cant find any exist guide specific ro file migration on search

thx in advance :)

Link to comment
Share on other sites

8 answers to this question

Recommended Posts

  • 1
Mikegyver Poring

Mikegyver

Posted
  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  399
  • Reputation:   69
  • Joined:  12/26/15
  • Last Seen:  
Posted (edited)

it is much easier to backup old sql database using phpmyadmin.

 

how to backup old sql database

1. login into phpmyadmin. click export.

2. on export method, click custom.

3. on output, tick view output as text.

4. on object creation options, tick Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement

5. then click on go button.

6. the db sql is generated in text format. copy all & paste it blank notepad.

7. save it on ur computer. be sure to remember the file name & directory location. as u will use it to restore back in new vps

 

how to restore olq sql database

1. login into phpmyadmin. click import.

2. click on button browse your computer. search the txt file that contain sql files which u save earlier.

3. then click on go button.

 

the purpose in saving sb sql files in txt formatted is to overcome the slow internet connection problem... as the txt file size is much smaller than in .sql

Edited by hazimjauhari90
  • Upvote 1
Link to comment
Share on other sites
  • 0
Mikegyver Poring

Mikegyver

Posted
  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  399
  • Reputation:   69
  • Joined:  12/26/15
  • Last Seen:  
Posted

if u running old linux (debian distribution0, easiest way by doing SCP command.. login using putty at old VPS and execute this command.

scp  -r /[home directory]/[rAthena directory] [user]@[new vps IP address]:/[home directory]

example:

scp -r /home/rAthena [email protected]:/home

Link to comment
Share on other sites
  • 0
Chaos92 Pouring

Chaos92

Posted
  • Group:  Members
  • Topic Count:  49
  • Topics Per Day:  0.01
  • Content Count:  1606
  • Reputation:   247
  • Joined:  08/03/12
  • Last Seen:  
Posted
2 hours ago, Valor said:

can anyone provide me link or  guide txt how to do save n easy way migration VPS to VPS for ragnarok server? Basicly i have almost zero knowledge about this, currently im using Putty SSH and Filezilla FTP only, no cpanel, vps has unpublished rathena server database, website(empty), and forum(empty) in it. what important thing to note and what changes necesary on migration. (client xml , patch, etc). cant find any exist guide specific ro file migration on search

thx in advance :)

1. Copy your rathena server file folder

2. Paste in your new VPS 

3. Backup your phpmyadmin/mysql database.

4. import/export database to new VPS

5. change clientinfo.xml IP to latest VPS IP.

Link to comment
Share on other sites
  • 0
Valor Poring

Valor

Posted
  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  72
  • Reputation:   28
  • Joined:  12/21/16
  • Last Seen:  
  • Author
Posted
12 hours ago, hazimjauhari90 said:

if u running old linux (debian distribution0, easiest way by doing SCP command.. login using putty at old VPS and execute this command.

scp  -r /[home directory]/[rAthena directory] [user]@[new vps IP address]:/[home directory]

example:

scp -r /home/rAthena [email protected]:/home

im using CentoS 6, its same method as download upload using filezilla via ftp?

 

11 hours ago, Chaos92 said:

1. Copy your rathena server file folder

2. Paste in your new VPS 

3. Backup your phpmyadmin/mysql database.

4. import/export database to new VPS

5. change clientinfo.xml IP to latest VPS IP.

maybe i can do 1,2,5 ,seems easy  but point 3,4 i dont understand, is that using command at SSH? or filezila?

 

both @Chaos92 @hazimjauhari90 thx

Link to comment
Share on other sites
  • 0
Mikegyver Poring

Mikegyver

Posted
  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  399
  • Reputation:   69
  • Joined:  12/26/15
  • Last Seen:  
Posted (edited)

basically ftp is almost same as ftp. but, it is transfer method directly from old vps to new vps... perhaps if the file size is larger, & ur internet connection is slow, maybe u will have difficulties in upload back the files in the new vps.. i'm not farmiliar with centos.. but, i think u can search in google the correct scp command parameter for centos....

about point no 3 & 4, do u have phpmyadmin installed in ur old vps?

Edited by hazimjauhari90
Link to comment
Share on other sites
  • 0
Chaos92 Pouring

Chaos92

Posted
  • Group:  Members
  • Topic Count:  49
  • Topics Per Day:  0.01
  • Content Count:  1606
  • Reputation:   247
  • Joined:  08/03/12
  • Last Seen:  
Posted
57 minutes ago, Valor said:

im using CentoS 6, its same method as download upload using filezilla via ftp?

 

maybe i can do 1,2,5 ,seems easy  but point 3,4 i dont understand, is that using command at SSH? or filezila?

 

both @Chaos92 @hazimjauhari90 thx

backup database :

mysqldump --opt --user=root --password=xxxxxxxx ragnarok > backup.sql

then import

mysql -u root -p ragnarok < backup.sql

 

Link to comment
Share on other sites
  • 0
Valor Poring

Valor

Posted
  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  72
  • Reputation:   28
  • Joined:  12/21/16
  • Last Seen:  
  • Author
Posted
30 minutes ago, hazimjauhari90 said:

basically ftp is almost same as ftp. but, it is transfer method directly from old vps to new vps... perhaps if the file size is larger, & ur internet connection is slow, maybe u will have difficulties in upload back the files in the new vps.. i'm not farmiliar with centos.. but, i think u can search in google the correct scp command parameter for centos....

about point no 3 & 4, do u have phpmyadmin installed in ur old vps?

yes, i have phpmyadmin installed in old vps... new to linux, i need to google more hehe

Link to comment
Share on other sites
  • 0
Mikegyver Poring

Mikegyver

Posted
  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  399
  • Reputation:   69
  • Joined:  12/26/15
  • Last Seen:  
Posted (edited)
15 minutes ago, Valor said:

yes, i have phpmyadmin installed in old vps... new to linux, i need to google more hehe

old vps not using linux? isn't CentoS 6 is a one kind of linux.. or perhaps ur new vps is Centos 6? just little bit confuse here. :lol:

Edited by hazimjauhari90
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to question listing
×
×
  • Create New...