How to do SQL updates?

[sever]

[SQL]: - detected 1 new SQL updates[SQL]: -- 'sql-files/upgrades/2014-09-01--16-53.sql'[SQL]: To manually skip, type: 'sql update skip <file name>'

 

[jaBote]

Simply, if you recompile your server, run the specified SQL file into your RO database for being totally up-to-date.

 

[sever]

is this the command?

sql update sql-files/upgrades/2014-09-01--16-53.sql

i'm very cautious as there is no revert for this.

 

[jaBote]

I'm unaware that command exists on current Hercules. I do personally prefer to do that via console with the awrver shut down:

mysql -u user -p rodatabase < file.sql

Then you'll be prompted for the user's password

 

[sever]

Thanks jaBote.