Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Import Successful but empty db :(

Quote Reply
Import Successful but empty db :(
I just tried to import from Links SQL 1.13 into NG Final.

I had imported two categories from DMOZ into SQL 1.13 and made a backup of Links and Categories.

When I went to the import area and restored the data from the backups, for both the categories and links I got no errors and it said the imports were successful, however MySQLMan shows nothing has been added to the database and no pages are built after running nph-build.cgi.

I re-indexed and rebuilt but nothing worked :(

Any ideas?

Paul Wilson.
http://www.wiredon.net
Quote Reply
Re: Import Successful but empty db :( In reply to
Paul:

This sounds like the same trouble I ran into upgrading from b5. Alex created a post at
http://www.gossamer-threads.com/p/123795 that I think will solve your problem. You need to run these queries in order to update your tables. Don't ask me why. It's way over my head. All I know is it worked. And ignore the error messages when running the queries.

Mark Brasche
http://SurfSafely.com/
Quote Reply
Re: Import Successful but empty db :( In reply to
Thanks....I'll give it a try.......

Paul Wilson.
http://www.wiredon.net
Quote Reply
Re: Import Successful but empty db :( In reply to
Ugh...no sorry......thinking about it, I actually installed into a new mysql db so it can't be that.

Thanks anyway.

Paul Wilson.
http://www.wiredon.net
Quote Reply
Re: Import Successful but empty db :( In reply to
Installed to new but backed up from old. Did you try it anyway? Humor me.

Mark Brasche
http://SurfSafely.com/
Quote Reply
Re: Import Successful but empty db :( In reply to
Did you look at the database? What is in it?

Also, after importing Dmoz, did you run re-index, and check for lost cats? Shouldn't matter, but it might.

Also, you might want to make sure your paths are really where you think they are. Make sure hwat you are importing is what you mean to import.

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://LinkSQL.com/FAQ


Quote Reply
Re: Import Successful but empty db :( In reply to
Thanks for the tips everyone....I will give them all a try.

Paul Wilson.
http://www.wiredon.net