backup error!

[adnan1983]

I have been trying to backup my tables using phpmyadmin. Everytime I click exports, it gives me a weird error.

SQL-query :

SHOW TABLE STATUS LIKE 'vote' FROM 'vote'

MySQL said:

You have an error in your SQL syntax near 'FROM 'vote'' at line 1

Can anyone tell me how I can fix this?

[Drakla]

you have a database called "Vote" with a table called "Vote" in it?

[adnan1983]

my database is called adnan, with a table in it called vote.

[Drakla]

In that case your query should be

SHOW TABLE STATUS FROM adnan LIKE 'vote';

Or just

USE adnan;
SHOW TABLE STATUS LIKE 'vote';