June 28, 2010
by Mohan Cheema
0 comments
Fatal error: Can’t open and lock privilege tables: Table ‘mysql.db’ doesn’t exist
I faced this problem while I was shifting the location of mysql data directory to non-default location. I copied all the files from /var/lib/mysql(default data location) to the /data and changed path in /etc/my.cnf also.
June 8, 2010
by Mohan Cheema
0 comments
Blobbing Data With PHP and MySQL
Databases can be used for storing large amounts of binary data, known as BLOB’s. These BLOB’s can store just about any type of data imaginable, including MS Word documents, GIF/JPEG images, PDF files, MP3′s, etc. In this article we will see how to create a binary file repository using PHP and MySQL that can store and retrieve several different file types.
May 24, 2010
by Mohan Cheema
0 comments
One of the most versatile SSL tools is OpenSSL which is an open source implementation of the SSL protocol. There are versions of OpenSSL for nearly every platform, including Windows, Linux, and Mac OS X. OpenSSL is commonly used to create the CSR and private key for many different platforms, including Apache. However, it also has hundreds of different functions that allow you to view the details of a CSR or certificate, compare an MD5 hash of the certificate and private key (to make sure they match), verify that a certificate is installed properly on any website, and convert the certificate to a different format. A compiled version of OpenSSL for Windows can be found here.
May 6, 2010
by Mohan Cheema
0 comments
I continuously forget the syntax for this (doesn’t help that it’s different in every database engine):
select table_name from user_tables;
Shows all user tables. You can also do:
select owner,table_name from all_tables;
which shows all tables.
To see what a particular table looks like, you can do:
April 28, 2010
by Mohan Cheema
0 comments
In todays system you will hardly find the Too many open files error. However, if you are running Java application and processing it taking time you see these errors in your application log.
April 28, 2010
by Mohan Cheema
0 comments
You need to use Memtest86 utility for Linux memory testing. It is software designed to stress-test an x86-compatible computer’s random access memory for errors.
You can run software from a bootable floppy disk or CD-ROM without an operating system being present.
April 27, 2010
by Mohan Cheema
0 comments