Not sure if this is a tough one or an easy one. Take a shot at it - maybe you can solve it.
I have a production server running 3.23.36-log, and I just set up a development box about a week ago. The development box was intended for testing out new versions of things, so we had MySQL 3.23.42 on there. Now we want to mimic the production server and put 3.23.36 on there, among other things. So I copied over the document root from the production server to the development box, which included phpMyAdmin. I then deinstalled 3.23.42 (a FreeBSD port), and downloaded the source for 3.23.36. I configured it as follows: ./configure --prefix=/usr/local/mysql-3.23.36-debug --with-unix-socket-path=/tmp/mysql.sock --localstatedir=/cartman/mysql --with-debug I ran make and make install and everything went fine. My original databases were in place, but when I tried to load up phpMyAdmin, it connected, and showed the normal phpMyAdmin page, but displayed small icons (the expand/shrink menu icon box-thingy) in the menu for each database, which is normal, but there were no database names next to the icons, which is not normal. I figured that perhaps it was the original databases that were incompatible for some reason. The only difference between the production and development versions was that the development version had debugging enabled (as shown in the configure line above). I then shut down MySQL, renamed the database directory, and created a new one in its place, and ran the mysql_install_db script to put in the default mysql and test databases, which worked fine. I updated the root password so that it matched the old one in phpMyAdmin's config file, and ran phpMyAdmin again. I have the same story - with icons for both mysql and test, but I don't see their names - just two icons. If I try to create a new database from phpMyAdmin (for example, 'devtest'), I get an error, but the 'devtest' directory gets created correctly. If I use the command-line 'mysql' program, I can see all the databases with "SHOW DATABASES" and tables with "SHOW TABLES", etc... I thought maybe it was a corrupted version of MySQL, but I tried another version and it had the same effect. I know it is CONNECTING because phpMyAdmin will die on me if I change the connection info to something incorrect, not to mention that it somehow knows the NUMBER of databases, because it shows one icon per database. Is there a problem with enabling debugging that causes other programs like this to fail? - Jonathan --------------------------------------------------------------------- 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
