Migrating users and etc tables and fields to another softwares

[sella2009]

I just want to know if there is a simple way to migrate my users from my old project to a new web application, I mean I want to migrate the users, comments and etc, so can anyone here please tell me a simple way to do that?? and which software should I use to speed it up.

[cags]

That would depend how compatible the old and new systems are and also how you are storing those pieces of information. In theory assuming the items are stored in MySQL you could log in to PHPMyAdmin goto the export tab, export it to an SQL file, go to the new server and do the same only with the import tab. That's the best I can suggest without more details.

[sella2009]

That would depend how compatible the old and new systems are and also how you are storing those pieces of information. In theory assuming the items are stored in MySQL you could log in to PHPMyAdmin goto the export tab, export it to an SQL file, go to the new server and do the same only with the import tab. That's the best I can suggest without more details.

thanks for the reply friend, one more thing, can you please tell me how I can change the field name, for example my field name is id and I want to change it to user_id, btw I am using phpmyadmin.

[cags]

To do it in PHPMyAdmin, make sure the table is selected, click the structure tab, tick the box next to the field you wish to change and then click the change button (it looks like a pencil).

[sella2009]

To do it in PHPMyAdmin, make sure the table is selected, click the structure tab, tick the box next to the field you wish to change and then click the change button (it looks like a pencil).

thanks friend