Can this be done? Import old member table

[aipforum]

We closed our site a year ago for reasons that don't matter here, but we decided to re-open the site and we have a fresh install of Integramod 1.40.

Our old Inegramod 1.32 was highly customized, and comparing the User tables from the old export to the User tables from the new install show a striking number of tables (using Excel, it shows quiet additional columns) of mismatched information and stuff we no longer need or have installed.

For convenience sake to the members, we would like to have their accounts ready with their username and password intact and ready to go. Of course they would need to update their profile, etc...

But the question I'm asking is ...

What is the bare minimum we would need to import to have their accounts work upon first visit to the new site?

Can we just import the username, password and email address so that their account is already there and active --- just needing (forcing) them to update their profile?

Is it okay if all the other tables are completely blank?

Or do we absolutely have to match up every column in the new database to data from the old database, delete the extra columns, delete the message id's that are no longer relevant, etc???

I hope I explained that well enough. If not, I'll try to do better.

All we really want is their username, password and email to be in the database at this point.

TIA for your suggestions.

-- Brent

[napukjon]

It is possible to do, however if you have that database in front of you, the best thing i think would be to compare both databases and take out fron the old what isnt needed, and also any members that have re joined (if any have after re open)

[aipforum]

Yeah, I already started doing that, but I'm so scared I'll mess things up doing it that way. So I got the bright idea to see if just the user/pass/email would be enough to get things started. With the data being over a year old, it all needs updating anyway.

We're thinking maybe we just need to have them re-register and start completely fresh.

This is a difficult decision. URGH.

Thanks for the reply.

[napukjon]

im not entirely sure, and i get that way sometimes when im playing with the DB. Im getting used to it, and learning more about it each time, but it still scares me

[found it]

Have you tried copying everything to a test site and doing everything on there first.....

I do all my testing on exact replicas of my live sites and make pleanty of backups if i screw it up....

try here if you havnt seen it all ready

http://integramod.com/forum/viewtopic.p ... ight=xampp

then you can mess around with the database as much as you like but you always have a copy to correct it with...

i appreciate it is time consuming but does save the errors later

[aipforum]

Have you tried copying everything to a test site and doing everything on there first.....

Probably as you we're typing that, yet another lightbulb went off in my head.

I have Mandriva Linux installed on a partition of my desktop, and I just setup Apache, MySQL, etc... to do exactly that on my own computer. I'm going to mirror the website locally and just muck around with everything and give it a go. If I screw it up, so be it.

There are other things I've wanted to play around with and, especially, learn about. So doing it locally first won't hurt anything one bit.

We're not in any hurry, so your suggestion is exactly what I'm going to do. I can work with everything directly in PHPMyAdmin and an actual "live" website rather than trying to do it in Excel. Makes perfect sense to me.

Thanks everyone.
I really do appreciate it.

-- Brent