Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2013
    Posts
    3

    Unanswered: Invalid (old?) table or database name 'Time_'135514'

    I'm getting an error:

    5224, ERROR, Invalid (old?) table or database name 'Time_'135514'

    In MySQL Workbench with
    mysql-installer-web-community-5.6.15.0.msi
    Running in Win7 Pro 32bit

    What do I need to do to fix this?

    Thank you,

    Docfxit

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    To fix it you need to share with us your code that produces this error, otherwise we can only guess.

    Guess #1: Your object name has an erroneous apostrophe in the middle Time_'135514

    Guess #2: You've deleted the object you are looking for. Try querying the information_schema catalogues
    George
    Home | Blog

  3. #3
    Join Date
    Jul 2013
    Posts
    3
    I would be happy to share anything that will resolve this.

    Time_'135514 is the name of a folder. There is nothing in the folder. This folder was created during the install of:
    mysql-installer-web-community-5.6.15.0.msi

    C:\Programs\MySQL\MySQL Server 5.6\data\Time_'135514

    I have no idea what it's for. Is it required by MySQL?
    Can I delete it? How would I delete the pointers to it?

    I don't know how to query the information_schema catalogues

    I took a stab at it with this:

    I created a bat file called MySQLShowDatabaseTables.bat
    Code:
    @Echo On
    C:
    CD C:\Programs\MySQL\MySQL Server 5.6\bin
    mysqld --init-file=D:\Dnload\MySQLShowDatabaseTables.txt --console
    
    CMD
    I created a txt file called MySQLShowDatabaseTables.txt
    Code:
    SHOW CREATE TABLE INFORMATION_SCHEMA.TABLES\G
    When I ran it I received this error:
    2014-01-03 07:58:26 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

    Thank you,

    Docfxit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •