Problem with running external .sql text file

[rudenborg]

Hi-

I have a database on a sever that is running some version of MySQL 4. I wan't to put the same database on my local computer.

I ran a MySQL dump from the server and tried to run the resulting text file from the UNIX command line on my computer (Running MySQL 5 on Mac OS 10.4). I always get error 1064:

ERROR 1064 (42000) at line 1: 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 '
CREATE TABLE 'art_type' (
  'art_type_id' tinyint(11) unsigned NOT NULL auto' at line 1

All of the SQL is generated from a working database so I have no idea why I would get errors parsing it.

Any help would be greatly appreciated!

Thanks,

Jonathan

 

[r937]

change

CREATE TABLE 'art_type' (
'art_type_id'

to

CREATE TABLE `art_type` (
`art_type_id`

r937.com | rudy.ca