PHPMyAdmin
Revision as of 16:27, 4 November 2024 by Woozle (talk | contribs) (Woozle moved page MySQL/porting/data/phpmyadmin to PHPMyAdmin without leaving a redirect: reorganizing)
PHPMyAdmin (PHPMA) is an easy-to-use web-based database management tool for MySQL.
Backing up
- Make sure you've got PHPMyAdmin running happily. I won't cover this part here as it varies with your set up.
- Login and choose Export from the main page
- Leave most of the default options. Specifically,
- Format: SQL
- Select the database(s) you want in the listbox
- etc.
- Checkmark 'Add DROP TABLE'. This will make sure that when you restore from a backup, it will delete existing tables before restoring from the backed up ones.
- Checkmark 'Save to file' at the bottom, or it will just dump it to your browser window, and that's no fun.
- You probably also want to use compression. These won't be huge files, but a 1.5mb database compresses to about 150kb. So, y'know, whatever. Wiggy recommends BZIP.
- Click Go.
Restoring from backup
I'm writing this from memory, so I might be wrong, but I think it's right.
- Click Databases from the PHPMA main page
- Click the name of your database (or create it, if not present).
- Click the SQL tab
- Where it says Location of textfile:, browse to your latest backup, then click Go.
Notes
Some installations of PHPMA may have an upper size-limit on imports, which may make it unusable for your particular databases. The limit may be set by the PHPMA configuration, or it may be set by the PHP configuration in any of several places. It might be easier to use a different tool, if you run into this.