 Mysql Help Needed |
|
|
|
|
  |
 Aug 2 2006, 10:39 PM
Post
#1
|
|
|
Super Member  Group: Members Posts: 219 Joined: 4-July 06 From: Nottingham UK Member No.: 26,049  |
Right, where do I start...
I have a phpbb forum, which is ok but doesnt give me the scope for expansion which I need, so I have switched over to phpnuke (which has phpbb integrated anyway). My problem is this - how do I transfer all the member details from the phpbb forum to the phpnuke database? I'd really rather not have to ask everyone to rejoin if it can be helped, & I guess there must be some clever way of using the mysql database to sort it out. I'll be the first to admit i'm pretty clueless when it comes to the finer workings of mysql databases, so any help on this would be great. |
 |
 
|
|
Aug 3 2006, 12:03 AM
Post
#2
|
|
|
Trap Double Mocha Member Group: [HOSTED] Posts: 2,257 Joined: 5-November 05 From: That one place over there... Member No.: 13,830 myCENT:6.15 |
Ok so go into your forum administration and look under the General Admin tab and go to Backup Databases. Do a full back up or whatever and then download it to your computer. Then go into the forums on your PHP Nuke site, look under General Admin again, and go to Restore Databases, and upload the file from your computer there and it will restore all users topics, categories, and I think even the theme if it is uploaded.
|
|
|
|
|
Aug 3 2006, 12:26 AM
Post
#3
|
|
|
Super Member Group: Members Posts: 219 Joined: 4-July 06 From: Nottingham UK Member No.: 26,049 |
I gave it a go but got this lot, any idea what i'm doing wrong?
QUOTE 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 '42', '48807696a0', '\'Z\' - Artists', '[url=http://http://www.t INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('41', '4835ce9aed', '\'0-9\' - Artists', 'Homicide[color=red:4835ce9aed]All Found Here![/color:4835ce9aed] INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('42', '48807696a0', '\'Z\' - Artists', '[color=red:48807696a0]All Found Here![/color:48807696a0] INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('43', '508f85594a', '\'Y\' - Artists', '[color=red:508f85594a]All Found Here![/color:508f85594a] * Y Kant Tori Read - The Big Picture * Y&T - Contagious * Yarbrough & Peoples - Don\'t Stop The Music * Yazoo - Don\'t Go * Yazz - The Only Way Is Up * Yello - Oh Yeah * Yellow Magic Orchestra - Technopolis * Yes - Owner Of A Lonely Heart * Yngwie Malmsteen - You Don\'t Remember * Young MC - Bust A Move * Yuri - Este Amor No Se Toca') Line : 980 File : admin_db_utilities.php *edit* - I deleted the thread that all that lot corresponded to & the backup was successful  This post has been edited by serverph: Aug 3 2006, 01:59 AM |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 22nd November 2008 - 01:57 AM |