Linked Questions

19
votes
5answers
67k 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 ...
10
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
12k 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
2k 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
624 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
977 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
489 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
140 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 ...