Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Restoring Backup

Quote Reply
Restoring Backup
Hi,

I've just restored a backup of 38,000 links. I can see all the links in mysqlman and they all listed when doing the import. For example it counted every 1000 links as it was importing as well as the categories etc......

However when I repair and reindex it finishes in minutes and says there are 0 links.

Link Status in the admin panel shows New Links : 38,000 and I can still see them in mysqlman so they are definitely there but reindexing/repairing and rebuilding all show 0 links

Any tips most welcome.

Last edited by:

RedRum: Oct 16, 2001, 10:35 AM
Quote Reply
Re: [RedRum] Restoring Backup In reply to
Oh also Verify Links checks 38,000 links so I know they are there.
Quote Reply
Re: [RedRum] Restoring Backup In reply to
Hi!

Would you mind to insert first two lines of your import or export file ... i'm still having problems with categories ...

Gregor
Quote Reply
Re: [sc2utp] Restoring Backup In reply to
How do you mean?

The backup file?

I'm importing from a file in the backup directory and it is 50MB
Quote Reply
Re: [RedRum] Restoring Backup In reply to
i meant first two lines of your backup file ... i would like to see which fields do you have in pipe delimited ... my export won't export categories so i cannot import them back ...

thanx

Gregor
Quote Reply
Re: [sc2utp] Restoring Backup In reply to
It's a Links SQL backup - not a mysql export.
Quote Reply
Re: [RedRum] Restoring Backup In reply to
aaha ... i thought you exported it to a file ... is there a way to add new links into backup databse ...?

Gregor
Quote Reply
Re: [sc2utp] Restoring Backup In reply to
The backup is created everytime you build.
Quote Reply
Re: [RedRum] Restoring Backup In reply to
yeikssss .. sorry . you have RESTORED from backup .. sorry for not reading the first article carefully enough ...

Gregor
Quote Reply
Re: [sc2utp] Restoring Backup In reply to
Yup that's correct :)

The links are in the database but Links SQL is ignoring them for some reason :(
Quote Reply
Re: [RedRum] Restoring Backup In reply to
Hi,

Reindex will finish right away if you have no weights set. Repair shouldn't though. Do you have entries in CatLinks table? Does the Browse function work?

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Restoring Backup In reply to
Hi,

Browse works but all totals are 0 even after re-indexing


Here are some table totals.....

lsql_CatLinks 38433
lsql_Category 3827
lsql_Category_Score_List 3080
lsql_Category_Word_List 1075
lsql_Links 38436
lsql_Links_Score_List 77205
lsql_Links_Word_List 19028

(3 links are not in a category)

Last edited by:

RedRum: Oct 16, 2001, 1:09 PM