473,769 Members | 1,743 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Upgrade to 4.1.1 from 4.0 and keep getting corrupted table

I upgraded to MySQL 4.1.1-alpha-standard the other night and ever
since then at least twice a day my main message board table will
crash.

Here's what i get when I check on the board or analyze it:

check board:
Table Op Msg_type Msg_text
myboard.board_d ata check warning Table is marked as crashed
myboard.board_d ata check error Key in wrong position at page 3072
myboard.board_d ata check error Corrupt

analyze table:
Table Op Msg_type Msg_text
myboard.board_d ata analyze error Key in wrong position at page 3072
myboardboard_da ta analyze error Corrupt
I have been able to repair the board each time by using repair or
myisamchk.

Besides setting up a cron job to run myisamchk every few hours i have
no idea what this problem means and what I should do for it.

I know 4.1 has some problems with charsets compared to 4.0 so perhaps
this is causing the problem.

In phpMyAdmin I do see this in the row statistics section:
Charset
Notice: Undefined index: Charset in
/var/www/html/phpMyAdmin-2.5.1/tbl_properties_ structure.php on line
511

Also i couple of times the board will be up but when people try and
post they get this "Incorrect key file for table: 'board_data'; try to
repair it
INSERT INTO board_data ...

originalliy i thought this was related to a fulltext index i added on
the table but removed the index and still have the errors. I saw
something about a possible bug but think i used the latest version
available for the install.

The table has about 300,000 records in it.

any help would be appreciated. Thank you
Jul 19 '05 #1
0 1199

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

28
4059
by: Lee Rouse | last post by:
Hello all, This is going to be a rather lengthy "question". I have an Access 2k database, separated front end/back end. Front end copies are on about 30 workstations and used frequently during the work day. The backend has a table called CLIENTS with approximately 6000 client records. Changes to data in the table are made via a frontend db Form which has CLIENTS as its record source.
3
4082
by: Leinad Kong | last post by:
I'm using Access 2002, as front-end and back-end as well: 1) I faced database corrupted problems, when more than 1 user edit concurrently. I'm using All-records Locking, and open-exclusively as default. But, still face the same problem: Database corrupted! (But, it allows to be repaired) 2) I found that the relationship linkage between those related tables(which corrupted) was disconnected/lost after problem (1)
47
4544
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!
11
1334
by: John E. Fox | last post by:
Dear All, Apologies if this is a duplicate posting We are using A97 and it does what we want it to. Is there any compelling reason to upgrade to the latest version? If we do, it would probably also involve upgrading all of MSOffice at the same time, i.e. Word + Excel + Powerpoint Any advice would be appreciated.
3
2788
by: RayPower | last post by:
I'm having a system using Access 2000 as both front-end (queries, forms, reports & temp tables for reports) & back-end (data) with back-end running on the server. The application runs on the network with around 15 users. The back-end database is suffering from performance issues. There were several corruptions since few months & one major corruption & corrupted the MSysObjects table. Also, the system will run batch process that generate...
3
2174
by: NEWSGROUPS | last post by:
Is there any way to find out what database object or table was corrupt after a repair has run in Access 2000? If I can find this out I may find out why the corruption is happening. Any help would be appreciated. Thanks, Mark
13
2537
by: JakeD | last post by:
SInce about 1996, I have been happily using MS Access for Windows 95, but would now like to upgrade to a recent version. If I get a Windows XP version, will I be able to import all my Access 95 files without problems? Alternatively, should I continue applying the "if it ain't broke, don't fix it" approach, and keep on using Access for Win 95? Thank you for any advice.
13
1886
by: John | last post by:
Our technical guy says that our linux server is running PHP 4. I thought we were running 5 already. He says he wants to charge us £500 a year to install and support it because it is a lot of work, and the problems it will create on our current systems are huge etc. Now I installed 5 on my PC at home running Apache without any problems and develop sites locally and then upload to the server (running 4). I have never had a problem with...
5
1447
by: jaad | last post by:
I have built a Database to take care of everything a rental building requires: work orders, purchase orders, task scheduling and so on… it work great but wanted to make it more efficient. Here are some of the things I need to change and wanted to know if it is possible to do it in a way that would be bullet proof. I currently use the “Work Orders” portion of the database to create a record when a building resident requires work performed at...
0
9423
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10212
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9995
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9863
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8872
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5304
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3962
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3563
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2815
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.