- Where is the PHPMyAdmin?
- Should I choose MyISAM or InnoDB for my tables?
- How to convert tables from MyISAM to InnoDB
Where is the PHPMyAdmin?
There are often security issues regarding PHPMyAdmin, so we don't recommend installing it on our managed servers. Instead please use PIL's PHPMyAdmin installation - you can find it at
If you are having trouble with logging in, please check the following:
- Ensure you have typed in the all of the servername including '.pil.dk' eg. 'myserver.pil.dk' in the Server field.
- Check twice that you typed the exact username and password provided by us.
- Send us a message providing hostname, database name, username and your ip ( check www.myip.dk ) - Do not send us your password!
Should I choose MyISAM or InnoDB for my tables?
MyISAM has been the default MySQL engine for many years, but since MySQL 5.5.5 the default has been switched to InnoDB. And with good reason, allthough MyISAM historically has been the fastest for simple queries, that is usually no longer the case.
MyISAM especially suffers from table based locking and lack of scalability on multicore servers:
How to convert tables from MyISAM to InnoDB
The simplest way to convert a table is with the
ALTER TABLE tablename ENGINE=InnoDB; syntax ( mysql documentation ). But remember that the table is locked while doing so, and that it can take some time on large tables.
You can also mysqldump into a file, substitute the engine and restore the table again (this can can faster than alter table):
mysqldump $db $table | sed 's/ENGINE=MyISAM/ENGINE=InnoDB/' > table_dump.sql. The table can be restored again with
mysql $db < table_dump.sql