Welcome! Log In Create A New Profile


Empty Database

Posted by rcull 
Empty Database
February 16, 2017 05:31PM
I ran the script and indexed directories and urls which I would rather not have searched.

I am looking for a way to empty the database and re-index a site. Is the only method to go into the database and "Truncate" it?

I am not good with databasessad smiley

Re: Empty Database
February 20, 2017 12:36PM
Yes, Sphider does not offer an option to delete the content of the database, as well as an 'Erase & Re-index‘ option is not available. Sphider-plus offers al these features.
Consequently you will be obliged to truncate the tables of your database individually.
As an application hint: Do not delete the content of the table 'sites‘. So the URLs you intend to index will remain avaialable in your database. The wrong URLs you my delete individually in 'Sites' view of your admin backend.

Re: Empty Database
June 18, 2017 03:36AM
There is a way to empty the database from within Sphider. Go to the database tab, select all tables, then check "Structure only" and perform a backup. Then do a restore on the backup just created. As Tec mentions, you just may want to UN-check the sites table before doing the backup so you don't lose all your urls. Unwanted urls can be deleted in the fashion mentioned by Tec.

Not exactly what you could call a "clean" solution, but it does work.
Sorry, only registered users may post in this forum.

Click here to login