Example SQL->CSV export queries for vBulletin->Discourse import script

firstpost.sql

use kf;

select
      post.postid,
      post.threadid,
      post.userid,
      replace(replace(pagetext, '\n', '\\n'), '\r', '\\r'),
      post.dateline,
      post.visible,
      post.parentid,
      thread.firstpostid
from
	post
inner join `thread` on post.threadid = thread.threadid
where
	postid = thread.firstpostid
into outfile "D:\\\SQLOutput\\firstpost.csv"
character set utf8
fields
	terminated by ','
	escaped by '"'
	enclosed by '"'
lines terminated by '\n'
;

forum.sql

use kf;

select
    forumid,
    title,
    displayorder,
    replace(replace(description, '\n', ''), '\r', '')
from
	forum
into outfile "D:\\\SQLOutput\\forum.csv" # this is used by import_categories, primarily
fields
	terminated by ','
	escaped by '"'
	enclosed by '"'
lines terminated by '\n'
;

forumpermission.sql

use kf;

select
    usergroupid,
    forumid,
    forumpermissions
from
	forumpermission
into outfile "D:\\\SQLOutput\\forumpermission.csv" # this is used by import_categories, primarily
fields
	terminated by ','
	escaped by '"'
	enclosed by '"'
lines terminated by '\n'
;

post.sql

use kf3;

select
      postid,
      threadid,
      userid,
      replace(replace(pagetext, '\n', '\\n'), '\r', '\\r'),
      dateline,
      visible,
      parentid
from
	post
where postid > 2662917 #2323691 #1800186 #1280223 #558363
order by postid asc
limit 500000
into outfile "D:\\\SQLOutput\\post_kf3.csv" # this is used by import_categories, primarily
character set utf8
fields
	terminated by ','
	escaped by '"'
	enclosed by '"'
lines terminated by '\n'
;

thread.sql

use kf3;

select
    threadid,
    "open",
    firstpostid,
    postuserid,
    replace(replace(title, '\n', '\\n'), '\r', '\\r'),
    forumid,
    dateline,
    visible,
    views,
    sticky    
from
	thread
where threadid > 381060
into outfile "D:\\\SQLOutput\\thread_kf3.csv" # this is used by import_categories, primarily
character set utf8
fields
	terminated by ','
	escaped by '"'
	enclosed by '"'
lines terminated by '\n'
;

user.sql

use kf3;

select
    userid,
    username,
    email,
    homepage,
    replace(replace(usertitle, '\n', '\\n'), '\r', '\\r'), 
    usergroupid
from
	user
where
	userid > 218292
#limit
#	100
into outfile "D:\\\SQLOutput\\user_kf3.csv"
character set utf8
fields
	terminated by ','
	escaped by '"'
	enclosed by '"'
lines terminated by '\n'
;

usergroup.sql

use kf;

select
    usergroupid,
    title
from
	usergroup
into outfile "D:\\\SQLOutput\\usergroup.csv"
fields
	terminated by ','
	escaped by '"'
	enclosed by '"'
lines terminated by '\n'
;