Results 1 to 2 of 2
  1. #1
    volkerjung's Avatar
    volkerjung is offline Novice
    Windows Vista Access 2003
    Join Date
    Sep 2015
    Posts
    1

    MySQL slave table crashed, how to fix it?

    I have a corrupt MySQL slave table, it says:
    table is marked as crashed and last repair failed



    Of course, when i ran repair statement, it still showed: Corrupt

    My purpose is to quickly restore the slave table. Since master table is good, my question is can i use one of the two options listed below:
    1. Drop slave table, stop and start slave again, will replication automatically restore the slave table? (previously the replication was working fine)
    2. Drop slave table, use mysqldump to dump the master table to slave table (suppose there is not much traffic at this time).

    Thanks for any suggestion.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I backup (about) everyday. I import all tables to an Access database.
    if needed, export data back to MySql tables.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Inserting Data to Access Table (Local) from MySQL table (Net)
    By gambit1430 in forum Import/Export Data
    Replies: 2
    Last Post: 09-26-2014, 01:34 AM
  2. Update Master Table Baesd on Slave Table
    By alexbeatle in forum Queries
    Replies: 7
    Last Post: 09-21-2014, 01:06 PM
  3. Replies: 4
    Last Post: 07-08-2014, 08:59 AM
  4. mySQL statement not updating table!!
    By Ran in forum SQL Server
    Replies: 3
    Last Post: 01-10-2012, 11:48 AM
  5. Office 2010, 64 bit crashed
    By gppkuntz in forum Access
    Replies: 2
    Last Post: 12-21-2010, 06:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums