content_image/846030.jpg
## • --tz-utc 

This option enables TIMESTAMP  columns to be dumped and reloaded between servers in different time zones. mysqldump  sets its connection time zone to UTC and adds SET TIME_ZONE=’+00:00’  to the dump file. Without this option, TIMESTAMP  columns are dumped and reloaded in the time zones local to the source and destination servers, which can cause the values to change if the servers are in different time zones. --tz-utc  also protects against changes due to daylight saving time. --tz-utc  is enabled by default. To disable it, use --skip-tz-utc . 

## • --xml , -X 

Write dump output as well-formed XML. 

NULL , ’NULL’ , and Empty Values : For a column named column_name , the NULL  value, an empty string, and the string value ’NULL’  are distinguished from one another in the output generated by this option as follows. 

<img src='content_image/846030.jpg'>

The output from the mysql  client when run using the --xml  option also follows the preceding rules. (See Section 4.5.1.1, “mysql Client Options” .) 

XML output from mysqldump  includes the XML namespace, as shown here: 

shell> mysqldump --xml -u root world City <?xml version="1.0"?> <mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <database name="world"> <table_structure name="City"> <field Field="ID" Type="int(11)" Null="NO" Key="PRI" Extra="auto_increment" /> <field Field="Name" Type="char(35)" Null="NO" Key="" Default="" Extra="" /> <field Field="CountryCode" Type="char(3)" Null="NO" Key="" Default="" Extra="" /> <field Field="District" Type="char(20)" Null="NO" Key="" Default="" Extra="" /> <field Field="Population" Type="int(11)" Null="NO" Key="" Default="0" Extra="" /> <key Table="City" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="ID" Collation="A" Cardinality="4079" Null="" Index_type="BTREE" Comment="" /> <options Name="City" Engine="MyISAM" Version="10" Row_format="Fixed" Rows="4079" Avg_row_length="67" Data_length="273293" Max_data_length="18858823439613951" Index_length="43008" Data_free="0" Auto_increment="4080" Create_time="2007-03-31 01:47:01" Update_time="2007-03-31 01:47:02" Collation="latin1_swedish_ci" Create_options="" Comment="" /> </table_structure> <table_data name="City"> <row> <field name="ID">1</field> <field name="Name">Kabul</field> <field name="CountryCode">AFG</field> <field name="District">Kabol</field> <field name="Population">1780000</field> </row> ... <row> <field name="ID">4079</field> 

