Hello, REPEAT is indeed a reserved word in MySQL in 5.0
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html Jimmy Guerrero Sr Product Manager MySQL, Inc > -----Original Message----- > From: Kurt Cypher [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 09, 2006 3:13 PM > To: mysql@lists.mysql.com > Subject: Moving Databases from v4.0.23 to v5.0.24 > > I'm in the process of setting up mysql v5.0.24 on a new > server. The server it's replacing is running mysql v4.0.23. > > I've run mysqldump to get a text file of SQL statements to > read into mysql on the new server, and everything seems to > work fine until it gets to a particular section of the > mysqldump output. > > I turned on logging on the new server, and found that the > last few lines in the log look like (preceded by literally > hundreds of similar "INSERT INTO" lines): > > 1 Query INSERT INTO permission VALUES (80,80,'W') > 1 Query DROP TABLE IF EXISTS repeat > 1 Quit > > I checked a little earlier in the log, and found plenty of > lines where the "DROP TABLE" command had worked fine for > other table names. > > It would appear that it's getting ready to create a table > called "repeat" and bombing. Looking at a text file > containing the mysqldump output, I find that there are plenty > of lines of SQL after the "repeat statement. I'm thinking > "repeat" might be a reserved word in mySQL v5.0.24, > especially after the following test: > > mysql> DROP TABLE IF EXISTS repeat; > ERROR 1064 (42000): 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 'repeat' at line 1 > mysql> DROP TABLE IF EXISTS permission; > ERROR 1046 (3D000): No database selected > > That would seem to indicate that v5.0.x of mysql expects > "repeat" to be something special. If this is the case, then > it would seem that we would need to rename this table in > order for the database to work with mysql v5.0.24, no matter > what method I use to transfer the data. > > Am I on the right track, or am I missing something obvious? > > Thanks, > Kurt > > > -- > Kurt Cypher > Senior Systems Programmer, CaTS > Wright State University > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
