I have completed a tutorial that I have been working on for a long time. Its the Interactive SQL(Structured Query Language) Tutorial – it teaches you the basics of SQL. SQL, for those of you who are unaware of it, is the language used to access and manipulate data within a database. It is very simple and very powerful.
Some time ago, I was approched by the publisher of the book to write a review of their book ‘Mastering phpMyAdmin 2.11 for Effective MySQL Management by Marc Delisle[Affliate link]’. This got a bit delayed because of the plugin week. But I managed to finish the book today – so here is the review. Bottom line – most people are using phpMyAdmin for only the most basic operations(editing data, import, export, etc.). If you are one of them, you don’t need the book – you already know all you need to know about phpMyAdmin. But other(like me) use it for advanced purposes – to manage MySQL, create database/tables, run queries, etc. I would recommend you get this book. It covers everything from basic usage(which is a bit boring and should be skipped over) to advanced stuff(like designer view, configuration options, triggers, innoDB relation options etc.)
My second WordPress Plugin – Remote Database Backup. Its is based on the WordPress Database Backup plugin. If you are a regular wordpress user, you might be better off using WordPress Database Backup plugin instead of my version. But if you, like me, have a local server on your system and has a copy of your site on the local server as well as the online server, you will find great use for my plugin.
Installing the LAMP environment on a Linux system is easy if you are comfortable with using the native package management software. If you on a Red Hat/Fedora/CentOS system, that will be yum – and for Debian/Ubuntu systems, that will be apt. This tutorial shows you how to install Apache 2, PHP 5 and MySQL 5 in Debian using apt.