Re: [MDB2] Way to dump existing DB into XML-schema file?
| From: | Thorsten Suckow-Homberg | Date: | Thu, 22 Apr 2004 20:11:22 +0000 |
| Subject: | Re: [MDB2] Way to dump existing DB into XML-schema file? | ||
| References: | 1 2 3 4 5 6 7 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-12062@lists.php.net to get a copy of this message | ||
I think I tracked it down...
U are using
SHOW INDEX FROM $table
for getting the table-definitions of a database.
Using phpmyadmin with this, I get a table in which the names of the columns
are all starting with an Upper-Case. This names are used in your scripts,
but u are ignoring the upper-case and using the array-keys as lower-case.
Exaple:
File mysql.php
Line 880: $key_name = $row['key_name'];
Changing this into
$key_name = $row['Key_name'];
works good for me. I have set error-reporting to E_ALL so I get sometimes a
notice because of a not set array-key, but the schema-file is created
nonetheless.
Any comments/hints on this?