Links and resources for the web 2.0 developer.
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) 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. Comments Off
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 [...]