[Solved]Restore Database

[Falconenator]

Im having trouble restoring database cause i went to a new host so did a freash install now im trying to restore the backup sql from the old forums but every time i try and restore database i get this error

Error importing backup file

DEBUG MODE

SQL Error : 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 'collate latin1_general_ci default '', `lw_date` int(11) defa

CREATE TABLE `phpbb_account_hist` ( `user_id` mediumint(8) default '0', `lw_post_id` mediumint(8) default '0', `lw_money` float default '0', `lw_plus_minus` smallint(5) default '0', `MNY_CURRENCY` varchar(8) collate latin1_general_ci default '', `lw_date` int(11) default '0', `comment` varchar(255) collate latin1_general_ci default '', `status` varchar(64) collate latin1_general_ci default '', `txn_id` varchar(64) collate latin1_general_ci default '', `lw_site` varchar(10) collate latin1_general_ci default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci

Line : 1388
File : admin_db_utilities.php


Can anyone help me

Edit: it would seem the new database does not have a collate column as the old one did is there anyway around this or a way to add that column

[bbalegere]

I have same problem.

[Adrian Rea]

Is your db file larger than 2Mb (that is 2Mb without Gzip compression)? If yes, did you use a splitter program such as bigdump?

A

[Falconenator]

EDIt: ok i deleted some of the error lines as it seems there where already in there

it fully updated and it seems there are post but only in test category. In order to get them all back to look exactly like the orginal do i have to upload my old files aswell onto the new host?

[Mighty07]

Did you resolved this issues?