Mysql Help : Table Maintenance and Repair How to

mysqlcheck – a table maintenance and repair program

mysqlcheck must be used when the mysqld server is running, whereas myisamchk (similar in function to mysqlcheck) should be used when it is not. The benefit of using mysqlcheck is that you do not have to stop the mysql server to check or repair your tables.

mysqlcheck uses the SQL statements like CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE depend on the mysqlcheck options.

There are three general ways to invoke mysqlcheck:

#mysqlcheck [options] db_name [tables]
#mysqlcheck [options] –databases DB1 [DB2 DB3...]
#mysqlcheck [options] –all-databases

If you do not name any tables or use the –databases or –all-databases option, entire databases are checked.

mysqlcheck Option Reference:

–analyze, -a
Analyze the tables

–all-databases, -A
Check all tables in all databases. This is the same as using the
–databases option and naming all the databases on the command line

–check, -c
Check the tables for errors.

–check-only-changed, -C
Check only tables that have changed since the last check or that
have not been closed properly

–quick, -q
If you are using this option to check tables, it prevents the check
from scanning the rows to check for incorrect links. This is the
fastest check method.

If you are using this option to repair tables, it tries to repair
only the index tree. This is the fastest repair method

–fast, -F
Check only tables that have not been closed properly

–extended, -e
If you are using this option to check tables, it ensures that they
are 100% consistent but takes a long time

If you are using this option to repair tables, it runs an extended
repair that may not only take a long time to execute, but may
produce a lot of garbage rows also!

–optimize, -o
Optimize the tables

–force, -f
Continue even if an SQL error occurs

–repair, -r
Perform a repair that can fix almost anything except unique keys
that are not unique.

–auto-repair
If a checked table is corrupted, automatically fix it. Any necessary repairs are done after all tables have been checked

Mysql dump error Re: ERROR 1044 (42000): Access denied for user

Mysql dump error Re: ERROR 1044 (42000): Access denied for user

When i tried to create the backup .sql file of database through shell with mysqldump command i got the following error:

Mysqldump error:
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name'

This error mean that the problem with lock table into the database of that user so simply fetch the following command to resolve.
the issue..

# mysqldump --skip-lock-tables -u mysqluser -p password mysqldbname > mysqlfile.sql

After issue this command it will ask you the password, so provide there mysql Database password there after it will take minimum 30 min to create databse.sql file ( it's depend on database size..)

Note: make sure that at which directory you fired this command .sql file location should be the same

Spamd Failed error message in Cpanel.

Server experienced server overload problem. I restarted server, but after that after each 5 minutes i receiving error message:

spamd failed @ Sat sep 22 8:10:28 2010. A restart was attempted automagically.
Service Check Method: [check command]

Cmd Service Check Raw Output: Spamd is not running

-----------------------------------------------------------------------------------------------------------------------------------------------

You can simply use command

# /scripts/upcp --force

# /etc/init.d/cpanel restart

after that you can check the spamd status.. and everything should be fine for you..

following to check if spamd is running & restart:

# /scripts/restartsrv_spamd --status

# /scripts/restartsrv_spamd

It will work for you..! :-)

Email error : 110 Can't open SMTP stream

If you are getting following error while sending emails from squirrelmail.

---------------------------------------------------------------------------
Message not sent. Server replied:

Connection timed out
110 Can't open SMTP stream.
-----------------------------------------------------------------------------

If above case if you are having shell access then login to your server with root user, then edit
config file and do the changes as given below.

Code should be edited into :

# vi /usr/local/cpanel/base/3rdparty/squirrelmail/config/config.php

$useSendmail = false;
to:
$useSendmail = true;

restart the cpanel and exim service.

============================================================
Refresh the squirrelmail mail and check ..

Done..