H> SQL Question

[Erba]

First and Foremost i dont know where to ask this question, forgive me if i posted on the wrong section..

 

now the question is, i am using rathena 16797 and i wish to move on and use the latest svn which is 17701 the question is will my sql backups will be having problems when i import it in the sql tables of 17701?

help

[Missingno]

Use the necessary files from sql-files/upgrades/ in r17701 to update your database from r16797 all the way to r17701 prior to updating your server. In your case, you would need to apply upgrade_svn16823.sql through upgrade_svn17541.sql.

[Erba]

can you guide me how to update it? or how can i apply it?

[Missingno]

Just import them using Workbench, phpMyAdmin, or whatever GUI you're using.

[Erba]

Quest Also Regarding.. global_reg_value, can i empty this portion even if i have lots of data in my whole ragnarok database?

 

and how to convert MyISaM to InnoDB and how does this work, im very much confuse and willing to learn all this stuffs, since ive read that InnoDB gives better results than myIsAm i want to convert myisam to innodb can someone explain it to me in the simplest form?

[Missingno]

Quest Also Regarding.. global_reg_value, can i empty this portion even if i have lots of data in my whole ragnarok database?

 

and how to convert MyISaM to InnoDB and how does this work, im very much confuse and willing to learn all this stuffs, since ive read that InnoDB gives better results than myIsAm i want to convert myisam to innodb can someone explain it to me in the simplest form?

 

I wouldn't recommend dropping global_reg_value, since it stores character and account variables; any players' quest progress would be erased. Regarding your second question, you can change from MyISAM to InnoDB with this query:

ALTER TABLE `table_name` ENGINE=INNODB

Edited February 10, 2014 by Missingno

[Erba]

my server is 255/120 and it doesnt have quest using "#" and i wish to clean up my database so is it possible for me to empty the global_reg_value?

and does converting myisam to innodb will affect scripts with sql queries?

[Erba]

BUmp : Can i empty my global_reg_value?