homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Apache Web Server
Forum Library, Charter, Moderators: Ocean10000 & incrediBILL & phranque

Apache Web Server Forum

How to export a large (3GB) MySQL Database?
Please help - the phpMyAdmin Export keeps stoping at 250mb :(

 12:13 pm on Mar 5, 2010 (gmt 0)


I'm having to re-install Windows Vista from scratch on a PC - and need to export a fairly large 3GB MySQL database (then later import it again). The database is on my local machine.

I'm using the phpMyAdmin (version "") and using its export facility.

It begins downloading (tried both firefix and ie) but when the sql export finishes the file always comes in at around 250mb - far below the actual size of the database.

I've tried to ajust settings in a file called "php.ini" (increasing the values for anything I can find!) - but it doesn't seem to be making a difference.

Can anyone help?




 1:28 pm on Mar 5, 2010 (gmt 0)

In case it helps any, I just realised that its not stopping when it gets to 250mb - but rather after the export has been running for 5 minutes.

Is there a way to increase the time allowed for it to complete?


 3:27 pm on Mar 5, 2010 (gmt 0)

It is much easier to

stop the mysql server
locate database directory
zip up all the files
copy to the new machine
start the mysql server on the new machine

Of course that will overwrite existing databases on the new box but it is a quick way when transfering from an old box to a new one.

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Apache Web Server
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved