Convert MyBB to WordPress Step by Step

We have been using MyBB software for around two years, it was hard to do anything, you need coding skills or hire someone to do easy tasks. After while we need bigger hosting as visitors grow up with many database maximum connections error, then started to check VPS hosting to solve load problem.

MyBB SEO is too hard (even we have very high bounce rate 80%), you have to do everything by yourself, with few plugins and supporting coders and companies.

While checking competitors’ websites, we found them all using WordPress, they have better SEO and Google traffic with very low bounce rate.

After all those points we decide to migrate our MyBB forum to WordPress, but how, will we have to start from the beginning, what about our indexed Google pages, and a lot of questions. At the end, we did it without losing posts and search traffic.

 

How to Migrate your MyBB forum to WordPress Step by Step

 

Tools needed:

1- Access to MySQL (PHPMyAdmin from CPanel)

2- Access to hosting files (file manager from Cpanel or any FTP program)

 

Step 1: Transfer MyBB to subfolder

You have to transfer your forum files to new subfolder before installing WordPress at your hosting, else WordPress installation files will replace your forum files.

  • Create new subfolder using your CPanel “File Manager” at Public_html and call it “forum”
  • Enter MyBB Admin -> Configuration -> Site Details, and change Board URL and Homepage URL to your temp URL – if your website called domain.com then change it to domain.com/forum and save setting
  • Move all files from Public_html to Public_html/forum

Now your forum is working at domain.com/forum

 

Step 2: Install WordPress

You can install WordPress from QuickInsall at CPanel or upload files to Public_html, then install.

 

Step 3: Database Migration between MyBB and WordPress

Now you have two databases, one for MyBB and other for WordPress.

Enter your PHPMyAdmin from your CPanel, click on WordPress database it would be like “_wpdb1” then click SQL.

copy and paste this SQL use the following code:

  • Copy all posts from MyBB to WordPress except reply

INSERT INTO `domain_wrdp1`.`wp_posts` (`ID`, `post_author`, `post_date`, `post_content`, `post_title`,
`post_status`, `comment_status`, `ping_status`, `guid`, `post_type`)
select tid,1,from_unixtime(floor(dateline)),message,subject,’publish’,’closed’,’open’,CONCAT(‘https://domain.com/?p=’,tid),’post’
from domain_mybb.mybb_posts where subject not like ‘%Re%’

don’t forget to change databases names and domain name

  • Copy all foums as Tags or Catgories

INSERT INTO `domain_wrdp1`.`wp_terms` ( `name`, `slug`)
select name,name
from domain_mybb.mybb_forums

  • Change image and url from mybb to WordPress

UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`, ‘[img]’, ‘<img src=”‘);
UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`, ‘[/img]’, ‘”/>’);
UPDATE `wp_posts` SET `post_name` = REPLACE(`post_title`, ‘ ‘, ‘-‘);
UPDATE wp_terms set slug= REPLACE(`name`, ‘ ‘, ‘-‘);

 

Step 4: Forward traffic from old MyBB posts to new WordPress posts

edit your .htaccess file and make it like

 

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /

RewriteRule ^Thread\-([^./]+)$ $1/ [L,QSA,R=301]
RewriteRule ^Forum\-([^./]+)$ tag/$1/ [L,QSA,R=301]

RewriteRule ^index\.php$ – [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>

# END WordPress

 

We have added those two bold lines, you can edit then to forward to ids if you are using default MyBB setting.

 

Now your MyBB forum has been transferred to WordPress,

 

Notes:

1- If you wish to transfer your website to new hosting, first migrate at same hosting then transfer your WordPress to new hosting.

2- If you are using MyBB Google SEO URLs, this will work for you.

3- If you are using Unicode characters, try using “Regenerate post permalinks” plugin to rowurlencode names.

4- If you wish to add reply posts, you can modify the insert code.

5- code needs to deal with other sets than images like fonts and colors etc..

6- Try to check your .htaccess after installing new WordPress plugins, it may be reset to default values.

 

Feel free to ask more information and we will reply you and update the post.