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