Basu --<br><br>Between the time you exported the file and when you imported, probably the character set does not match. This is part of the work you have to do to ensure important UTF-8 handling. You might be able to tell from looking at the SQL file what the settings were at that time. You can tell what they are for your current user by asking mysql:<br>
<br><span style="font-family: courier new,monospace;">mysql> show variables where Variable_name like "char%";</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">+--------------------------+----------------------------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| Variable_name | Value |</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">+--------------------------+----------------------------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| character_set_client | utf8 | </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">| character_set_connection | utf8 | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| character_set_database | utf8 | </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">| character_set_filesystem | binary | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| character_set_results | utf8 | </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">| character_set_server | utf8 | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| character_set_system | utf8 | </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">| character_sets_dir | /usr/share/mysql/charsets/ | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+--------------------------+----------------------------+</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">8 rows in set (0.00 sec)</span><br style="font-family: courier new,monospace;">
<br>You probably want to set those in /etc/mysql/my.cnf or ~/.my.cnf. In a worst case, you might have to copy the SQL file and manually remove the parts that wont load, then deal with those separately.<br><br style="font-family: courier new,monospace;">
--Joe<br><br><div class="gmail_quote">2009/7/9 Basu Talikoti <span dir="ltr"><<a href="mailto:basudpl@gmail.com">basudpl@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
hi<br><br>I have taken backup from the server which run koha 3.0 on centos and i want to load in other computer installed same version of koha. but give the following error;<br><br>[root@localhost ~]# mysql -u root -p koha</root/Desktop/koha01july.sql <br>
Enter password: <br>ERROR 1064 (42000) at line 3325: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '��� ���<nrb��O<R�0,�Q}�9��R �,j�i��{���� 0�%�π1h8 R}<br>
3����]��2�hӱ�LJ:� ��m�' at line 1<br>[root@localhost ~]# <br><br>it load up to 97 tables . when uploading systempreference table it give the above error<br><br>Can anyone explain what the problem is and how to solve it..<br>
<font color="#888888">
<br>basu</font><br></blockquote></div><br>