Chapter 10 . Databases And (Web hosting providers) Data 261 database
Chapter 10 . Databases And Data 261 database the IF NOT EXISTS keywords were introduced in version 3.23.12 of MySQL. The keywords IF NOT EXISTS will be enclosed in an escape sequence along with the version number. This allows the functionality of IF NOT EXISTS to be used by those versions that can handle it and safely ignored without error on those versions that do not include the function. Normal usage of mysqldumpcalls for the command along with options such as user- name and password followed by the name of the database to dump and (optionally) specific tables and columns to dump. In Figure 10-27 the mysqldumpcommand is issued to dump just the dbtable of the MySQL grants database. The command is as follows: mysqldump -p mysql db Figure 10-27: Using mysqldump to obtain the DDL and DML for one table of one database For most of its uses, mysqldumpredirects the output to a file instead of sending the output to stdoutor to the screen (which is the default). The characters used to redirect output can vary by OS: . In Linux, you perform redirect operations with the greater-than (>) sign. . In Windows, use the -ror –result-file= switch with mysqldump, which assists the newline and carriage return.
We highly recommend you visit web and email hosting services if you need stable and cheap web hosting platform for your web applications.