Backing up and Restoring a Single Database via phpMyAdmin

At the moment, taking backups for a single database is not available in the Control Panel. This article will explain how you can back up and restore a single database via phpMyAdmin.

Backup

1. Locate the target application

Log in to the Control Panel and locate your target application on the Home page or the My Applications page.

Locate the target application

2. Navigate to the phpMyAdmin page

Click the "Manage" button on the Home page or the My Applications page to go to the phpMyAdmin page.

Navigate to the phpMyAdmin page

Export a MySQL Database via phpMyAdmin

Click “Launch” on the phpMyAdmin page in the Control Panel.

Launch phpMyAdmin

Log in to the phpMyAdmin interface with one of database user’s username and password.

Log in to the phpMyAdmin interface

1>From the database drop-down on the left, select the database you would like to back up. 2>Click “Export” in the navigation bar at the top.

Export backup

Choose the Export method as Quick or Custom and the Format as SQL, followed by hitting the "Go" button. You are downloading a backup file to your local machine.

Using a Quick export

Using a Quick export

Using a Custom export

Using a Custom export

Besides the default ticked-on options, please tick on the “IF NOT EXISTS” under Objection creation options and the “Truncate table before insert” option under Data creation options. This is to make sure that your target database only includes the data from your backup file after the restoration.

Tick on the IF NOT EXISTS under Objection creation options

Restoration

Note: when you import files using phpMyAdmin, the file size can not excess 100MB. If you need to transfer larger files, please refer to Backing up and Restoring a Single Database via SSH

Import a MySQL database via phpMyAdmin

Click “Launch” on the phpMyAdmin page in the Control Panel.

Launch phpMyAdmin

Log in to the phpMyAdmin interface with one of database user’s username and password.

Log in to the phpMyAdmin interface

1> From the database drop-down on the left, select the database you would like restore data to.(Before you start the restoration, please make sure there is no data in the database. ) 2>Click “Import” in the navigation bar at the top.

Import a backup

Choose the backup file from your local disk and click the Go button. The process runs.

Restore

Copyright © 2021 Cloud Clusters Inc. all right reserved,powered by GitbookRevised on 05/05/2023

results matching ""

    No results matching ""