[ejabberd] Ejabberd mysql migration

Sean Dilda sean at duke.edu
Mon Jun 23 17:45:22 MSD 2008

Michael Ossareh wrote:
> Hi guys,
> We're migrating from mnesia to mysql. We get the following error when
> running the migration process:
> #42000You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near ';delete from users where username='1431905';insert into
> users(username, password' at line
> Does anyone have any idea's why? It looks to me as though the
> submisssion of the back to back sql statements is making the server
> unhappy. I know this can be done on the mysql CLI but I guess its down
> to the client libs to see the >1 query and know to submit them
> seperately. Could it be that the the erlang/odbc/mysql lib/module
> isn't doing this correctly?

It doesn't look like its the back to back as much as the second 
statement isn't complete.    What is the process you're going through to 
do this migration?

More information about the ejabberd mailing list