Webmastersite.net
Register Log In

SQL Database problem
I am struggling to import an sql database

Comments on SQL Database problem

Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007

Total Topics: 32
Total Comments: 130
Jez
Posted Jan 19, 2007 - 7:48 AM:

I just bought WSN Links Simple and have a pre existing SQL database to import. I have imported the DB into MySQL with no problems but I cannot get WSN to display any of the data.

I don't seem to be able to find a tutorial on this subject. Am I missing something simple here or amd I trying to accomplish a difficult task that no newbie should ever tackle?

I would really appreciate some help, pointers, advice! i know this probably won't be much of an influence but if i can get this one database to load and work correctly I have another 7 to do. That means another 7 copies of the WSN Links script I have to buy! :-)
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jan 20, 2007 - 3:55 PM:

There are two ways to do SQL imports:

1) Adapt one of the existing importers such as the PHPLinkDirectory importer: scripts.webmastersite.net/w...snlinks/?section=resources
2) Transform all the fields of the old table via phpmyadmin to use the WSN names, remove extranous fields, export with complete inserts, then import to the WSN table and set needed data like validated=1, then regenerate counters.

amd I trying to accomplish a difficult task that no newbie should ever tackle?

It certainly isn't trivial. If you aren't comfortable with phpmyadmin and aren't comfortable editing a PHP file then you may not have much luck. Of course it can always be purchased as a custom project.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.