Forum Moderators: open

Message Too Old, No Replies

how to import/export from table to another table?

table import

         

john1000

11:10 pm on Aug 9, 2006 (gmt 0)

10+ Year Member



Hello,

I hope someone can help me out here as my knowledge with is like zero..

what i want is this..
long ago i converted my downloads to a different download module..
it had a different prefix as well,but also more rows.

but now i want to change to a different system/cms but before i can do that i need to put it back to how it was...
so converting it back...

at that time someone pulled a script together in like 20 minutes or so and it went ok.....
but i lost the script and the person who made cannot be found...

for any coder this is simple,unfortunately not for me...

anyway...
the current table/rows ar:

lid
cid
title
url
description
date
name
email
hits
sid
is_media
coupontrue
coupon_code
icon
submitter
sub_ip
filesize
version
homepage
active
price
currency
sale
image
share
previewtrue
mediacheck
previewurl
presentationurl
keywords

And has to be imported into this again:

lid
cid
sid
title
url
description
date
name
email
hits
submitter
downloadratingsummary
totalvotes
totalcomments
filesize
version
homepage

Anyone willing to help me on this?

Thank you,

John

coopster

8:22 pm on Aug 22, 2006 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Which database are you using?
What will you do with the three new columns that are non-existent in the old table layout?
downloadratingsummary 
totalvotes
totalcomments