Corrupt an SQL File Online
Corrupt a .sql dump online for free. Breaks statement structure and encoding so imports fail instead of loading partial data.
- Yükleme yok
- Boyut sınırı yok
- Kayıt yok
SQL dosyanızı bozun
.sql, .dump için ayarlandı ve diğer tüm biçimlerde de aynı şekilde çalışır.
SQL dosyalarını düzgün bozmak neden zordur
An SQL dump is a text file of statements executed in order. That makes partial corruption genuinely dangerous in the real world, an import can succeed for thousands of rows and then fail halfway, leaving a database in an inconsistent state. Reproducing that on demand is exactly what this is for.
Bu araç neyi yok eder
- Statement terminators. Semicolons and line breaks are overwritten, so statements run together into unparseable input.
- String literal quoting. Quotes are broken up, leaving literals unterminated and swallowing subsequent statements.
- The dump header. The opening bytes containing the client and server version comments are destroyed.
- Encoding validity. Invalid UTF-8 sequences make the file fail on import before any statement executes.
Sonrasında ne göreceksiniz
| Uygulama | Davranış |
|---|---|
mysql < dump.sql | "ERROR 1064 (42000): You have an error in your SQL syntax" and the import aborts. |
psql -f | Reports invalid byte sequence for the encoding and stops. |
| phpMyAdmin / Adminer | Import fails with a syntax error and a line number. |
| Light level | Import may run partway before failing, the realistic partial-restore scenario. |
Bunu yapmanın yaygın nedenleri
- Rehearsing a restore from a damaged backup before it happens for real.
- Verifying an import runs inside a transaction and rolls back cleanly on failure.
- Testing that a migration tool reports the failing statement rather than continuing.
- Demonstrating why backups must be verified, not just taken.
SQL dosyası nasıl bozulur
- .sql dosyanızı yukarıdaki kutuya bırakın veya seçmek için tıklayın.
- Kısmi hasar (Light) istemiyorsanız ya da kurtarma yazılımını alt etmeniz (Heavy) gerekmiyorsa seviyeyi Standard bırakın.
- Dosyayı boz düğmesine basın. İşlem cihazınızda yapılır, bu yüzden neredeyse anında biter.
- Sonucu indirin. Varsayılan olarak özgün dosya adını ve bayt uzunluğunu korur.
SQL hakkında sık sorulanlar
Can I simulate a partial restore?
Yes, and this is the most useful case. Light level leaves most statements intact, so an import typically runs for a while before failing, which is precisely the scenario that catches missing transaction handling.
Does it work on compressed dumps?
A .sql.gz file is handled as a gzip archive instead, which breaks the whole thing at once. Decompress first if you want statement-level damage.
Will it break a specific table?
Not deterministically, damage is scattered, not targeted at named objects.
Is the original dump modified?
No. The corruption is applied to a copy in memory and downloaded separately.