Overclock.net › Forums › Specialty Builds › Servers › MySQL Database Keeps Erroring Tables....
New Posts  All Forums:Forum Nav:

MySQL Database Keeps Erroring Tables....

post #1 of 7
Thread Starter 
Alright I have a very small/simple webserver that is mostly for my own learning and keeping contact with some close friends.

I have upgraded to Windows Server 2003 and reinstalled Appserv and PHPBB3. Now when the server is running sometimes the database will end up with damaged tables and I have to repair them. I have done 4 in the past 8 hours. I never had an issue with Windows Server 2000. What gives? I don't want to roll back because I plan on hosting a game with this server and Windows 2000 just can't support it.


Suggestions? Maybe.......sigh.....Linux?
    
CPUMotherboardGraphicsRAM
Intel Overdrive 486DX4 100Mhz Digital Venturis 466 S3 Trio 32 1MB 68MB 72 Pin SIMMs 
Hard DriveOptical DriveOSMonitor
1.2Gb & 270Mb 32X CD-ROM Windows 98 SE LG 23" Flatron 
KeyboardPowerCaseMouse
Microsoft PS/2 Lite-On Digital Venturis 466 Logitech PS/2 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Intel Overdrive 486DX4 100Mhz Digital Venturis 466 S3 Trio 32 1MB 68MB 72 Pin SIMMs 
Hard DriveOptical DriveOSMonitor
1.2Gb & 270Mb 32X CD-ROM Windows 98 SE LG 23" Flatron 
KeyboardPowerCaseMouse
Microsoft PS/2 Lite-On Digital Venturis 466 Logitech PS/2 
  hide details  
Reply
post #2 of 7
maybe you shouldnt use appserv, why dont you try using another prepackage like easyphp, there is no problems with mysql and windows 2003
post #3 of 7
Thread Starter 
Well I have been using appserv for years with zero problems. I upgrade to Windows 2003 and have problems?

I tried easyphp before, i'll look at it again. I doubt I will be changing.
    
CPUMotherboardGraphicsRAM
Intel Overdrive 486DX4 100Mhz Digital Venturis 466 S3 Trio 32 1MB 68MB 72 Pin SIMMs 
Hard DriveOptical DriveOSMonitor
1.2Gb & 270Mb 32X CD-ROM Windows 98 SE LG 23" Flatron 
KeyboardPowerCaseMouse
Microsoft PS/2 Lite-On Digital Venturis 466 Logitech PS/2 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Intel Overdrive 486DX4 100Mhz Digital Venturis 466 S3 Trio 32 1MB 68MB 72 Pin SIMMs 
Hard DriveOptical DriveOSMonitor
1.2Gb & 270Mb 32X CD-ROM Windows 98 SE LG 23" Flatron 
KeyboardPowerCaseMouse
Microsoft PS/2 Lite-On Digital Venturis 466 Logitech PS/2 
  hide details  
Reply
post #4 of 7
I use mysql and easyphp in windows server 2003. No issues as of yet.
    
CPUMotherboardGraphicsRAM
E6600 Conroe @ 3.4 ASUS P5N32-E SLI XFX 9800GTX OCZ DDR2 PC7200 2x 1GB Gold Series 
Hard DriveOptical DriveOSMonitor
SATAII Seagate Perpendicular 250GB NEC DL DVD+/-R Vista Ultimate 19" WS HD HDCP Gateway 
KeyboardPowerCaseMouse
Logitech G15 Thermaltake Toughpower 750watt Apevia X-Discovery ATX Mid Diamondback Razor 
Mouse Pad
Geeksquad Special... 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
E6600 Conroe @ 3.4 ASUS P5N32-E SLI XFX 9800GTX OCZ DDR2 PC7200 2x 1GB Gold Series 
Hard DriveOptical DriveOSMonitor
SATAII Seagate Perpendicular 250GB NEC DL DVD+/-R Vista Ultimate 19" WS HD HDCP Gateway 
KeyboardPowerCaseMouse
Logitech G15 Thermaltake Toughpower 750watt Apevia X-Discovery ATX Mid Diamondback Razor 
Mouse Pad
Geeksquad Special... 
  hide details  
Reply
post #5 of 7
What kind of tables are you using, and what recovery mode are you running MySQL in?

