[webmin-l] problem with mysql backup

[<and...@fr...>]

Hi all,
I am having a problem in doing a backup /restore operation in a mysql
database.

The backup was created using webmin.

The database was about 75 MB in size.

The problem is that the file created has about 75 rows of 1 MB length, and
I am not able to execute back the script, both
to the same server or to another server, neither via webmin nor via command
line, neither in linux nor in windows.

The error is always the same: the row is too long, and the row is truncated
and the sql gives the error:

ERROR 1136 (21S01) at line 48: Column count doesn't match value count at
row 74

I also tried a visual query tool, Mysql query Browser, and the result is
the same.

Is it possible to do something in order to make the backup to produce
smaller rows ?? I see that the limit
(my limit, perhaps it could be tuned via my.ini....) is about 10000 bytes
per insert statement

By the way, on the same machine I can upload via java into another database
blob fields up to 1 GB
(I changed the max_allowed_packet=1024M)

I tried to watch at the webmin MySql module configuration, but I didn't see
any option there

Any help will be greatly appreciated,
thanks in advance

Andrea

Chi ricevesse questa mail per errore e' gentilmente pregato di cancellarla.

Visitate il sito http://www.frameweb.it