Re: [PHP-DB] Data Migration

[Max E.K]

with kind regards,
From: Karl DeSaulniers k...@designdrumm.com
To: php-db@lists.php.net
Sent: Monday, November 8, 2010 12:19:23 PM GMT +01:00 Amsterdam / Berlin / Bern 
/ Rome / Stockholm / Vienna
Subject: [PHP-DB] Data Migration

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.. 

- Original Message -

Just thinking about it, how about a stored procedure, that does select from 
registration table and insert into the user table, you can then delete the 
inserted record from the registration table.

Something like this.

Insert into table_users (fields1, field2)
Select field1, field2 from registrations_table WHERE some_criteria

you can have a marker field for tracking what was already worked up on.

Just a thought.

with kind regards,

Max.

Max Kimambo
Franz-Stenzer-Straße, 51
12679, Berlin.
T: +493057706550 (new number)
M: +4917649520175


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Data Migration

[Bastien]

On 2010-11-08, at 6:19 AM, Karl DeSaulniers k...@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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php