MySQl migration from one field to another

thunderbird · Hangin' Around Joined: Jul 13, 2005 Posts: 38

HI,

ok here is my problem.

I am currently using nuke 7.6 distro from this site and want to intrograte another php app into it, basically just using the username and password from when the person registered instead of having to do it twice.

I have one mysql DB with different fields. with in this one DB I need to some how migrate one field (users" to another called "users". Slightly different names in side and the variables.

What I am trying to do is somehow beable, through maybe a page after they have signep up is be able to have the main file "user" be migrated over to "users". Any one have any clues or is there software out there that will do this say once an hour?

Thanks in advance

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

Do you mean synchronize tables across 2 databases? If so, I'd be surprised if there was something that you could drop in. However, you could probably do that with a custom php app and a cron job to call it.