As promised in my previous post with usefull PHP articles and tutorials, now it’s time for some cool and handy SQL articles!
Here we go:
Execute SQL job through batch file
This article will show you how you can execute a SQL job with one click, allowing anyone to do this.
Author Divya Agrawal shows a technique to let other users run jobs that do things such as perform a backup with a batch file.
SQLyog 8.1 – Fast and Furious
Article about the new version of SQLyog!
Using netcat to copy MySQL Database
It often makes sense to use netcat/nc to copy MySQL database between hosts in trusted networks.
It bypasses encryption overhead of SSH and depending on configuration can be significantly faster.
Tutorial: Mass killing of MySQL Connection
Tutorial on how to mass kill your MySQL connections!
What is a MySQL storage engine anyway?
MySQL allows you to select the storage engine not just for the application, but for each table used by the application.
Let me use an analogy to describe how powerful this is. Consider an automobile that enables you to simply switch from one engine to another.
You could have specialized engines for things like towing, or top-end speed, or quickness off the line, mileage, hill climbing, etc.
Hope you find them usefull!
Related posts:
- Recommened PHP articles to improve your programming skills! I had some cool PHP articles in my RSS reader,...
- Useful PHP and MySQL articles to improve your development skills! CakePHP Authsome Authentication for people who hate the AuthComponent. Triggering...
- 15 essential PHP and MySQL tutorials! Showing Google Maps with many markers in PHP Sometimes you...
- PHP tutorials which make you a better developer! Part 2 Some weeks ago I posted an article with some usefull...
- 5 articles to improve your jQuery skills! jQuery 1.4 API Cheat Sheet Complete cheat sgeet of the...
Related posts brought to you by Yet Another Related Posts Plugin.
The article is usefull for me. I’ll be coming back to your blog.