2.2.4.2. Backup

Selecting "Backup" from the Database screen allows you to back up the EWE database tables. The EWEPRIV_READDB or EWEPRIV_MODIFYDB privilege is needed to view this option.

There are four options for backup:

Local DB: This option means that the backed up tables are written to the local EWE database.
Remote DB: This option means that the backed up tables are written to a remote database. When selected, the Host, Database, User, and Password boxes are enabled which allow you to specify the remote database access information.
File: This option will write SQL statements to a file which is stored in the EWE backups folder. After the backup is completed, you are given a chance to download the file.
Screen: This option will write the SQL statements to the browser screen which will restore the database if used in something like MySQL Workbench or the EWE database workbench.

The Host, Database, User, and Password boxes are used when backing up to a remote database. The appropriate values must be provided in order to access the remote database.

Under "Tables to backup", is a list of all tables in the EWE datase. Those that are checked will be backed up. Those that are unchecked will not be. Pressing the "Select all" button will select all tables, while pressing the "Unselect all" button will uncheck all the tables.

When the "Start Backup" button is clicked, the selected tables will be backed up.