IntegraMOD

Re: [Solved]Restore Database

2006-06-06T08:43:50-07:00

Did you resolved this issues?

Statistics: Posted Author: Mighty07 — Tue Jun 06, 2006 8:43 am

[Solved]Restore Database

2006-05-11T04:56:54-07:00

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?

Statistics: Posted Author: Falconenator — Thu May 11, 2006 4:56 am

[Solved]Restore Database

2006-05-11T01:33:00-07:00

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

Statistics: Posted Author: Adrian Rea — Thu May 11, 2006 1:33 am

[Solved]Restore Database

2006-05-10T21:43:54-07:00

I have same problem.

Statistics: Posted Author: bbalegere — Wed May 10, 2006 9:43 pm

[Solved]Restore Database

2006-05-11T10:43:52-07:00

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

Statistics: Posted Author: Falconenator — Wed May 10, 2006 3:27 pm