[eluser]Devon Lambert[/eluser]
Hello all CIers,
I have two separate member tables in my dev database. One table contains a large grouping of members from the live site I am working on. The other table will be the NEW and improved table made specifically to work with a CI authentication library. What I am trying to do is preserve some of the columns in the current member table and import those tables (data and all) into the NEW member table.
The database uses mysql and I am looking for an easy way to accomplish the above task.
Nice would be: Some sql query, or group of queries, to perform the transfer of a column from one table to the other seamslessly.
Best Case: Some automatic script that would do the above and also make it so that I could grab member data from the live site as it is updated. This may very well be a dream but I thought it couldn't hurt to ask around. :-)
Thank you for any help you can provide.
