What's New
- Null byte stripping — removes
\0bytes that causeASCII '\0' appeared in the statementerrors - Double-escaped quote fix — detects and fixes
\\'→\'from backup tool bugs (e.g.hold\\'em→hold\'em) - Trailing backslash fix — detects values ending with
\where the dump writes\'instead of\\', causing the string to never close - Progress bar — real-time progress showing percentage, bytes processed, and fix count when processing files
- Smart CSS-safe heuristic — the escape-fix look-ahead correctly ignores CSS properties inside HTML email templates (e.g.
gradient(startColorstr=\'#fff\'))
Errors Resolved
| Error | Fix |
|---|---|
| Reserved words as column names (ERROR 1064) | Backtick-quotes them |
Literal newlines in strings (Unknown command '\') |
Escapes as \n |
| Foreign key constraints (ERROR 1451) | --disable-fk flag |
Null bytes (ASCII '\0') |
Strips them |
| Double-escaped quotes (ERROR 1064) | \\' → \' |
Trailing backslash values (Unknown command '\') |
\' → \\' |
Install
curl -sSL https://raw.githubusercontent.com/jimmyalcala/clean-sql/main/install.sh | shOr download a binary below for your platform.