with kind regards, From: "Karl DeSaulniers" <karl@xxxxxxxxxxxxxxx> To: php-db@xxxxxxxxxxxxx Sent: Monday, November 8, 2010 12:19:23 PM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna Subject: 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
