bulk insert statements with Sqlite

[jonjames1070]

Hi,

Anybody know how I can do bulk insert statements using Sqlite? I have a few lines of text for each entry, and probably 200 entries to insert. I know I can use: .read FILENAME with the sqlite executable, but which table(s) and column(s) do I insert the values? I can't even seem to read the database file with the executable - all I can find is a file called "s9y_f88803eab73183e7fde0dfccaf531d2d.db", which it tells me is invalid. But my blog is working fine, and that file is 52k which is about right.

thanks!

[garvinhicking]

Maybe your SQLite executabe is different than the version that is used by PHP?

You can try to use a SQLite manager, there is one available coded in PHP. Then you could do the SQL INSERT on the serendipity_entries Table. Look at existing entries to reverse engineer the fields

Regards,
garvin