Title: SQLITE 3 database file with WordPress?
Last modified: October 21, 2018

---

# SQLITE 3 database file with WordPress?

 *  [jasminalisondesign](https://wordpress.org/support/users/jasminalisondesign/)
 * (@jasminalisondesign)
 * [7 years, 7 months ago](https://wordpress.org/support/topic/sqlite-3-database-file-with-wordpress/)
 * Hi All,
 * So I’ve been given a zip file of a wordpress site backup from a previous developer,
   and I’m trying to restore it from these files but not having much luck! I thought
   this would be straightforward but it’s proving otherwise.
 * I’ve migrated the site files over to my local server. I now need to connect the
   database, but the only database file I can seem to find for this site in the 
   zip file is an SQLITE3 file and I can’t seem to import it into phpmyadmin? I 
   thought wordpress databases are ususally .mysql files?
 * So I have some questions – is this definitely a database file that can be used
   with wordpress? If so, how can I connect it to the site or convert it into a 
   useable file?
 * Complete newbie so apologies for my lack of appropriate terminology 🙂 Thanks
   for any help you can give.
 * Jasmin

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

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [7 years, 7 months ago](https://wordpress.org/support/topic/sqlite-3-database-file-with-wordpress/#post-10801037)
 * You need to use MySQL or MariaDB. You cannot use SQLITE. Most backups create 
   the database dump with an extension of .sql. What happens when you try to import
   to MySQL with PHPMYADMIN?
 *  Thread Starter [jasminalisondesign](https://wordpress.org/support/users/jasminalisondesign/)
 * (@jasminalisondesign)
 * [7 years, 7 months ago](https://wordpress.org/support/topic/sqlite-3-database-file-with-wordpress/#post-10801054)
 * Thanks for your swift response! That’s confirmed what I thought – wp databases
   should be in .sql surely so I was surprised to see this format. Would you suggest
   I go back to the previous developers and ask? I can’t seem to find any other 
   database related files in the zip folder they gave me
 * This is the error I get when I try and import:
    #1064 – You have an error in 
   your SQL syntax; check the manual that corresponds to your MySQL server version
   for the right syntax to use near ‘SQLite format 3’ at line 1
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [7 years, 7 months ago](https://wordpress.org/support/topic/sqlite-3-database-file-with-wordpress/#post-10801082)
 * Yeah, I think you need to talk to the folks who gave you that file.
 * This site will convert a small sqlite file to mysql format — it might be worth
   a try: [https://www.rebasedata.com/convert-sqlite-to-mysql-online](https://www.rebasedata.com/convert-sqlite-to-mysql-online)
 *  Thread Starter [jasminalisondesign](https://wordpress.org/support/users/jasminalisondesign/)
 * (@jasminalisondesign)
 * [7 years, 7 months ago](https://wordpress.org/support/topic/sqlite-3-database-file-with-wordpress/#post-10801152)
 * OK – Thank you. I tried converting it, but no joy 🙁

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

The topic ‘SQLITE 3 database file with WordPress?’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [local](https://wordpress.org/support/topic-tag/local/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [server](https://wordpress.org/support/topic-tag/server/)
 * [sqlite](https://wordpress.org/support/topic-tag/sqlite/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [jasminalisondesign](https://wordpress.org/support/users/jasminalisondesign/)
 * Last activity: [7 years, 7 months ago](https://wordpress.org/support/topic/sqlite-3-database-file-with-wordpress/#post-10801152)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics