N00b here trying to move old SQL database to this host. Here is the export options from my old host. Which ones should I select to facilitate import to this host? Step by step would be VERY much appreciated and I can consider buying the info with say 50 $frih 
| Code: |
| View dump (schema) of databases
Export Select All / Unselect All SQL LaTeX Microsoft Excel 2000 Microsoft Word 2000 CSV for MS Excel CSV SQL options Add custom comment into header (\n splits lines): Enclose export in a transaction Disable foreign key checks Database export options: Add DROP DATABASE Structure: Add DROP TABLE Add IF NOT EXISTS Add AUTO_INCREMENT value Enclose table and field names with backquotes Add into comments Creation/Update/Check dates SQL export compatibility: NONE ANSI DB2 MAXDB MYSQL323 MYSQL40 MSSQL ORACLE POSTGRESQL Data: Complete inserts Extended inserts Use delayed inserts Use ignore inserts Use hexadecimal for binary fields Export type: INSERT UPDATE REPLACE LaTeX options Include table caption Structure Table caption Continued table caption Label key Data: Column names Table caption Continued table caption Label key Replace NULL by CSV options Fields terminated by Fields enclosed by Fields escaped by Lines terminated by Replace NULL by Put fields names in the first row Excel options Replace NULL by Put fields names in the first row Excel edition: Windows Excel 2003 / Macintosh Microsoft Excel 2000 export options Replace NULL by Put fields names in the first row Microsoft Word 2000 export options Structure Data: Replace NULL by Put fields names in the first row XML This format has no options Save as file File name template: ( remember template )* Compression None "zipped" "gzipped" "bzipped" |
