Jump to content

move a large file database f


dianikol85

Recommended Posts

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...

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...