Import with mysql 5.0.67

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Import bdd with mysql 5.0.67
2. You sea an error php that explain a problem in query SELECT * FROM
TABLES WHERE TABLE_SCHEMA = '".$db."'"

What is the expected output? What do you see instead?
You sea an error php that explain a problem in query SELECT * FROM TABLES
WHERE TABLE_SCHEMA = '".$db."'" in a reponse

What version of the product are you using? On what operating system?
I'm using mysql 5.0.67 in local environement on linux

Please provide any additional information below.
In mysql 5 the query SELECT * FROM TABLES WHERE TABLE_SCHEMA = 'XXX' was
replace by SHOW TABLES FROM 'XXX'. The same problème occur with this query
SELECT * FROM COLUMNS WHERE TABLE_NAME, she was replace by SHOW COLUMNS
FROM 'TABLE' FROM 'DB'; 

Original issue reported on code.google.com by benoit.2...@gmail.com on 20 Dec 2009 at 8:09

[GoogleCodeExporter]

I cannot agree here. MySQL 5 *uses* the information_schema to store table/column
metadata, one can easily verify that. On my linux box with MySQL 5.0.51, I can 
do:

mysql> use information_schema;
mysql> describe tables;
mysql> describe columns;

Both "describe" statements show that there truly *are* TABLES and COLUMNS 
tables.
Therefore, I believe that your issue is caused by something else.

Original comment by ondrej.zara on 20 Dec 2009 at 8:27

[GoogleCodeExporter]

I agree with you, the catalog database itself is a database containing the 
metadata
but i am a problem, after several test I can pass the query if i'was logged on 
the
basis INFORMATION_SCHEMA. 

setup_import function () (
define ( "SERVER", "localhost");
define ( "USER", "root");
define ( "PASSWORD", "xxxxxx");
define ( "DB", "INFORMATION_SCHEMA");
)

In the $ _GET, I pass the name of my database ...

and it's work

Best regards

Original comment by benoit.2...@gmail.com on 20 Dec 2009 at 9:10

[GoogleCodeExporter]

Original comment by ondrej.zara on 3 Jan 2010 at 7:21

• Changed state: Invalid