[SOLVED] Trying to transfer my forum to new domain. (newbie)

[spawn2000]

Hi there, I'm trying to transfer my forum to a new domain and if i knew anything about phpbb and mysql I'm sure this whole process would be so much easier.  i figured out how to export the database in the phpbbadmin part on my Cpanel but when i try to import the  database on my new domain i get the error below.

 

SQL query:

 

-- phpMyAdmin SQL Dump

-- version 2.11.0

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Jan 19, 2008 at 01:50 PM

-- Server version: 5.0.45

-- PHP Version: 5.2.3

--

-- Database: `web33-neocore_db`

--

CREATE DATABASE `web33-neocore_db` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

 

MySQL said: Documentation

#1007 - Can't create database 'web33-neocore_db'; database exists

 

it directed me to some mysql site which confused the hell out of me so i was just wondering why i have an access denied? I installed a blank database then tried to import this into it but to be honest i have no idea what I'm doing. If you need any more info please get in contact.

 

Thanks

Nick

[trq]

As the error says....

 

Can't create database 'web33-neocore_db'; database exists

 

The database already exists. Either remove the blank database that you made and let the sql file do the work, or remove the create database section from the sql file.

[spawn2000]

ok that worked its imported.. I transferred the physical files to my domain (http://nmgsupport.co.uk/forum/) but I now get a critical php error could not connect to database. Now i'm guessing this is cuz the files are still pointing towards the old domain. But what file(s) do i need to alter in order for it to connect??

 

Thanks

Nick

[spawn2000]

Its cool I found the config.php file and saw the details in there needed changing to the new database name and password!

 

Thanks for your help

 

Nick