Transferring posts and members database to fresh installation

Started by Ne0z, December 29, 2005, 12:50:49 AM

Previous topic - Next topic

Ne0z

Hello ,

i am new to using SMF. Recently i've just switched to a new server. I did a fresh installation of SMF onto the new server and can i just transfer the posts and members database from my old server to the new one ? i've also changed my domain name too !
How can i do it ?

Thanks a lot!

Dannii

"Never imagine yourself not to be otherwise than what it might appear to others that what you were or might have been was not otherwise than what you had been would have appeared to them to be otherwise."

Ne0z

I've tried importing my old database using phpadmin into my new server but i've got this error

SQL query:

# ==========================================================
#
# Database dump of tables in `alverdi_yabb1`
# January 02, 2006, 10:27:54 PM
#
# ==========================================================
#
# Dumping data in `yabbse_board_permissions`
#
INSERT INTO `yabbse_board_permissions` (
`ID_GROUP` ,
`ID_BOARD` ,
`permission` ,
`addDeny`
)
VALUES (
-1, 0, 'moderate_board', 0
), ( 3, 0, 'make_sticky', 1 ) , ( 3, 0, 'lock_any', 1 ) , ( 3, 0, 'delete_any', 1 ) , ( 3, 0, 'move_any', 1 ) , ( 3, 0, 'merge_any', 1 ) , ( 3, 0, 'split_any', 1 ) , ( 3, 0, 'remove_any', 1 ) , ( 3, 0, 'modify_any', 1 ) , ( 2, 0, 'make_sticky', 1 ) , ( 2, 0, 'lock_any', 1 ) , ( 2, 0, 'delete_any', 1 ) , ( 2, 0, 'move_any', 1 ) , ( 2, 0, 'merge_any', 1 ) , ( 2, 0, 'split_any', 1 ) , ( 2, 0, 'remove_any', 1 ) , ( 2, 0, 'modify_any', 1 ) , ( 2, 0, 'poll_lock_any', 1 ) , ( 3, 0, 'moderate_board', 1 ) , ( 2, 0, 'moderate_board', 1 ) , ( 0, 0, 'delete_own', 1 ) , ( 0, 0, 'lock_own', 1 ) , ( 0, 0, 'mark_any_notify', 1 ) , ( 0, 0, 'mark_notify', 1 ) , ( 0, 0, 'modify_own', 1 ) , ( 0, 0, 'poll_add_own', 1 ) , ( 0, 0, 'poll_edit_own', 1 ) , ( 0, 0, 'poll_lock_own', 1 ) , ( 0, 0, 'poll_post', 1 ) , ( 0, 0, 'poll_view', 1 ) , ( 0, 0, 'poll_vote', 1 ) , ( 0, 0, 'post_attachment', 1 ) , ( 0, 0, 'post_new', 1 ) , ( 0, 0, 'post_reply_any', 1 ) , ( 0, 0, 'post_reply_own', 1 ) , ( 0, 0, 'remove_own', 1 ) , ( 0, 0, 'report_any', 1 ) , ( 0, 0, 'send_topic', 1 ) , ( 0, 0, 'view_attachments', 1 ) , ( 2, 0, 'delete_own', 1 ) , ( 2, 0, 'lock_own', 1 ) , ( 2, 0, 'mark_any_notify', 1 ) , ( 2, 0, 'mark_notify', 1 ) , ( 2, 0, 'modify_own', 1 ) , ( 2, 0, 'poll_add_own', 1 ) , ( 2, 0, 'poll_edit_own', 1 ) , ( 2, 0, 'poll_lock_own', 1 ) , ( 2, 0, 'poll_post', 1 ) , ( 2, 0, 'poll_view', 1 ) , ( 2, 0, 'poll_vote', 1 ) , ( 2, 0, 'post_attachment', 1 ) , ( 2, 0, 'post_new', 1 ) , ( 2, 0, 'post_reply_any', 1 ) , ( 2, 0, 'post_reply_own', 1 ) , ( 2, 0, 'remove_own', 1 ) , ( 2, 0, 'report_any', 1 ) , ( 2, 0, 'send_topic', 1 ) , ( 2, 0, 'view_attachments', 1 ) , ( 3, 0, 'delete_own', 1 ) , ( 3, 0, 'lock_own', 1 ) , ( 3, 0, 'mark_any_notify', 1 ) , ( 3, 0, 'mark_notify', 1 ) , ( 3, 0, 'modify_own', 1 ) , ( 3, 0, 'poll_add_own', 1 ) , ( 3, 0, 'poll_edit_own', 1 ) , ( 3, 0, 'poll_lock_own', 1 ) , ( 3, 0, 'poll_post', 1 ) , ( 3, 0, 'poll_view', 1 ) , ( 3, 0, 'poll_vote', 1 ) , ( 3, 0, 'post_attachment', 1 ) , ( 3, 0, 'post_new', 1 ) , ( 3, 0, 'post_reply_any', 1 ) , ( 3, 0, 'post_reply_own', 1 ) , ( 3, 0, 'remove_own', 1 ) , ( 3, 0, 'report_any', 1 ) , ( 3, 0, 'send_topic', 1 ) , ( 3, 0, 'view_attachments', 1 ) , ( 7, 1, 'post_reply_own', 1 ) , ( 3, 2, 'post_reply_own', 1 ) , ( 3, 2, 'post_reply_any', 1 ) , ( 3, 2, 'post_new', 1 ) , ( 3, 2, 'post_attachment', 1 ) , ( 3, 2, 'poll_view', 1 ) , ( 3, 2, 'poll_vote', 1 ) , ( 7, 0, 'poll_edit_own', 1 ) , ( 7, 0, 'poll_add_own', 1 ) , ( 7, 0, 'modify_replies', 1 ) , ( 7, 0, 'modify_own', 1 ) , ( 7, 0, 'delete_own', 1 ) , ( 6, 0, 'remove_replies', 1 ) , ( 6, 0, 'remove_own', 1 ) , ( 6, 0, 'post_reply_own', 1 ) , ( 6, 0, 'post_reply_any', 1 ) , ( 6, 0, 'post_new', 1 ) , ( 6, 0, 'poll_remove_own', 1 ) , ( 6, 0, 'poll_edit_own', 1 ) , ( 6, 0, 'poll_add_own', 1 ) , ( 6, 0, 'modify_replies', 1 ) , ( 6, 0, 'modify_own', 1 ) , ( 6, 0, 'delete_own', 1 ) , ( 5, 0, 'remove_replies', 1 ) , ( 5, 0, 'remove_own', 1 ) , ( 5, 0, 'post_reply_own', 1 ) , ( 5, 0, 'post_reply_any', 1 ) , ( 5, 0, 'post_new', 1 ) , ( 3, 2, 'poll_post', 1 ) , ( 3, 2, 'poll_lock_own', 1 ) , ( 3, 2, 'poll_edit_own', 1 ) , ( 3, 2, 'poll_add_own', 1 ) , ( 3, 2, 'modify_own', 1 ) , ( 3, 2, 'mark_notify', 1 ) , ( 3, 2, 'mark_any_notify', 1 ) , ( 3, 2, 'delete_own', 1 ) , ( 3, 2, 'lock_own', 1 ) , ( 7, 1, 'post_reply_any', 1 ) , ( 7, 1, 'remove_own', 1 ) , ( 2, 4, 'moderate_board', 1 ) , ( 3, 4, 'moderate_board', 1 ) , ( 2, 4, 'poll_lock_any', 1 ) , ( 2, 4, 'modify_any', 1 ) , ( 2, 4, 'remove_any', 1 ) , ( 2, 4, 'split_any', 1 ) , ( 8, 0, 'remove_replies', 1 ) , ( 8, 0, 'remove_own', 1 ) , ( 4, 0, 'poll_remove_own', 1 ) , ( 4, 0, 'poll_edit_own', 1 ) , ( 4, 0, 'poll_add_own', 1 ) , ( 4, 0, 'modify_own', 1 ) , ( 4, 0, 'remove_own', 1 ) , ( 4, 0, 'remove_replies', 1 ) , ( 4, 0, 'modify_replies', 1 ) , ( 4, 0, 'post_reply_any', 1 ) , ( 4, 0, 'post_reply_own', 1 ) , ( 4, 0, 'delete_own', 1 ) , ( 4, 0, 'post_new', 1 ) , ( 3, 1,


view_attachments', 1 ) , ( 3, 1, 'send_topic', 1 ) , ( 3, 1, 'report_any', 1 ) , ( 3, 1, 'remove_own', 1 ) , ( 3, 1, 'post_reply_own', 1 ) , ( 3, 1, 'post_reply_any', 1 ) , ( 3, 1, 'post_new', 1 ) , ( 3, 1, 'post_attachment', 1 ) , ( 3, 1, 'poll_vote', 1 ) , ( 3, 1, 'poll_view', 1 ) , ( 3, 1, 'poll_post', 1 ) , ( 3, 1, 'poll_lock_own', 1 ) , ( 3, 1, 'poll_edit_own', 1 ) , ( 3, 1, 'poll_add_own', 1 ) , ( 3, 1, 'modify_own', 1 ) , ( 3, 1, 'mark_notify', 1 ) , ( 3, 1, 'mark_any_notify', 1 ) , ( 3, 1, 'lock_own', 1 ) , ( 3, 1, 'delete_own', 1 ) , ( 2, 1, 'view_attachments', 1 ) , ( 2, 1, 'send_topic', 1 ) , ( 2, 1, 'report_any', 1 ) , ( 2, 1, 'remove_own', 1 ) , ( 2, 1, 'post_reply_own', 1 ) , ( 2, 1, 'post_reply_any', 1 ) , ( 2, 1, 'post_new', 1 ) , ( 2, 1, 'post_attachment', 1 ) , ( 2, 1, 'poll_vote', 1 ) , ( 2, 1, 'poll_view', 1 ) , ( 2, 1, 'poll_post', 1 ) , ( 2, 1, 'poll_lock_own', 1 ) , ( 2, 1, 'poll_edit_own', 1 ) , ( 2, 1, 'poll_add_own', 1 ) , ( 2, 1, 'modify_own', 1 ) , ( 2, 1, 'mark_notify', 1 ) , ( 2, 1, 'mark_any_notify', 1 ) , ( 2, 1, 'lock_own', 1 ) , ( 2, 1, 'delete_own', 1 ) , ( 8, 0, 'post_reply_own', 1 ) , ( 8, 0, 'post_reply_any', 1 ) , ( 2, 2, 'view_attachments', 1 ) , ( 2, 2, 'send_topic', 1 ) , ( 2, 2, 'report_any', 1 ) , ( 2, 2, 'remove_own', 1 ) , ( 2, 2, 'post_reply_own', 1 ) , ( 2, 2, 'post_reply_any', 1 ) , ( 2, 2, 'post_new', 1 ) , ( 2, 2, 'post_attachment', 1 ) , ( 2, 2, 'poll_vote', 1 ) , ( 2, 2, 'poll_view', 1 ) , ( 2, 2, 'poll_post', 1 ) , ( 2, 2, 'poll_lock_own', 1 ) , ( 2, 2, 'poll_edit_own', 1 ) , ( 2, 2, 'poll_add_own', 1 ) , ( 2, 2, 'modify_own', 1 ) , ( 2, 2, 'mark_notify', 1 ) , ( 2, 2, 'mark_any_notify', 1 ) , ( 2, 2, 'lock_own', 1 ) , ( 2, 2, 'delete_own', 1 ) , ( 0, 2, 'post_new', 0 ) , ( 4, 2, 'post_new', 0 ) , ( 5, 2, 'post_new', 0 ) , ( 6, 2, 'post_new', 0 ) , ( 7, 2, 'post_new', 0 ) , ( 8, 2, 'post_new', 0 ) , ( 5, 0, 'poll_remove_own', 1 ) , ( 5, 0, 'poll_edit_own', 1 ) , ( 5, 0, 'poll_add_own', 1 ) , ( 5, 0, 'modify_own', 1 ) , ( 5, 0, 'modify_replies', 1 ) , ( 5, 0, 'delete_own', 1 ) , ( 8, 0, 'post_new', 1 ) , ( 8, 0, 'poll_remove_own', 1 ) , ( 8, 0, 'poll_edit_own', 1 ) , ( 8, 0, 'poll_add_own', 1 ) , ( 8, 0, 'modify_replies', 1 ) , ( 8, 0, 'modify_own', 1 ) , ( 8, 0, 'delete_own', 1 ) , ( 7, 0, 'remove_replies', 1 ) , ( 7, 0, 'remove_own', 1 ) , ( 7, 0, 'post_reply_own', 1 ) , ( 7, 0, 'post_reply_any', 1 ) , ( 7, 0, 'post_new', 1 ) , ( 7, 0, 'poll_remove_own', 1 ) , (
-1, 4, 'post_new', 0
), ( 3, 4, 'make_sticky', 1 ) , ( 3, 4, 'lock_any', 1 ) , ( 3, 4, 'delete_any', 1 ) , ( 3, 4, 'move_any', 1 ) , ( 3, 4, 'merge_any', 1 ) , ( 3, 4, 'split_any', 1 ) , ( 3, 4, 'remove_any', 1 ) , ( 3, 4, 'modify_any', 1 ) , ( 2, 4, 'make_sticky', 1 ) , ( 2, 4, 'lock_any', 1 ) , ( 2, 4, 'delete_any', 1 ) , ( 2, 4, 'move_any', 1 ) , ( 2, 4, 'merge_any', 1 ) , ( 2, 2, 'moderate_board', 1 ) , ( 3, 2, 'moderate_board', 1 ) , ( 2, 2, 'poll_lock_any', 1 ) , ( 2, 2, 'modify_any', 1 ) , ( 2, 2, 'remove_any', 1 ) , ( 2, 2, 'split_any', 1 ) , ( 2, 2, 'merge_any', 1 ) , ( 2, 2, 'move_any', 1 ) , ( 2, 2, 'delete_any', 1 ) , ( 2, 2, 'lock_any', 1 ) , ( 2, 2, 'make_sticky', 1 ) , ( 3, 2, 'modify_any', 1 ) , ( 3, 2, 'remove_any', 1 ) , ( 3, 2, 'split_any', 1 ) , ( 3, 2, 'merge_any', 1 ) , ( 3, 2, 'move_any', 1 ) , ( 3, 2, 'delete_any', 1 )

