sqlite2 path/to/olddb .dump > backupfile
sqlite3 path/to/newdb < backupfile
I'm a freelance software engineer, dealing mostly with content management and social software. I'm the creator of the blog system Lyceum, and a few other projects in various phases of completion. Learn more about me at my about page.
a few other blogs i read
Blogs of Friends
Friend's projects
My Projects
Archives
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- September 2005
- August 2005
- July 2005
- June 2005
- May 2005
- April 2005
- March 2005
- February 2005
- January 2005
- December 2004
- November 2004
- October 2004
- September 2004
- August 2004
- July 2004
- June 2004
- May 2004
- April 2004
Hello!
I tried this way and it seems to work good, but for a unicode database table fields !! I think that part didn’t work right. So, any Ideas to solve such problem?
Thanks.
Where can I get sqlite2? It doesn’t appear to come with the version distro, at least not for Gentoo.
Like, you know, the internet man.