Printer-friendly version of this topic Bookmark this topic (Registered users only)	Previous Topic | Next Topic
VPC Forums VPC Tech

Current Message

Guido_Ostkamp Certificates/Ratings/Crew Stations: 12. "RE:New Version FlyNow! and Flight R..." 04-02-02, 15:47z  Hi Paul, > >> if you haven't backed up your database (none of us do regularly), > you're pretty much stuck reinstalling greenie's database/zip and > downloading the new messages since that build again. << > > Any suggestions as to exactly which files/folders should be backed up? > Not essential I know but it's more efficient than just backing up > everything. the correct way to backup your database is by using the tool 'mysqldump.exe'. This must be called once for each table in the database (of course with appropriate parameters) and gives you a database version and OS independent dump that can be used for a later restore. If you are interested in this official method, let me know, and I'll tell you the details. The quick and dirty way is AFAIK to first shutdown MySQL, then zip the C:\mysql\data folder including all files and subdirectories, as Ben already told you. This is a non-portable version specific backup, that means if you update MySQL, it might no longer be usable. You can partially automate that by using InfoZIPs free ZIP (a DOS box commandline ZIP utility) and calling that within a DOS batch file. Of course, the backup should be done regularly. The rest of the installation doesn't need to be backuped, if you keep your installation ZIPs. Regards, Guido **** OLR.PL Build 1.74 **** Remove | Alert Edit | Reply | Reply With Quote | Top

Table of Contents

Subject      Author      Message Date     ID      New Version FlyNow! and Flight Room...    Ben Chiu       03-29-02              RE:New Version FlyNow! and Flight R...    jerryrosie       03-29-02       1            RE:New Version FlyNow! and Flight R...    vgbaron       03-29-02       2                 RE:New Version FlyNow! and Flight R...    jerryrosie       03-29-02       3                      RE:New Version FlyNow! and Flight R...    Ben Chiu       03-29-02       5                           RE:New Version FlyNow! and Flight R...    jerryrosie       03-30-02       6                           RE:New Version FlyNow! and Flight R...    jerryrosie       03-30-02       7                                RE:New Version FlyNow! and Flight R...    Ben Chiu       03-30-02       8                                     RE:New Version FlyNow! and Flight R...    PaulCroft       04-01-02       9                                          RE:New Version FlyNow! and Flight R...    Ben Chiu       04-01-02       10                                               RE:New Version FlyNow! and Flight R...    PaulCroft       04-02-02       11                                          RE:New Version FlyNow! and Flight R...    Guido_Ostkamp       04-02-02       12                                               RE:New Version FlyNow! and Flight R...    PaulCroft       04-03-02       13            RE:New Version FlyNow! and Flight R...    Ben Chiu       03-29-02       4

Forums | Topics | Previous Topic | Next Topic