Posts Tagged ‘MySQL’

MySQL For Database Administrators Course

Saturday, October 29th, 2011

The very popular MySQL for Database Administrators course has been updated to bring you more on InnoDB, MySQL’s default storage engine, more on MySQL tools and even better hands-on exercises. This course is the cornerstone curriculum for MySQL Database Administrators and brings you all the skills you need to be a great MySQL DBA.

In this course students learn how to secure users privileges, set resource limitations, access controls and describe backup and recovery basics. Students also learn how to create and use stored procedures, triggers and views.

Link: Oracle’s MySQL Blog

Build a CMS in an Afternoon

Saturday, June 25th, 2011

Building a content management system can seem like a daunting task to the novice PHP developer. However, it needn’t be that difficult. In this tutorial I’ll show you how to build a basic, but fully functional, CMS from scratch in just a few hours. Yes, it can be done!

Along the way, you’ll learn how to create MySQL databases and tables; how to work with PHP objects, constants, includes, sessions, and other features; how to separate business logic from presentation; how to make your PHP code more secure, and much more!

Link: Elated

Using Spawner To Populate SQL Database

Saturday, December 27th, 2008

There are many reasons why you would want to generate bogus data for your database. Perhaps you’d like to know how well your databases will perform when filled with data, or maybe you just need some data so that you can start creating a front end for the database.

Link: LinuxHaxor

Monitor & Kill Long-Running MySQL Queries

Monday, December 1st, 2008

A simple script to monitor MySQL queries and log them into a file for future processing. Optionally will kill long-running queries. There are a couple of supporting scripts:

Link: Philo Vivero