esandra Posted January 29, 2011 Share Posted January 29, 2011 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 Quote Link to comment Share on other sites More sharing options...
AV1611 Posted January 29, 2011 Share Posted January 29, 2011 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. Quote Link to comment Share on other sites More sharing options...
l4nc3r Posted January 29, 2011 Share Posted January 29, 2011 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. Quote Link to comment Share on other sites More sharing options...
esandra Posted January 31, 2011 Author Share Posted January 31, 2011 is it possible to simply fetch from the server(mySql) and then dump it online? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.