next »

[Otico]

Hi there,
within the SitePusher-module you use the script named mysql.php, and in this a command
SHOW TABLES FROM $dbname;
which does not work with my host.
My hoster only gave me on mysql-database named somethong like 12345-0.
I figured out, that using 'SHOW TABLES FROM 12345-0 gives an error 1064. if I used 'SHOW TABLES' everything would work.

Here's my question: why use the FROM - as the database was selected in the mysql.php just some lines above the SHOW-command?
Could this be changed in the next release of the module?

Thanks, Otico

[leifnicholz]

This reply might be a little too late but here's what I think... You're probably getting that error because you typed in the wrong syntax. To show tables from any mysql database, you should first tell the mysql command line what table to use... you can do this by typing:

Code:

USE table_name;

Where "table_name" represent the name of the table you want to use.
Only after that can you tell mysql to show the contents of the selected table. That's why when you typed this code:

Code:

SHOW TABLES;

mysql worked properly. That's probably because the database that you are using is currently selected by default or is the only database available in your site.