I need to know how to clear my database of links. I added them incorrectly by tab file and now i need to remove them. How do i do it without doing it manually. There are over 5000 links. Thanks,
brickholius
Active Member
Remove all added links
I need to know how to clear my database of links. I added them incorrectly by tab file and now i need to remove them. How do i do it without doing it manually. There are over 5000 links. Thanks,
brickholius
Active Member
run the following mysql command from the the INDEXU Admin Control Panel or from phpmyadmin ( this also resets the auto increment of link_id to 1 ):
TRUNCATE TABLE idx_link
Last edited by esm; 10-27-2004 at 01:00 PM.
esm
"The older I get, the more I admire competence, just simple competence, in any field from adultery to zoology."
.
Active Member
I also tried phpmyadmin for the first time. I just clicked on the link portion of the database and emptied it (truncated). and it solved my problem.
Thanks esm! i will definitly give that a try from indexu instead of going into phpmyadmin.
brickholius
Active Member
if you ran the TRUNCATE TABLE idx_link, you are fine.
if not, you may want to reset the auto increment value of link_id. otherwise, it will be 5000 or whatever the last (highest) link id number was before you deleted all the links.
esm
"The older I get, the more I admire competence, just simple competence, in any field from adultery to zoology."
.
Active Member
Yes, i ran the TRUNCATE TABLE idx_link from phpmyadmin. But next time i will try from indexu admin screen.
Posting Permissions
