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

UPDATE mysql.db SET Db = 'database_name' WHERE Db = 'database\-name';
FLUSH PRIVILEGES;













































Comments









  1. Kayal mMarch 13, 2019 at 5:53 AM
    This post very useful for enhancing my knowledge. I got huge information in this post. Thank you!!!
    Tableau 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
    ReplyDelete
  2. Sivanandhana GirishMarch 14, 2019 at 12:17 PM
    I am really enjoying reading your well written articles. 
    It 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
    ReplyDelete
  3. Anbarasan14March 15, 2019 at 9:20 AM
    This was an excellent info being posted. This would definitely help the needed ones to a greater extend.

    Computer 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
    ReplyDelete
  4. luckysJune 28, 2019 at 4:16 PM
    whatsapp groups
    ReplyDelete
  5. luckysJuly 4, 2019 at 2:54 PM
    1movies
    ReplyDelete
  6. luckysJuly 6, 2019 at 9:40 AM
    gomovies
    ReplyDelete
  7. Raj MaanJuly 12, 2019 at 2:20 PM
    movies whatsapp groups 
    ReplyDelete











Post a Comment



















Popular posts from this blog









Basic Send Message to MQ with Java and IBM MQ JMS






-















package my.mq.samples;


import javax.jms.JMSException;

import javax.jms.Session;

import javax.jms.TextMessage;


import com.ibm.mq.jms.MQQueue;


import com.ibm.mq.jms.MQQueueConnection;

import com.ibm.mq.jms.MQQueueConnectionFactory;

import com.ibm.mq.jms.MQQueueSender;

import com.ibm.mq.jms.MQQueueSession;

import com.ibm.msg.client.wmq.WMQConstants;


public class MQSend {

public static void main(String[] args)
{
try {
MQQueueConnectionFactory cf = new MQQueueConnectionFactory();
cf.setHostName("localhost");
cf.setPort(1414);

cf.setIntProperty(WMQConstants.WMQ_CONNECTION_MODE, WMQConstants.WMQ_CM_CLIENT);

cf.setQueueManager("QM_GRIDSERVER");
cf.setChannel("SYSTEM.ADMIN.SVRCONN");

MQQueueConnection connection = (MQQueueConnection) cf.createQueueConnection();
//MQQueueConnection connection = (MQQueueConnection) cf.createQueueConnection("username","password");

MQQueueSession session = (MQQueueSession) connection.createQueueSession(false, Session.AUTO_ACKN…








Read more










Basic Receive Message to MQ with Java and IBM MQ JMS






-















package my.mq.samples;


import javax.jms.JMSException;

import javax.jms.Session;

import javax.jms.TextMessage;

import com.ibm.mq.jms.MQQueue;

import com.ibm.mq.jms.MQQueueConnection;

import com.ibm.mq.jms.MQQueueConnectionFactory;

import com.ibm.mq.jms.MQQueueReceiver;

import com.ibm.mq.jms.MQQueueSession;

import com.ibm.msg.client.wmq.WMQConstants;


public class MQReceive {

public static void main(String[] args)
{
try {
MQQueueConnectionFactory cf = new MQQueueConnectionFactory();
cf.setHostName("localhost");
cf.setPort(1414);

cf.setIntProperty(WMQConstants.WMQ_CONNECTION_MODE, WMQConstants.WMQ_CM_CLIENT);

cf.setQueueManager("QM_GRIDSERVER");
cf.setChannel("SYSTEM.ADMIN.SVRCONN");

MQQueueConnection connection = (MQQueueConnection) cf.createQueueConnection();
//MQQueueConnection connection = (MQQueueConnection) cf.createQueueConnection("username","password");

MQQueueSession session = (MQQueueSession) connection.createQueueSession(false, Session.AUTO…








Read more










Configure Database Connection using MyBatis






-















Step 1: Create a propertiese file and store the relevant MySQL connection details here.


In my case the config.properties file contains the following
username=mysqluser
password=1234mysql
url=jdbc:mysql://localhost/bankrecords
driver=com.mysql.jdbc.Driver


Step 2: Create a configuration.xml file, this should contain all the required information needed to connect to your MySQL instance.  you need to reference the above propertiese file in the XML config file.


< ?xml version="1.0" encoding="UTF-8" ?>

< !DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
<properties resource="config.properties" />
<environments default="staging">
<environment id="staging">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<…








Read more