OvalEdge Database Backup Process (MySQL)

Purpose

This document outlines the db backup process of OvalEdge Database and provides step-by-step instructions for establishing connections and performing database backups.

Installation of OE Database

1. Local Installation: Choose the option for local installation of OvalEdge Database.
2. Host Installation (e.g., AWS, Azure):  If installed on a host server, obtain the IP address for connecting to the database.

Establishing the Connection in Windows Machine

1. Connect through MySQL Command-Line: Open Command Prompt and navigate to the MySQL bin folder. 

Command Prompt

mysql -u <username> -p ovaledgedb

2. Using Host IP: If OvalEdgeDB is installed on a remote server, use the following command:

Command Prompt

mysql -h <HostName/HostIP> -u ovaledge -p ovaledgedb

Establishing the Connection in Linux Machine

1. Ensure MySQL Server is installed on the Linux machine.

2. Connect to MySQL: Run the command

Command Prompt

mysql -u <username> -p ovaledgedb

3. Connect to Remote Server: If OvalEdgeDB is installed on a remote server, use the command:

Command Prompt

mysql -h <HostName/HostIP> -u ovaledge -p ovaledgedb

Database Backup Commands:

1. Local Backup: Execute the command:

Command Prompt

mysqldump -u <username> -p <databasename> > Folder_path\filename.sql

Example: mysqldump -u root -p ovaledgedb > D:\ovaledgebkp_210222.sql

Note: Username must be Root user.

2. Remote Backup: Execute the command:

Command Prompt

mysqldump -h <hostname> -u <username> -p <databasename> > folderpath\filename.sql