kill all links?

[kwilder]

I imported a tab delimited file into my new installation of indexu. I exported it from Access and didn't realize that Access would move populated fields and put them ahead of non-populated fields... So basically, it put the fields in the wrong order, moving the password field ahead of the hits, votes, etc. that are empty fields.

Now, in the "details" view of links, it has "password" as the email address.

I *think* the easiest thing to do would be to empty the links from the db and re-import them, but if anyone has a better idea let me know. In the meantime, if someone can tell me how to delete all the links (NOT manually, I'll be here all day!), that would be great.

Thanks.

-kristie

[dody]

If you know how to write sql query, you may use send it from indexu. Go to admin cp -> database table -> alter -> query box

To delete all links write this query
delete from idx_link

To delete all categories write this query
delete from idx_category

[kwilder]

Can I go into SSH and delete the link records from the tables? Would that work OK? Or would it mess something up. I intend on keeping all my categories, etc. the same. I just need to clean out all the links so I can upload them properly.

-kristie

[kwilder]

Thanks Dody, we must have been posting at the same time. I'll try it!

-kristie

[kwilder]

Can you help me with an SQL Query that would change all the dates for all the links from the 1969 date (as they are now) to the current date (or some other date?). Thanks.

-kristie

[dody]

That's okay. I feel a little confuse too