Data Dumps

 Back to the main menu

 In order to perform actions with data dumps, you must use the "File->Import; File->Export" menu options of Sequel Pro. A variety of exports/dumps can be performed: Sequel Pro 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 Sequel Pro dump or a CSV file.

CSV File Format Information
  • You can choose the following characters: fields enclosed, fields terminated, escaped and line ends
  • 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
  • NULL values are written without enclosed character. If it is enclosed, it is interpreted as a string.
  • When importing a csv, unenclosed \N is also interpreted as NULL (this format is used by mysqldump)
  • The recommended formats should work best. When importing, enclosed/terminated/escaped characters should be all only one character long (line ends may be longer).

Importing Dumps
  • Choose "File->Import" from the Sequel Pro Menu
  • You must choose to import a CSV file (table data) or a Sequel Pro dump (varied information)

Excel CSV Formatting Options
If you wish to export data to a CSV file for use in Excel, use the following settings:
  • Enclosed by: " (single quote)
  • Escaped by: " (single quote)
  • Line ends: \r (for Macs)
  • Delimiter: , (comma)