crazysaint Posted September 20, 2008 Share Posted September 20, 2008 Hey everyone,its been ages since i was here.anyway i need some help.does anyone know how i can get an sql script to download data from an online server to a local machine runnin MS SQL.am hopin my question makes sense Quote Link to comment https://forums.phpfreaks.com/topic/125112-importing-data/ Share on other sites More sharing options...
crazysaint Posted September 21, 2008 Author Share Posted September 21, 2008 after much thought,i decided to us a different approach to solve my issue. sorry for not mentioning but am using MySQL 5.0. i would like to come up with a php code that can access the db online and download it to a local machine to a specified folder in .CSV file format. i wouldn't mind a php code that i can run on my local host and on request it downloads the sql dump. Quote Link to comment https://forums.phpfreaks.com/topic/125112-importing-data/#findComment-646947 Share on other sites More sharing options...
fenway Posted September 29, 2008 Share Posted September 29, 2008 You can use SELECT INTO OUTFILE. Quote Link to comment https://forums.phpfreaks.com/topic/125112-importing-data/#findComment-653287 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.