jakebur01 Posted May 3, 2007 Share Posted May 3, 2007 I exported a table from my localhost mysql database in sql and csv formats. I am trying to import this into my remote mysql database using phpmyadmin. The sql server query file is 46.5mb and has 80,000 rows. The csv file is about 33mb. I have tried importing either one of these files, it will just load for a little while and then goes to a white page. I am assuming it is just timing out or something. What are some other approaches I could use? `Jake Quote Link to comment https://forums.phpfreaks.com/topic/49762-solved-importing-large-file/ Share on other sites More sharing options...
woolyg Posted June 13, 2007 Share Posted June 13, 2007 jakebur01 - would you mind sharing how you solved this one? I'm trying to import a .sql file (about 22M) into my MYSQL db using phpmyadmin, and though the smaller files go in fine, this file just hangs the browser. I've set the timeout period to 0 (never) and my max import filesize to be 160M. My PC has a P4 processor and 1G RAM, so overhead is no issue. I'm only trying to import to my local machine, not over a network/internet.. Any thoughts appreciated Woolyg Quote Link to comment https://forums.phpfreaks.com/topic/49762-solved-importing-large-file/#findComment-274125 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.