-
Popular Posts
- Load Delimited Data (csv, excel) into MySQL Server
- 10 Steps: MySQL Monitoring through Nagios: Install & Configure
- MySQL Stored procedure – Split Delimited string into Rows
- No More Spool Space Teradata Query Solution
- Working with EditPlus Text Editor-Regular Expression How To
- Selected Oscar Wilde Quotes
- Collection for insulting – one liners
- The Dos Chat – Lan Messenger
- How to echo colored text in linux shell script
- Ganapati Aarti: Sukhkarta Dukhharta – With English Translation | download mp3
-
MySQL Archive
-
Load Delimited Data (csv, excel) into MySQL Server
Posted on January 11, 2010 | 73 CommentsLoading csv to MySQL or any delimited data files to MySQL database is a very common task frequently questioned about and almost every-time LOAD DATA INFILE come into rescue. In... -
Petition – Help saving MySQL – II
Posted on December 29, 2009 | No CommentsRecently 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 CommentsI’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 CommentsRecently 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) -... -
Monty: Help Saving MySQL – The Oracle & EC
Posted on December 14, 2009 | No CommentsWe all are aware about the acquisition happened to MySQL; Sun and now Oracle. A common understanding tells me that a business will always seek profit; so will Oracle. And... -
Stored procedure to Find database objects
Posted on December 5, 2009 | 1 CommentThis procedure lists available database objects under passed database name. It lists present Tables, Views, Stored Procedures, Functions and Triggers under particular database. It also lists storage engine of tables.... -
MySQL Stored procedure – Split Delimited string into Rows
Posted on December 5, 2009 | 20 CommentsThis procedure will split a “;” separated column in to new fields preserving ids. This is very specific problem, lets check it with example. Consider a sample table test: And... -
MySQL Stored procedure – Execute query if table or Column exists
Posted on December 5, 2009 | 2 CommentsWell procedures mainly carried out working with information schema and it’s usage in stored procedure. Procedures are fairly simple and easy to understand. 1. Edit_table – following procedure executes queries to... -
MySQL master master replication monitor with php code
Posted on December 4, 2009 | 3 CommentsFor monitoring replication we know a lot of tools and codes – but this one is different because I wrote it Well this is fairly simple php code for monitoring... -
Calculate Mysql Memory Usage – Quick Stored Proc
Posted on November 16, 2009 | No CommentsWhile going through mysql doc and MySQL Server Memory Usage, I noted following quick points regarding how mysql uses memory. We have global buffers which are allocated irrespective of connections...