Data Migration

--Apple-Mail-1--477165797
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed

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..
--Apple-Mail-1--477165797--

Re: Data Migration

with kind regards,
From: "Karl DeSaulniers"
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 =20
method to migrate data on a fairly simple scale.
I have a registration form that gets submitted. I want to take that =20
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 =20
the owner or his employees to access and be able to
activate the account. Behind the scenes, the info from the =20
registration table is simply moved to the users table and an email is =20
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 =20
in MySQL?

Examples, tuts, keywords appreciated.
TIA

Karl DeSaulniers
Design Drumm
http://designdrumm.com

PS: I'm on google now..=20

----- 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: Data Migration

On 2010-11-08, at 6:19 AM, Karl DeSaulniers wrote:

> Hello All,
> I was wondering if I could get some pointers on the best/safest method to m=
igrate data on a fairly simple scale.
> I have a registration form that gets submitted. I want to take that info a=
nd 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 o=
wner or his employees to access and be able to
> activate the account. Behind the scenes, the info from the registration ta=
ble is simply moved to the users table and an email is sent out.
>=20
> 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 My=
SQL?
>=20
> Examples, tuts, keywords appreciated.
> TIA
>=20
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>=20
> PS: I'm on google now..


Karl,

A better solution might be to add a temp flag or status field and avoid the n=
eed 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.=20

Bastien Koert

Sent from my iPhone=

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