Is it possible to use sql table of an old server.

[Nero]

Is it possible to use sql table of an old server to transfer the items and account or etc in renewal server?

[Asura]

Hi sampang99,

Yes, it's possible. You would just need to adjust some tables to fit the format of the renewal databases.

[Brian]

Yes.

1. open your /sql-files/ folder

2. find all the upgrade_svn*****.sql files after your old SVN revisioin

3. execute the SQL queries in those files to update your SQL databases.

[Nero]

hi brian

Im still confused because currently Im using the Old sql table .

do u mean that if i use my renewal sql i need to execute all the upgrade_svn*****.sql in the renewal sql table?

[Asura]

Hi sampan99,

Brian said to do the following...

1) Find out what SVN version you are using right now with the old SQL tables.

2) Look in rAthena's 'sql-files' folder and find the closest number for the revision that is above your revision number.

3) Then start running all the .sql files which are considered new updates from where your currently old revision left off at.

[Nero]

i really dont know what to do sir.

because i use my old sql and revison 14009M

and im going to transfer the sql to 3ceam 650? is that possible and how please im newbie and i need some detailed guide thank you for your patience sir. im really sorry for being noob in this topic. please continue helping me.

[Asura]

Hi sampang99,

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

Run all the .sql files to your database starting from "upgrade_svn14036.sql", until you finish with "upgrade_svn15572.sql".

[Nero]

@asura and brian

Thank you very much!

[Cancel]

https://rathena.svn....runk/sql-files/

Run all the .sql files to your database starting from "upgrade_svn14036.sql", until you finish with "upgrade_svn15572.sql".

thanks Asura, you changed my perseption on sql issues, where i thought that just run the main.sql n logs.sql only like wiki said... XDD..