sql command

/usr/libexec/mysqld: Incorrect key file for table ‘./DBNAME/TABLE_NAME.MYI’; Try To Repair It Error and Solution

by Vivek Gite on July 1, 2010 · 1 comment

I‘m getting the following error in my mysql.log file:

100630 2:03:39 [ERROR] /usr/libexec/mysqld: Incorrect key file for table ‘./app2_db/aix_data_user_c.MYI’; try to repair it

How do I fix this error and repair my table under UNIX or Linux operating systems?

{ 1 comment }

Ubuntu Linux Install MySQL Server Version 5.x

by Vivek Gite on June 23, 2010 · 0 comments

How do I install Oracle (Sun) MySQL database server v5.x under Ubuntu Linux operating systems? How do I add a new user and database for Apache web server and php access under Ubuntu Linux?

{ 0 comments }

MySQL List Databases

by Vivek Gite on April 12, 2008 · 3 comments

Q. How do I display a list of all databases under MySQL Server?

{ 3 comments }

MySQL Change root Password

by Vivek Gite on January 2, 2006 · 106 comments

How do I change MySQL root password under Linux, FreeBSD, OpenBSD and UNIX like operating system over ssh / telnet session?

{ 106 comments }