RE: mysql dump problems, no data dumped

2008-10-31 Thread Andy Smith
Hi Rick, ok sorry, heres a bit more detail, and I see some more useful stuff I didn't see before too (I still duno whats wrong but guess will be helpful to those more knowledgeable!). I believe its using InnoDB for the tables, previously I was seeing an error 24 which from digging around can

ANN: SQL Maestro for MySQL 8.10 released

2008-10-31 Thread SQL Maestro Team
Hi! SQL Maestro Group announce the release of SQL Maestro for MySQL 8.10, a complete Windows GUI solution for MySQL server administration and database development. http://www.sqlmaestro.com/products/mysql/maestro/ New features: = 1. An ability of using the LOAD DATA INFILE command

Re: I don' t know difference between myisam_sort_buffer_size and myisam_max_sort_file_size

2008-10-31 Thread Jake Maul
From dev.mysql.com: myisam_max_sort_file_size : The maximum size of the temporary file that MySQL is allowed to use while re-creating a MyISAM index (during REPAIR TABLE, ALTER TABLE, or LOAD DATA INFILE). If the file size would be larger than this value, the index is created using the key

Basic information: MySQL Table crash?

2008-10-31 Thread Roman Eberle
hi, someone else had a similar question, but didn't get any useful reply here on the list - I'll give it another try. :-) I need some basic understanding of MySQL table crashes. Maybe you can help me, I think it's so basic, no one ever wrote about it. (Until now! ;)) The mysql manual just says

Re: Basic information: MySQL Table crash?

2008-10-31 Thread Gerald L. Clark
Roman Eberle wrote: hi, someone else had a similar question, but didn't get any useful reply here on the list - I'll give it another try. :-) I need some basic understanding of MySQL table crashes. Maybe you can help me, I think it's so basic, no one ever wrote about it. (Until now! ;)) The

Re: I don' t know difference between myisam_sort_buffer_size and myisam_max_sort_file_size

2008-10-31 Thread Moon's Father
Thanks for your patient replay. This means the myisam_max_sort_file_size is the limitation of myisam_sort_buffer_size. And they are both implemented to improve the DDL statements. On Fri, Oct 31, 2008 at 11:45 PM, Jake Maul [EMAIL PROTECTED] wrote: From dev.mysql.com: