Using Windows Batch Files to Backup MySQL using mysqldump
Tuesday, May 20th, 2008 Posted in Programming | Comments Off[singlepic=735,320,240,web20,right]Backing up your database can be a drag/pain in the ass. You want to make sure you're getting all of the data and you don't want to have to remember to run your scripts at certain times throughout the week. And, if you're like me you don't have any super cool tape library/backup software to do the job for you. I ended up creating several .bat file pieced together from various snippets on the web. The process works like this...there's a ...
Dealing with MySQL Old Passwords
Tuesday, May 20th, 2008 Posted in Programming | Comments Off[singlepic=734,320,240,web20,right]If you're a developer that works with MySQL on a regular basis, you've run into the scenario where you've had trouble authenticating with a PHP script when you knew the username and password were correct. Often times this scenario ends with you remembering that you had created the user and set the password but that it was storing the password with the newer MySQL password hashing mechanism and you're connecting using the old method. So, you hit google and search ...
