Graal Forums - Copying table from one SQLite database to another?

Graal Forums (https://forums.graalonline.com/forums/index.php)

- NPC Scripting (https://forums.graalonline.com/forums/forumdisplay.php?f=8)

- - Copying table from one SQLite database to another? (https://forums.graalonline.com/forums/showthread.php?t=134264024)

xXziroXx

07-28-2011 04:44 PM

Copying table from one SQLite database to another?

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

07-28-2011 10:55 PM

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.

All times are GMT +2. The time now is 09:09 PM.