ldoozer Posted February 1, 2007 Share Posted February 1, 2007 I have a .sql file that is an exported table from my mysql database, which I want to import into another database. Thing is its 30mb and too large to import through phpmyadmin. Is there a way to split the table in to parts and import them individually? Quote Link to comment Share on other sites More sharing options...
artacus Posted February 1, 2007 Share Posted February 1, 2007 The easiest way to do it is using the mysql console you'll need something like so: /usr/local/mysql/bin/mysql -u myUsername myDbName -p < reallybigfile.sql Quote Link to comment Share on other sites More sharing options...
fenway Posted February 1, 2007 Share Posted February 1, 2007 Just remember that you may want to turn off FK constraints during the import. Quote Link to comment Share on other sites More sharing options...
ldoozer Posted February 1, 2007 Author Share Posted February 1, 2007 sorry guys, have no clue what u mean - im kinda new to it all. Do you mean i wouldnt use phpmyadmin to import ? Could you give a fuller expaination Quote Link to comment Share on other sites More sharing options...
ShogunWarrior Posted February 1, 2007 Share Posted February 1, 2007 Have a look at: http://www.ozerov.de/bigdump.php Quote Link to comment Share on other sites More sharing options...
ldoozer Posted February 4, 2007 Author Share Posted February 4, 2007 thanks all very much - just used the bigdump.php file as suggested by ShogunWarrior. Worked a treat Quote Link to comment Share on other sites More sharing options...
ShogunWarrior Posted February 4, 2007 Share Posted February 4, 2007 Great, it's work bookmarking. 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.