Notifications
Clear all

wpForo 1.x.x [Closed] Moving wpforo to another database

5 Posts
2 Users
0 Likes
657 Views
Posts: 21
Topic starter
(@vasiliy)
Eminent Member
Joined: 6 years ago

Hi! The wordpress database is damaged, but wpforo is working normally. Question: can I move the forum to another wordpress database by simply copying all the wpforo tables and the users and usermeta tables?

4 Replies
Robert
Posts: 10498
Admin
(@robert)
Support Team
Joined: 8 years ago

Hi @vasiliy,

It depends on the wp_users and wp_usermeta tables.

If you can move these table identically to the target database then you can copy wpForo tables too. If these two tables are broken then wpForo has no chance to show topics and posts correctly because user information are lost. I'd recommend ask your hosting service for some backup/restoration.

Posts: 21
Topic starter
(@vasiliy)
Eminent Member
Joined: 6 years ago

Backup does not work, it is also broken. If the id and nickname of all users and the id of all topics and posts are saved. Is it possible to move the database?

1 Reply
Robert
Admin
(@robert)
Joined: 8 years ago

Support Team
Posts: 10498

@vasiliy,

In that case you can. But all your post authors will become not-registered users, but the names will be displayed in forum. To make all this working, after the moving wpforo tables you should add user nicknames to 'name' column in wp_wpforo_posts and wp_wpforo_topics tables corresponding to the Users ID in 'userid' column.

In other words all posts and topics 'name' fields should be updated by user nicknames based on the topic and posts 'userid' column. You should find some developer who can do this with custom SQL queries.

Once all is done you should update 'userid' column of both tables and set them 0 to allow wpForo track users as guests and read 'name' column instead of 'userid' column. Then go to Dashboard > Forums > Dashboard and click the [Delete all caches] to reset topics and posts data.

Posts: 21
Topic starter
(@vasiliy)
Eminent Member
Joined: 6 years ago

Thanks.