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 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 Link to comment https://forums.phpfreaks.com/topic/49762-solved-importing-large-file/#findComment-274125 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.