The world server and the database server are not the same host. You should simply modify the script to add --host="$host" to the various mysql command lines and that would solve the issue.
As a work-around, I've simply set the MYSQL_HOST environment variable prior to running ./world
Even then, the script still doesn't fully update the database (coming from peqbeta_2014-10-11-02:01.sql) as apparently that database is missing some core tables like character_buffs so there are 8 required updates which fail to apply. Not really a problem with the script, per-se, although I'm surprised there isn't a simple empty schema included with the source that one could apply to build an empty, clean and current database so that this whole patch process wouldn't be necessary for a brand new installation. Relying on PEQ to provide the base schema seems silly.
|