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:
- 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...
- 5 articles to improve your jQuery skills! jQuery 1.4 API Cheat Sheet Complete cheat sgeet of the...
- Attention all MySQL Data warehouse users! One aspect of my positions with Calpont, MySQL, and other...
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.