Author: Lycanth » Wed Sep 29, 2010 6:16 pm
I think most stuff is running smoothly....but there are a couple of things I know I'd really like, heh. Is it even possible to merge an old database with the present one? Story is: did a backup in march, then took a few months off (new baby), and my second in command accidentally deleted a big chunk of posts and data. The site has been active since and I don't want to overwrite the new data with the old, but just want to...splice the old into the current. I tried with bigdump but got this error:
Error at the line 3: INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard, rating_rank_id) VALUES('1', '1', '1', '2', '1204595865', '7F000001', '', '1', '0', '1', '0', '1254198994', '2', '0', '3', NULL, '0');
Query: INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard, rating_rank_id) VALUES('1', '1', '1', '2', '1204595865', '7F000001', '', '1', '0', '1', '0', '1254198994', '2', '0', '3', NULL, '0');
MySQL: Duplicate entry '1' for key 'PRIMARY'
Any ideas? Can I change the values somehow, or change the post tables to auto_increment?
ETA: I'd really love for the arcade mod to be added to my HP site, too, if at all possible.