To backup all databases on a given server:

  1. Log into the phpMyAdmin web interface on the desired server
  2. From the top bar select 'Export'
  3. For a quick backup select 'Quick'
    1. Then select GO
  4. For a full backup select Custom
    1. Press 'Select All'
    2. check include TimeStamps
    3. check Include foreign key constraints
    4. check add CREATE database / USE statements
    5. Then Select GO

Once file is downloaded, zip and encrypt it, delete the unencrypted file, and move it to the desired backup repository.

  • dr/mysql_and_phpmyadmin.txt
  • Last modified: 2019/03/15 17:28
  • by ericclaus