guilliam

[quote] a. "Enclose export in a transaction" - This only matters for InnoDB tables, or if you're importing into a live site. b. "Disable foreign key checks" - Same thing -- InnoDB allows for FK constraints, which complain if the records are inserted in the "wrong" order. c. "Add DROP TABLE" - Drops the table before creating it, in case it already exists. d. "Add IF NOT EXISTS" - Only creates the table if it doesn't already exist. e. "Complete inserts" - Add any default values to be explicitly specified in the VALUES() part of the INSERT (e.g. uid). f. "Extended inserts" - Combines many INSERTs together -- i.e. many VALUE()s are added in each insert (this is faster). g. Maximum length of created query - So that you don't exceed the max query size (e.g. 2048 KB). h. "Use delayed inserts" - Runs the INSERTs delayed, so that the client doesn't wait to get confirmation of each insert. i. "Use ignore inserts" - Runs the insert with the ignore option, so errors are supressed (use with caution). [/quote] ^^just to consolidate the definition side by side. this is very helpful to all those new to phpmyadmin and importing/exporting. - g