I am getting a weird error in my mysql database:
SELECT * FROM mytable
ERROR 1932 (42S02): Table 'mydb.mytable' doesn't exist in engine
I can confirm that the tables do indeed exist on local file system and
show tables; does indeed return the tables I am interested in.
show tables; +-----------------+ | Tables_in_mydb | +-----------------+ | presets | | mytable | +-----------------+
And the select:
select * from mytable; Table 'mydb.mytable' doesn't exist in engine.
Error makes absolute no sense and I’ve been working with this tables a couple of days ago without any problems. I haven’t moved the tables. What should I do?
Before that error above showed up I was getting an error:
Access denied for user ‘root’@’localhost’ (using password: YES), but I successfully updated the password. I have no idea what triggered this error because I haven’t played with passwords.
However, when I tried to fix this error I have set permissions on
/Applications/XAMPP/xamppfiles/var/mysql to read/write to everyone.
I have physical access to .frm and .ibd files of the database. I believe I use InnoDB storage engine.
✓ Extra quality
ExtraProxies brings the best proxy quality for you with our private and reliable proxies
✓ Extra anonymity
Top level of anonymity and 100% safe proxies – this is what you get with every proxy package
✓ Extra speed
1,ooo mb/s proxy servers speed – we are way better than others – just enjoy our proxies!
USA proxy location
We offer premium quality USA private proxies – the most essential proxies you can ever want from USA
99,9% servers uptime
No usage restrictions
Perfect for SEO
We are working 24/7 to bring the best proxy experience for you – we are glad to help and assist you!