Doing database backups for MySQL can be as simple as commandline dumps, but complex deployments can make things well, very complicated. This guide on bulletproof MySQL backups can be very helpful if you think you’ll be going into the complex type of deployments.
If you’re using the latest MAMP (1.7.2) …
If you’re using the latest MAMP (1.7.2) on your Mac for your development server, the easiest way to change the MySQL password would be /Applications/MAMP/Library/bin/mysqladmin -u root -p password YOURNEWPASSWORD.
Linux tips
Having just done some work on a Linux webserver, here’s some articles I recently used to make tasks just a bit easier.
- Recover MySQL root password
- How to Move the MySQL data directory in Ubuntu (Can be used for migrating your MySQL install to different system)
- How to kill a running process using PID
- How to edit and understand /etc/fstab
- How to mount filesystems in Linux
mount -t ext3 /dev/otherdrive /mountdir - Get hard disk info (but please be careful with this one):
fdisk -l - How To Speed Up WordPress With Nginx And WP Super Cache
- Linux / Unix tar command
- logrotate
- mysqldump
- Backing up your database using straight MySQL commands
- Perfect Setup: Ubuntu Hardy+Nginx+MySQL5+PHP5+WordPress