Re: need Help - Mysqldump issue

2010-11-22 Thread Christophe DUMONET
Hello, Thank for your help I just try mysqldump with --quick or --opt option ... to avoid out of memory problem but -- dump fails with --max_allowed_packet=2048M and --quick : r...@pcjahia01:/# /usr/bin/mysqldump -A --max_allowed_packet=2048M --quick --default-character-set=UTF8 -u

need Help - Mysqldump issue

2010-11-19 Thread Christophe DUMONET
Hello, Starting today, my daily database backup script does not work :-( with mysqldump typically Out of memory error. So, I try to change max_allowed_packet option value, but I don't succeed (mysql run on ubuntu 10.04 OS with 5.1.41-3ubuntu12.7 0 mysql version.) On the last successfull

Re: mysqldump issue

2004-07-26 Thread Egor Egorov
Ginger Cheng [EMAIL PROTECTED] wrote: If a table has a column defined as 'float not null' and the corresponding txt file used to load it have sth like 'nan' for the column, although giving warnings, the record will be loaded and the column looks like 'nan' by using mysqlimport. But

mysqldump issue

2004-07-22 Thread Ginger Cheng
Hello, MySQL gurus, Since I have been moving data around using mysqldump recently, I have found sth annoying: If a table has a column defined as 'float not null' and the corresponding txt file used to load it have sth like 'nan' for the column, although giving warnings, the record will be

Re: mysqldump issue

2004-07-22 Thread gerald_clark
Ginger Cheng wrote: Hello, MySQL gurus, Since I have been moving data around using mysqldump recently, I have found sth annoying: If a table has a column defined as 'float not null' and the corresponding txt file used to load it have sth like 'nan' for the column, although giving

Re: mysqldump issue (table named group)

2003-02-02 Thread Benjamin Pflugmann
Hello. On Fri 2003-01-31 at 13:45:26 -0600, [EMAIL PROTECTED] wrote: Description: One of our customers had a table named group, admitedly a bad design but still not something that should cause mysqldump to fail hard! Please be more specific. Did mysqldump error out or the

mysqldump issue (table named group)

2003-02-01 Thread btallman
Description: One of our customers had a table named group, admitedly a bad design but still not something that should cause mysqldump to fail hard! How-To-Repeat: Name a table group and run mysqldump, even with --opt Fix: Quick workaround is to rename the table, but