I am trying to set up my database in MySQL using XAMPP. I am doing this via phpMyAdmin on localhost(Apache is running). The only action on my part is typing in a new, unused, name for a database, click create and…
this error occurs:
Error
SQL query: DocumentationEdit Edit
SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'stuff_tessss' AND `table_name` = '' AND FIND_IN_SET('CREATE DATABASE',tracking) > 0
MySQL said: Documentation
#1932 — Table ‘phpmyadmin.pma__tracking’ doesn’t exist in engine
The database is showing in the list of databases. If you were to click on one, it takes forever and a day to not load.
I’ve tried researching and implementing the other 1932 error solutions on stack and other places but to no avail.
Here are the following versions for the tech I am utilizing:
- OS X El Capitan — 10.11.1
- Server version: Apache/2.4.16 (Unix)
- PHP 5.6.15 (i had to reinstall with -intl extensions because CakePHP was complaining about a dependency)
- CakePHP 3.0 (this required installation of Composer to utilize cakePHP from command line, which I believe runs off of PHP)
- mySQL Ver 14.14 Distrib 5.7.9, for osx10.11 (x86_64)
- XAMPP 5.6.14-4
I’ve read all sorts of solutions such as run it in Linux, or using an older version of XAMPP, etc. I figured there is a smarter person out there who might know the solution. I mainly had a hard time trying to figure out where to research, as well.
If anyone who could point me in the right direction I would greatly appreciate it!
Hi i’am new to php and sql database, i am getting this error (mysql 1932 table doesn’t exist in engine) when i’am accessing the database, how can resolve this
issue i need to access rk_sourav database
I tried so many ways but i’m not find any solution
Shadow
33.4k10 gold badges50 silver badges62 bronze badges
asked Jul 1, 2018 at 11:10
DanyDany
571 silver badge10 bronze badges
2
Load 7 more related questions
Show fewer related questions
Disclaimer: Please read the whole answer to the end before you perform any modifications. Please backup everything before you change the permissions and/or owners. You are changing permissions at your own risk
Possible Root Cause
Changing the permissions on the .../var/mysql directory isn’t the best idea.
However, when I tried to fix this error I have set permissions on
/Applications/XAMPP/xamppfiles/var/mysqlto read/write to everyone.
What MySQL Prefers
MySQL prefers the following directory permissions:
0700 (-RWX------)
MySQL prefers the following file permissions:
0660 (-RW-RW----)
By default, MySQL creates database directories with an access permission value of 0700.
…and…
The default UMASK and UMASK_DIR values are 0660 and 0700, respectively.
Reference: B.5.3.1 Problems with File Permissions
Fixing Permissions
To alter the directory and file permissions you would have to set off two commands like this:
Directory Permissions
bash> find /Applications/XAMPP/xamppfiles/var/mysql -type d -exec chmod 0700 {} ;
In the directory
/Applications/XAMPP/xamppfiles/var/mysqlfind all directories and modify the directory permissions to-rwx------
File Permissions
bash> find /Applications/XAMPP/xamppfiles/var/mysql -type f -exec chmod 0660 {} ;
This translates to: In the directory
/Applications/XAMPP/xamppfiles/var/mysqlfind all files and modify the directory permissions to-rw-rw---
Reference: How do I set chmod for a folder and all of its subfolders and files in Linux Ubuntu Terminal? [clsoed]
Owner?
You should have reset everything the way MySQL prefers it, unless you modified the owner of the .../var/mysql sub-directories and files, which should normally belong to the mysql linux user and equally to the mysql group.
In the case that the files and directories no longer belong to mysql mysql then you might have to reset the owner and group using:
bash> chown -R mysql mysql /Applications/XAMPP/xamppfiles/var/mysql
Individual File and Directory
You might want to consider looking at the permissions of that one file.
Final Observations
Looking at your directory listing I noticed that the user is set to _mysql (with underscore) and the group is set to 706. This might be because the linux group mysql has been deleted and the user _mysql changed.
Is the group mysql displayed if you issue the following command:
bash> cat /etc/group
Possible output:
mysql:x:117:
Does the user mysql exist when you type the following command:
bash> cat /etc/passwd
Possible output:
mysql:x:109:117:MySQL Server,,,:/home/mysql:/bin/bash
Note that the mysql user (109) belongs to the mysql group (117), which matches the ID from the cat /etc/group command.
Please Note:
Running the CHMOD and CHOWN commands will only reset the permissions correctly if the user and group exist. If the user and group exist, then you might be able to reset the permissions and owners to the correct values.
Last Resort
If all else fails you might want to consider re-installing your whole MySQL environment.
Last Resort 2
After reading the newest comments and updates to question there is a possible other solution
Reinstalling the XAMPP stack apparently does not remove all previous *.frm files containing your previously created tables.
However, reinstalling the XAMPPP stack will not allow you to access the previously accessible objects. This is because the files/tables are no longer referenced in the system catalogues. This is why you are receiving an error message when you try to select from your tables.
You might achieve a partial restore of the data and/or table definitions with the MySQL Utilities 1.5 which contain the following tool:
5.10 mysqlfrm — File reader for .frm files.
The tools is documented as follows:
…
A diagnostic mode is available by using the--diagnosticoption. This switches the utility to read the .frm files byte-by-byte to recover as much information as possible. The diagnostic mode has additional limitations in that it cannot decipher character set or collation values without using an existing server installation specified with either the--serveror--basediroption. This can also affect the size of the columns if the table uses multibyte characters. Use this mode when the default mode cannot read the file, or if a MySQL server is not installed on the host.
…
This might be your last resort to retrieving the information from your *.frm files in your broken MySQL instance.
This works in XAMPP 5.6.3, php 7.3.9 just copy and paste this code in config.inc.php in C:xamppphpMyAdmin and remember username is root and you do not have any password so password is empty.
<?php
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */
/*
* Servers configuration
*/
$i = 0;
/*
* First server
*/
$i++;
/* Authentication type and info */
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';
/* Bind to the localhost ipv4 address and tcp */
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';
/* Advanced phpMyAdmin features */
/*
* End of servers configuration
*/
?>
-- Database : `phpmyadmin`
--
CREATE DATABASE IF NOT EXISTS `phpmyadmin`
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
USE phpmyadmin;
-- --------------------------------------------------------
--
-- Privileges
--
-- (activate this statement if necessary)
-- GRANT SELECT, INSERT, DELETE, UPDATE, ALTER ON `phpmyadmin`.* TO
-- 'pma'@localhost;
-- --------------------------------------------------------
--
-- Table structure for table `pma__bookmark`
--
CREATE TABLE IF NOT EXISTS `pma__bookmark` (
`id` int(10) unsigned NOT NULL auto_increment,
`dbase` varchar(255) NOT NULL default '',
`user` varchar(255) NOT NULL default '',
`label` varchar(255) COLLATE utf8_general_ci NOT NULL default '',
`query` text NOT NULL,
PRIMARY KEY (`id`)
)
COMMENT='Bookmarks'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__column_info`
--
CREATE TABLE IF NOT EXISTS `pma__column_info` (
`id` int(5) unsigned NOT NULL auto_increment,
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`column_name` varchar(64) NOT NULL default '',
`comment` varchar(255) COLLATE utf8_general_ci NOT NULL default '',
`mimetype` varchar(255) COLLATE utf8_general_ci NOT NULL default '',
`transformation` varchar(255) NOT NULL default '',
`transformation_options` varchar(255) NOT NULL default '',
`input_transformation` varchar(255) NOT NULL default '',
`input_transformation_options` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
)
COMMENT='Column information for phpMyAdmin'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__history`
--
CREATE TABLE IF NOT EXISTS `pma__history` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`username` varchar(64) NOT NULL default '',
`db` varchar(64) NOT NULL default '',
`table` varchar(64) NOT NULL default '',
`timevalue` timestamp NOT NULL default CURRENT_TIMESTAMP,
`sqlquery` text NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`,`db`,`table`,`timevalue`)
)
COMMENT='SQL history for phpMyAdmin'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__pdf_pages`
--
CREATE TABLE IF NOT EXISTS `pma__pdf_pages` (
`db_name` varchar(64) NOT NULL default '',
`page_nr` int(10) unsigned NOT NULL auto_increment,
`page_descr` varchar(50) COLLATE utf8_general_ci NOT NULL default '',
PRIMARY KEY (`page_nr`),
KEY `db_name` (`db_name`)
)
COMMENT='PDF relation pages for phpMyAdmin'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__recent`
--
CREATE TABLE IF NOT EXISTS `pma__recent` (
`username` varchar(64) NOT NULL,
`tables` text NOT NULL,
PRIMARY KEY (`username`)
)
COMMENT='Recently accessed tables'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__favorite`
--
CREATE TABLE IF NOT EXISTS `pma__favorite` (
`username` varchar(64) NOT NULL,
`tables` text NOT NULL,
PRIMARY KEY (`username`)
)
COMMENT='Favorite tables'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__table_uiprefs`
--
CREATE TABLE IF NOT EXISTS `pma__table_uiprefs` (
`username` varchar(64) NOT NULL,
`db_name` varchar(64) NOT NULL,
`table_name` varchar(64) NOT NULL,
`prefs` text NOT NULL,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`username`,`db_name`,`table_name`)
)
COMMENT='Tables'' UI preferences'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__relation`
--
CREATE TABLE IF NOT EXISTS `pma__relation` (
`master_db` varchar(64) NOT NULL default '',
`master_table` varchar(64) NOT NULL default '',
`master_field` varchar(64) NOT NULL default '',
`foreign_db` varchar(64) NOT NULL default '',
`foreign_table` varchar(64) NOT NULL default '',
`foreign_field` varchar(64) NOT NULL default '',
PRIMARY KEY (`master_db`,`master_table`,`master_field`),
KEY `foreign_field` (`foreign_db`,`foreign_table`)
)
COMMENT='Relation table'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__table_coords`
--
CREATE TABLE IF NOT EXISTS `pma__table_coords` (
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`pdf_page_number` int(11) NOT NULL default '0',
`x` float unsigned NOT NULL default '0',
`y` float unsigned NOT NULL default '0',
PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`)
)
COMMENT='Table coordinates for phpMyAdmin PDF output'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__table_info`
--
CREATE TABLE IF NOT EXISTS `pma__table_info` (
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`display_field` varchar(64) NOT NULL default '',
PRIMARY KEY (`db_name`,`table_name`)
)
COMMENT='Table information for phpMyAdmin'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__tracking`
--
CREATE TABLE IF NOT EXISTS `pma__tracking` (
`db_name` varchar(64) NOT NULL,
`table_name` varchar(64) NOT NULL,
`version` int(10) unsigned NOT NULL,
`date_created` datetime NOT NULL,
`date_updated` datetime NOT NULL,
`schema_snapshot` text NOT NULL,
`schema_sql` text,
`data_sql` longtext,
`tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') default NULL,
`tracking_active` int(1) unsigned NOT NULL default '1',
PRIMARY KEY (`db_name`,`table_name`,`version`)
)
COMMENT='Database changes tracking for phpMyAdmin'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__userconfig`
--
CREATE TABLE IF NOT EXISTS `pma__userconfig` (
`username` varchar(64) NOT NULL,
`timevalue` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`config_data` text NOT NULL,
PRIMARY KEY (`username`)
)
COMMENT='User preferences storage for phpMyAdmin'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__users`
--
CREATE TABLE IF NOT EXISTS `pma__users` (
`username` varchar(64) NOT NULL,
`usergroup` varchar(64) NOT NULL,
PRIMARY KEY (`username`,`usergroup`)
)
COMMENT='Users and their assignments to user groups'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__usergroups`
--
CREATE TABLE IF NOT EXISTS `pma__usergroups` (
`usergroup` varchar(64) NOT NULL,
`tab` varchar(64) NOT NULL,
`allowed` enum('Y','N') NOT NULL DEFAULT 'N',
PRIMARY KEY (`usergroup`,`tab`,`allowed`)
)
COMMENT='User groups with configured menu items'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__navigationhiding`
--
CREATE TABLE IF NOT EXISTS `pma__navigationhiding` (
`username` varchar(64) NOT NULL,
`item_name` varchar(64) NOT NULL,
`item_type` varchar(64) NOT NULL,
`db_name` varchar(64) NOT NULL,
`table_name` varchar(64) NOT NULL,
PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`)
)
COMMENT='Hidden items of navigation tree'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__savedsearches`
--
CREATE TABLE IF NOT EXISTS `pma__savedsearches` (
`id` int(5) unsigned NOT NULL auto_increment,
`username` varchar(64) NOT NULL default '',
`db_name` varchar(64) NOT NULL default '',
`search_name` varchar(64) NOT NULL default '',
`search_data` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`)
)
COMMENT='Saved searches'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__central_columns`
--
CREATE TABLE IF NOT EXISTS `pma__central_columns` (
`db_name` varchar(64) NOT NULL,
`col_name` varchar(64) NOT NULL,
`col_type` varchar(64) NOT NULL,
`col_length` text,
`col_collation` varchar(64) NOT NULL,
`col_isNull` boolean NOT NULL,
`col_extra` varchar(255) default '',
`col_default` text,
PRIMARY KEY (`db_name`,`col_name`)
)
COMMENT='Central list of columns'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__designer_settings`
--
CREATE TABLE IF NOT EXISTS `pma__designer_settings` (
`username` varchar(64) NOT NULL,
`settings_data` text NOT NULL,
PRIMARY KEY (`username`)
)
COMMENT='Settings related to Designer'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `pma__export_templates`
--
CREATE TABLE IF NOT EXISTS `pma__export_templates` (
`id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(64) NOT NULL,
`export_type` varchar(10) NOT NULL,
`template_name` varchar(64) NOT NULL,
`template_data` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `u_user_type_template` (`username`,`export_type`,`template_name`)
)
COMMENT='Saved export templates'
http://sourceforge.net/projects/xampp/files/XAMPP%20Linux/5.6.12/
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
Я пытаюсь настроить свою базу данных в MySQL с помощью XAMPP. Я делаю это через phpMyAdmin на localhost (работает Apache). Единственное действие с моей стороны — это ввести новое, неиспользуемое имя для базы данных, нажать «Создать» и…
возникает эта ошибка:
Error
SQL query: DocumentationEdit Edit
SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'stuff_tessss' AND `table_name` = '' AND FIND_IN_SET('CREATE DATABASE',tracking) > 0
MySQL said: Documentation
# 1932 — Таблица «phpmyadmin.pma__tracking» не существует в двигателе
База данных отображается в списке баз данных. Если вам нужно щелкнуть по одному, это займет целую вечность, а не день, чтобы не загрузить.
Я пробовал исследовать и реализовывать другие решения ошибок 1932 в стеке и других местах, но безрезультатно.
Ниже приведены следующие версии технологии, которую я использую:
- OS X El Capitan — 10.11.1
- Версия сервера: Apache/2.4.16 (Unix)
- PHP 5.6.15 (мне пришлось переустановить с -intl расширениями, потому что CakePHP жаловался на зависимость)
- CakePHP 3.0 (для этого требуется установка Composer для использования cakePHP из командной строки, которая, как мне кажется, убегает от PHP)
- mySQL Ver 14.14 Распространение 5.7.9 для osx10.11 (x86_64)
- XAMPP 5.6.14-4
Я читал всевозможные решения, такие как запуск в Linux или использование более старой версии XAMPP и т.д. Я подумал, что есть более умный человек, который может знать решение. Мне в основном приходилось пытаться выяснить, где искать исследования.
Если кто-то может указать мне в правильном направлении, я бы очень признателен!
Question: When attempting a mysqldump on one of the databases on a MariaDB server with this command I received the error message mysqldump: Got error: 1932: «Table ‘schema1.myTable’ doesn’t exist in engine» when using LOCK TABLES
mysqldump -u myun -p database_name > /mariadb/backups/mydb1171117.sql
Description: Backup of [~myDB1~] MySQL database failed. The error message [~mysqldump: Couldn’t execute ‘show create table `my_code`’: Table ‘mydb1.my_code’ doesn’t exist in engine (1932) ~] is received during backup.
Source: myserver1, Process: MySqlBackupChil
How can I fix? In summary — some files were moved around and this has caused the issue
Answer:I’ve found this error message appears when files have been moved around incorrectly.
Test 1 — Try a native MariaDB backup and see if the same error occurs
mysqldump -u myun -p database_name > /mariadb/backups/mydb1171117.sql
mysqldump: Got error: 1932: «Table ‘myschema.mytable’ doesn’t exist in engine» when using LOCK TABLES
Test 2 — check to see if table exists
use db;
show tables;
Yes it appears in list . The reason «show tables;» works is because mysqld will scan the database directory for .frm files only. As long as they exist, it sees a table definition.
Test 3 — Tried --skip-lock-tables parameter
Try to use --skip-lock-tables parameter with mysqldump to skip lock tables, like in the example below:
mysqldump --skip-lock-tables -u myun -p database_name > /mariadb/backups/mydb1171117.sql
mysqldump: Couldn’t execute ‘show create table `mytable`’: Table ‘myschema.mytable’ doesn’t exist in engine (1932)
Test 4 — Check permissions — it should be mysql both group and owner
grep datadir /etc/my.cnf
ls -la /my_data_dir/mysql/data
Test 5 — If problem persists — try a TABLE REPAIR
mysqlcheck —repair mydb -uroot -p
status : Operation failed
myschema.myTable
Error : Table ‘myschema.myTable’ doesn’t exist in engine
The tests above are a range of tests to establish some basic checkouts. Mainly this error occurs when these situations exist
1) InnoDB tablespace was deleted and recreated but related InnoDB table.frm files from the db directory were not removed.Another option is .frm files were moved to a different database
2)Incorrect permissions and ownership on table’s files in MySQL data directory — check Test 4 above
3) MariaDB table data is corrupted
!
Author: Rambler (http://www.dba-ninja.com)
Share:
Using version «10.1.0-MariaDB-log — Source distribution» on MacOS X Server 10.6.8 via phpMyAdmin 4.1.8 using raw SQL, I recently used ALTER TABLE to add a VIRTUAL column to a table that was the simple difference between two columns: «ALTER TABLE s_vehicle_log ADD COLUMN v_distance INT(5) AS (odometer — begin) AFTER odometer».
This first appeared to work; I could see the new column in phpMyAdmin and it appeared to have the proper values. But within an hour, I could no longer access that table.
Going into the mysql CLI, executing «SELECT count(*) FROM s_vehicle_log;» yields «ERROR 1932 (42S02): Table ‘EcoReality.s_vehicle_log’ doesn’t exist in engine» (I do the same on other tables in the same database successfully.)
Going into the shell (bash), I can see the proper files, and they have the same perms as other tables that work properly:
# ls -l s_vehicle_* -rw-rw---- 1 _mysql _mysql 1264 Feb 12 18:40 s_vehicle_cost.frm -rw-rw---- 1 _mysql _mysql 98304 Feb 12 18:40 s_vehicle_cost.ibd -rw-rw---- 1 _mysql _mysql 3796 Jul 15 15:56 s_vehicle_log.frm -rw-rw---- 1 _mysql _mysql 688128 Jul 15 15:56 s_vehicle_log.ibd -rw-rw---- 1 _mysql _mysql 2583 Feb 12 18:40 s_vehicle_monthly_query.frm
It is interesting that, though ERROR 1932 says the table doesn’t exist, phpMyAdmin shows it in the list of tables, showing «in use» as its table type:
s_vehicle_cost Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~11 InnoDB latin1_swedish_ci 16 KiB -
s_vehicle_log Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop in use
mysql SHOW TABLE STATUS isn't very helpful, either:
MariaDB [EcoReality]> show table status like 's_vehicle_%'
-> ;
+-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------------------------------------------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------------------------------------------+
| s_vehicle_cost | InnoDB | 10 | Compact | 11 | 1489 | 16384 | 0 | 0 | 0 | NULL | 2015-02-12 18:40:32 | NULL | NULL | latin1_swedish_ci | NULL | | Cost per km of vehicles over time. |
| s_vehicle_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Table 'EcoReality.s_vehicle_log' doesn't exist in engine |
| s_vehicle_monthly_query | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Table 'EcoReality.s_vehicle_log' doesn't exist in engine |
+-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------------------------------------------+
3 rows in set, 2 warnings (0.00 sec)
Looking at the most recent file that seems to be a binlog reveals nothing of interest; just phpMyAdmin logging queries about the damaged table:
# mysqlbinlog ../mysql-bin.000127 | fgrep s_vehicle_log
REPLACE INTO `phpmyadmin`.`pma__table_uiprefs` VALUES ('root', 'EcoReality', 's_vehicle_log', '[]', NULL)
REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"},{"db":"EcoReality","table":"s_shares"}]')
REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"},{"db":"EcoReality","table":"s_shares"}]')
REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"},{"db":"EcoReality","table":"s_shares"}]')
repair table s_vehicle_log
REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"},{"db":"EcoReality","table":"s_shares"}]')
REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_vehicle"},{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"}]')
----------------
Anyone know what’s going on, and what to do about it? (Besides «restore from backup,» which is a bit old.)
I am trying to set up my database in MySQL using XAMPP. I am doing this via phpMyAdmin on localhost(Apache is running). The only action on my part is typing in a new, unused, name for a database, click create and…
this error occurs:
Error
SQL query: DocumentationEdit Edit
SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'stuff_tessss' AND `table_name` = '' AND FIND_IN_SET('CREATE DATABASE',tracking) > 0
MySQL said: Documentation
#1932 — Table ‘phpmyadmin.pma__tracking’ doesn’t exist in engine
The database is showing in the list of databases. If you were to click on one, it takes forever and a day to not load.
I’ve tried researching and implementing the other 1932 error solutions on stack and other places but to no avail.
Here are the following versions for the tech I am utilizing:
- OS X El Capitan — 10.11.1
- Server version: Apache/2.4.16 (Unix)
- PHP 5.6.15 (i had to reinstall with -intl extensions because CakePHP was complaining about a dependency)
- CakePHP 3.0 (this required installation of Composer to utilize cakePHP from command line, which I believe runs off of PHP)
- mySQL Ver 14.14 Distrib 5.7.9, for osx10.11 (x86_64)
- XAMPP 5.6.14-4
I’ve read all sorts of solutions such as run it in Linux, or using an older version of XAMPP, etc. I figured there is a smarter person out there who might know the solution. I mainly had a hard time trying to figure out where to research, as well.
If anyone who could point me in the right direction I would greatly appreciate it!
This question is related to
mysql
apache
phpmyadmin
xampp
Finally, I find the solution.
We can find there really exists the table ‘pma__tracking’ when we expand the phpmyadmin database.
But the system error call on #1932 — Table ‘phpmyadmin.pma__tracking’ doesn’t exist in engine.
So just try to remove the old pma__* database first and reconfig them later.
1.Remove the wrong tables in xampp’s installation path and remove all the files in var/mysql/phpmyadmin/, which are similar like pma__bookmark.frm/pma__bookmark.ibd…
2.Reinstall the sql of phpmyadmin, which located in phpmyadmin/sql/, something like ‘create_tables.sql’, run them with mysql < create_table.sql, etc.
Then it works.
Today I ran into a strange MySql (MariaDB) error. Strange because I’m working with Oracle databases since 1991, so I’m used to drop indexes since years (moslty temporary to speed up huge bulk inserts, e.g. on a predefinded set of full load inserts, to create the index afterwards again), so ….
… I dropped an FK index on my MySql table (note: not dropping the FK constraint).
No problem on Oracle, but MySql seems to have a problem on FK constraints without index. Now, EVERY access to this table shows:
#1932 – Table ‘schema.importanttable’ doesn’t exist in engine
The same error on all sql clients as PhpMyAdmin or even with a Java JDBC class.
Check mysql_error.log: 2019-12-22 17:24:54 19652 [Warning] InnoDB: Load table ‘schema/importanttable’ failed, the table has missing foreign key indexes. Turn off ‘foreign_key_checks’ and try again. –> ok here I found out the problem with the dropped FK index!
2019-12-22 17:25:00 20348 [Warning] InnoDB: Load table ‘schema/importanttable’ failed, the table has missing foreign key indexes. Turn off ‘foreign_key_checks’ and try again.
2019-12-22 17:25:00 20348 [Warning] InnoDB: Cannot open table schema/importanttable from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem
Ok, I simply try to create the FK index again, but I still get error #1932
ALTER TABLE `importanttable` ADD KEY `othertable_id` (`othertable_id`)
2019-12-22 17:24:54 19652 [Warning] InnoDB: Load table ‘schema/importanttable’ failed, the table has missing foreign key indexes. Turn off ‘foreign_key_checks’ and try again.
Google search: MYSQL “the table has missing foreign key indexes”, I found this solution
— Do not check foreign key constraints
SET FOREIGN_KEY_CHECKS = 0;
SET GLOBAL FOREIGN_KEY_CHECKS = 0;
— create the FK index again (now this works! may have to try twice….)
ALTER TABLE `importanttable` ADD KEY `othertable_id` (`othertable_id`)
— Specify to check foreign key constraints (this is the default)
SET FOREIGN_KEY_CHECKS = 1;
SET GLOBAL FOREIGN_KEY_CHECKS = 1;
Problem solved!
Hope this might help other people with the same MySql (MariaDB) Problem