MySQL said: Documentation #1046 - No Database Selected



Can someone help me please , thanks !



Grudge

Create the empty database FIRST, then try an import from that database.
I'm only a half geek really...

Ne0z

Now i get this error .

*My website's name has been replaced by "sitename"

MySQL said: Documentation
#1146 - Table 'sitename_fir.yabbse_board_permissions' doesn't exist



What i've done was
1. Created a new database named "fir"
2. Imported it using phpadmin

Whats wrong ? tq

Grudge

Oh dear, your backup doesn't contain instructions on how to create the tables.

Can you tell me what version your backup came from? If you can I'll attach an SQL file to import FIRST to set the tables up.
I'm only a half geek really...

Ne0z

i've got it working !

so sorry. I did not check the option "save table structures" at my forum while backing up just now.

Now it says
Your SQL query has been executed successfully:
The content of your file has been inserted. (alverdi_yabb1-complete_2006-01-02.sql.gz: 113 Instructions)


So after this what do i do ?
I've freshly install SMF 1.05 using fantastico through my cpanel.
Do i create a username and password for the new database i've just imported, then use repair_settings.php to change the SQL settings ?

Grudge

Ahhh, I should back track a little  asec :o

If fantastico has already created a database for your SMF install the easiest thing to do is actually to go into the database fantastico created, and import your data into there instead. Then just run repair_settings and you're done.

If you want, you needn't put the backup into the same database as fantastico created, but I believe this will be easier due to way fantastico handles upgrades.
I'm only a half geek really...

Ne0z

Yep i've got it to work already ! I can see all the posts from my old server on the new one.
Thank you very much !

is there anything i need to take note now at this stage ?

Advertisement: