XF 2.0 How to import previous user database

[Garrett Horne]

We had to do a fresh install of Xenforo after a myriad of issues. We backed up the user database and reinstalled the same version of Xenforo. We figured we could just replace the new database with the old one, but doing that just kills the site with an unresponsive message. How can I go about installing the old database? It's imperative that we keep it.

 

[Chris D]

You need the "XenForo Importers" add-on (available to download from the Customer area) and then once that is installed go to Tools > Import data.

 

[AndyB]

We backed up the user database

How many posts does your forum have?

How was the backup done?

Is the backup a .sql file?

 

[Garrett Horne]

How many posts does your forum have?

How was the backup done?

Is the backup a .sql file?

The backup is in the form of an sql. It contains nearly 1k users and the posts they have made, though they are low.

 

[AndyB]

You will need to create a new database and import the .sql backup into it. Then edit your config.php file to reflect the new database name.

 

[Garrett Horne]

You will need to create a new database and import the .sql backup into it. Then edit your config.php file to reflect the new database name.

We tried replacing the new sql with the old one and just changed the database name of the old one to the new one and it bricked the site.