Guest netrix Posted May 31, 2006 Share Posted May 31, 2006 I'm trying to import a large database using PHPMyAdmin which has a 2mb limit on the file sizes. Now I can just move the customers account to another host that will provide a CLI or one that will import it themselves but it got my wheels turning and I wondered if there was any easy way to import/split larger databases. The file is 7mb gzipped and 74mb uncompressed. I tried using the linux split command but it has absolutely no regard for completing SQL statements so it breaks it every time. I tried splitting by line but some of the lines are extremely large so I end up with some files that are 700K and some that are 6mb. Any suggestions would be appreciated! Quote Link to comment Share on other sites More sharing options...
Guest magicpaul Posted June 1, 2006 Share Posted June 1, 2006 What you need is a little tool called BigDump (funny name, I know!). It can be found at http://www.ozerov.de/bigdump.php I had the same problem importing a 24MB MySQL database and this little baby was the answer to my prayers! */* Quote Link to comment Share on other sites More sharing options...
Guest netrix Posted June 1, 2006 Share Posted June 1, 2006 Thanks thats exactly what I was looking for. I give it a shot later tonight. Thanks! Quote Link to comment Share on other sites More sharing options...
Guest netrix Posted June 8, 2006 Share Posted June 8, 2006 Ok I'm running behind schedule a bit but I finally had a chance to try this out and wanted to say it worked great! Thanks for the suggestion. 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.