|
/Admin/databases/MySQL:
phpmyadmin: Mixed Review
Generally speaking I find phpmyadmin to be a very handy piece of software, but today my enthusiasm is tempered (and the command line still rules!) because I spent a fair bit of time bumping up against phpmyadmin's limitations:
Problem #1: in all the confusion it is very hard to be absolutely positive, but I am pretty sure an imported mysqldump (imported with phpmyadmin) was corrupted.
Problem #2: phpmyadmin advertises a capability to rename a database. Apparently this was actually a part of MySQL for only a short time before it was ripped out, and not unsurprisingly it does not work for the version of MySQL that I am using. It actually fails rather sloppily, creating a database with the new name but short some tables, and throws an obtuse error message.
The recommended method for renaming a MySQL database is apparently a mysqldump, followed by an import into the new database.
posted at: 09:09 | path: /Admin/databases/MySQL | permanent link to this entry