Serendipity Forums

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!

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