I am writing a php script to back up mysql to sqlite(3) via PDO
My process is :
--------------------------
Create SQLite database connection
Loop several tables
Describe mysql table
Drop sqlite table if exists, Create matching sqlite table
query mysql table for recordset.
insert recordset into sqlite table
End Loop
Kill SQLite connection
----------------------------
This process works fine if the database is a new file otherwise I get an
error :
SQLSTATE[HY000]: General error: 6 database table is locked;
What am I missing here - perhaps the tables are left open ?
*Ben Marchbanks*
www.magazooms.com <http://www.magazooms.com/>
Signature
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Phone: (864) 284.9918
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
