[BNM] mysql4.0 importing mysql4.1?

[Ali]

okay skip that - was something to do with the way Wordpad formatted the file I was editing, a paste into notepad fixed it.

cheers

ali


On 22/06/2006 15:52:44, Ali (ali at nubz.com) wrote:
> Hi
> 
> Hoping someone can help here.
> 
> I have exported a mysql 4.1.19 database from a Linux machine and I am
> trying to import the resultant sql file into a mysql 4.0 database on a
> windows machine. Anything I should know about how to reformat it or if I
> should reformat it?
> 
> I keep getting the following error which is a bit baffling:
> 
> #1064 - You have an error in your SQL syntax.  Check the manual that
> corresponds to your MySQL server version for the right syntax to use near '{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\f
> 
> the text is nowhere within the sql file.
> 
> Is this something to do with ANSI mode in 4.1?
> 
> tearing my hair out.....
> 
> Ali
> --
> 
> BNM info/subscription/archives: http://www.brightonnewmedia.org/
> 
> BNM archive search: http://www.roddis.org/bnm/search.php
> BNM Del.icio.us tag: http://del.icio.us/tag/bnm/
> BNM Flickr group: http://www.flickr.com/groups/bnm/
> 
> BNM powered by http://www.screen-play.net/