Contact: Web / Voice / Email / Tips
Simple Thoughts Blog - Java and Web Technologies

The Database Blog

 

How To Change MySQL Password

April 20th, 2008 by Angsuman Chakraborty

Let’s look at all the ways to change MySQL password, for root and other users:

Read more (78 words) »

Filed under Database, Headline News, How To, MySQL, Programming, RDBMS, Tech Note | Feedback | RSS 2.0 | Email this Article

How To Use AWK To Simplify Scripting: Multi-Database Backup Example

April 20th, 2008 by Angsuman Chakraborty

AWK is an extremely versatile and powerful language for processing files and text data. Often you can use awk to perform complex tasks on Unix / Linux / Mac OS command line which would otherwise take a full-fledged programming effort. AWK is great for log processing, creating custom scripts which will then be executed and more. For example I wanted to create a backup of all of my MySQL databases, each to a separate file after compressing them with gzip (maximum compression). I already created a list of databases on my MySQL server is a file named databases (how original!). Here is the awk script which processes the file and creates another file (named database_backup) which contains commands to backup all the databases as specified above.
Read more (172 words) »

Filed under Database, Headline News, How To, Linux, MySQL, Programming, Web | Feedback | RSS 2.0 | Email this Article

MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases

April 20th, 2008 by Angsuman Chakraborty

Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server:

Read more (149 words) »

Filed under Company, Database, Enterprise Software, Headline News, How To, MySQL, RDBMS, Tech Note, Web | Feedback | RSS 2.0 | Email this Article

MySQL High End Features Should be Closed Source & for Paid Customers Only

April 18th, 2008 by Angsuman Chakraborty

I am serious. While MySQL is a great open source database, I have full respect to Sun’s plan to provide high-end features for paying customers only. After all they are in the business of making money and not philanthropy, last I checked.

Read more (135 words) »

Filed under Company, Database, Headline News, MySQL, RDBMS, Sun, Web | 1 Comment | RSS 2.0 | Email this Article

Google To Launch Database Web Service Using BigTable?

April 5th, 2008 by Angsuman Chakraborty

TechCrunch got it from a source that Google plans to launch their BigTable, their proprietary internal database which is used for Google Search, as a web service to compete with Amazon SimpleDB Web Service.

Read more (145 words) »

Filed under Company, Database, Enterprise Software, Google, Headline News, Web, Web Services | Feedback | RSS 2.0 | Email this Article

MySQL SQL Delete Notes

November 27th, 2007 by Angsuman Chakraborty

To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id’s to delete from the original table.

Read more (140 words) »

Filed under Database, Headline News, How To, MySQL, Open Source Software, RDBMS | Feedback | RSS 2.0 | Email this Article

MySQL: Creating Users & Granting Access Simplified

November 23rd, 2007 by Angsuman Chakraborty

In MySQL you can use the GRANT statement to create users and assign privileges to them at the same time. It is extremely convenient and beats create user or directly hacking the mysql.user table. I learned few things about GRANT the hard way.

Read more (182 words) »

Filed under Database, Enterprise Software, Headline News, How To, MySQL, Open Source Software, Programming, RDBMS | Feedback | RSS 2.0 | Email this Article

6 MySQL Database Replication Tips

November 18th, 2007 by Angsuman Chakraborty

Replicating on two or more MySQL master database servers

Read more (112 words) »

Filed under Database, Database Replication, Enterprise Software, Headline News, How To, Linux, MySQL, Open Source Software, Programming, RDBMS, Tech Note, Web Hosting | Feedback | RSS 2.0 | Email this Article

Monitoring MySQL Queries Using Bash Script

November 18th, 2007 by Angsuman Chakraborty

Monitoring MySQL queries is a favorite pastime of MySQL administrators especially for performance reasons. Here is a simple bash script to monitor long running MySQL queries in realtime using the ubiquitous ’show processlist’. The best part about this script is that you can use it to log your queries over time for later evaluation.
Read more (213 words) »

Filed under Bash, Database, Enterprise Software, Headline News, How To, Linux, MySQL, Open Source Software, Programming, RDBMS, Tech Note, Web, Web Hosting, Web Services | Feedback | RSS 2.0 | Email this Article

Solution: MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master

November 16th, 2007 by Angsuman Chakraborty

When you try MySQL master-master replication with two (or more) servers you may often find that in the process of configuring the original master to also act as a slave server (start slave), it fails with the following error:

mysql> start slave;
ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO

Read more (97 words) »

Filed under Database, Database Replication, Enterprise Software, Headline News, How To, Linux, MySQL, Open Source Software, RDBMS | Feedback | RSS 2.0 | Email this Article

No. 1 method to ethically increase your blog traffic and reach.

Translate

Translate to EnglishÜbersetzen Sie zum Deutsch/GermanPřeložit do Čech/CzechOversætte hen til Dansk/DanishKääntää jotta Finnish/FinnishLefordít -hoz Magyar/HungarianÞýða til Íslenska/IcelandicTraducir a Latinoamericano Español/Latin American Spanishtagapagsalin sa Filipino/FilipinoTłumaczyć wobec Polski/PolishA traduce la spre Român/RomanianPrevesti za Srpski/Serbiantolmačiti v slovenski/SlovenianÖversätta till Svensk/SwedishChyfieitha at Cymraeg/Welshtercüme etmek -e doğru Türk/TurkishPrevesti to Hrvatski/CroatianПревеждам към Българин/BulgarianTraduzca al Español/SpanishTraduisez au Français/FrenchTraduca ad Italiano/ItalianTraduza ao Português/Portuguese日本語に翻訳しなさい /Japanese한국어에게 번역하십시오/Korean中文翻译/Chinese Simplifiedترجمة الى العربية/ArabicVertaal aan het Nederlands/DutchΜεταφράστε στα ελληνικά/GreekПереведите к русскому/RussianOversetter til Norsk/Norwegian中文翻译/Chinese TraditionalTraduzir a Língua portuguesa brasileira/Brazilian PortugueseReddo ut Latin/Latin

Taragana Network

»Ctrl-S
»Enterprise Blog
»Free Book on Eye Care by Natural Therapy
»Health Care Blog
»Hot Computer Jobs Blog
»Pet Care & Grooming News and Tips
»Phil Law Blog
»Taragana - Software Outsourcing
»The Angsuman Chakraborty Blog
»The Diabetes Cure Blog
»The Eye Treatment Blog
»The Stem Cell Blog
»Weblog Hosting Blog
"Weakness of attitude becomes weakness of character." - Albert Einstein