Back-up and Restore > Back-up Globodox DB > Back-up MySQL-based Globodox DB

You are here: Back-up and Restore > Back-up Globodox DB >Back-up MySQL-based Globodox DB

You will need to use the MySqlDump application to backup your MySql Server based Globodox DB.

You will need to take a backup of...
The Master DB, i.e. MainDB and its Cache file i.e the MainDB_cache
And all your Globodox DBs along with their cache files

For each Globodox DB, you must also backup it's linked folder which contains the File Store, by zipping it.

In the below example we are backing up the MainDB.

On the MySQL Server machine we will back-up the...

MainDB and the MainDB_cache

AND

In the folder where Globodox Databases is located (this is usually the C:\Globodox Databases folder), we will back-up the MainDB sub-folder.

To Backup a MySQL Server based Globodox DB

1.	Make sure Globodox is not running. Click Start > All Programs > Accessories > Command Prompt. The Command Line window will now be launched.

2.	You will need to run the mysqldump application from the Command Line. Using the Command line browse to the folder where mysqldump is installed. The mysqldump is usually located in the C:\Program Files\MySQL\MySQL Server 5.0\Bin folder.

3.	Now, type the following at the Command line... mysqldump –-user [user name] –-password=[password] [database name] > [sql file] where,

[user name] = --user followed by the user name of the account that can connect to the MySQL Server.

[password] = The password of the above user.

[database name] = The name of the database that you want to backup.

[sql file] = The name of the backup file

Example: mysqldump --user admin --password=alphaomega MainDB > MainDBbackup.sql

4.	Hit the Enter key to begin the backup. The backup file will be created in the folder in which mysqldump is located, i.e. C:\Program Files\MySQL\MySQL Server 5.0\Bin folder.

5.	Follow steps 3-4 to back-up the MainDB_cache.

6.	Once you have backed-up MainDB and MainDB_cache, close the Command Prompt.

7.	Now, open the folder where Globodox Databases are located. This is usually the C:\Globodox Databases folder. (You can also backup the entire Globodox Databases folder by zipping it)

8.	Locate the MainDB folder in the Globodox Databases folder. Now, zip this folder.

Open the the ITAZ\Globodox folder created under the folder designated as the Common Application Data folder in your Windows installation.
For Windows Vista/Windows 2008/Windows 7, this will be the C:\ProgramData\ITAZ\Globodox folder.
For Windows 2000/XP/2003 this will be C:\Documents and Settings\All Users\Application Data\ITAZ\Globodox

10.	Locate the multi-user.gdx file and zip it.

11.	Now, copy these files to a device (Pen Drive) or burn them on a CD. Follow the same steps to back-up other DB's

Notes:

•	To restore a backed-up copy of MySQL Server based Globodox DB see, Restore a Backed-up MySQL DB

Related Topics
Backup MS SQL Server 2000 DB

Backup MS SQL Server 2005 DB

Backup MS SQL Server 2008 DB
Use the CD/DVD Module

Page URL: https://www.globodox.com/support/help/index.htm?backup_a_mysql_based_db.htm