Woozle: Woozle moved page MySQL/porting/data/phpmyadmin to PHPMyAdmin without leaving a redirect: reorganizing

2024-11-04T16:27:11Z

Woozle moved page MySQL/porting/data/phpmyadmin to PHPMyAdmin without leaving a redirect: reorganizing

← Older revision	Revision as of 16:27, 4 November 2024
(No difference)

Woozle: Created page with "PHPMyAdmin (PHPMA) is an easy-to-use web-based database management tool for MySQL. ==Backing up== # Make sure you've got [http://www.phpmyadmin.net PHPMyAdmin] running..."

2024-08-11T18:44:19Z

Created page with "PHPMyAdmin (PHPMA) is an easy-to-use web-based database management tool for MySQL. ==Backing up== # Make sure you've got [http://www.phpmyadmin.net PHPMyAdmin] running..."

New page

[[PHPMyAdmin]] (PHPMA) is an easy-to-use web-based database management tool for [[MySQL]].
==Backing up==
# Make sure you've got [http://www.phpmyadmin.net 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.

PHPMyAdmin - Revision history

Woozle: Woozle moved page MySQL/porting/data/phpmyadmin to PHPMyAdmin without leaving a redirect: reorganizing

Woozle: Created page with "PHPMyAdmin (PHPMA) is an easy-to-use web-based database management tool for MySQL. ==Backing up== # Make sure you've got [http://www.phpmyadmin.net PHPMyAdmin] running..."