spawn2000 Posted January 20, 2008 Share Posted January 20, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/86904-solved-trying-to-transfer-my-forum-to-new-domain-newbie/ Share on other sites More sharing options...
trq Posted January 20, 2008 Share Posted January 20, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/86904-solved-trying-to-transfer-my-forum-to-new-domain-newbie/#findComment-444313 Share on other sites More sharing options...
spawn2000 Posted January 20, 2008 Author Share Posted January 20, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/86904-solved-trying-to-transfer-my-forum-to-new-domain-newbie/#findComment-444348 Share on other sites More sharing options...
spawn2000 Posted January 20, 2008 Author Share Posted January 20, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/86904-solved-trying-to-transfer-my-forum-to-new-domain-newbie/#findComment-444360 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.