akiles99
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
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
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...
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
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
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks