On 28-Jun-00 Armand A. Verstappen wrote:
> Hi,
>
>> ... 
> 
> 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.

Its easy to use mysqldump. You can dump only the midgard database (with the
complete table definition) or the complete contens of your mysql data.

mysqldump midgard > midgard.dump

To restore it, first remove (a possible exisiting) database:
mysqladmin drop midgard

Then restore your dumped midgard db:
mysqladmin create midgard
mysql midgard < midgard.dump 


best regards

Ralf Eisinger
-------------------
IHS - University of Stuttgart, Germany
Pfaffenwaldring 10
70150 Stuttgart
Phone: (0049)-711-685-3201


--
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]

Reply via email to