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?
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?
How do I access MySQL server from the shell prompt (command line)?