So because it seemed more convenient at the time, I built a site with SQLite for the db. Now the site is big with loads of content, and I need to swap to a better server (currently on crappy shared hosting).
I cannot find any way of copying the entire site. The only option seems to be by using shell commands (I don’t have access) or by just plain old copying all the files (results in corrupt db).
My site is trapped, and worse, I have no backup should anything fail. If anyone had mentioned the pitfalls of SQLite I would have stuck with SQL.
Can anyone help me?