SQL Buddy Offers an Ajax-y PhpMyAdmin

A new way to connect to your databased launched late last year. Named SQL Buddy, the software was downloaded over 20,000 times when the developer reported on the stats back in January. While PhpMyAdmin works well, it does feel a lot like 1985. SQL Buddy appears to be a more Web 2.0, Ajax-friendly version.

I use Navicat which is super powerful but runs as a local client only. SQL Buddy runs on your server which means it can be accessed from anywhere. SQL Buddy is free and is distributed under an open source MIT-style license.

Back Up A Large MySQL Database

Anyone that’s dealt with a Web application using a MySQL backend has probably dealt with incomplete backups. Those of you that use phpBB have almost certainly encountered this issue. Unfortunately, within phpBB and quite a few other PHP/MySQL-based applications, the backup scripts fail miserably with any reasonably large amount of data. Most of them fail because of either PHP time outs or file size limits. This article will show you two different ways to successfully back up that data. At least one of these two methods should be available in almost every remote hosting package that uses MySQL and PHP.