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

[Volker Wysk]

Am Donnerstag, dem 29.08.2024 um 09:01 +0100 schrieb Peter Flynn:
> I thought mysql had a -X option that dumped in XML syntax. It certainly
> used to because I used it frequently. 

Interesting. But the OP said he can't install a MySQL server.

V.

> 
> P
> 
> On 29 August 2024 08:27:53 Volker Wysk <post at volker-wysk.de> wrote:
> 
> > Am Donnerstag, dem 29.08.2024 um 06:10 +0000 schrieb 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
> > > 
> > > 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.
> > > 
> > 
> > If you know some programming language, you could write a program that
> > parses
> > the mysql dump file and outputs it in a more readable format.
> > 
> > I would know how to do this.
> > 
> > It depends on the dump (and the programming language), how hard this
> > would
> > be.
> > 
> > But best would of course be, to set up a MySQL server and restore the
> > dump...
> > 
> > Cheers,
> > Volker
> > 
> > -- 
> > ubuntu-users mailing list
> > ubuntu-users at lists.ubuntu.com
> > Modify settings or unsubscribe at:
> > https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
> > 
>