Archives For Database

Have you seen this error before? This is because you’re trying to dump the performance_schema database while locking tables.
Continue Reading…

You’ll eventually run into a client who has a crashed table in their database – this table will be pretty large – maybe even larger than the system’s default temporary directory (usually /tmp).
Continue Reading…

You’ll need to import a database via command line from time to time – I’ll normally opt for this anyway. After seeing how easy it is, you’ll probably end up using the command line instead as well (instead of phpmyadmin, etc..).
Continue Reading…

Your MySQL script was running great, but then you started getting errors – If you get this warning when dumping the mysql database, it’s not a bug – MySQL did this on purpose because they wanted people to know that they weren’t dumping the event table. Previous versions did not give the warning.
Continue Reading…