Re: [webmin-l] problem with mysql backup

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

If, in the command line shell, I perform the command "mysqldump
--net_buffer_length=4k ......" everything is OK, and I can restore back the
file

Is it a way to add the parameter into the webmin-->mysql module config ?

Andrea



                                                                           
             andrea.lanza@fram                                             
             eweb.it                                                       
             Sent by:                                                   To 
             webadmin-list-adm         web...@li... 
             in...@li...                                          cc 
             rge.net                                                       
                                                                   Subject 
                                       [webmin-l] problem with mysql       
             01/02/2006 12.02          backup                              
                                                                           
                                                                           
             Please respond to                                             
             webadmin-list@lis                                             
             ts.sourceforge.ne                                             
                     t                                                     
                                                                           
                                                                           




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



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log
files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
-
Forwarded by the Webmin mailing list at web...@li...
To remove yourself from this list, go to
 http://lists.sourceforge.net/lists/listinfo/webadmin-list