Re: [MDB2] Way to dump existing DB into XML-schema file?
| From: | Lukas Smith | Date: | Thu, 22 Apr 2004 20:15:25 +0000 |
| Subject: | Re: [MDB2] Way to dump existing DB into XML-schema file? | ||
| References: | 1 2 3 4 5 6 7 8 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-12064@lists.php.net to get a copy of this message | ||
Thorsten Suckow-Homberg wrote:
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?yeah exactly what i was guessing .. the problem is in the portability options .. in MDB try to set the option "optimize" to "portability" .. but I dont have the nerve to debug this tonight sorry .. should have a fix in about 20 hours :-) regards, Lukas Smith smith@backendmedia.com _______________________________ BackendMedia www.backendmedia.com berlin@backendmedia.com Linn Zwoch Smith GbR Pariser Str. 44 D-10707 Berlin Tel +49 30 83 22 50 00 Fax +49 30 83 22 50 07