I am trying to move my database from the free hosts over at informe.com to my new DNS/mySQL which I have set up with phpBB3. I BELIEVE my database at informe.com is phpBB2X but I am not sure.
I was able to get a database dump from the informe people, which is a file of 530 or so kb, but I have been unsuccessful in getting phpBB3 to take it. I first tried to upload the file into the "store" directory and restore the database using the admin restore feature, but for some reason the file (in .sql and .gz zipped) is not recgonized by phpBB. I don't see any files at all in the list.
After searching here I learned about the bigdump script, so I tried that next. I uploaded the modified bigdump.php to a "dump" directory, along with my dump file that I got from informe.com. Running the script, I get these errors:
A lot of errors.Error at the line 2206: ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query: CREATE TABLE `wiki_categorylinks` (
`cl_from` int(8) unsigned NOT NULL default '0',
`cl_to` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
`cl_sortkey` varchar(86) character set utf8 collate utf8_bin NOT NULL default '',
`cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
KEY `cl_sortkey` (`cl_to`,`cl_sortkey`),
KEY `cl_timestamp` (`cl_to`,`cl_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
MySQL: Specified key was too long; max key length is 1000 bytes
Alright, so I tried it another way. I downloaded a big dump using the admin panel that is accessible to me on informe.com. This is a much larger file, uncompressed is 6.29mb. I made a whole fresh database with a brand new installation of phpBB3, edited the bigdump.php file, added it to a "dump" directory, and tried to restore again. (whew)
The script actually runs this time (now it is obvious it didn't last time), and after waiting for it to cook bigdump tells me this:
Congratulations: End of file reached, assuming OK
However, when I try to look at the forums, I get this:
SQL ERROR [ mysql4 ]
Unknown column 'is_dynamic' in 'where clause' 
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Not sure where to go from here.