Mailing List Archive

DB dumps
Hello,

I din't find it on the donload page, so I ask here:

Are you dumping using the -e option of mysqldump?

Smurf
--
------------------------- Anthill inside! ---------------------------
Re: DB dumps [ In reply to ]
On Wed, 16 Apr 2003, Thomas Corell wrote:
> I din't find it on the donload page, so I ask here:
>
> Are you dumping using the -e option of mysqldump?

Yes (via --opt).

-- brion vibber (brion @ pobox.com)
Re: DB dumps [ In reply to ]
Brion Vibber wrote:
> On Wed, 16 Apr 2003, Thomas Corell wrote:
>
>>I din't find it on the donload page, so I ask here:
>>Are you dumping using the -e option of mysqldump?
> Yes (via --opt).

*sigh* after some hours with my favourite editor I thought so. I never
expected that editors have so much problmes with a linelenght of about 1
million chars :(
Just for some tests with my postgresql, can you send me a mysqldump (from
german wikipedia, if possible) without that option?

Postgresql is unable to handle multivalue inserts. And transforming is not
impossible, but could produces errors I don't want to search.


Smurf
--
------------------------- Anthill inside! ---------------------------
Re: DB dumps [ In reply to ]
On Wed, 16 Apr 2003, Thomas Corell wrote:
> Brion Vibber wrote:
> > On Wed, 16 Apr 2003, Thomas Corell wrote:
> >>Are you dumping using the -e option of mysqldump?
> > Yes (via --opt).
>
> *sigh* after some hours with my favourite editor I thought so. I never
> expected that editors have so much problmes with a linelenght of about 1
> million chars :(

Clearly these text editors were not designed for the modern database
professional. :D

> Just for some tests with my postgresql, can you send me a mysqldump (from
> german wikipedia, if possible) without that option?

Sure, here's a cur dump which ought to be in more traditional syntax*:
http://de.wikipedia.org/tarballs/20030416_cur_table.sql.bz2

* Using options: --add-drop-table --add-locks --all --quick
instead of --opt.

If you want an old dump too, just shout.

-- brion vibber (brion @ pobox.com)
Re: DB dumps [ In reply to ]
Brion Vibber wrote:

> Sure, here's a cur dump which ought to be in more traditional syntax*:
> http://de.wikipedia.org/tarballs/20030416_cur_table.sql.bz2
>
> * Using options: --add-drop-table --add-locks --all --quick
> instead of --opt.
>
> If you want an old dump too, just shout.

Thank you very much, one dump is enough for testing.
*Sending virtual easter prestent* :)

Smurf
--
------------------------- Anthill inside! ---------------------------
Re: DB dumps [ In reply to ]
Thomas Corell wrote:

> Thank you very much, one dump is enough for testing.
> *Sending virtual easter prestent* :)

That's the virtual present for you Brion:
http::/corell.dyndns.org/Homonymzusaetze.html

First, it shows that Wikipedia works fine unter PostgreSQL (DB only) and
second it is an 'live' Example for the sugested SpecialPage: Qualifier

Happy hacking :)

Smurf
--
------------------------- Anthill inside! ---------------------------