MySQL Error Invalid Table or Database Name
We upgraded our MySQL server recently which ran several Joomla web sites
After the upgrade we discovered the following error in the mysql log files
090425 23:10:52 [ERROR] Invalid (old?) table or database name 'database-name'
It turns out MySQL does not like the use of - in database names.
One solution is to rename the MySQL database changing the - to an _
Then update the mysql dictionary
After the upgrade we discovered the following error in the mysql log files
090425 23:10:52 [ERROR] Invalid (old?) table or database name 'database-name'
It turns out MySQL does not like the use of - in database names.
One solution is to rename the MySQL database changing the - to an _
Then update the mysql dictionary
UPDATE mysql.db SET Db = 'database_name' WHERE Db = 'database\-name'; FLUSH PRIVILEGES;
Comments
Post a Comment