[Koha] mysqldump and backup

[Joe Atzberger]

Basu --

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:

mysql> show variables where Variable_name like "char%";
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

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.

--Joe

2009/7/9 Basu Talikoti <basudpl at gmail.com>

> hi
>
> 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;
>
> [root at localhost ~]# mysql -u root -p koha</root/Desktop/koha01july.sql
> Enter password:
> 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}
> 3����]��2�hӱ�LJ:�        ��m�' at line 1
> [root at localhost ~]#
>
> it load up to 97 tables . when uploading systempreference table it give the
> above error
>
> Can anyone explain what the problem is and how to solve it..
>
> basu
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090709/4cd5cd41/attachment.htm