well, first of all, i know there r converters, and yes, i did read most instructions etc. but somehow, it's not working
so far, i only got a database copy of our old invisionfree board:
file-size: ~30MB
content-demo:
Code: Select all
INSERT IGNORE INTO ibf_badwords (wid, type, swop, m_exact) VALUES ('89155','*censored*','[Diet Dr Pepper]','0');
INSERT IGNORE INTO ibf_badwords (wid, type, swop, m_exact) VALUES ('89299','fucking','Love-Making','1');
INSERT IGNORE INTO ibf_badwords (wid, type, swop, m_exact) VALUES ('89320',':rolleyes:','8)','0');
INSERT IGNORE INTO ibf_badwords (wid, type, swop, m_exact) VALUES ('89509','):|','{:|','0');
INSERT IGNORE INTO ibf_posts (append_edit, edit_time, pid, author_id, author_name, use_sig, ip_address, post_date, icon_id, post, queued, topic_id, forum_id, new_topic, edit_name, attach_hits, attach_type, attach_file) VALUES ('0','0','55925','1','ROOT','1','88.110.206.48','1155666462','0',' Welcome to the New Forum and squad <!--emo&B)--><img src=\'http://209.85.48.10/html/emoticons/cool.gif\' border=\'0\' style=\'vertical-align:middle\' alt=\'cool.gif\' /><!--endemo--> ','0','2','1','0','','','','');
INSERT IGNORE INTO ibf_posts (append_edit, edit_time, pid, author_id, author_name, use_sig, ip_address, post_date, icon_id, post, queued, topic_id, forum_id, new_topic, edit_name, attach_hits, attach_type, attach_file) VALUES ('0','0','88390','6','[ASS] VADER[FIN]','1','84.231.199.63','1155733221','0',' welcome <!--emo&:)--><img src=\'http://209.85.48.10/html/emoticons/smile.gif\' border=\'0\' style=\'vertical-align:middle\' alt=\'smile.gif\' /><!--endemo--> <!--emo&B)--><img src=\'http://209.85.48.10/html/emoticons/cool.gif\' border=\'0\' style=\'vertical-align:middle\' alt=\'cool.gif\' /><!--endemo--> <!--emo&:D--><img src=\'http://209.85.48.10/html/emoticons/biggrin.gif\' border=\'0\' style=\'vertical-align:middle\' alt=\'biggrin.gif\' /><!--endemo--> ','0','2','1','0','','','','');
INSERT IGNORE INTO ibf_posts (append_edit, edit_time, pid, author_id, author_name, use_sig, ip_address, post_date, icon_id, post, queued, topic_id, forum_id, new_topic, edit_name, attach_hits, attach_type, attach_file) VALUES ('0','0','88491','3','[ASS] Jay','1','82.46.130.108','1155733417','0',' welcome and enjoy <!--emo&:P--><img src=\'http://209.85.48.10/html/emoticons/tongue.gif\' border=\'0\' style=\'vertical-align:middle\' alt=\'tongue.gif\' /><!--endemo--> ','0','2','1','0','','','','');
i just can't import the sql file;(C) 2003 Obelix - Ni[o wrote:3/ In PhpMyAdmin, import your Invision Board tables ; the one you have just saved.
first of all, it's apparently too big (max. file-size to upload at once: 2,048 KiB); so i just tried to split it manually - upload only some lines at once; but, however, this didn't work neither (set: Character set of the file=utf8; tried several options); all i ever got was:
i also tried softwares such as mysqldumper, but that doesn't seem to work neither..Error
SQL query:
ibf_badwords(
wid, TYPE , swop, m_exact
) VALUES (
'88558', 'PAM', 'person above me', '1'
);
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 'ibf_badwords (wid, type, swop, m_exact) VALUES ('88558','PAM','person above me',' at line 1
error given:
Code: Select all
Array
(
[num_table_fields] => Array
(
)
[max_zeit] => 22
[startzeit] => 1205247042
[xtime] => 1205247042
[fileEOF] =>
[actual_table] => ibf_badwords
[offset] => 0
[aufruf] => 1
[table_ready] => 0
[part] => 0
[do_it] =>
[errors] => 0
[notices] => 0
[anzahl_eintraege] => -1
[anzahl_tabellen] => -1
[filename] => 1204895924.sql
[actual_fieldcount] => 0
[eintraege_ready] => 0
[anzahl_zeilen] => 70
[summe_eintraege] => 0
[erweiterte_inserts] => 0
[flag] => -1
[EOB] =>
[dump_encoding] => utf8
[kind] => 0
[compressed] => 0
[filehandle] => Resource id #13
)
Couldn't read rowcount for table ibf_badwords!
Restore:ibf_badwords
many thanks in advance!
bird-kid
EDIT @ 03-15-2008
nvm ... fixed it..