Skip to main content
S
StearmanDriver
Known Participant
October 7, 2008
Question

Exporting MySQL DB w/ PHPAdmin...

  • October 7, 2008
  • 2 replies
  • 402 views
Hi,

Not really a CF question but I thought somene might know: I'm trying to migrate a fairly large DB to a new server, and can't figure out how to get the whole DB exported to a .sql file. The problematic table has around 158,000 records, and the most I can seem to get out of PHPMyadmin is around 150,000. I'm using bigdump to import them and that seems to work ok, the problem is I can't get a full export.

Anyone else had this problem? Any easy solution??

Thanks!
This topic has been closed for replies.

2 replies

N
Newsgroup_User
Inspiring
October 9, 2008
i have stopped sing phpmyadmin since i got my own vps and have sqlyog
installed on it, but before that i used it a lot...

phpmyadmin has a max file size limit of 2MB. it will not save your db
dump if the resulting file exceeds this limit. iirc, there was a tweak
for this, since i remember making db dumps of 20+MB with no problems and
importing them, too, but i can't recall now what it involved. plus, if
you are on a shared host, your host will probably NOT make the necessary
tweaks for you anyway...

so, to overcome this limit, do NOT save the dump as file. instead, make
phpmyadmin output the dump on screen, then copy the text on screen and
save it as .sql file.

if you can then use that file to import the db on your server - good.
but if not, you will instead have to paste the dump generated by
phpmyadmin as text into the appropriate window on import db page.

hth

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
S
StearmanDriverAuthor
Known Participant
October 7, 2008
Nevermind, today it worked. I think it was a problem with Bluehost, the old host.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices