OvalEdge Database Backup Process (MySQL)

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 the 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. 

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

Establishing the Connection in Linux Machine

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

2. Connect to MySQL: Run the command


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

Database Backup Commands:

1. Local Backup: Execute the command:

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

Note: Username must be Root user.

2. Remote Backup: Execute the command:

---

Copyright © 2024, OvalEdge LLC, Peachtree Corners, GA USA