-
Daily Popular
- 10 Steps: MySQL Monitoring through Nagios: Install & Configure
- Unique birthday card wishes for My dear Brother
- No More Spool Space Teradata Query Solution
- Load Delimited Data (csv, excel) into MySQL Server
- Working with EditPlus Text Editor-Regular Expression How To
- Extreme Movie Review: Singham (2011) Ajay Devgn
- Search-find through all databases, tables, columns in mysql
- Selected Oscar Wilde Quotes
- The Dos Chat – Lan Messenger
- Using LOAD DATA INFILE with Stored Procedure Workaround-MySQL
-
MySQL Archive
-
MySQL related file types and basic information
Posted on March 29, 2010 | 5 CommentsMore...This post covers the basic information of files that MySQL Server uses / creates for various tasks. my.cnf : It is the main configuration file for MySQL. You may find... -
SQL syntax with /*! c-style comments in MySQLdump
Posted on March 11, 2010 | 1 CommentMore...In mysql we have — , /* and /*! comments. This post is mainly about very basic c-style comments. /*! : C-Style comments in MySQL We normally see comments in... -
Ideas for select all columns but one mysql stored procedure
Posted on March 5, 2010 | No CommentsMore...Assume we’ve a table with 100 rows and we need to select all columns but one. The problem is headache of actually typing out all 99 required columns!! Solutions /... -
5 useful MySQL Command Options-pager-prompt-rehash-tee-system
Posted on February 27, 2010 | No CommentsMore...There are set of commands that MySQL itself interprets. You may use “help” or “\h” at the mysql> prompt to list them. Below are the 5 most useful MySQL Command... -
MyDumpSplitter-Extract tables from Mysql dump-shell script
Posted on February 11, 2010 | 32 CommentsMore...A lot of articles have been written on splitting mysqldump and grab required tables. Long back when Shlomi had suggested a “sed” way, I actually shell scripted it, and now... -
Stored procedure to add-remove prefix by rename table mysql
Posted on February 8, 2010 | 3 CommentsMore...Here is one more procedure – (this time) for mass renaming of table. Adding and Removing table-name prefixes A friend of mine was renaming 100+ tables by using replace methods... -
Load Delimited Data (csv, excel) into MySQL Server
Posted on January 11, 2010 | 57 CommentsMore...Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost everytime LOAD DATA INFILE come into rescue. Here we will try... -
Petition – Help saving MySQL – II
Posted on December 29, 2009 | No CommentsMore...Recently Monty has posted again and I completely convinced with whatever Monty has conveyed now or earlier. The explainations he has provided under self-interview, I find sensible enough. I did participated the help-saving-mysql campaign... -
MySQL Memory Usage Limits on 32 bit Linux
Posted on December 18, 2009 | No CommentsMore...I’m having RHEL 5 (32-bit) and MySQL-5. I was trying to check how much is the Memory Utilization limits for MySQL 5 on 32bit OS. We can easily calculate the... -
MySQL Certification Free Retake: Get TWO chances to get MySQL Certified
Posted on December 15, 2009 | No CommentsMore...Recently MySQL has offered MySQL Certification Free Retake on both DBA or Developer Certifications for a limited time. For MySQL Certifications: 1. MySQL 5.0 Data Base Administrator Certification (SCMDBA) -...