On Jul 29, 2009, at 3:52 AM, Michal Čihař wrote:
( 1 ) Create and Select the database ( 2 ) Click on SQL icon ( 3 ) Click on "Import Files" link ( 4 ) Import the file containing the Structure and Data ( 5 ) Try to select a table to view the records
( 6 ) Everything appears fine, but as soon as I try to select a Table to view the records, phpMyAdmin crashes.
What does mean it crashes? You get some error message?
No, the application does a hard crash, It Quits Instantly, NO warning... The next thing I see is a dialog sending Apple the crash dump info...
I worked quite a bit yesterday in phpMyAdmin with databases that had been created in Navicat, and had absolutely NO problems. The crashes occur when I am trying to import a Structure and Data that originated from either Navicat, or from phpMyAdmin. phpMyAdmin will export the Structure and Data via a dump, but the if I delete (drop) the database using phpMyAdmin, everything appears fine. I can then create a new database with the same name, and then if I try to import the dump, it appears OK, but when I select a table, there is an instant crash...
One other thing, when I log into phpMyAdmin, it lets me in the door, but as soon as I select a database, it immediately takes me back to the Login Screen and makes me login again.
There is some timeout depending on your PHP configuration (session gc) and phpMyAdmin, maybe you just hit the limit.
-- ( 3 ) phpMySQL : DOES a lot of the keywords in lowercase, not all
Can you tell which ones? I think we should be consistent here if possible.
I can send you a database dump from Navicat and one from phpMyAdmin if you would like, I also wrote a script to try to standardize the dump from phpMyAdmin in order to run a diff with BBEdit. I would be happy to send the script as well, but it requires BBEdit...
-- ( 6 ) NAVICAT : On the INSERT statements Navicat does not list the fields before the VALUES -- ( 6 ) INSERT INTO `projects` VALUES('1','mvc_begin','Use Zend Framework to work with a Model, View, Controller PHP System','null','null','Bill Hernandez');
You can configure this on export page.
I like the way phpMyAdmin does this better with the field names included...
Thanks for the prompt reply...
Best Regards,
Bill Hernandez Plano, Texas