database name

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

by 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 }

Import MySQL Dumpfile, SQL Datafile Into My Database

by on August 23, 2006 · 61 comments

How can I import a MySQL dumpfile into my database? I’m using CentOS Linux 5 server. My old hosting provider gave me a data.sql file and I do have access to my Unix / Linux server via ssh. So How do I restore my data using command line over the ssh session?

{ 61 comments }

Access MySQL Server From The Shell Prompt (Command Line)

by on March 28, 2006 · 7 comments

How do I access MySQL server from the shell prompt (command line)?

{ 7 comments }