[MySQL] How to import a column from db1.table to db2.table

[kevin.kool]

Hello,

I've just downgraded my forum from vb4 to vb3, and would like to keep the "thanked" amount from old db. I looked into the old db and notice that "thanked" is a column in "user" table.

So i would like to ask how can i move (or copy) that column from old database into the table of the new database?

Also, is there anyway to plus 1 value in the "userid" field (of that column)? Because of i've used ImpEx and it's created a new admin with userid = 1, then my old admin account has userid = 2.

Thank you.

[Disasterpiece]

You'd have to create a new column with the exact datatype like the original column (if that istn't already done) then you'd have to create a php script, that queries every user row, builds a new query with updated userid (+1) in the WHERE clause to apply the sql query.

Could look something like this:

SELECT userid, thankedamount FROM vb4_user

The function will return an array which you'll run through in a foreach loop, then you run a query for every user:

UPDATE vb4_user SET thankedamount = ".$thankedamount." WHERE userid = ".$userid+1

Depending on how good your knowledge in php is, this will be a quite simple task.

[kevin.kool]

I have ran this query in phpmyadmin and it's ok, but only for the user who has id=2, how to loop it?
Sorry because my php knowledge is bad.

This is the query that i have used:

SELECT userid, post_thanks_thanked_times FROM vb4forum.user;
UPDATE vb3forum.user SET post_thanks_thanked_times = '.$post_thanks_thanked_times.' WHERE userid = '.$userid.+1';

[Disasterpiece]

it's no mysql query at all

there needs to be a php script built around this...
Can you tell me if the two vbulletin installations are stored in the same or in a different database?
And tell me how the exact name of the column is where the amount of thanks is stored.

[kevin.kool]

Two forums are store in 2 different databases. I wrote as 'vb4forum' and 'vb3forum' as above.
And the 'thanked amount' column name is post_thanks_thanked_times

Could you create a sample php page?

[Disasterpiece]

This is my old convert-youtube script. I just adjusted some values and added a 2nd database.

This only works if username and password are the same for the 2 databases.

open the file, enter your credentials at the top of the script. It works like
$db1 reads, $db2 writes. So $db1 is your old db to read from, $db2 is the one where you want the thanks transferred to.

Upload it into the root dir of your site (not forum root) so it can be accessed like "http://someurl.tld/transferthanks.php"
and run it.

didn't test it myself, if you're getting errors, report back. And I suggest to test it in a safe environment first.

[kevin.kool]

Thank for the file but when it's got error:

Warning: Cannot use a scalar value as an array in C:\AppServ\www\transferthanks.php on line 34

Notice: Undefined variable: id in C:\AppServ\www\transferthanks.php on line 41
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1 (id: )

Line 34:

		$res['post_thanks_thanked_times'] = 0;

Line 41:

	else echo "Error: ".mysql_error()." (id: $id)<br />";

[Disasterpiece]

d'ouh, my bad.

Fixed

[kevin.kool]

Got this error:

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1 (id: 1)

For the whole from id 1 to id 509 (i have 509 users) and nothing change in database.

[Disasterpiece]

huh weird... change line 42 from:

PHP Code:

    else echo "Error: ".mysql_error()." (id: $id)<br />"; 


to:

PHP Code:

    else echo "Error: ".mysql_error()." ($q) (id: $id)<br />"; 


And post what the first error is, thanks.