OvalEdge Database Backup Process

This article outlines the OvalEdge Database database backup process 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 to connect 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. 
   mysql -u <username> -p ovaledgedb
2. Using Host IP: If OvalEdgeDB is installed on a remote server, use the following command:
   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
   mysql -u <username> -p ovaledgedb
3. Connect to Remote Server: If OvalEdgeDB is installed on a remote server, use the command:
   mysql -h <HostName/HostIP> -u ovaledge -p ovaledgedb

Database Backup Commands

1. Local Backup: Execute the command:
   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:
   mysqldump -h <hostname> -u <username> -p <databasename> > folderpath\filename.sql

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