Past 2017 top best forum
Today's Date
Nigeria free 2018 Gallery
9ja NOTICE: You are currently viewing this website as a Guest and are restricted from viewing some vital information. For more permissions on Earlyface.com.ng? Like posting Comments, Topics and Uploading contents without Verification And Moderator's approval. Fast loading and quick accessibility. Registration is required. Please Login or Register now to gain full access. It is fast and free!!

CLICK HERE NOW TO BECOME EARLYFACE MEMBER...


Author Topic: How to Repair Tables in MySQL Database Using phpMyAdmin  (Read 170 times)

0 Members and 1 Guest are viewing this topic.

Offline EarlyMan

  • VIP MEMBER
  • Gifted Member
  • *
  • Posts: 367
  • Vote for me: +89/-6
How to Repair Tables in MySQL Database Using phpMyAdmin
« on: December 27, 2012, 12:38:37 am »

How to Repair Tables in MySQL Database Using phpMyAdmin

Due to day to day usage, database table becomes corrupt, thereby not giving you access to them, or bringing out error.

Some of the errors may look like this:

"Unfortunately a query has failed [DELETE FROM member_tracking WHERE mt_time<1350942237 OR (mt_member_id=2 AND mt_type=&#39;misc&#39; AND mt_id=&#39;234&#39; AND mt_page=&#39;topicview&#39;)] [Table &#39;./member_tracking&#39; is marked as crashed and should be repaired]"

The good news is that you can always fix the table so you can access the data again. Doing this in phpMyAdmin is a fairly simple process.

You are advice to always backup your data as some lost datas are not restoreable.

Repairing a MySQL Database with phpMyAdmin

Follow these instructions to repair the
MySQL Database with phpMyAdmin
  1. Sign in to your cpanel
  2. Click on phpMyAdmin
  3. In the  PhpMyAdmin, choose the affected database. If you only have one database, it should choose it by default so you don&#39;t need to do anything.
  4. In the main panel, you should see a list of your database tables. Check the boxes by the tables that need repair.
  5. Finally, look at the bottom of the window just below the list of tables, there is a drop down menu. Click on  "Repair Table"
Surely, this should fix the error.
Remember, always backup your files.
   
To be getting all EarlyFace confirmed Updates (latest news in town, free browsing cheats, hottest FREEBIES, post-UTME tips, school matter and Exam stuff) for free through your Facebook and Twitter profile;
 
  • CLICK HERE to Like EARLYFACE on Facebook
  •  
  • CLICK HERE to Follow EARLYFACE on Twitter

  •    
    How To Create A Topic On Earlyface
     
    How To Create A Topic or Post On Earlyface as a Novice.

     

    Related Topics

      Subject / Started by Replies Last post
    16 Replies
    893 Views
    Last post July 09, 2013, 11:58:28 am
    by adelabu4fred
    2 Replies
    669 Views
    Last post December 20, 2013, 04:42:27 am
    by Mr Success
    13 Replies
    2419 Views
    Last post June 02, 2016, 05:16:52 pm
    by segzy1995
    0 Replies
    629 Views
    Last post February 14, 2014, 02:36:17 pm
    by Aldrin
    0 Replies
    294 Views
    Last post September 12, 2014, 05:05:04 pm
    by JEFFREY96
    0 Replies
    160 Views
    Last post September 29, 2015, 01:53:49 pm
    by JEFFREY96
    0 Replies
    53 Views
    Last post August 08, 2018, 12:44:34 am
    by JEFFREY96

    Updated Topics

    NetContacts Membership Invitation by wedco893
    March 26, 2024, 06:42:58 pm

    NetContacts Membership Invitation by wedco893
    March 26, 2024, 06:26:58 pm

    CORRECT: 2024/2025 JAMB RUNS SUBSCRIPTION( REFORMED PACKAGES) by MANDINHO
    March 24, 2024, 09:11:15 pm

    UK FOOTBALL POOLS COUPON | 30TH MARCH 2024 | WEEK 39: X-02-X by wedco893
    March 24, 2024, 07:40:25 pm

    UK FOOTBALL POOLS COUPON | 23RD MARCH 2024 | WEEK 38: X-05-X by wedco893
    March 18, 2024, 06:52:10 pm

    Solve you've been logout for using unofficial Whatsapp app Gb Whatsapp problem by Wiz.gee
    March 16, 2024, 02:18:51 am

    Girls: Female's Education Ends In Kitchen by Babatunde aliyat
    March 12, 2024, 06:12:54 am


    FBLike US on Facebook.. TWFollow US on Twitter..

    Portal
    Forum
    RSS Feeds
    FAQ
    Members Intro
    Announcements
    Privacy Policy
    Terms Of Use
    Partners
    About Us

    Problem Solutions
    Global News
    Sports
    Celebs
    Politics
    Gists In Town
    General
    Song Lyrics
    Dating
    Religion

    Examination
    Post-UTME/Admission
    School News
    Online Reading
    Scholarship
    Education
    Entertainment
    Download Links
    Stories
    Fashion

    MTN NG
    9Mobile NG
    Airtel NG
    Glo NG
    World Networks
    Pc Tweaks
    Mobile Phone
    Computer Tips
    WebMaster
    Programming

    Browsing Cheats
    Net Tricks
    Health n Welfare
    Latest Jobs
    EarlyFace Group Of Nigeria © 2022