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

[Peter Flynn]

I thought the -X was an option on a retrieval command (to any mysql server 
you have access to). But it's been a while.

P

On 29 August 2024 09:27:05 Volker Wysk <post at volker-wysk.de> wrote:

> 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
>> >
>>
>
>
> --
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at: 
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20240829/3b52ee56/attachment.html>