SQLITE 3 database file with WordPress?

  • jasminalisondesign

    (@jasminalisondesign)


    7 years, 5 months ago

    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)

    (@sterndata)

    Volunteer Forum Moderator

    7 years, 5 months ago

    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

    (@jasminalisondesign)

    7 years, 5 months ago

    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)

    (@sterndata)

    Volunteer Forum Moderator

    7 years, 5 months ago

    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

    Thread Starter jasminalisondesign

    (@jasminalisondesign)

    7 years, 5 months ago

    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.