Business web site - 268 Part II . SQL Essentials Figure 10-35:
268 Part II . SQL Essentials Figure 10-35: The mysqldump -p ecommerce –lines-terminated- by= HELLO –tab=outputdir command is run to terminate lines by the word HELLO. Figure 10-36: The mysqldump -p ecommerce –fields-enclosed-by= \ –tab=outputdir command to produce output with a backslash around the fields. Note the use of two slashes in the actual command. The all-databases function There are two macro-level functions to dump all databases with mysqldump. With such functions it is possible to make a backup copy of an entire database server though MySQL AB recommends that you use the mysqlhotcopy utility for this purpose. Cross-The mysqlhotcopy utility for making backups is covered in Chapter 14. Reference The first option, –all-databases or -A, dumps all databases, including database structure and data. The –all-databasesoption also creates the actual databases as well. In Figure 10-37 the –all-databases macro serves to dump all databases contained on my example server. The command to run is as follows: mysqldump -A -p
We recommend cheap and reliable webhost to host and run your web applications: Coldfusion Web Hosting services.