Linked Questions

19
votes
5answers
69k views

Cannot open table mysql/innodb_index_stats [duplicate]

After a fresh install of XAMPP and import from my linux live db that is working to the windows Dev-stage, I started encountering problems with INSERT. Everything else seems to work well. The errors I ...
11
votes
3answers
15k views

ERROR - Function 'innodb' already exists

I'm looking to start converting some MyISAM tables to INNODB. Running Ubuntu 14.04 Server with MySQL 5.6 ( apt-get upgraded from 5.5 ), 32G ram on 4 core/ 8 thread cpu. Initially had trouble with... ...
3
votes
1answer
15k views

InnoDB: Error: Table “mysql”.“innodb_table_stats” not found

I've got the same error, although I'm running galera cluster with 3 nodes. I tried following the instructions from InnoDB: Error: Table "mysql"."innodb_table_stats" not found after ...
6
votes
1answer
13k views

Any known issues upgrading from MySQL 5.1.73 to 5.6.21?

I am planning my MySQL DB ver5.1.73 running on a CentOS 6.5 machine to MySQL 5.6.21. I understand the basic procedure for this based on what I have read on StackOverflow, but I was curious if anyone ...
1
vote
2answers
3k views

ERROR 1031 (HY000): Table storage engine for 'proc' doesn't have this option

I am new to MySQL administration, and this week a customer came to me with a problem. They created an application with Wamp in a Windows Server environment. For some reason when listing the tables in ...
3
votes
2answers
3k views

Lost connection to MySQL server during DROP TABLE query: How to find out why?

I seem to have the following error: Lost connection to MySQL server during query However, I know for absolute fact that this is not about the wait_timeout nor the max_allowed_packet, as I've set ...
3
votes
2answers
654 views

Will hacking away ibdata1 destroy databases with only MyISAM tables?

I made a mistake. I have a huge database of MyISAM tables that I was playing with converting [a copy of] to InnoDB. I didn't set innodb_file_per_table=1 before doing so. I know that safely shrinking ...
1
vote
1answer
1k views

Mysql will no longer start after DB import and password change

I'm running Mysql5.6 on RHEL 7. I had managed to get the mysql service up and running, and imported a database into it with no issues. However, after attempting to reset a user's password, the ...
0
votes
1answer
515 views

How do I stop MYSQL trying to load a missing InnoDB table?

Everytime I start MySQL, I receive the error: Cannot open datafile for read-only: '.\deleteddatabase\deletedtable.ibd' OS error: 103 I can't DROP the table, because it doesn't exist. There's no ...
0
votes
2answers
141 views

Mysql Windows Issues

I've been having allot of issues with my mysql databases on Windows dying on me. About once a week or so it will refuse to work and I'll spend all night poking at it & a few computer restarts ...
1
vote
0answers
137 views

InnoDB: Error: Table “mysql”.“mysql.transaction_registry” not found after upgrade to mariadb 10.3

I've upgraded the mariadb to 10.3 packages on my Debian 10, however something went wrong and I ended in the same issue which is mentioned several times Cannot open table mysql/innodb_index_stats [...