<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Hi Arthur,<br>
<br>
What distro are you using ? (out of curiosity) <br>
<br>
somehow I'm afraid that char '-' is not allowed in the name of a
database - try naming the new db as "opensips_db"<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<br>
On 04/29/2013 07:33 PM, Arthur Titeica wrote:
<blockquote cite="mid:1915583.HA2Jf7KZ89@lhart" type="cite">
<pre wrap="">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.
</pre>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>