Usage

Step 1: Upload SQL File

Option A: Browser Upload

1. Drag & drop your .sql or .gz file
2. Real-time upload progress bar
3. Recommended for files under 100MB

Option B: FTP Upload

1. Upload large files via FTP to smartdump_uploads/ folder
2. Click "Refresh Files" in the FTP tab
3. Select your file

Step 2: Database Configuration

Enter your MySQL credentials:

1. Host (usually localhost)
2. Database name
3. Username
4. Password

Click "Test Connection" to verify before proceeding.

Step 3: Import Settings

Auto-Detection (Recommended)

1. Click magic wand 🪄 buttons to auto-detect:
2. Charset from SQL file
3. Table prefix from existing database

Manual Configuration

1. Charset: utf8mb4, utf8, latin1, cp1251
2. Collation: utf8mb4_unicode_ci, etc.
3. Max queries per step: 300 (default)
4. Max time per step: 30 seconds (default)

Optional Settings

1. Old Prefix → New Prefix: Change table prefixes
2. Email Notification: Get notified when done
3. Error Handling:
4. Continue on errors (recommended for WordPress)
5. Ignore duplicates only
6. Stop on first error (strict mode)
7. DROP DATABASE: ⚠️ Delete all existing data

Step 4: Import

1. Watch real-time progress
2. Monitor live logs
3. Get statistics (queries executed, failed, success rate)
4. Optionally backup database when complete