Also, what version of MySQL are you running? I run a MySQL4 server with about 3000 databases on it, and we very rarely have tables that get corrupted. My first guess would be that you're having problems with your disk, as typically MySQL doesn't easily corrupt its tables on its own.
My System
(13 items)
 
   
CPUMotherboardGraphicsRAM
Intel Core2 Quad Q6600 Asus Maximus Formula Zotac Geforce 8800GT 8GB Kingston DDR2800 
Hard DriveOptical DriveOSMonitor
80GB Intel X25M G2 Ben-Q DVD+-RW Windows 7 Ultimate Dual Dell 19" Trinitrons + 1 Hanns-G 19" LCD 
KeyboardPowerCaseMouse
MS Natural Multimedia Rosewill RX750-D-B Antec 900 Razer Diamondback 
Mouse Pad
Razer eXactMat 
CPUCPUMotherboardRAM
Intel Xeon Intel Xeon 440BX Desktop Reference Platform Kingston ValueRam - 72GB 
Hard DriveHard DriveHard DriveOS
Seagate Barracuda ES.2 Hitachi HUS724040ale640 Micron M500DC VMware ESXi 6.0 
Other
Synology ds2015xs 
  hide details  
Reply
My System
(13 items)
 
   
CPUMotherboardGraphicsRAM
Intel Core2 Quad Q6600 Asus Maximus Formula Zotac Geforce 8800GT 8GB Kingston DDR2800 
Hard DriveOptical DriveOSMonitor
80GB Intel X25M G2 Ben-Q DVD+-RW Windows 7 Ultimate Dual Dell 19" Trinitrons + 1 Hanns-G 19" LCD 
KeyboardPowerCaseMouse
MS Natural Multimedia Rosewill RX750-D-B Antec 900 Razer Diamondback 
Mouse Pad
Razer eXactMat 
CPUCPUMotherboardRAM
Intel Xeon Intel Xeon 440BX Desktop Reference Platform Kingston ValueRam - 72GB 
Hard DriveHard DriveHard DriveOS
Seagate Barracuda ES.2 Hitachi HUS724040ale640 Micron M500DC VMware ESXi 6.0 
Other
Synology ds2015xs 
  hide details  
Reply
post #6 of 7
Thread Starter 
I also have mysql4 and the database is for nothing more than a phpbb3 forums so it's about 70 tables. The errors seem to have stopped now? I have no idea what happened.
    
CPUMotherboardGraphicsRAM
Intel Overdrive 486DX4 100Mhz Digital Venturis 466 S3 Trio 32 1MB 68MB 72 Pin SIMMs 
Hard DriveOptical DriveOSMonitor
1.2Gb & 270Mb 32X CD-ROM Windows 98 SE LG 23" Flatron 
KeyboardPowerCaseMouse
Microsoft PS/2 Lite-On Digital Venturis 466 Logitech PS/2 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Intel Overdrive 486DX4 100Mhz Digital Venturis 466 S3 Trio 32 1MB 68MB 72 Pin SIMMs 
Hard DriveOptical DriveOSMonitor
1.2Gb & 270Mb 32X CD-ROM Windows 98 SE LG 23" Flatron 
KeyboardPowerCaseMouse
Microsoft PS/2 Lite-On Digital Venturis 466 Logitech PS/2 
  hide details  
Reply
post #7 of 7
Quote:
Originally Posted by keith27 View Post
I also have mysql4 and the database is for nothing more than a phpbb3 forums so it's about 70 tables. The errors seem to have stopped now? I have no idea what happened.
I would definately atleast check the integrity of your hard disks.
    
CPUMotherboardGraphicsRAM
E6600 Conroe @ 3.4 ASUS P5N32-E SLI XFX 9800GTX OCZ DDR2 PC7200 2x 1GB Gold Series 
Hard DriveOptical DriveOSMonitor
SATAII Seagate Perpendicular 250GB NEC DL DVD+/-R Vista Ultimate 19" WS HD HDCP Gateway 
KeyboardPowerCaseMouse
Logitech G15 Thermaltake Toughpower 750watt Apevia X-Discovery ATX Mid Diamondback Razor 
Mouse Pad
Geeksquad Special... 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
E6600 Conroe @ 3.4 ASUS P5N32-E SLI XFX 9800GTX OCZ DDR2 PC7200 2x 1GB Gold Series 
Hard DriveOptical DriveOSMonitor
SATAII Seagate Perpendicular 250GB NEC DL DVD+/-R Vista Ultimate 19" WS HD HDCP Gateway 
KeyboardPowerCaseMouse
Logitech G15 Thermaltake Toughpower 750watt Apevia X-Discovery ATX Mid Diamondback Razor 
Mouse Pad
Geeksquad Special... 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Servers
Overclock.net › Forums › Specialty Builds › Servers › MySQL Database Keeps Erroring Tables....