mysql crashing after restore

Hello, I have a server that was using raid5. I also did a daily rsync from the machine. The raid5 failed and the data was lost. I recopied all of the data back to the machine from the backup. Most of which was a 133G ibdata1 file. Now when I try to start mysql I get the following: ---

InnoDB Assertion failure

Greetings. MySQL 4.0.20 has run flawlessly here for 7 months on a Linux 2.4.18-14 (Redhat 8) box serving 5 small databases for PHP websites. But something appears to have happened to my installation on Dec 23 that now prevents MySQL from starting. I've reviewed the instructions about forcing Inn

Re: if you know the answer,please answer immediately contd

Take a look at http://dev.mysql.com/doc/mysql/en/myisamchk_syntax.html and http://dev.mysql.com/doc/mysql/en/myisamchk_memory.html & http://groups.google.be/groups?hl=nl&lr=&ie=UTF-8&threadm=cb9qd5%241oqt%241%40FreeBSD.csie.NCTU.edu.tw&rnum=3&prev=/groups%3Fq%3Dmyisamchk%2Bmonitoring%26hl%3Dnl%26

Delivery reports about your e-mail

Eø¬ÇМnµòDýÙ×w”¦3åGuG³‡¥fÓÉXÉ8©ô”Id…ÔRÖÒQËÇb5':R|LHrxšÅNÏðR¼Nø.¨µ–aŒ‹õ¹jtvª%ð·¹ßSµ}êŠ µÚqäËßÁÌ~KβÔ`:écn­è™ï›øx}Gdq“ïX (×<9,±zU®:`þ§ÖÑpOÙæ۪ܛ©Ü2ëߍ ò\ªÞ8-ÂA˜!‹?²ƒ\ãH4?jÞ0± 3P«d ï_|¢¦(§ŽÒèà‘Š‡Û4?Mz‰Äìn{º«ðÛ_ƒÊÐ2½áA•£YAt½ïHuÔ Š~#TécPÈøÒRKã‹µð‚¹·Ò¼3"j5ªoòh—û¼×½;ËX^ÚušÉÒïÑÏÜ÷#5ôd/†úéVø0éÀ¾î

Questions About Creating Tables

I have some questions about some instructions for recreating tables I'm trying to follow: 1. This first table is the simplest. The only thing I don't understand is "serial." I created char and date columns easily enough, but I don't see "serial" listed in phpMyAdmin. create table "itis".kingdoms

MySQL 4.0.23 wrong shared libraries output??

4.0.22 libdbug.a libmyisam.a libmysqlclient.so.12.0.0 libnisam.a libheap.a libmyisammrg.a libmysqlclient.so libmystrings.alibvio.a libmerge.a libmysqlclient.la libmysqlclient.so.12libmysys.a 4.0.23 libdbug.a libmerge.a libmyisammrg.a libmysqlclient

Re: Copying DB and full-text search files from one server to another

Hello. Like MyISAM data files, InnoDB data and log files are binary-compatible on all platforms if the floating-point number format on the machines is the same. You can move your database by copying all the relevant files. If the floating-point formats on the machines are different but you

Re: How to change root password - getting error

Hello. >Worst case, do I just uninstall and reinstall mysql? Don't panic :) My opinion: this situation looks similar to the example described at: http://dev.mysql.com/doc/mysql/en/Connection_access.html May be you have several entries at user table. Can you login using your old passw

Re: last_insert_id() and load data infile

Hello. As said at: http://dev.mysql.com/doc/mysql/en/Information_functions.html "If you insert many rows at the same time with an insert statement, LAST_INSERT_ID() returns the value for the first inserted row." LOAD DATA INFILE inserts several rows a time, so this is a usual behavio