"Armand A. Verstappen" 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 can then can safely try to run the database-update script to adapt your
> existing database to be compliant with 1.4beta4.
I agree.
> If you need return to the
> old situation you can just stop the server again and copy back the original
> files.
Restore the db with
mysql -umidgard -pmidgard midgard < midgard.sql
Simple as that.
Frank
--
Dr Frank Boehme | Email: [EMAIL PROTECTED]
National University of Ireland, Cork | phone: +353-21-903163
Dept of Computer Science | fax: +353-21-903113
Cork, Ireland |
--
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]
