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

[Marco Fioretti]

Greetings,
I have a  plain text backup file of a MySql database, generated years ago with mysqldump or similar commands (not by me, so I have no more details). It is the backup of a Drupal website, with lots of posts and even more metadata.
I need to convert it to something more readable, because I must find, copy and reuse the text of some posts, and doing that directly on the backup file would be really cumbersome, because I don't even know in advance which and how many posts I should copy.
For several reasons, I have nowhere to install a MySql *server* right now, so I need to process the backup file directly.
The only source I have found that really deals with this problem is this paywalled post:
https://blog.twineworks.com/converting-a-mysql-dump-to-csv-files-b5e92d7cc5dd (https://blog.twineworks.com/converting-a-mysql-dump-to-csv-files-b5e92d7cc5dd)
so I'd like to ask if somebody else has already tackled this problem, how, and any suggestions you may have on how to proceed.
TIA,
Marco
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20240829/50777e71/attachment.html>