Rebuilding a Mysql Database
Step 1 - Make a Backup
The Dreamgrid program has backup utility. Start Dreamgrid and click Ctrl-B, or Navigate to Content->Database Backup and Restore:
The system will open a DOS prompt and back up your regions and both Robust and Opensim region databases to Outworldzfiles\Autobackup folders. This can take a LONG TIME!
Look in that folder and make sure you have both files. These two are only 2K as it is a blank database.
Step 3 - Stop Mysql and move the Data folder
First, exit Dreamgrid. This will stop Mysql.
Navigate to Outworldzfiles\Mysql\
Rename the data folder to data.bak
Step 4 - Create a new, blank database
Download this zip file: Blank-Mysql-Data-folder.zip
Extract it to the Outworldzfiles\Mysql\data.
Step 5 - Start the database
Navigate to mysql\bin. Once there, click on StartManually.bat to run it. You should get a DOS window that is running MySql. This window should not exit.
Go back to the folder view of mysql\bin. Right click the blank area next to the file list and press and hold the shift key. Select Open PowerShell Window Here, or Open Command Prompt here:
A dos box will appear. Type this:
Type into the MySQL window:
mysql -u root <
But do not press enter!
Step 6 - Restore your grid
Then drag and drop the opensim.sql file onto the dos prompt:
It will type in the path to the file so it becomes something like this:
mysql -u root < c:\blah blah
This will take some time. When it finishes, repeat for the other .sql file, if there is one. Some versions compress them into one .sql file, others up to three files.
You may now start your grid up.
Log in and make sure your database is okay. Then you can delete the mysql\data.bak folder.
Back to the Best Free Tools in Second Life and OpenSim.