Clean .sql dumps
by - Thursday, January 1, 1970 at 12:00 AM
Hello! 

Does anyone know how I can clean up .sql database dumps? 

Like converting them to CSV or XLSX or something  :pomthink:
(AKA Post Malone)
Thank you @TheKreator for MVP! <3
Thank You @LeakBase for GOD! :pomlove:
~uwu~

Reply
for small databases you can use this
https://tableconvert.com/sql-to-excel
its easy
for big dbs you can use SQL Server Management studio , dbforge , python ( just search on github )
Reply
If you're familiar with Linux: use gnu tools like cut, awk and tr. Size of file doesn't matter.
Reply
For sql files, you can use sqlrip, with it you can upload the fields you need in txt format, specifying the character you need as a separator in the string, and then simply change the extension from txt to csv in some text editor.
https://breached.vc/Thread-SQLRIP-SQL-tables-viewer?highlight=sqlrip
Reply
(November 27, 2022, 02:58 PM)Addka72424 Wrote: For sql files, you can use sqlrip, with it you can upload the fields you need in txt format, specifying the character you need as a separator in the string, and then simply change the extension from txt to csv in some text editor.
https://breached.vc/Thread-SQLRIP-SQL-tables-viewer?highlight=sqlrip


Thank you, this is exactly what I was looking for!  :pomhappy:
(AKA Post Malone)
Thank you @TheKreator for MVP! <3
Thank You @LeakBase for GOD! :pomlove:
~uwu~

Reply


 Users viewing this thread: Clean .sql dumps: No users currently viewing.