Bug? #1146 - Table 'xxx.xxxxx' doesn't exist

create table error 1146
42s02 1146
pymysql err programmingerror: (1146 table doesn t exist)
42s02 nativeerr 1146
mysql_upgrade error 1146: table 'mysql gtid_executed doesn t exist
db error #1146
error number: 1146
error 1146 table my2 status doesn t exist

I am using windows XP. I am creating a table in phpMyAdmin using its built-in create table feature, my database name is ddd.

It generates the following code:

CREATE TABLE  `ddd`.`mwrevision` (

`asd` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`sddd` INT NOT NULL
) ENGINE = INNODB;

and the following error shows up:

MySQL said:     
#1146 - Table 'ddd.mwrevision' doesn't exist 

What might be the problem?


I also had same problem in past. All had happend after moving database files to new location and after updating mysql server. All tables with InnoDB engine disappeared from my database. I was trying to recreate them, but mysql told me 1146: Table 'xxx' doesn't exist all the time until I had recreated my database and restarted mysql service.

I think there's a need to read about InnoDB table binaries.

Bug #1175137 “error #1146, After upgrading from 12.10 to 13.04 I had the following error error #1146 - Table '​phpmyadmin.pma_recent' doesn't exist the way to fix it was to  SQL Error: 1146 - Table 'this' doesn't exist. durakiller Junior Member. Posts: 18 Threads: 12 Joined: Jun 2009 Reputation: 0 #1. 2009-06-19, 05:45 PM .


I had the same problem and can't get a good tip for this over the web, so I shared this for you and for all who needs.

In my situation I copy a database (all files: frm, myd) to the data folder in MySQL data folder (using Wamp at home). All thing was OK until I want to create a table and have the error #1146 Table '...' doesn't exist!.

I use Wamp 2.1 with MySQL version 5.5.16.

My solution:

  1. Export the database to file;

  2. verify if exported file is really OK!!;

  3. drop the database where I have issues;

  4. create a new database with the same name that the last;

  5. import the file to the database.

FOR ME IS PROBLEM SOLVED. Now I can create tables again without errors.

Forums - 1146 Table 'XXXXXXXXX.#__ , This is a known bug with the Joomla updater. I think that Max has now published an updated version so it should be fixed. If not you can  Thank you for the bug report. Work-around is to download the non-install package which contents the related tables. [18 Oct 2008 17:30] Tomas Dalebjörk


Restarting MySQL works fine for me.

Database query failed. Error received from database was #1146 , #1146: Table 'helpdesk.mantis_bug_table' doesn't exist for the query: after click the any one bug "id" from view_all_bug_page.php page,  Bug #66211: CREATE TABLE says "ERROR 1146 (42S02): Table 'mydb.foo' doesn't exist" Submitted: 6 Aug 2012 10:42: Modified: 18 Jan 2013 19:29: Reporter: Greg Hazel


In my case I ran this command even if the table wasn't visible in PhpMyAdmin :

DROP TABLE mytable

then

CREATE TABLE....

Worked for me !

Cannot install Plesk: ERROR 1146 (42S02) at line 1: Table 'psa , Applicable to: Plesk Onyx for Linux Symptoms Plesk cannot be installed: PLESK_INFO: ERROR 1146 (42S02) at line 1: Table 'psa.misc' Description: Using binary distribution: mysql-5.0.51a-linux-x86_64-glibc23 If you use temporary tables, and do a binlog-replay using mysqlbinlog results in: ERROR 1146 (42S02) at line 22: Table 'food.tempmeat' doesn't exist This totally breaks incremental backups using bin-logs if you happen to use temporary tables.


Check filenames. You might need to create a new database in phpmyadmin that matches the database you're trying to import.

Dump of the MySQL database hosted on the Plesk server fails , mysqldump: Got error: 1146: Table '<TABLENAME>' doesn't exist when using LOCK TABLES. Backups have the following warning related to  ERROR 1146 (42S02) at line 1: Table 'nova.migrate_version' doesn't exist Final sanity check failed. File a bug report on bugzilla.redhat.com against the openstack-nova package. Expected results: Additional info: Looking at the script openstack-nova-db-setup, looks like the 'nova-manage db sync' doesn't create the table nova.migrate_version.


MySQL Bugs: #78159: Document behavior of SHOW command with , mysql> show status; ERROR 1146 (42S02): Table 'performance_schema.​session_status' doesn't exist mysql> show variables; ERROR 1146  Toutes les tables avec moteur InnoDB ont disparu de ma base de données. J'ai essayé de recréer, mais mysql m'a dit 1146: Table 'xxx' doesn't exist tout le temps jusqu'à ce que j'ai recréé ma base de données et redémarré le service mysql. je pense qu'il y a un besoin de lire sur InnoDB binaires de table.


A database query error has occurred. This may indicate a bug in the , ( /home/webpages/lima-city/wod-berlin/html/maintenance/tables.sql ) Error: 1146 Table 'db_287222_1.user' doesn't exist (mysql.lima-city.de). ERROR 1146 (42S02) at line 1885: Table 'mysql.innodb_table_stats' doesn't existERROR 1146 (42S02) at line 1886: Table 'mysql.innodb_index_stats' doesn't existFATAL ERROR: Upgrade failedHow to repeat:- create a datadir with 5.5 server;- start 5.6 server with --skip-innodb --default-storage-engine=myisam --default-tmp-storage-engine=myisam;- run mysql_upgrade;- observe the errorsSuggested fix:In mysql_fix_privilege_tables, there is a logic that carefully avoids creating InnoDB


Base table or view not found: 1146 Table 'drupal.path_alias' doesn't , Better to describe as a major bug which is making the upgrade path to Update to 8.8.0 fails at, » Base table or view not found: 1146 Table  According to your query, it is set to default value mantis, but in 0023957:0058821 you mention that the table name is helpdesk_bug_table which implies a prefix of helpdesk. As things stand, I am not able to reproduce the issue.