Re: Problem with mysqldump and local-infile

2007-04-16 Thread Ding Deng
Mark van Herpen <[EMAIL PROTECTED]> writes: > Hi, > > I want to backup my databases with mysqldump, but mysqldump won't run > because I use the 'local-infile=1' option in the my.cnf file: > > [client] > port= 3306 > socket = /tmp/mysql.sock > local-infile= 1 > > This is be

Re: key_buffer_size and InnoDB tables

2007-04-12 Thread Ding Deng
"Jim" <[EMAIL PROTECTED]> writes: > On the following page and in the example ini files installed with MySQL > it's suggested that key_buffer_size is an option that affects MyISAM > performance. > > http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html > > But on the following page ab

Re: myisamcheck

2007-02-28 Thread Ding Deng
Payne <[EMAIL PROTECTED]> writes: > Hi, > > I am currently using SuSE and like to be able use myisamcheck when start > up mysql. Is there a command that I can added to my init.d script that > would do that. MySQL Debian package[0] does this. The init.d script is just a bash script, so you may add