Page 1 of 1

if anyone could give me any suggestions on this

Posted: Sat Jan 29, 2011 1:29 am
by 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

Re: if anyone could give me any suggestions on this

Posted: Sat Jan 29, 2011 9:12 am
by endyourif
I've done something similar before where you create a simple Foxpro program that loops through the tables and just builds the SQL for you and this can either be saved into your clipboard or outputted on screen for you to copy and paste into something like phpMyAdmin.

Or if you have access to the mysql database from Foxpro, you can just connect directly to the DB and import it from there.