Hello Jim,JimA wrote:Import the old database at your new host and change the database details to reflect this in your config.php file of the new 3.1.9 install on your new host.
Hello Jim,JimA wrote:You do need to make a database back-up first on your old host, you can use phpMyAdmin for that too.
Read the relevant parts of this article: Knowledge Base - Transferring Your Board to a New Host or Domain
Hello Jim,JimA wrote:Into your phpBB install? So you did use phpMyAdmin to import the database successfully?
An 1044 error indicates that it can't connect, so it's likely that the information in your config.php file is wrong. Change it and empty the cache folder on your server, except for the .htaccess and index.htm files.
If that does not work, please show us a screenshot of what error message exactly you're getting.
Hello Jim,JimA wrote:Ah, right. This might be because you're already inside of a database, likely with another name.
Try opening your .sql file and remove the "CREATE DATABASE" line in there.
That way it should only create the tables inside of the database where you're already logged in.
I'll try this. I'm trying to reinstall my board now.JimA wrote: ..... Can't you create an entirely new, empty database and try to import your back-up (without the CREATE DATABASE statement) into that one?
Code: Select all
--
-- Database: `michael_community`
--
CREATE DATABASE IF NOT EXISTS `michael_community` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `michael_community`
Code: Select all
USE your_new_database_name;