The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

OS commerce db corupted

Discussion in 'General Discussion' started by cbwass, Jun 30, 2003.

  1. cbwass

    cbwass Well-Known Member

    Joined:
    Mar 29, 2002
    Messages:
    148
    Likes Received:
    0
    Trophy Points:
    16
    Hi,
    I have OS Commerce running on a domain, and every 7 to 10 days the db becomes corupted. My client normaly calls and from WHM I run 'Repair a Local DataBase' to fix it, this is OK if I'm available.
    I can also run the following command from root to fix it 'myisamchk -r /var/lib/mysql/db_name/*.MYI', could someone help me by telling me what I should put in a Cron tab to run this every 30 mins., so if I'm not avaliable the thing will fix it's self.
    Is there a way for the client to fix it?
    Thanks.

    cPanel.net Support Ticket Number:
     
  2. MatthewMKSolutions

    Joined:
    Aug 11, 2002
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    What version of SQL are you running?

    cPanel.net Support Ticket Number:
     
  3. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    36
    If you've repaired the database numerous times you may want to consider some alternatives:

    1. dumping, removing, re-creating and importing the database.

    2. fsck /var

    3. check to make sure that you're using the 4.x client with the 4.x server.

    You may also want to check dmesg, messages & the mysql error log to see if there are any clues there.

    cPanel.net Support Ticket Number:
     
  4. cbwass

    cbwass Well-Known Member

    Joined:
    Mar 29, 2002
    Messages:
    148
    Likes Received:
    0
    Trophy Points:
    16
    I'm using mysql (4.0.13)

    cPanel.net Support Ticket Number:
     
  5. MatthewMKSolutions

    Joined:
    Aug 11, 2002
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    The only way I got rid of the database corruption problems was to downgrade from 4.x to 3.x. As far as I know, 4.x has not been fixed yet.

    cPanel.net Support Ticket Number:
     
  6. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    36
    4.x works fine. Just make sure that you have the 4.x client compiled and that your applications are up to date.

    cPanel.net Support Ticket Number:
     
  7. MatthewMKSolutions

    Joined:
    Aug 11, 2002
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Can you contact me via email. I would like to know more about this client. Thanks! :)

    cPanel.net Support Ticket Number:
     
  8. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    36
    And where might one find your email address? :P

    cPanel.net Support Ticket Number:
     
  9. MatthewMKSolutions

    Joined:
    Aug 11, 2002
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
  10. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    36
    I might as well just explain it in these forums again. When you're running the 4.x server by choosing it in tweak settings or your machine comes with it the client that's used to connect to MySQL is left at 3.x.

    Basically what you have to do is recompile PHP on your machine. If you have a new directory of the buildapache source then you can use that, simply go to the PHP source directory within, get the old configure command via phpinfo page (for the lazy), make clean, use the configure command you snagged from phpinfo but change the mysql path to /usr (i.e. --with-mysql=/usr), make, make install. Restart apache and you're gold.

    I make no warranties, use at your own risk, yadda yadda yadda.

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page