Hot on HuffPost Tech:

See More Stories
Free Switched iPhone app - try it now!
AOL Tech

Tag: MYSQL

Backup2Mail: automatically back up your site's database to email

It's a good idea to back up your website's databases periodically, in case of unforeseen server catastrophes, but it can be hard to remember to do it manually. One automated backup process you might consider is Backup2Mail, which sends backups of your MySQL databases to an email address on a schedule you specify using cron jobs. As long as you can run PHP apps, you're set to go. A lot of free em...

Flipping the Linux switch: Linux web tools, Pt. 2 - Using LAMP for testing

There was a toss up this week about whether it would be better to dig right in to the Linux HTML editors, or to wax poetic about setting up LAMP so that those choosing to go the content management system (CMS) route could test any changes they made with such editors on their local machines. We ultimately decided to tackle setting up a LAMP testing ground. This will certainly not be necessary for e...

RIAA website gets hacked by SQL injection

Yesterday a Reddit user posted a link that supposedly runs a time-consuming SQL query on the RIAA'a website. Of course the Reddit community began trying to stick it to the RIAA, and eventually someone may have deleted all of the site's content by exploiting a poorly configured web/database server with an SQL injection attack. The site appears to be operating fine now, but we noticed it certainl...

Sun Microsystems purchases MySQL

Sun Microsystems has made a huge leap into the open-source market by purchasing MySQL AB, the company behind the wildly popular MySQL database, for $1 Billion in stocks and cash. In a humorously named blog post titled "Helping Dolphins Fly", Sun Microsystems CEO Jonathan Shwartz stated that Sun would not only support MySQL once the transaction is finalized, but they'll be throwing their engineerin...

WAMP5 and EasyPHP, both great local web server options

EasyPHP is a great little web server package, as you might expect, it has the usual LAMP (Linux, Apache, MySQL, and PHP) stack, with phpMyAdmin, and a few other things. The only issue you might have with the EasyPHP 1.8 release is that it uses PHP 4. This may not be a problem unless you really need some of those sweet new features from PHP5. No word yet on when the folks at EasyPHP will be includi...

Panic brings Coda to the web development world

Panic, the fine folks that bring us Transmit, finally revealed the top secret app they've been developing over the past year with the release of the web development application Coda V1.0. This is not a WYSIWYG, drag-and-drop, do-all application. Coda has a specific target audience that consists of people who edit raw code using multiple tools such as a text editor, FTP client, CSS editor and Ter...

Oracle's Free SQL Developer upgrade

Like many web developers, I use MySQL constantly. Sure I can just use the command line, but it is faster to use some kind of graphical client with a decent UI. There are many out there, but my favorite for a while was MySQL's own MySQL Control Center (which has now been discontinued for a while). The replacement for Control Center is Administrator, and I am just not a big fan of it. I loved Cont...

MySQL's license is now GPL 2 only

MySQL's VP of community relations Kaj Arno's he explains in his blog that MySQL has changed its license from "GPLv2 or later" to "GPLv2 only", so MySQL doesn't have to be forced to use the GPLv3, which as you know is not so widely adopted yet. MySQL may very well move to the new v3 license once it becomes more commonplace, but for now, they don't want to put users and developers in a tight spot wi...

ForumMatrix - Compare forum software side-by-side

ForumMatrix is a handy comparison matrix to check if you are thinking about running a public forum and aren't sure what forum software to use, or if you already do run a forum and want to switch to a different package. You can select different packages from their list and compare the details (license, features, cost, etc.) side-by-side in a easy to follow table. If you aren't sure where to start F...

phpMyAdmin 2.9.0.2 is available

phpMyAdmin is one of the best and most heavily used (at least on my desk) MySQL management tools. It makes everything you do in MySQL simple, and can be either desktop or web-based. Even LAMP installs have a portable, USB drive friendly version, which is one of my favorites. Sure, I love SQLyog, MySQL Administrator and other desktop based clients too, but none is as versatile and useful as phpMyA...

XAMPP, the new LAMP hotness

XAMPP is an easy to install web server distribution containing Apache, MySQL, PHP and Perl. It claims to be a snap to use and install. After I got through clicking like 20 times to find the actual file download link on the XAMPP site (hosted at sourceforge), which irritated me a bit, the process got a bit better. You can download three different versions of the file, the installer (32MB), the zip ...

SQLyog: Open source MySQL manager for Windows

I've never actually heard of SQLyog before (even though it claims to be the "most popular MySQL GUI for the last 4 years"), but its web site is making a big deal out of the fact that this GUI front-end for MySQL is now open source, ergo free, and I certainly won't complain about there being more free MySQL front-ends in the world. To be fair, it's the "Community Edition" that's gone OSS--Enterpri...

MySQL Used By Majority Of "AlwaysOn 100" Innovators

The AlwaysOn Summit at Stanford University wraps up today, but not before making a declaration of something many LAMP developers have known for a long time. The "AlwaysOn 100" honors 100 private companies for their technical innovation, customer adoption and market potential. This year's 100 innovators are comprised of a majority of companies that share one common characteristic, they all use MyS...

gotAPI: Slick web developer's reference

gotAPI is a cool Ajaxy web app that gives you quick access to reference materials for a variety of web technologies. On the top there's a list of languages including HTML, JavaScript, CSS, PHP, Java, Perl, and six others, and when you click on one of them the list of HTML tags, JavaScript objects, PHP functions, etc. pops up. There's a search box at the top for finding items quickly, and clicking ...

PGnJ - PostgreSQL & MySQL Database Management Application

Since getting out of the database business a few years ago, I haven't had to sully myself with things like foreign keys or even SQL for a while. But now that it looks like I'll be building a site using MySQL and PHP, it's back to the db again. Luckily, developer Thomas Mango sent in a tip about his PGnJ app. It's written in Java, and serves as a database manager for PostgreSQL and MySQL databases....