Backup-MySQL

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
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 cokmmands which can use used to restore the data base.  E.g. with
+
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.

Personal tools
General
About This Wiki