Transfering Forums

[tehpwner]

I have my forums on my old host and I uploaded them onto x10 hosting. I looked in the MySQL but I can't find a Import SQL anywhere. I'm using IPB. Do I just re-install the board?

 

[Brandon]

Go to SQL in Cpanel go to the bottom and click phpmyadmin then click on the left the database then go to the top click SQl go to the upload form on the bottom and upload it.

 

[tehpwner]

It's not working, I click on go when the file is in the box and I set everything and it just doesn't do anything

 

[Tyler]

Or click on backups in cpanel and upload it from there.

 

[tehpwner]

SQL-query:

-- phpMyAdmin SQL Dump
-- version 2.6.1-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 04, 2005 at 08:32 PM
-- Server version: 4.1.10
-- PHP Version: 5.0.4
--
-- Database: `ewforum`
--
-- --------------------------------------------------------
--
-- Table structure for table `ewforum_admin_logs`
--
CREATE TABLE `ewforum_admin_logs` (
`id` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`act` varchar( 255 ) default NULL ,
`code` varchar( 255 ) default NULL ,
`member_id` int( 10 ) default NULL ,
`ctime` int( 10 ) default NULL ,
`note` text,
`ip_address` varchar( 255 ) default NULL ,
PRIMARY KEY ( `id` )
) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =1

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 28

This is an error I got when trying to up it

 

[tehpwner]

Wait, I backed it up but this is what I get now

IPB WARNING [2] mysql_connect(): Access denied for user: 'simardbrad@localhost' (Using password: YES) (Line: 115 of /ips_kernel/class_db_mysql.php

 

[Brandon]

Its looks like youll need to set the new database and users

 

[tehpwner]

Arg, It took me forever to do all of the **** on those forums. Now I gotta re-create them.... bleh

 

[Brandon]

No I mean just edit the config!

 

[tehpwner]

As in the config file where you have the SQL database name and password and stuff. Already tried that and then it still gave me an SQL error

 

[Maurice]

Can't you just log into your old board make a back up , log in to your new board and then import it :/ Would save the hassle.

 

[tehpwner]

I've decided just to recreate everything. I want to organize it a different way and they skin screwed everything up. I'll just freshly restart it