266 Part II . SQL Essentials –fields-terminated-by= –fields-enclosed-by= –fields-optionally-enclosed-by= –fields-escaped-by= –lines-terminated-by= The first switch, –quote-names, places backquotes (`) around the names of tables and databases. The second switch, –tab=, can also be abbreviated as -T. The –tab=switch causes mysqldumpto create two files, placing output from each table in the argument list. One file
.sqlis the normal output of the DDL that you would expect from mysqldump. The second file,
.txt, is a tab-delimited file containing only the data from the table. Tip The –tab= switch can be useful for importing data into other applications such as Microsoft Access. The –tab= or -T switch expects a directory or path as an argument, in effect, using –tab=outputdirwill cause the results to be placed in a directory called outputdir. It is important that MySQL have permission to write into that directory. For this reason, the –tab= switch only works when run from the server that mysqld runs on. A few examples of the –tab=switch are shown in Figure 10-32. The first attempt is unsuccessful because the specified directory does not exist. In the second attempt, the MySQL server does not have permission to write into the directory specified. The final attempt is successful. Figure 10-32: Three examples of use of the –tab= switch, two unsuccessful and one successful
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check mysql web server services.
This entry was posted
on Tuesday, August 28th, 2007 at 6:13 am and is filed under Domain.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.