Link to home
Create AccountLog in
Avatar of akiles99
akiles99Flag for India

asked on

mysql-transfer

Hi,
      I am running a video-sharing site using the Clip-Share script. I am switching the site over to PHPMotion. What I am needing is for someone to write an import script that will take all the data from the ClipShare tables and insert it into the proper locations in the PHPMotion tables.

I have done this transfer once myself but manually, this time I have way too many videos and members to do it manually.

I can provide the table structures for both scripts if needed.

The table structure for the two scripts is different.

I transferred it over manually once when I only had about 250 members and 250 videos, took me 4 days. Now I have double the members and videos to transfer over.

Cheers,
akiles


Avatar of jopie916
jopie916

I am not familiar with either of those programs, but perhaps if you post the table structures for both I could write a script/query to do the transfer...
Avatar of akiles99

ASKER

table 1

ondate date
id int
name varchar(25)
age int
videos varchar(255)

table 2

id int
videos varchar(255)
price float
name varchar(25)
age int

ASKER CERTIFIED SOLUTION
Avatar of jopie916
jopie916

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Thanks