Help with some SQL to import one table to another table

Hi There,
I have successfully imported some products from a virtuemart shopping cart (version 1.1.4, joomla 1.5) to a new install of joomla 2.5 virtuemart 2.0.2.

I did this using csv improved.

My only issue is I cannot seem to get the image paths imported across or the product descriptions.

So i was thinking I could get my hands dirty and do a direct import into the database.

Can anyone help me do this?
LVL 11
Amanda WatsonWeb DeveloperAsked:
Who is Participating?
 
johanntagleConnect With a Mentor Commented:
Are they on the same mysql instance?  Then you can just do something like

insert into new_db.new_table (col1, col2, col3) select col1, col2, col3 from old_db.old_table <optional where clause here>;

You just need a user that has access to both databases/schemas.  If they are not on the same mysql instance, do a mysqldump (or export from phpmyadmin as sql statements) of the needed tables from the old database, import to a temporary database on the new mysql instance, then do the same insert operations above.
0
 
Amanda WatsonWeb DeveloperAuthor Commented:
Thanks that would have worked, I ended up having a folder permission issue with csv import, and that solved it for me, but your solution would have worked for me also.
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.