On Monday 24 March 2003 12:03, Stefan Toobe wrote: > does anybody know how to use mysqlump with "big tables"? > I´ve got a db with a few tables. One of that tables has > 100000 rows. > Making a dump with mysqldump 3.23.54 causes following error:
> mysqldump: Got error: 1104: The SELECT would examine too many records > and probably take a very long time. Check your WHERE and use SET OPTION > SQL_BIG_SELECTS=1 if the SELECT is ok when retrieving data from server try adding --opt. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
