Hello Frank,
Wednesday, June 28, 2000, 5:43:44 AM, you wrote:
>> To backup your database I would:
>>
>> Stop the mysql server, copy all relevant files to a safe location (your
>> database is stored as files on your filesystem in the end), restart the
>> mysql server.
> I advise against this approach. First, keep the database server running
> and simply say:
> mysqldump --opt -umidgard -pmidgard midgard > midgard.sql
> (the command aboce assumes the defaults for user passwd and db).
> This gives you a simple sql script which can be used to recreate the db.
You also could use two dump programs in the midgard-data package for
beta 4. One (update.c) creates sql dump of midgard database using
UPDATE statements instead of insert so it is convinient for upgrading.
Another one creates usual INSERT statements suitable for direct (or
CVS) editing.
--
Best regards,
Alexander mailto:[EMAIL PROTECTED]
--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org
To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]
