Importing MYSQL Column Data for VBCredits from other Database?

[Toupsx]

Greetings, here's what my problem is:
I have just recently imported my board from SMF to VB with Implex, working great. Of course it couldn't take the credit information with it. In my SMF board the table Members (same as the table User in VB pretty much) had two columns called money and moneyBank going along with each member's row. Now in VB I installed the mod VBCredits which put in the columns credits and credits_saved corresponding to each user's row. What I want to do is take the data from the money row from my old forum and put it in the new credits row in my new forum.. and the same for moneyBank & credits_saved..

They are basically the same exact thing just different names.

I'm inexperienced with SQL queries or importing/exporting data with specific columns like this so if anyone could help that would be amazing.

[Marco van Herwaarden]

If you have questions/problems with a modification or style, then please post in the thread (or support forum/board) about that modification/style. Best chance to receive a reply from either the author or another member using the same modification/style.

[Toupsx]

Originally Posted by Marco van Herwaarden

If you have questions/problems with a modification or style, then please post in the thread (or support forum/board) about that modification/style. Best chance to receive a reply from either the author or another member using the same modification/style.

Its a mysql question.. not style or mod.. I asked in VBCredits' mod topic and he said post here/at vbulletin.com because he doesn't know how.. so.. yeah..

[Marco van Herwaarden]

Well we don't have any knowledge of the database stucture used in these modifications, they are really the only ones that can give a correct answer.

[Toupsx]

Originally Posted by Marco van Herwaarden

Well we don't have any knowledge of the database stucture used in these modifications, they are really the only ones that can give a correct answer.

Read my first post please.. not looking to import everything from them.. I'm looking for help to import two single columns into the User table from another database whos member table is basically the same thing.. really has nothing to do/no needed information for either of the modifications.. its the default Vbulletin database structure for the User table.. with just two columns that I want to import data to..

[Regs]

I believe what he is asking is pretty straightforward in the sense that it doesn't matter which modification he is using.

The point being made is that both structures are the same just the 2 columns are names differently. On one side, the 2 columns has all the data and the other has none.

To the original poster, one avenue you might want to try is export the 2 tables using phpmyadmin, open them up in a spreadsheet and copy the data over from one file to the other. Then import back using phpmyadmin.

This is of course assuming that the userids in both tables match up, if not, you might need to do some 'massaging'.

I would test this out on a test install first.

There are probably much better ways of doing this but you'll need a helpful coder here to get you going.

Cheers,

Regs.

--------------- Added [DATE]1219333529[/DATE] at [TIME]1219333529[/TIME] ---------------

I should add that when I say copy the data over, I mean just the 2 columns, not everything

[Toupsx]

Originally Posted by Regs

I believe what he is asking is pretty straightforward in the sense that it doesn't matter which modification he is using.

The point being made is that both structures are the same just the 2 columns are names differently. On one side, the 2 columns has all the data and the other has none.

To the original poster, one avenue you might want to try is export the 2 tables using phpmyadmin, open them up in a spreadsheet and copy the data over from one file to the other. Then import back using phpmyadmin.

This is of course assuming that the userids in both tables match up, if not, you might need to do some 'massaging'.

I would test this out on a test install first.

There are probably much better ways of doing this but you'll need a helpful coder here to get you going.

Cheers,

Regs.

--------------- Added [DATE]1219333529[/DATE] at [TIME]1219333529[/TIME] ---------------

I should add that when I say copy the data over, I mean just the 2 columns, not everything

Hello, yes that basically sums it up, I tried exporting the data & then importing it selecting "just the columns I wanted" in the import.. didn't work, it completely erased the user (made it on a test user just importing those two columns for just it). So yeah. if someone could give me some better instructions on how to do it or a better way to do it, would be great.

[Opserty]

If you have no experience with MySQL then you may want to consider hiring someone to do it for you. If there was an easy answer, someone would have given it by now. My best guess would be that you'd need to use an "UPDATE" possibly with a join (if thats possible in update queries).

[Toupsx]

Originally Posted by Opserty

If you have no experience with MySQL then you may want to consider hiring someone to do it for you. If there was an easy answer, someone would have given it by now. My best guess would be that you'd need to use an "UPDATE" possibly with a join (if thats possible in update queries).

It really doesn't seem that hard of a thing.. you have 1 database with 2 columns with data in them.. you have another database with 2 columns with the exact same set up with no data in them... you take data from database 1 and put it in database 2.

That's all I want.. all these mod makers and such do a lot more & harder SQL things I'm sure so really don't think it would be worth spending money on.. seems like a 5 minute job for someone that actually knows how to do it.. really only want this to save me from putting in the data manually for each user..

[Eikinskjaldi]

Originally Posted by Toupsx

It really doesn't seem that hard of a thing.. you have 1 database with 2 columns with data in them.. you have another database with 2 columns with the exact same set up with no data in them... you take data from database 1 and put it in database 2.

assuming both databases are on the same system:

[sql]
update vbdatabase.user u, otherdatabase.credittable o
set u.newfield1=o.oldfield1, u.newfield2=o.oldfield2
where u.userid=o.userid
[/sql]