Hello,

When Alex first installed links SQL h did the DB impot for me. I tried to update the DB with a new Links 2.0 DB and figured it would overwrite the old links. It did not. I now have twicethe amount of links as before.

How do I delete the DB and start from scratch? OR what is the best method?

------------------
James L. Murray
VirtueTech, Inc.
www.virtuetech.com

Use the setup.cgi to drop all the tables, and recreate them. Then import the new data.

If you've made changes to the .def files -- such as defaults, weights, and stuff, copy those to a local directory, drop the tables, recreate them, then copy the old def files over the ones that were just created, and go from there.

Remember, to turn off any "required" fields when importing, but if you were able to import already, that's not a problem for you.

------------------
POSTCARDS.COM -- Everything Postcards on the Internet www.postcards.com
LinkSQL FAQ: www.postcards.com/FAQ/LinkSQL/

Hello!

The best possibility known to me or rather faster than using
setup.cgi and re-creating the tables entirely new is as follows:

1.
Start editor.cgi
2.
Look in the function Import data
3.
Click on delete old data and make sure its checked.
Import the data through editor.cgi. I assume that the format is
compatible. The editor.cgi will gulp all the data to be imported while
it has already digested the old one in there during the work in progress!

The simplest way to clear data from just one database like Links or Categories is to go to SQL Monitor and type:

DELETE FROM Links

That would clear all the data in the database "Links" in the same way you could clear categorie data like this:

DELETE FROM Category

You could also do this a few times and clear all your data.

Steven