Long story made short, I'm switching webhosts, but my current XOOPS installion can't be moved (databases can't be named the same), so I have to install 2.0.16 and import my old content.

I know how to export the MySQL information (tables, etc), but I don't know how to insert all my registered users, forum posts, et al., into the new installation. I already read the FAQ on migrating a site, but this situation is just slightly different enough for me to be left utterly confused.

(I already tried importing the information into the database, but I received an error saying the table already existed.)

If someone could point me in any sort of direction, I'd be very grateful!

Cheers,
Chella

either select the option in phpmyadmin when you export the db to add DROP table if exists (which will then drop existing tables when you import)

or go thru the export file and edit out the create table parts just leaving the INSERT or UPDATE queries.

or create the db on your new server, copy the files across to the new server, but don't go thru the install process.

simply import your db into an empty database that hasn't got any tables created.. then edit mainfile.php to reflect the new paths & db info..

Thank you, I was able to move my old site over. My only problem now is that none of the modules will load in my admin page...is this a problem with the files, or the database?