Moving MySQL Database.

[Neverseen 0]

Hello,So I've got a phpBB forum installed on my Xisto hosting, But now I'm moving to another hosting and would like to move my forum there, but I haven't got enough of knowledge about databases. In fact I've exported my database through phpMyAdmin to an SQL file and tried to import it through phpMyAdmin as well to my new hosting. But the problem is that my username for MySQL on my new hosting is different, so access is denied when I try to import it. Let's say my username at Xisto is neverseen@localhost and the database's name is neverseen_phpbb1 Now at my new hosting my username is.. let's say newuser@localhost So when I try to import neverseen_phpbb1, the message I get isError: 1044 Access denied for user: 'newuser@localhost' to database 'neverseen_phpbb1'I don't know what would be the easiest way to get ride of this problem... maybe I should create in my new database a user named neverseen@localhost ? or maybe I should grant all priveleges to newuser@localhost ? I'm not even sure about all that. Please correct me if I'm telling senseless things and if anyone of you already had this problem, please let me know how you have managed to transfere database. Thanks in advance !

[Quatrux 4]

Use phpmyadmin to import export sql data ? because I think you're using the phpbb one ? just export with phpmyadmin your old database into a textfile and later improt it to the new one when you create it on your other place, use phpmyadmin and/or cpanel, cpanel can backup too.

[Hercco 0]

In phpBB the username, password and the database name are stored in configuration file at the phpBB root directory. So what you need to do is to put the correct username, password and the forum database names in the configuration file. If you do not know the right user name for the database you can create a new username password pair through cPanel. From there you can also see the database name for your forum.

[Quatrux 4]

Use phpmyadmin to import export sql data ? because I think you're using the phpbb one ? just export with phpmyadmin your old database into a textfile and later improt it to the new one when you create it on your other place, use phpmyadmin and/or cpanel, cpanel can backup too.

[Houdini 0]

The problem here is that they can not connect to the database using the given username this is what would give that error. Are you getting into the databse at all using the username newuser because that is what the error is calling the username?

 

The config.php file ain't gonna help until they can sucessfully connect to their database, it is only godd for running the application when the values are correct? If you username is neverseen then your config.php would look like

$dbms = 'mysql';$dbhost = 'localhost';  //This assumes Xisto$dbname = 'neverseen'; //this is from the error$dbuser = 'neverseen';  //with Xisto the username and dbname are the same$dbpasswd = 'whateverYourPasswordIs'; //replace the text in the password to yours$table_prefix = 'phpbb_';define('PHPBB_INSTALLED', true);

Are you using the phpBB install program? If so is this when the error shows up?

[CaptainRon 0]

OK I got a very simple solution which i think will definitely work.See once you export the SQL file, download it to your hard disk (by checking 'Save File' option at the end) and then open the file in Notepad. Switch on Word Wrap from Format menu. Now look at the second line towards the right end, there will be a statement like Database: 'neverseen_phpbb1'Change this name to a database name that ur current user has got access to. Now try importing through this file, and i suppose it will definitely work.In case it doesn't, check for your db name appearances at other places in the SQL file and replace them with the name of the database to which you want to upload.Hopefully that works for u. If it does do PM me.cya!Ron Out

[Neverseen 0]

Thsnks a lot for your replies, everybody!! I really appreciated your help, but the winner here is CaptainRon ! Because his solution was the easest and the most effective ! Thank you very much, CaptainRon! But one thing I had to do is to copy my login.php file from my old hosting to be able to sign in on my forum. Maybe there are more files I had to copy from my old forum ? In fact, before importing the database I already had a new and EMPTY forum installed....

[CaptainRon 0]

Oh thanx! It was a pleassure to have been able to help. It was good to see that simple hack work.