Can't display table's content on new platform

[lupidol]

Hello everyone,
I moved into a new computer and copied databases from the old machine's MySQL databases
located in c:\xampp\mysql\data\dbname to the new machine.
When I tried to show table's content I get an error message that says:
"table dbname.tablename doesnt exist" but when I type: "show tables" it shows up !
Attached is a screenshot shows a folder's content of c:\xampp\mysql\dbname where table
"employers" exists and a screeshot of MySQL interface where table "employers" shows up
when I type: "show tables" but when I type: "select * from employers" I get an error
message says that it doesn't exist !
Can anyone help me with make that table come to life again?
Thanks !

 

[feherke]

Hi

That dash ( - ) in the table name yells for quoting, so I would try :

[b]select[/b] * [b]from[/b] [COLOR=red yellow]`[/color]index-employers[COLOR=red yellow]`[/color]

Feherke.
feherke.ga

 

[lupidol]

Thanks,
It didn't work like I expected because I had another try on a table without a dash at its' name: "Select * from emps" and received an error message that says:
"Table allavdut.emps doesn't exist".

 

[feherke]

Hi

Maybe there is some special character in that table's name ? Like a trailing whitespace character. Or written with cyrillic e instead of latin e.

I would run [tt]mysqldump -Qd allavdut | grep 'CREATE TABLE'[/tt] and check the exact spelling of that table's name.


Feherke.
feherke.ga

 

[lupidol]

I doubt it because I tried many other tables and it all ended the same error. Anyway, I'll try what you wrote, tomorrow.
Thanks a lot

 

[lupidol]