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]

Reply via email to