Web and email hosting - 264 Part II . SQL Essentials Figure 10-30:
264 Part II . SQL Essentials Figure 10-30: Examples of the types of INSERT statements that can be produced by mysqldump Using the -d switch, a mysqldump will simply output the table (and possibly database) creation statements. This feature can be useful for making a skeleton copy of the database and table structure on another server. Figure 10-31 is an example of the -d switch in action, producing the DDL for the ecommercedatabase. The command for this example is as follows: mysqldump -p -d ecommerce Adding drops and locks mysqldump can be configured to add statements to lock and unlock tables around INSERT statements. Doing so ensures that the INSERT will complete without an unexpected change in the data or contention for the table. The switch to enable the locking function is –add-locks. You can also lock the tables around the reads that produce the output of mysqldump. The switch -lor –lock-tablesturns this function on. The –add-drop-tableswitch tells mysqldumpto add a DROP TABLEstatement just before creating the table. Adding this switch can be helpful if you already have tables of the same name that do not contain useful data.
Note: In case you are looking for affordable and reliable webhost to host and run your j2ee application check Vision J2ee Web Hosting services.