MySQL Forums
Forum List  »  Newbie

moving data with diferent DB structures
Posted by: Rui Silva
Date: June 09, 2014 03:38PM

I'm having some difculties with two databases.

I had an joomla 2.5 website with 15.000 users registered.

Now, i'm bilduing an new joomla website V3.2 wich have a diferent db structure.

I've imported the articles db with success.

But when doing the same with users db, i get errors and cannot move users data.

When I compare both db, i see diferent colmuns. The older one has more colmuns than the new one.

I've tried INSERT INTO thru an ssh terminal but nothing happens.

If i move all the data & structure to the new one, all 15.000 users are moved with success but, the i lose the administration privilieges. Even if creating a new user directly in phpmyadmin.

If i try to move only the data i get this error:

SQL:

INSERT INTO `teste`.`qolxc_users`
SELECT *
FROM `xbz`.`xbz_users`

#1136 - Column count doesn't match value count at row 1

Options: ReplyQuote


Subject
Written By
Posted
moving data with diferent DB structures
June 09, 2014 03:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.