Chapter 10 (Hp web site) . Databases And Data 263 Figure
Chapter 10 . Databases And Data 263 Figure 10-29: Using the –where= switch to specify only certain records to be dumped Suppressing DDL In the examples in Figure 10-30, you may have noticed an extra option: -t (also known as –no-create-info), which suppresses the DDL or the statements that would otherwise create the table. The -t option can be useful for making a quick backup of the data in a table. For example, if you have another server that contains the same table structure and only want to migrate your data to the new server, you could suppress the DDL with the -toption. The result is the DML or statements to insert the data into the table or tables. Suppressing DML and data Just as you might want to suppress the printing of table creation statements in the output of a mysqldump, you might also want to suppress the actual DML or insert statements from the output as well. The switch for this option is -d or –no-data.
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check mysql web server services.