I need to import the data from vBulletin addon into xenforo showcase addon
I don't have importer, therefore I tried to transfer the data from vBulletin database called "vb4final" to xenforo database called "xenforum" from phpMyAdmin using this query:
Importing items query (from table "adv_links" to "xf_nflj_showcase_item")
INSERT INTO xenforum.xf_nflj_showcase_item( item_id, item_name, description, category_id, username, user_id, date_added, last_update, item_view_count ) SELECT linkid, name, description, catid, username, userid, dateline, lastupdated, views FROM vb4final.adv_links
INSERT INTO xenforum.xf_nflj_showcase_comment( comment_id_id, item_id, message, user_id, username, comment_date ) SELECT postid, linkid, pagetext, userid, username, dateline FROM vb4final.adv_links_posts
Q1: Is this a right method for importing? I mean why we need to program a long importer if it is possible to easily copy the data from column 1 in database 1 to column 2 in database 2?
Q2: I am facing a problem after done the importing, vBulletin database was (latin1) and xenforo is (UTF8). Therefore, the text in some column is not showing correctly, how I can solve this?
In xenforo importer we can use a command like this "'title' => $this->_convertToUtf8($title, true)," but is it possible to convert to UTF8 through SQL manual query?