Page 1 of 1
Exporting the Blacklist
Posted: Wed Oct 06, 2010 9:35 pm
by wally3178
Goodevening to all Kiwi's
Can anyone tell me if it is possible to export the whitelist and the blacklist to a txt file for importing into AVG Internet Security 2011? If it is possible, could you please tell me how to do it?
Cheers from Oz,
Wal
Re: Exporting the Blacklist
Posted: Thu Oct 07, 2010 3:01 am
by stan_qaz
Sure, pretty easy to do. The list is in the Sqlite database found under the user files option in help. Download the Sqlite command shell from here:
http://www.sqlite.org/sqlite.html
Then you can dump the list to a file using the commands in the shell. You will have to do a search/replace to convert from regex to plain text to get the final list.
If you need the step by step commands post back and I'll give them whern I get time.
Re: Exporting the Blacklist
Posted: Thu Oct 07, 2010 12:29 pm
by wally3178
Stan_qaz,
Thank you for helping this illiterate with his problem.
I've downloaded sqlite_amalgamation and sqlite-3 7 2.zip and I have unpacked both into seperate directories. My first question, obviously, is should these now be placed into one directory on my C: drive for the command line function to work? Or, should I just doubleclick the sqlite.exe file?
I've had a look in the user files and cannot see any sql db files, is the file I need called regex.txt?
Cheers and beers,
Wal
Re: Exporting the Blacklist
Posted: Thu Oct 07, 2010 4:11 pm
by stan_qaz
Sqllite is a command line program, double-clicking it won't help, you need to open a command window and run it from there.
Exit MW and make a copy of your database file,
DO NOT use your real database for this! Comments, instructions are under each image.

- Start Sqlite with the copy of the MW database, your location may be different but watch the quotes carefully they are needed if your directory or file names have spaces.
- sqllite-start-1.png (8.56 KiB) Viewed 7379 times

- Show your tables so you know what is there and what they are called.
- sqllite-tables-2.png (2.18 KiB) Viewed 7379 times

- Set the column mode to make editing easier.
- sqllite-mode-3.png (822 Bytes) Viewed 7379 times

- Show the schema so you know what column you want to select.
- sqllite-schema-5.png (4.61 KiB) Viewed 7379 times

- Try a test select to make sure you are getting what you want in the results.
- sqllite-select-6.png (945 Bytes) Viewed 7379 times

- Set the output to a file, this will go to your user's home directory, where you started Sqlite from (not Documents or Desktop) and do the query to write the text file.
- sqllite-output-7.png (1.57 KiB) Viewed 7379 times
Set your output back to your screen (.output stdout) and do the same steps 5-6-7 for the blacklist.
Move the output files to your Documents folder or where you want to work on them.
Don't forget to delete the copy of the database once you are done with it and have exited Sqlite.
Your lists are now ready to be edited into the format you need for your other program.
Re: Exporting the Blacklist
Posted: Sat Oct 09, 2010 1:46 pm
by wally3178
Stan,
Thanks mate, for the invaluable assistance.
It took me a little while to master but I am there now, thanks to you; I owe you.
Cheers & Beers,
Wal
Re: Exporting the Blacklist
Posted: Sat Oct 09, 2010 4:54 pm
by stan_qaz
Having the Sqlite database is going to prove to be interesting as it makes a lot of stuff visible (but not editable without grave danger to MW's continued operation) that was buried in the registry where a typo would mess your whole Windows install.
Re: Exporting the Blacklist
Posted: Sat Oct 09, 2010 5:35 pm
by wally3178
Stan,
Don't worry mate, I'm not a compulsive fiddler LOL Unless I have detailed instruction, like you provided and like that on the sqlite site, I wouldn't dream of touching anything......too much like black magic for me.
Cheers,
Wal