1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

MySQL Repair Issue

Discussion in 'Plesk for Linux - 8.x and Older' started by timraines, Apr 4, 2006.

  1. timraines

    timraines Basic Pleskian

    23
    23%
    Joined:
    Feb 3, 2006
    Messages:
    32
    Likes Received:
    0
    Location:
    Australia
    Hey Guys

    I have a issue.. which I think is small, but well really don't know! ..:confused:

    I have Plesk 7.5.4, so its MySQL 4.x .. Now my issue is with a full text search I have running here, http://kb.raines.com.au/ The search wont find things, using the mysql documentation, I learn its related to the fact that I am using this in my SQL statement, BOOLEAN MODE
    Example:
    Code:
    MATCH(article,issue) AGAINST ('$ArticleQ' IN BOOLEAN MODE)
    Now, I work out its all related to the fact that the database has just moved from a SQL server running v3.23 of MySQL and that I need to re-build the indexes, thats fine, so I go an do that from the console, I run this:
    Code:
    REPAIR TABLE tbl_KBArticles USE_FRM;
    And receive a syntax error! Says near the USE_FRM; part. And when I try the QUICK option instead it works, though thats no help because the mysql documentation specifically states that when you use BOOLEAN MODE you need to use the USE_FRM switch for the repair function.

    So does anyone have ideas, this script has not been changed and used to work brilliantly before I moved it to the new server (PLESK) and the updated version of MySQL. So the script is fine, far as I see it.

    Help would be much appreciated, or a direction to where to go.

    Thanks, ;)
     
  2. timraines

    timraines Basic Pleskian

    23
    23%
    Joined:
    Feb 3, 2006
    Messages:
    32
    Likes Received:
    0
    Location:
    Australia
    Any Ideas? :)
     
  3. jimmyr

    jimmyr Guest

    0
     
    Re: My SQL Database Repair

    Many a time the database gets corrupt or damaged.It happens so because of virus attack. The solution to this problem is My SQL Database Repair software. This software repairs the corrupt database by using sophisticated algorithm and program. This software first search for the corrupt tables through powerful scanning and after that it repairs them. After when the repair work is over, the software displays the repaired database tables on the screen in a thumbnail pattern.
     
  4. David Poul

    David Poul Guest

    0
     
    The database gets corrupt or damaged due to which such error occurs. To resolve this problem or error you need mysql repair software. This software eepair and recover corrupted MySQL database from MyISAM and InnoDB storage engines across Windows and Linux platforms with precision by using powerfull algorithm.

    David
     
Loading...