Recent content by FDudeH

Just a couple notes I want to make in case anyone else tries this. I don't have phpMyAdmin installed, so I'm doing it all command line. 1. SHOW CREATE DATABASE <db_name> will show the original database create statement in mysql. You can then capture this and use it to recreate the database...

Ok thanks, I successfully did that, but there were and awful lot of table drops I had to do. Can I just drop the entire database instead and then recreate the whole database?

I have a backup of a clean database saved in a .sql file. This was created manually in mysql. If I want to restore this database and wipe out the existing one, what is the process for doing that? Do I simply go into the existing database in mysql and drop all the tables and then do a restore...

So do I have to reinstall Xenforo from scratch?

So what is the hard way to reset the forum? It's too late now for me since I didn't make a clean backup. Can I drop and recreate all the tables? Truncate the tables? Should I do all tables, or just certain ones?

I have successfully imported 615 thousand posts from Simple Machines into our new Xenforo forum and it went mostly ok. I still have a few remaining questions though: 1. I have some sub forums where the titles are showing &amp; in them. At the bottom of the import for SMF it asks for character...

The root password was not stored in the config.php file. That was the first place I looked for it. Is there any reason it needs to be there?

If I reset the mysql root password, will that have an impact on Xenforo?

I'm trying to log onto mysql as root and the password isn't working, and I'm afraid we may have lost it. If I shut down mysql so I can reset the password will that cause any problems with Xenforo when I restart mysql?

I'll have to see if I can locate where the files are stored. Right now I just want to see if I can import the basic forum data successfully. Will the importer blow up if it can't find a file that is associated with a post or thread?

If I go into mysql on the new server and restore my backup into a new database, can I then just point the importer to that new database without having to create a new subdomain?

Is there no way to do a direct import from a file?

I'm attempting to import from a Simple Machine forum, but having issues. The forum is located on a different server. I have run mysql dump and have backed up the SMF to a dump file. The Importer guidelines say to move the backup file to the same server, but don't say where to put it, or how...