MySQL — import & export with Mildport
Dieser Inhalt ist noch nicht in deiner Sprache verfügbar.
Validate and review before INSERT … ON DUPLICATE KEY UPDATE — and when a MySQL dump becomes a spreadsheet, clean it the same way.
Pick your direction
Section titled “Pick your direction”- From MySQL — data left MySQL as a file; it needs to land cleanly somewhere else.
- Into MySQL — your users bring files; typed, valid rows reach your tables.
Either way, the same engine
Section titled “Either way, the same engine”Files in: CSV, TSV, Excel, ODS, JSON, XML — even PDF tables and scans. Mildport reads the file, matches its columns to the right fields, and flags anything it is not sure about. You (or your user) review before a single record is written — and the same file always maps the same way.