Re: Data Migration

On 2010-11-08, at 6:19 AM, Karl DeSaulniers <karl@designdrumm.com> wrote: > Hello All, > I was wondering if I could get some pointers on the best/safest method to migrate data on a > fairly simple scale. > I have a registration form that gets submitted. I want to take that info and store it in a > table as a sort of Que. if you will. > When the application is approved, I want to have something set up for the owner or his > employees to access and be able to > activate the account. Behind the scenes, the info from the registration table is simply moved > to the users table and an email is sent out. > > What would be the simplest way to migrate the data between the tables? > Is there a bulk way to move data in PHP? Or is that best/safest done in MySQL? > > Examples, tuts, keywords appreciated. > TIA > > Karl DeSaulniers > Design Drumm > http://designdrumm.com > > PS: I'm on google now.. Karl, A better solution might be to add a temp flag or status field and avoid the need to move data. When the user clicks the link in the email, then you would only need to update that one field to activate the user. Bastien Koert Sent from my iPhone