puter code geeks

[mrob]

anyone know a damn thing about mysql? Im bout to kill a kitten tryin to figure out how to take users from one database and importing it into a different scripts database which the tables are a bit different. 42k users so not something i can do by hand.

Is there a script out there anywhere where I can take one mysql database (in a sql or csv file) and move the information table by table into the correct area in a different database so the new script "creates" the user?

anyone know?

[MiSdIrEcTeD_1]

What exactly are you transferring? PM me if you dont want it public. I have done a little with sql but Im no pro.

[mrob]

Im tryin to import 42k users from one script into a different script. The passwords use the same encryption so i dont have that issue but the structure of the tables are different.. I dont want to have to go in and manually create 42k accounts thru the register now shit and then copy and paste their old passwords into the tables.

thats a bit much but about where im at.

[MiSdIrEcTeD_1]

Have you tried using converters? Like transferring sql to csv or xml and then xml/ csv back to sql? There are certain parameters in some of those converters that allow you to change the output variables. :shrug: Just a thought...

[mrob]

Have you tried using converters? Like transferring sql to csv or xml and then xml/ csv back to sql? There are certain parameters in some of those converters that allow you to change the output variables. :shrug: Just a thought...
I have them in CSV and trying to manipulate the order of the shit in excel.. but fuck thats tedious. theres gotta be a better way

[MiSdIrEcTeD_1]

Are you transferring between servers or is this all on the same server?

[mrob]

Are you transferring between servers or is this all on the same server?
same server