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;
This post very useful for enhancing my knowledge. I got huge information in this post. Thank you!!!
ReplyDeleteTableau Training in Chennai
Tableau Course in Chennai
Spark Training in Chennai
Pega Training in Chennai
Excel Training in Chennai
Oracle Training in Chennai
Oracle DBA Training in Chennai
Social Media Marketing Courses in Chennai
Tableau Training in Chennai
Tableau Course in Chennai
I am really enjoying reading your well written articles.
ReplyDeleteIt looks like you spend a lot of effort and time on your blog.
I have bookmarked it and I am looking forward to reading new articles. Keep up the good work..
ccna Training in Chennai
ccna Training institute in Chennai
Angularjs Course in Chennai
Ethical Hacking Course in Chennai
Tally Course in Chennai
ccna course in chennai
ccna training in chennai
This was an excellent info being posted. This would definitely help the needed ones to a greater extend.
ReplyDeleteComputer Education Franchise
Education Franchise India
Computer Center Franchise
Education Franchise Opportunities in India
Education Franchise India
Spoken English Franchise
Franchise For Spoken English Classes
Top Education Franchise in India
Best Education Franchise in India
whatsapp groups
ReplyDelete1movies
ReplyDeletegomovies
ReplyDeletemovies whatsapp groups
ReplyDeleteThis blog is very intersting to read, i gathered more usefulinformation from this blog..
ReplyDeleteData Science Course in Chennai
Data Science Courses in Bangalore
Data Science Training in Bangalore
Best Data Science Courses in Bangalore
Data Science Institute in Bangalore
Data Science Training Institutes in Bangalore
Data Science Training in BTM
AWS Training in Bangalore
DevOps Training in Bangalore
PHP Training in Bangalore
Wonderful Blog.... Thanks for sharing with us...
ReplyDeleteHadoop Training in Chennai
Big data training in chennai
big data course
Hadoop Course in Chennai
Big data training in vadapalani
Hadoop training in porur
Python Training in Chennai
JAVA Training in Chennai
Selenium Training in Chennai
Software testing training in chennai
Valuable blog....waiting for next update...
ReplyDeleteSpring Training in Chennai
Spring and Hibernate Training
Spring framework Certification
spring training in vadapalani
spring training in Guindy
Hibernate Training in Chennai
javascript training in chennai
QTP Training in Chennai
Mobile Testing Training in Chennai
SAS Training in Chennai
Everything is very open with a precise explanation of the issues. It was really informative. Your site is very useful. Thanks for sharing!
ReplyDelete