diff options
| author | abhibeckert <abhi@abhibeckert.com> | 2008-04-04 11:37:36 +0000 |
|---|---|---|
| committer | abhibeckert <abhi@abhibeckert.com> | 2008-04-04 11:37:36 +0000 |
| commit | 0f586da34dac2c764a12055158e4929cf69340a1 (patch) | |
| tree | bca3868c9715a10c08017a0a7b6d5148f8bd3556 /English.lproj/english_help/topics/dump.html | |
| parent | 5fb284b7c12887b8eea6c3a02fa83abf50793992 (diff) | |
| download | sequelpro-0f586da34dac2c764a12055158e4929cf69340a1.tar.gz sequelpro-0f586da34dac2c764a12055158e4929cf69340a1.tar.bz2 sequelpro-0f586da34dac2c764a12055158e4929cf69340a1.zip | |
Initial import from (slightly modified) CocoaMySQL v0.7b4
Diffstat (limited to 'English.lproj/english_help/topics/dump.html')
| -rwxr-xr-x | English.lproj/english_help/topics/dump.html | 93 |
1 files changed, 93 insertions, 0 deletions
diff --git a/English.lproj/english_help/topics/dump.html b/English.lproj/english_help/topics/dump.html new file mode 100755 index 00000000..f50804f1 --- /dev/null +++ b/English.lproj/english_help/topics/dump.html @@ -0,0 +1,93 @@ +<html> +<head> +<title>CocoaMySQL Help - Data Dumps</title> +<meta name="AppleTitle" content="Data Dumps"> +<meta name="AppleFont" content="Lucida Grande"> +<meta ROBOTS="robots" CONTENT="anchors"> +</head> +<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0"> + +<font face="Lucida Grande,Geneva,Arial"> + +<br> + +<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80"> + <tr> + <td align="left" valign="top" width="70"> + <img src="cocoamysql_logo.jpg" width="60" height="60" border="0"> + </td> + <td align="left"><h1>Data Dumps</h1> + </td> + </tr> + <tr> + <td colspan="2"> + <img src="bar.gif" width="100%" height="20"> + </td> + </tr> +</table> + +<br> +<font size="-1"> + <a href="../index.html">Back to the main menu</a> +<br> +<br> + + In order to perform actions with data dumps, you must use the "File->Import; File->Export" menu options of CocoaMySQL. A variety +of exports/dumps can be performed: CocoaMySQL dump, Export of Table Content Results (csv or xml format), Export of Custom +Query Results (csv or xml format), or Export of Multiple Table data (csv or xml format). On the other hand, you can only import a +CocoaMySQL dump or a CSV file. +<br> +<br> +<b>CSV File Format Information</b> +<table border="0" cellpadding="5" cellspacing="0" width="100%"> + <tr> + <td bgcolor="#fff8dc" valign="top"> + <font size="-1" face="Lucida Grande,Geneva,Arial"> + <ul> + <li>You can choose the following characters: fields enclosed, fields terminated, escaped and line ends</li> + <li>The following characters are escaped: the escaped-character itself, the line ends character, the enclosed character (if given) and the fields terminated character if no enclosed character is given</li> + <li>NULL values are written without enclosed character. If it is enclosed, it is interpreted as a string.</li> + <li>When importing a csv, unenclosed \N is also interpreted as NULL (this format is used by mysqldump)</li> + <li>The recommended formats should work best. When importing, enclosed/terminated/escaped characters should be all only one character long (line ends may be longer). </li> + </ul> + </td> + </tr> +</table> + +<br> +<b>Importing Dumps</b> +<table border="0" cellpadding="5" cellspacing="0" width="100%"> + <tr> + <td bgcolor="#fff8dc" valign="top"> + <font size="-1" face="Lucida Grande,Geneva,Arial"> + <ul> + <li>Choose "File->Import" from the CocoaMySQL Menu</li> + <li>You must choose to import a CSV file (table data) or a CocoaMySQL dump (varied information)</li> + </ul> + </td> + </tr> +</table> + + +<br> +<b>Excel CSV Formatting Options</b> +<br> +If you wish to export data to a CSV file for use in Excel, use the following settings: +<table border="0" cellpadding="5" cellspacing="0" width="100%"> + <tr> + <td bgcolor="#fff8dc" valign="top"> + <font size="-1" face="Lucida Grande,Geneva,Arial"> + <ul> + <li>Enclosed by: " (single quote)</li> + <li>Escaped by: " (single quote)</li> + <li>Line ends: \r (for Macs)</li> + <li>Delimiter: , (comma)</li> + </ul> + </td> + </tr> +</table> + +</font> + +</body> +</html>
\ No newline at end of file |