Phpbb last resort

[atomicant_2005]

ok, basically i have had this problem for 2 weeks now, i changed web host, installed a new forum onto the new server, and tried to upload a backup. but it was too large after alot off reasearch and questions realised i had to break them up and use phpmyadmin, SO i have installed the broken up files via phpmyadmin, my 9mb file was broken up into 9 chunks, BUT when i imported it 2 of the 9 came up with the following errors:

Quote:
SQL query:
INSERT INTO phpbb_search_wordlist( word_text, word_id, word_common )
VALUES (
'scared', '3470', '0'
);

MySQL said:
#1062 - Duplicate entry 'scared' for key 1
SQL query:
SELECT *
FROM
WHERE CONCAT_WS( "-", word_text, word_id, word_common ) = "scared"
ORDER BY word_text, word_id, word_common
MySQL said:
#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 'WHERE CONCAT_WS( "-", word_text, word_id, word_common )

and

Quote:
SQL query:
CREATE TABLE phpbb_themes_name(
themes_id smallint( 5 ) unsigned NOT NULL ,
tr_color1_name char( 50 ) ,
tr_color2_name char( 50 ) ,
tr_color3_name char( 50 ) ,
tr_class1_name char( 50 ) ,
tr_class2_name char( 50 ) ,
tr_class3_name char( 50 ) ,
th_color1_name char( 50 ) ,
th_color2_name char( 50 ) ,
th_color3_name char( 50 ) ,
th_class1_name char( 50 ) ,
th_class2_name char( 50 ) ,
th_class3_name char( 50 ) ,
td_color1_name char( 50 ) ,
td_color2_name char( 50 ) ,
td_color3_name char( 50 ) ,
td_class1_name char( 50 ) ,
td_class2_name char( 50 ) ,
td_class3_name char( 50 ) ,
fontface1_name char( 50 ) ,
fontface2_name char( 50 ) ,
fontface3_name char( 50 ) ,
fontsize1_name char( 50 ) ,
fontsize2_name char( 50 ) ,
fontsize3_name char( 50 ) ,
fontcolor1_name char( 50 ) ,
fontcolor2_name char( 50 ) ,
fontcolor3_name char( 50 ) ,
span_class1_name char( 50 ) ,
span_class2_name char( 50 ) ,
span_class3_name char( 50 ) ,
fontcolor5_name char( 50 ) DEFAULT 'Administrators'color ', fontcolor6_name char(50) DEFAULT 'Moderators ' color',
PRIMARY KEY ( themes_id )
);

MySQL said:
#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 'color',
fontcolor6_name char(50) DEFAULT 'Moderators' color',

i don't have a clue what to do. speak in noob language please

[sypher]

Basically you have messed it up for yourself

I would wipe it all of if i was you and start again.

Copy the database from the old host and upload to the new one (phpmyadmin has a db standard limit of 51mb)
Upload all the pages via ftp and set all the permissions. Also check config files to see if they need to be directed to the new domain.

and done

[atomicant_2005]

the domain is the same, do u mean copy the entire database rather than a back up and simply upload it via ftp.

what do u mean by changing the permissions do u mean the read write execute thing?

[sypher]

You need to download the database go into phpmyadmin and upload it there. (Using the same database name, and username, password.

Yes read write execute permissions.

[atomicant_2005]

how do u upload a 9mb database?what permission should i set it to?

also which database name should i use or doesn't it matter unless there the same?

[atomicant_2005]

i think i've done what u said but now it says:

phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'erikablack1.phpbb_config' doesn't exist

SELECT * FROM phpbb_config

Line : 166
File : e:\domains\e\erikablack.co.uk\user\htdocs\forum\co mmon.php

[sypher]

You mustnt be uploading all the db info as its saying that the table doesnt exist.

Check wether is does in ur phpmyadmin.

[atomicant_2005]

i've decided to result to using bigdump again. but came to a problem strait away.

Processing file: phpbb_db_backup[2].sql
Starting at the line: 3001
Error at the line 3001: b_posts` VALUES (2740, 326, 1, 108, 1118098661, '50040340', '', 1, 1, 1, 1, NULL, 0);
Query: b_posts` VALUES (2740, 326, 1, 108, 1118098661, '50040340', '', 1, 1, 1, 1, NULL, 0);
MySQL: 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 'b_posts` VALUES (2740, 326, 1, 108, 1118098661, '50040340', '',
Stopped on error

are these problems solveable?

[sypher]

Not if theres an error with the db info.

You may have to start again.