|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
February 16th, 2004, 10:06 AM
|
|||
|
|||
|
mysqldump error [Resolved]
I did a dump into a file, harry.sql. That went fine. But when I tried to read it back into a db, using the command:
Code:
mysql test < harry.sql I get the error" Code:
error 1064 at Line 12: You have an error in your SQL syntax near 'group ( Age grouporder varchar(30) default NULL, Age group varchar(30) defau' at line 1 The relevant text in the harry.sql file appears to be: Code:
DROP TABLE IF EXISTS `Age group`; CREATE TABLE age group ( Age grouporder varchar(30) default NULL, Age group varchar(30) default NULL, KEY ageorder (Age grouporder), KEY age (Age group) ) TYPE=MyISAM; I'm new to mysql, but I don't see an error. Any ideas? Thanks.
|
|
#2
February 16th, 2004, 10:18 AM
|
||||
|
||||
|
Spaces in your table names are probably the culprit.
__________________
Please don't PM me asking for solutions outside the scope of a thread. Keeping all responses in a thread stands to help others who come along later, which is after all what this forum's all about.
|
|
#4
February 16th, 2004, 10:34 AM
|
|||
|
|||
|
Thanks, I'll check that out. It seems strange, since it's coming from an existing mysql db on the server to the test db on my local machine. It seems like that'd be a problem on the server, too.
It's a huge .sql file, I wouldn't want to go through it to find all the field/table names. Over 100 tables w/dozens of fields in some. I tried to a straight dump, but now the boss says there's a problem on the server.
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > mysqldump error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
