Copying table from one SQLite database to another?

[xXziroXx]

I'm trying to copy a table from a database to another database, but I get this error:

PHP Code:

unknown database itemlogs 


I can access the itemlogs database separately just fine though. This is the query I'm using:

PHP Code:

requestSQL("CREATE TABLE itemlogs.foobar AS SELECT * FROM main.buffs", true); 


Any idea what's wrong?

[cbk1994]

I can't get attaches working like that. Your best bet is probably to copy the schema from the old database, execute it on the new database, then use GScript to select all the rows from the old database and copy them.