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