Restoring a MySQL Database

[inc]Non-Generic Conflict

This document is specific to the MySQL database however SMF also supports other database types such as SQLite and PostgreSQL. Please feel free to help out and explain how one can restore databases when the forum is using PostgreSQL or SQLite. [/inc]

What is a SQL Database? SMF is not only run by PHP files, it's also run by something called an SQL database. SMF uses an SQL database to store the majority of its information. This information includes things such as topics, posts, members, settings, etc. An SQL database is vital for running an SMF forum.

How Do I Restore or Import an SQL Database? To import or restore an SQL database, one way of doing it, is through the use of phpMyAdmin. If you have cPanel on your host you can access phpMyAdmin by logging into cPanel, usually at an address like: mysite.com/cpanel or mysite.com:2083. Once you are logged in, click on the "MySQL Databases" button. Scroll to the bottom of that page and click on the link that says phpMyAdmin. From there, click on the drop-down box on the left side of the page under Database and select the database name that corresponds to the database that your SMF Forum uses. Upon selecting your database, click on the tab near the top of the page that says "SQL". From there, click on the Choose button under Location of the textfile and browse for your database's SQL file on your local computer. Once that's completed, click on Go. If you encounter any errors upon uploading your database, consult the SMF support forum.

Newer versions of phpMyAdmin contain an Import button which streamlines this process just a little bit. After selecting your database you can then proceed to select the Import button.