Updating SVN

[Phaige]

I need help on how to update server files from 17128 to the latest revision without wiping my sql database.. I have a running server.. need support on this thanks..

Edited March 18, 2013 by Phaige

[Mootie]

If you are using linux

 

cd /root/Desktop/trunk

ls

svn update

 

to upgrade your .sql in database

 

 

Import MySQL Tables 

Change directory to the sql-files folder.cd trunk/sql-files/
Execute these commands:When prompted, enter your MySQL root password.mysql --user=root -p rathena4444_rag < main.sql
mysql --user=root -p rathena4444_rag < item_db.sql
mysql --user=root -p rathena4444_rag < item_db2.sql
mysql --user=root -p rathena4444_rag < mob_db.sql
mysql --user=root -p rathena4444_rag < mob_db2.sql
mysql -u root -p rathena4444_log < logs.sql

NOTE: if you want to use different SQL DBs for login/char/map servers this is the list of databases each server use:
login-server: global_reg_value, ipbanlist, login, loginlogmap-server: mapreg, item_db, item_db2, mob_db, mob_db2char-server: everything else + global_reg_value once again
Note that global_reg_value tables are needed by both login-server and char-server (though it may be different tables)
 

source http://rathena.org/wiki/Installation_%28CentOS%29#SVN_Checkout

 

or you can use your phpmyadmin

 

follow this guide

 

http://rathena.org/board/topic/77315-update-logs-on-linux-phpmyadmin/

 

Note: only update your database with the following changes

[Rayan]

just go in ur trunk directory , and do "svn update" without quotes ,

then for sql tables

https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/sql-files/upgrades/

 

update ur sql db from above link files.