How to do SQL updates?

[sever 0]

[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 438]

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

[sever 0]

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 438]

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 0]

Thanks jaBote.