|Frames||Modems||Help||Home Page||Chipsets||Search||No Frames|
|Diary Entries||See also Site Info & Diary.|
|17 December 2001||Backing up/Transporting the database...|
|MySQLDump is the utility program used for this.
A far quicker & simpler way to ensure regular backups of the database is to use mysqldump. (from the MySQL \bin folder):
mysqldump <database> > dump.txt"<database>" (no chevrons) needs replacing with the name of the database, of course. There are a staggeringly large number of other options, but the help text flashes by without page breaks, so I've ignored it.
This creates a text file full of the SQL commands necessary to first create a database table & then create the individual records. Another utility prog is used to automatically insert the commands using the dump file as a source, or they could be copy/pasted into mysqlgui. With 152 /mfc/ & 610 names this now starts becoming a real issue.