DBWillow Logo

Importing Data

Introduction

This tutorial shows you how to import data from CSV files and SQL files into your MySQL database using DBWillow.

Importing CSV Files

Step 1: Prepare Your CSV

  • Include headers in first row
  • Use consistent formatting
  • Clean data before importing
  • Save as UTF-8 encoding

Step 2: Start Import

  1. Click "Import" → "CSV"
  2. Select CSV file
  3. Import wizard opens

Step 3: Map Columns

Visual column mapping:

  • CSV columns on left
  • Database columns on right
  • Drag to match columns
  • Preview data

Step 4: Configure Options

  • Skip header row
  • Delimiter (comma, semicolon, tab)
  • Encoding
  • Error handling

Step 5: Preview and Import

  1. Review mapped data
  2. Check for errors
  3. Click "Import"
  4. Monitor progress

Importing SQL Files

Step 1: Select SQL File

  1. Click "Import" → "SQL File"
  2. Select SQL file
  3. Review statements

Step 2: Review SQL

  • See all statements
  • Check for errors
  • Verify target database
  • Review data

Step 3: Execute Import

  1. Click "Import"
  2. Statements execute
  3. Monitor progress
  4. Review results

Best Practices

Before Importing

  • Backup database
  • Test with small dataset
  • Verify data format
  • Check constraints

During Import

  • Monitor progress
  • Watch for errors
  • Review error log
  • Pause if needed

After Importing

  • Verify data
  • Check row counts
  • Test queries
  • Document import

Troubleshooting

Import Errors

  • Check file format
  • Verify column mapping
  • Review data types
  • Check constraints

Data Issues

  • Verify encoding
  • Check date formats
  • Review special characters
  • Validate data types

Next Steps