Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Cannot restore from backup: error 145

Quote Reply
Cannot restore from backup: error 145
My database has crashed for some reason or other. When I attempt to restore it from a backup I made a couple of weeks ago, I get the following error message for every link.

Importing lsql_Links ... (starting at line 9 of /web1/users/u2380/sites/bananaguide.com/cgi-bin/links/admin/linkssqlbackup.sql)
Starting import to table lsql_Links ...
WARNING: Unable to import `1|Amazon|http://www.amazon.com|admin|2003-04-24|2003-04-24|Biggest online book store on the Net.|||2451|No|No|No|Yes|0.00|0|200|2003-08-12 00:00:00|20030826114449' (line 9 of /web1/users/u2380/sites/bananaguide.com/cgi-bin/links/admin/linkssqlbackup.sql): Can't open file: 'lsql_Links.MYI'. (errno: 145)

Can someone help me?

Thank you,

Trevor
Quote Reply
Re: [trevorx] Cannot restore from backup: error 145 In reply to
Your database is corrupt. In MySQLMan, cna you type;

REPAIR TABLE lsql_Links

If that doesn't fix the problem, then you may need to get your host to run myiasmchk on them.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Cannot restore from backup: error 145 In reply to
Hi Andy,

When I go into MySQLMan I get an error message:

Error

MySQL said: Can't open file: 'lsql_Links.MYI'. (errno: 145).

Query: SELECT COUNT(*) FROM lsql_Links

I don't see where I can input the REPAIR command that you suggest.

Trevor
Quote Reply
Re: [trevorx] Cannot restore from backup: error 145 In reply to
You're gonna have to get your host to run myiasmchk for you on your database I think :(

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!