How to Fix MySQL Database (MyISAM / InnoDB)


 
Thread Tools Search this Thread
Operating Systems Solaris Solaris BigAdmin RSS How to Fix MySQL Database (MyISAM / InnoDB)
# 1  
Old 10-14-2008
How to Fix MySQL Database (MyISAM / InnoDB)

This tip describes seven ways to fix your MySQL database when a simple restart doesn't do the trick or when you have corrupt tables.

More...
Login or Register to Ask a Question

Previous Thread | Next Thread

2 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to fix connection to Oracle database through shell script?

I have a question regarding how to connect to Oracle Database through shell script. 1. If I want call a stored procedure on Linux server as this, it works. $sqlplus /nolog SQL*Plus: Release 12.1.0.2.0 Production on Fri Jun 12 14:49:49 2015 Copyright (c) 1982, 2014, Oracle. All rights... (2 Replies)
Discussion started by: duke0001
2 Replies

2. Web Development

Unkown table Engine 'InnoDB' on a RedHat server with MySQL v5!

hi all, After installing MySQL Source Code on my RedHat machine and compiling it, i no longer have access to some of my DBs having this error message. Unkown table Engine 'InnoDB' Before this step, i used to have another MySQL instance that used to work properly with all the DBs i do have,... (7 Replies)
Discussion started by: mehdi1973
7 Replies
Login or Register to Ask a Question
perror(1)							  MySQL database							 perror(1)

NAME
perror - describes a system or MySQL error code. SYNOPSIS
perror [OPTIONS] [ERRORCODE [ERRORCODE...]] DESCRIPTION
Can be used to display a description for a system error code, or an MyISAM/ISAM table handler error code. The error messages are mostly system dependent. OPTIONS
-?|--help Displays this help and exits. -I|--info Synonym for the above. -s|--silent Only print the error message -v|--verbose Print error code and message (default). -V|--version Displays version information and exits. EXAMPLE
shell> perror 64 79 Error code 64: Machine is not on the network Error code 79: Can not access a needed shared library SEE ALSO
isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi- lege_tables(1), mysqlshow(1), mysql_zap(1), replace(1) For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online at http://www.mysql.com/doc/en/ BUGS
Please refer to http://bugs.mysql.com/ to report bugs. AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur- media.com) ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +--------------------+------------------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +--------------------+------------------------------------+ |Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt | +--------------------+------------------------------------+ |Interface Stability | External | +--------------------+------------------------------------+ NOTES
Source for mysql is available on http://opensolaris.org. MySQL 4.0 19 December 2000 perror(1)