SQL question (sq lite)

[Scooby]

Hi, so ive managed to delete a load of entries in an sql table by accident.

i have backups of registry.db where its stored but this also contains other tables.

what i want to know is: is there a way for me to copy the table from backup registry then store it somewhere else

so i can add it back to the registry file it needs to be in?

(ie is it possible to save the table to another database temporarily?)

i cant just swap the files coz my backup is a week old and theres so much info in it in other tables thats changed.

ive tried exporting the table with 'Lita' but it doesnt let me import it back, it just imports 1 line.

i know i can fix this by writing a script to save the backup table to an xml, then swapping .db files and saving it back to sql

but thats a lot of hassle i guess... im just curious if theres an easy fix for this.

my sql skills arent great.

[Castillo]

You could try searching for another program to import it back.

[Scooby]

ok, can anyone recommend one?