Chapter 10 . Databases And (Web site traffic) Data 265 Figure
Chapter 10 . Databases And Data 265 Figure 10-31: The -d or –no-data switch causes mysqldump to exclude the DML or INSERT statements from the output. Caution Using the –add-drop-table switch will cause all data to be lost in any tables that are removed. mysqldump also includes a switch that can specify a number of the previously discussed options as well as others. The switch is the –opt switch and includes the switches –add, –add-drop-tables, –add-locks, –extended-insert, -lock- tables, and –quick. Tip If you are going to use the –add, –add-drop-tables, –add-locks, -extended- insert, –lock-tables, or –quick switch, specifying the –opt switch is a timesaver. Special formatting functions with mysqldump With mysqldumpyou can specify a number of options that determine how the output will look. These include special quotation of fields in the output, escaping or enclosing the fields in a special manner, and terminating lines and fields with the desired character. The switches or options to specify on the mysqldumpcommand line are as follows: –quote-names –tab=
Note: In case you are looking for affordable and reliable webhost to host and run your j2ee application check Vision J2ee Web Hosting services.