-1

I am new to hosting website and stuffs, I hosted a forum just for fun on 000webhost.com using an open source forum called Simple Machines Forum (SMF), by the time I setup the forum, I didn't know anything about database and all so I just typed random words like my username, my forum name etc. on "Database name", "Database server" fields. I think I typed my forum's link in "database server" field, so nothing was created on Mysql server and instead a database was created in the root of my website with a file format .db, so I want to import this .db to a proper Mysql server. When I opened this database with notepad++, all my posts, people usernames and file attachments were there. Can I import it?

Please let your answers be noob friendly. :D Thank you.

Seiji Dinzuala
  • 37
  • 1
  • 5

1 Answers1

6

Sorry, but there is no really noob friendly way to answer this, because it's a complex task.

This database you have is likely in SQLite format. You can try creating a dump of it like this:

sqlite3 your_database.db .dump >dump.sql

And then feed this dump to MySQL using phpMyAdmin or MySQL workbench, or command line. But doing this directly most like won't work because of incompatibilities between SQLite and MySQL. Check out this question for possible solutions for this.

Community
  • 1
  • 1
Konstantin Pereiaslov
  • 1,786
  • 1
  • 18
  • 26