Hello. Please, could add more details of your actions. Are you inserting in the table which already has data? Please, provide exact error message. I'm not a telepathist, but in case of duplicate key errors a brute solution is to perform a dump with --insert-ignore option.
Scott Johnson wrote: > Hi All, > > I'm trying to restore a database where the first column is set to > auto_increment. When I apply the inserts created from the mysqldump I get > errors about the auto_increment column. Is there a may to turn it off while > I run the inserts or do I have to modify the table? > > Thanks, > > Scott Johnson > [EMAIL PROTECTED] > Tel.: (514) 917-4922 > Fax: (514) 673-0011 > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]