Importing MySQL

[Dan]

The old script I am trying to export has over 100 rows of information. I don't want to manually go through and add each one. The problem is, the database isn't set up the same way, so an easy export, import won't work. I'm wondering what the best way possible to do it is.

The only way I can think of is to write a PHP script that explodes it by new line, then by ',' (how each value is seperated). Then, I can put each array piece back together and implode it into the new way.

Any suggestions?

 

[sjaguar13]

I'd write a script that loops through the database and selects everything that's important and then writes an SQL statement for the proper way to insert it into the new database. Loop for every line and then whatever it prints out should be all that's needed for the new import.

 

[Dan]

Well, I got it. It was pretty easy. :x

I exported the sql I wanted, exploded it by commas, put each thing I wanted into an easy to remember variable and wrote the MySQL query.