Backup-MySQL
From OpenSimulator
(Difference between revisions)
m (typo corrected) |
m (typos corrected) |
||
Line 1: | Line 1: | ||
Run a console (in Windows make sure you run it as administrator) | Run a console (in Windows make sure you run it as administrator) | ||
− | Backup the MySQL data base to a set of SQL | + | Backup the MySQL data base to a set of SQL commands which can use used to restore the data base. E.g. with |
mysqldump -u <username> -p --opt <databasename> > MyOpensimBackup.sql | mysqldump -u <username> -p --opt <databasename> > MyOpensimBackup.sql | ||
− | You will be prompted for your password. | + | You will be prompted for your password. --opt really is two hyphens. |
Revision as of 01:06, 8 October 2009
Run a console (in Windows make sure you run it as administrator)
Backup the MySQL data base to a set of SQL commands which can use used to restore the data base. E.g. with
mysqldump -u <username> -p --opt <databasename> > MyOpensimBackup.sql
You will be prompted for your password. --opt really is two hyphens.