[OpenSIPS-Users] migrate db with MariaDB

[Bogdan-Andrei Iancu]

Hi Arthur,

What distro are you using ? (out of curiosity)

somehow I'm afraid that char '-' is not allowed in the name of a 
database - try naming the new db as "opensips_db"

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com


On 04/29/2013 07:33 PM, Arthur Titeica wrote:
> Hello,
>
> As my distro switched to MariaDB it seems there is a problem when trying to
> migrate the database from 1.8 to 1.9.
>
> Everything goes like
>
> # opensipsdbctl migrate opensips opensips-new
> Enter character set name:
> latin1
> INFO: creating database opensips-new ...
> ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the
> manual that corresponds to your MariaDB server version for the right syntax to
> use near '-new character set latin1' at line 1
>
> Any hints where I should look further in order to solve this?
>
> Many thanks.
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130430/6a4510a5/attachment.htm>