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
if anyone could give me any suggestions on this
Moderator: General Moderators
Re: if anyone could give me any suggestions on this
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.
Or if you have access to the mysql database from Foxpro, you can just connect directly to the DB and import it from there.