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 ddd .
It generates the following code:
and the following error shows up:
What might be the problem?
20 Answers 20
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.
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.
Restarting MySQL works fine for me.
In my case I ran this command even if the table wasn’t visible in PhpMyAdmin :
DROP TABLE mytable
Check filenames.
You might need to create a new database in phpmyadmin that matches the database you’re trying to import.
I had the same problem. I tried to create a table in mysql and got the same error. I restarted mysql server and ran the command and was able to create/migrate table after restating.
Today i was facing same problem. I was in very difficult situation but what id did i create a table with diffrent name e.g (modulemaster was not creating then i create modulemaster1) and after creating table i just do the rename table.
I encountered the same problem today. I was trying to create a table users , and was prompted that ERROR 1146 (42S02): Table users doesn’t exist , which did not make any sense, because I was just trying to create the table!!
I then tried to drop the table by typing DROP TABLE users , knowing it would fail because it did not exist, and I got an error, saying Unknown table users . After getting this error, I tried to create the table again, and magically, it successfully created the table!
My intuition is that I probably created this table before and it was not completely cleared somehow. By explicitly saying DROP TABLE I managed to reset the internal state somehow? But that is just my guess.
Error Number: 1146 Table doesn’t exist как решить?
Апач, убунта. Проблема такая, что как то мне понадобилось исправить ошибку бэкендера так как неправильно было записано условие, через FileZilla зашел, изменил строку в функции, теперь он выдает в клиенте при пост запросе 500 internal server error в другой функции. Вернул файл который был, ошибка осталась, нашел проблемную строку:
Эта функция не редактировалась
Попробовал обратиться через REST выдало:
То есть я отредактировал файл, теперь он не видит бд, вернул файл, также не видит. В чем может быть проблема?
Ошибка: ERROR 1146 (42S02): Table ‘mysql.servers’ doesn’t exist
Ошибка: ERROR 1146 (42S02): Table ‘mysql.servers’ doesn’t exist
1. Заходим в MySQL под пользователем root:
mysql -u root -p mysql
И создаем недостающую таблицу:
CREATE TABLE `servers` (`Server_name` char(64) NOT NULL, `Host` char(64) NOT NULL, `Db` char(64) NOT NULL, `Username` char(64) NOT NULL, `Password` char(64) NOT NULL, `Port` int(4) DEFAULT NULL, `Socket` char(64) DEFAULT NULL, `Wrapper` char(64) NOT NULL, `Owner` char(64) NOT NULL, PRIMARY KEY (`Server_name`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=’MySQL Foreign Servers table’;
И делаем сброс привилегий:
Должно появится сообщение: Query OK, 0 rows affected (0.00 sec)
Windows сервера в Европе с оплатой в рублях
Облачные Windows сервера в Германии, Голландии, Эстонии.
Мощные системы защиты.
Возможность установки любого ПО на сервер.
Полная конфиденциальность.
Оплата в рублях.
Безнал для юридических лиц.