I recently transfered all of my sites to a new host because my previous one didn't have enough bandwidth. I got a simple question about how to get the database to work with my forum since the database name prefix was changed. Ex: the database name was "thesites_data1" (I named it "data1" when crating it, and the host automatically added the "thesites_" part in the front). My new host did the same thing (I uploaded the backup database to the new host) and now it's called "iwebprof_data1" where the prefix is automatic again. How can i change the prefix so it's thesites_data1, or can I do anything to the codes in the forum to make it read the new database (iwebprof_data1)? thanks
You have to export MySql from your old Cpanel and then you need to import over newer hosting Cpanel. Use only PhpMyAdmin to export and import databases
I've only ever really backed up files from inside phpbb3. Is there a video or some tutorial with pictures on where to click to export mysql? Also, I'm doing this at Brinkster and I don't think they have Cpanel! This is my first post, and it looks like a great forum full of interesting data! Found you guys just by googling about moving phpbb3. I have the same issue, but no Cpanel in my original host (brinkster).
Back up all your data base, edit your sql file and edit your lines thesites with your new name, there are editors that edit all lines ONCE. Good luck
Rather than making changes in the database, just make the required changes in config.php of your forum. It will be easy for you to edit config.php. You just need to change the value for variable in config.php. Kailash