DirectDB

Import CSV into MySQL

Connect → pick table → map columns → batch insert. Duplicates are skipped automatically.

Not connected

1. Database connection

2. Table & column mapping

Table CSV delimiter First row is header

Select a table to see columns.

Choose CSV file No file selected · single POST max 512M (large files auto-chunk)

3. Import settings

Duplicate handling Batch size

Select unique columns below when using “check then skip”, or ensure your table has a UNIQUE/PRIMARY key for IGNORE mode.

4. Clean tables & reset autoincrement

Empty the tables you choose, insert data again (here or in another tool), then set each AUTO_INCREMENT to one past the highest ID already in the table.

Paste table names

Select tables

0 tables selected

Connect to load tables.

I understand this permanently deletes every row in the selected tables

Clean runs TRUNCATE and turns foreign-key checks off only for that step. The autoincrement button finds each table’s AUTO_INCREMENT column (whatever it is named) and sets the counter to max ID + 1.

Import a .sql file

Export the same tables, then load that dump here. Plain .sql and Zstandard .sql.zst both work. The import runs in the background, so you can leave this page. When it finishes, or if it fails, the result stays in the list below. A table that already exists is not created again. A missing table is created from the file, then filled. DROP statements are ignored.

Choose .sql or .sql.zst No file selected · up to 16GB, uploaded in chunks

Saved import results

Background jobs from this page and from php cli/sql-import.php are listed here.

No background imports yet.