if anyone could give me any suggestions on this

[esandra]

How to do #3 by a PHP page instead? mainly so

that there wouldn't be a need to

export the sql after doing #2 then

import it into the online phpmyadmin(#3)

 

#1. Convert database from foxpro to sql

#2. Change some fields in the sql table

#3. Upload to phpmyadmin

 

Is it possible to create a code to export

from the server and then import the sql online?

 

like by making use of mysql_fetch_array() and insert into

[AV1611]

I have done this. My approach was to write a PHP script that parsed the date and stuffed it into a mysql table directly. To do so you need to set up PHP to use an ODBC (or maybe other way?) to dump the table. You can make the PHP script create the mysql table on the fly and make changes as needed.

 

[l4nc3r]

I'm assuming you're using an SQL dump to upload it.  If that's the case, then you could just do one grand mysql_query() on the entire dump inside of a php script.

[esandra]

is it possible to simply fetch from the server(mySql) and then dump it online?