Bug? #1146 - Table 'xxx.xxxxx' 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
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.
Export the database to file;
verify if exported file is really OK!!;
drop the database where I have issues;
create a new database with the same name that the last;
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
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.