Backing up Clientexec with PHPMyAdmin

It is strongly recommended that you backup your database at regular intervals and before an upgrade. Restoring your database from backup is then possible if something goes wrong.

phpMyAdmin is the name of the program used to manipulate your database. A good hosting package will have this included.

Backup Process

Log into phpMyAdmin on your server

From the main login screen, select 'Databases'

Now click the name of your database - or your Clientexec database if you have several databases.

The next screen will show you all the tables inside your Clientexec database.
Ignore those, and click the 'Export' tab on the top set of tabs.



Look at the left box at the top of the Export section. All the tables in the database you selected are in that box.
- If you only have Clientexec installed in that database, in the left column, click 'Select All'.

Ensure that the SQL button is selected too.
- The SQL section
- Tick the following boxes: Structure, 'Add DROP TABLE', 'Add AUTO\_INCREMENT' and 'Enclose table and field names with backquotes'

The DATA section
- Leave the boxes inside this section unticked, but make sure to keep the checkbox next to the
"DATA" heading checked.

Tick the 'Save as file' option, and leave the template name alone.
For now, select 'None' for compression.

Now click 'Go' and you should be prompted for a file to download. Save the file to your computer.
Depending on the database size, this may take a few moments.

Once that download is complete, check the 'zipped' option, click 'Go', and download the next file.
If you wanted, you could download a backup in each of the compression formats. Your choice.

You have now backed up your database.

Updated on: 04/04/2023