Title: Spip and Sqlite
Last modified: March 22, 2019

---

# Spip and Sqlite

 *  Resolved [hnzz](https://wordpress.org/support/users/hnzz/)
 * (@hnzz)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/spip-and-sqlite/)
 * Hi, i like to port my spip site to WordPress but before buying your product (
   as i want to move the keywords too) i like to know whether this will work with
   a spip site with a sqlite database. If not could someone me point to a resource
   which explains how to move spip from sqlite to mysql first. Yes searched the 
   internet but was not able to find anything on this
 * hnzz

Viewing 9 replies - 1 through 9 (of 9 total)

 *  Plugin Author [Kerfred](https://wordpress.org/support/users/kerfred/)
 * (@kerfred)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/spip-and-sqlite/#post-11346483)
 * This is a good idea.
    I have developed this feature in the latest version: [https://www.fredericgilles.net/fg-spip-to-wordpress/](https://www.fredericgilles.net/fg-spip-to-wordpress/)
 *  Thread Starter [hnzz](https://wordpress.org/support/users/hnzz/)
 * (@hnzz)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/spip-and-sqlite/#post-11346546)
 * My bad, was not aware of this possibility. So it just should work ? I am gonna
   retry the proces today. I have tried it once some time ago but no avail… Should
   the new version of the site reside on the same sever ?
 *  Plugin Author [Kerfred](https://wordpress.org/support/users/kerfred/)
 * (@kerfred)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/spip-and-sqlite/#post-11346553)
 * You just have to update the plugin to the latest version (2.36.0) and choose 
   the “SQLite” database driver in the settings.
 * > Should the new version of the site reside on the same sever ?
 * Yes, it is preferable. If it is not located on the same server, you must first
   copy the SPIP database to the WordPress server.
 *  Thread Starter [hnzz](https://wordpress.org/support/users/hnzz/)
 * (@hnzz)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/spip-and-sqlite/#post-11346583)
 * That is indeed very good news. Perfect way to start work on a sunny Saturday !
   
   Thnx hnzz
 *  Thread Starter [hnzz](https://wordpress.org/support/users/hnzz/)
 * (@hnzz)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/spip-and-sqlite/#post-11349493)
 * Ok copied the database (spip.sqlite) to the test server and changed ownership
   to www-data.
    After that I have chosen for de Sqlite driver in the plugin Filled
   in the path to the db file (/tmp/spip.sqlite) And then I get the following error:
   Connection failed See the errors in the log below
 * And the errors are:
    === START test_database 2019-03-24 14:29:55 === [ERROR] 
   Couldn’t read the SPIP database SQLite file: /tmp/spip.sqlite === END test_database
   2019-03-24 14:29:55 ===
 * Obviusly I do something wrong
 * NB:
    the user www-data owns the file permissions of the file are set to 777 I
   also tried the import with a backup from the spip site also not working
 * Any help much appreciated !
    hnzz
 *  Plugin Author [Kerfred](https://wordpress.org/support/users/kerfred/)
 * (@kerfred)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/spip-and-sqlite/#post-11349521)
 * Could you open a ticket on [https://www.fredericgilles.net/support/](https://www.fredericgilles.net/support/)
   and send me your SQLite database? I’ll do the test.
 *  Thread Starter [hnzz](https://wordpress.org/support/users/hnzz/)
 * (@hnzz)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/spip-and-sqlite/#post-11349538)
 * Ticket created
 *  Plugin Author [Kerfred](https://wordpress.org/support/users/kerfred/)
 * (@kerfred)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/spip-and-sqlite/#post-11349965)
 * Update:
    I have imported successfully your SPIP database to WordPress. You must
   check the database location of the SQLite file and the tables prefix.
 *  Thread Starter [hnzz](https://wordpress.org/support/users/hnzz/)
 * (@hnzz)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/spip-and-sqlite/#post-11349993)
 * Ok found it, it was the location of the file, moved it to the root of the site
   and now it works !
    Thanks for the support sofar Hnzz

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Spip and Sqlite’ is closed to new replies.

 * ![](https://ps.w.org/fg-spip-to-wp/assets/icon-256x256.png?rev=1286067)
 * [FG SPIP to WordPress](https://wordpress.org/plugins/fg-spip-to-wp/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/fg-spip-to-wp/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/fg-spip-to-wp/)
 * [Active Topics](https://wordpress.org/support/plugin/fg-spip-to-wp/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/fg-spip-to-wp/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/fg-spip-to-wp/reviews/)

 * 9 replies
 * 2 participants
 * Last reply from: [hnzz](https://wordpress.org/support/users/hnzz/)
 * Last activity: [7 years, 2 months ago](https://wordpress.org/support/topic/spip-and-sqlite/#post-11349993)
 * Status: resolved