Question Vbulletin to Kunena, jos_fb_messages

ok Matias, thank you very much

Do you know mysql command to copy record ? for example to populate jos_fb_messages_text with id and text from vb table. For the moment I use export/import in csv but if is possible with mysql, is faster... sorry for my english, I hope you can understand

Hello,

I don't know what you mean by copy record, but for insered something in a table use the sql instruction :

thanks xillibit, ok with you, but I would want to insert records from other table.

For example :

TABLE_1

'id' 'content'
1 content1
2 content2
3 content3
4 content4


TABLE_2
'id' 'content' 'other field' 'other field'
table is empty


I have tried this
INSERT INTO table_1 (id,content) VALUES (SELECT id,content FROM table_2)

But this not works

In this point, you need a php script to do that, i don't know if you have php skills. You need to do something like that :

This is just an example and it's not complete

ok thank you very much, I will try this method !

Hard job but very interesting..