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]
