Don't know if SMF installed correctly

[d.crozier7]

I have installed SMF about a week ago, I am using version 2.0.2.

I noticed that the database is in my file manager with a file extension of ".db"

When I go into my "phpmyadmin", there are no tables in there.

I have installed the same version of SMF on a different host in the past and it created a table in the myphpadmin, but this time it did not.

I don't know if this can bring up any issues in the future for any reason, so I just want to be sure if this alright/normal.

Note that my forum does work just fine without errors though, I am just not sure if this can cause any issues later on like maybe if I decide to move my forum to another web host.

Thanks in advance.

[Arantor]

Well... if it's physically working and you're able to post, that means it's installed and working.

However if you have no tables at all and it's all in a .db file, that suggests you're probably using SQLite and not MySQL. There will be problems down the line with this - SQLite is not very efficient for larger forums and some hosts may not be able to use it at all.

I have little to no experience with SQLite though

[d.crozier7]

Thank you for your reply, but I see that I do have MySQL.

However I do want to use another web host, would it be possible to transfer all of my threads to another host by taking the .db files in my file manager and putting them into a MySQL database table with another web host?

[Arantor]

Whether you have MySQL or not is currently irrelevant; SMF is not using MySQL. It is using SQLite. You cannot just shove the files into MySQL, it does not work like that (MySQL uses a totally different type of file)

It is not a simple transfer either from what I remember - it might work if you create a backup from SMF and then try to import that in MySQL but 1) it may or may not work properly and 2) you'll then have to change all the settings in your forum.