Home

mysql

boydjd's picture

How-to: Drop all tables from a mysql database

Thu, 03/27/2008 - 15:47 — boydjd

Much easier than have to drop a database, recreate it, and then grant privileges again.

mysqldump -u <username> -p <password> --add-drop-table --no-data <database> | grep ^DROP | mysql -u <username> -p <password <database>

boydjd's picture

Got error 28 from storage engine (1030)

Wed, 02/20/2008 - 16:48 — boydjd

Apparently rather than throwing a “disk full” error message, mysql likes to tell me ERROR 28. Oh how I love mysql error messages.

Also, I really enjoy having to do work on a “production server” that is a virtual machine, with 6GB of disk space, in a test lab.

Good idea guys. Maybe some server monitoring should be in place for a PRODUCTION SERVER, no?

Syndicate content