Twelve Dozen

Just another WordPress weblog

Backing up large MySQL database

Linux to the rescue. This sure beats using Export from PhpMyAdmin, it can be slow and may time out with large databases.

mysqldump -a -u USER -p DBNAME > /path/to/backupname.sql

http://www.metatitan.com/mysql/6/how-to-backup-and-restore-large-databases-in-mysql.html

  • 0 Comments
  • Filed under: Uncategorized
  • Shell Commands

    Find the size of a directory

    du -sh /dir

    How to remove files older than 60 days

    find * -mtime +60 -exec rm -R {} \;

  • 0 Comments
  • Filed under: Uncategorized
  • http://tuts4tech.net/2009/06/19/how-to-install-wordpress/

  • 0 Comments
  • Filed under: command line