Hi.
You may send us fragment of your file, near line 355. spiv007 <[EMAIL PROTECTED]> wrote: > Thanks, I go the dump now. but when i go to import the dump: > > mysql -D sd2000 -u root < mysqldump.txt > > Im getting errors; ERROR 1064 (42000) at line 355: You have an error > in your SQL syntax; check the manual, etc!!! > > What does this means? > > > On Wed, 03 Nov 2004 09:23:53 +0200, Gleb Paharenko > <[EMAIL PROTECTED]> wrote: >> Hi. >> >> What version of MySQL do you use? >> >> To make it easier to reload dump files for tables that have foreign key >> >> relationships, mysqldump automatically includes a statement in the dump >> >> output to set FOREIGN_KEY_CHECKS to 0 as of MySQL 4.1.1. >> >> >> >> >> spiv007 <[EMAIL PROTECTED]> wrote: >> >> > I just dumped my access tables into mysql via mysql dump script. >> >> > >> >> > But now when i del my ables in access then do an import it does not >> >> > save the primary key info nor the tables relationships. Is there >> >> > something I need to do to save this info before i remove the old >> >> > tables and insert the links. Because everything things works fine >> >> > until i del the tables. >> >> > >> >> > >> >> > Thanks for any ideals... >> >> > >> >> >> -- >> 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] >> >> > -- 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]
