Ack!!!!
Case sensitivity of table names gets screwed up when doing stuff with PHP/MySQL on Windows!! (Windows 95 in this case - yes, more paleo-computing!). I am using this set of canned scripts: phpslice v 0.2.0. The scripts have been installed successfully in multiple places on UNIX, been using it with success. The code in phpslice refers to tables with mixed case and the database creation scripts use mixed case names to create the tables. Works fine. The tables ended up being created in all low case when input through mysql.exe < createtables.sql. The weird part is that the scripts worked even though they were referencing mixed case table names that did not exist. Sounds like a windows thing for sure. Doing an export of the data to move to Solaris, wrote the tables all out in low case as the tables all existed with low case names at that point. So phpMyAdmin doesn't know any better at that point. I guess word to the wise, when moving back and forth between Windows and *NIX pay attention to the case of tables and what not in addition to the normal CF/LF issues. This is so dumb I could just scream. Didn't we solve low case and upper case issues between platforms in the 1980s? Ugh. Time for a coffee break. Anyway, thanks all that tried to help. I appreciate it. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
