dianikol85 Posted January 20, 2011 Report Share Posted January 20, 2011 (edited) As the title of the topic says i want to move a 40mb database form one server to another?? phpmyadmin cannot handles it Thanks Edited January 20, 2011 by dianikol85 Quote Link to comment Share on other sites More sharing options...
falkencreative Posted January 20, 2011 Report Share Posted January 20, 2011 I believe that PHP allows you to choose to export specific tables rather than the full database - that's how I would handle it. Instead of creating one giant export file, create a couple smaller files for individual table(s). That assumes, of course, that you don't have one giant table that holds all 40 MB of data... Quote Link to comment Share on other sites More sharing options...
dianikol85 Posted January 20, 2011 Author Report Share Posted January 20, 2011 I believe that PHP allows you to choose to export specific tables rather than the full database - that's how I would handle it. Instead of creating one giant export file, create a couple smaller files for individual table(s). That assumes, of course, that you don't have one giant table that holds all 40 MB of data... Unfortunately one of the tables is 35mb which is about 3000 records. Quote Link to comment Share on other sites More sharing options...
newseed Posted January 20, 2011 Report Share Posted January 20, 2011 Some hosting will allow you to set your own file size limit. If not, you are probably going to have to export that 35mb table and manually divide them up to be small enough to import them one at a time but I am unsure if you can do this with phpmyadmin muchless split them at all. If this is the case then you might contact your hosting provider to see if they will increase you upload limit or maybe they can upload it for you. Partioning your tables might help using either horizontal or vertical. Otherwise, I have heard people having great success with Navicat.com instead on phpmyadmin but I do not know if it will resolve your issue. Quote Link to comment Share on other sites More sharing options...
dianikol85 Posted January 20, 2011 Author Report Share Posted January 20, 2011 Thanks for the response Eddie Quote Link to comment Share on other sites More sharing options...
dianikol85 Posted January 21, 2011 Author Report Share Posted January 21, 2011 Navicat did the job. Actually is a great app. I'm gonna use it from now on.. 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.
Note: Your post will require moderator approval before it will be visible.