EPrints Technical Mailing List Archive
See the EPrints wiki for instructions on how to join this mailing list and related information.
Message: #09495
< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First
[EP-tech] Subject: Error 1194 - 'Access' Table Issue - Repair Required?
- To: eprints-tech@ecs.soton.ac.uk
- Subject: [EP-tech] Subject: Error 1194 - 'Access' Table Issue - Repair Required?
- From: Noorhafizah Mohd Akil <noorhafizah_ma@iium.edu.my>
- Date: Fri, 1 Dec 2023 15:58:37 +0800
CAUTION: This e-mail originated outside the University of Southampton.
Hello all.
I encountered an error for the 'access' table as follows:
Error 1194: Table 'access' is marked as crashed and should be repaired when dumping table 'access' at row 34762479.
The total in the 'access' table is:
sql
Copy code
SELECT count(*) FROM iiumprints.access;
-- Result: 34772338
Do I need to repair it? Is there a risk of data loss, or will a database crash occur?
Thank you in advance.
Error 1194: Table 'access' is marked as crashed and should be repaired when dumping table 'access' at row 34762479.
The total in the 'access' table is:
sql
Copy code
SELECT count(*) FROM iiumprints.access;
-- Result: 34772338
Do I need to repair it? Is there a risk of data loss, or will a database crash occur?
Thank you in advance.
- Follow-Ups:
- Re: [EP-tech] Subject: Error 1194 - 'Access' Table Issue - Repair Required?
- From: Yuri <yurj@alfa.it>
- Re: [EP-tech] Subject: Error 1194 - 'Access' Table Issue - Repair Required?
- Prev by Date: [EP-tech] Want to know total id item on document folder
- Next by Date: Re: [EP-tech] Subject: Error 1194 - 'Access' Table Issue - Repair Required?
- Previous by thread: [EP-tech] Want to know total id item on document folder
- Next by thread: Re: [EP-tech] Subject: Error 1194 - 'Access' Table Issue - Repair Required?
- Index(es):