Hi
Dne Tue, 28 Jul 2009 19:55:45 -0500 Bill Hernandez ms@mac-specialist.com napsal(a):
I have been reading in an sql file that creates some tables, triggers, adds a few records. There's less than 10 records involved and 3 tables.
( 1 ) 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?
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.
-- ( 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.