how to convert a MySQL dump file to human-readable text?

[Karl Auer]

On Thu, 2024-08-29 at 06:10 +0000, Marco Fioretti wrote:
> I have a  plain text backup file of a MySql database
> [...]
> I need to convert it to something more readable
> [...]
> I have nowhere to install a MySql *server* right now

Finding that last line hard to believe. A virtual on any platform, a
free tier AWS instance, a Raspberry Pi... really, nowhere? Anyway...

How big is the file? How many lines? How do you intend to identify the
bits you want (regardless of the format)?
 
> https://blog.twineworks.com/converting-a-mysql-dump-to-csv-files-b5e92d7cc5dd

If it's exactly what you need - pay the money?

When I search for "convert MySQL dump file to CSV" I find these, among
MANY other hits, though a lot do leverage MySQL or mysqldump.

Python:

https://github.com/yashsmehta/mysqldump-to-csv

Online (if your data is not secret):

https://www.rebasedata.com/convert-mysql-to-csv-online

I have not actually tried either.

But depending on how much data there is and how you will be identifying
the data you want, you might be able to just cut and paste out of less!

Regards, K.

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Karl Auer (kauer at biplane.com.au, he/him)
http://www.biplane.com.au/kauer