homepage Welcome to WebmasterWorld Guest from 54.145.209.80
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
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 :(
TravelSite

10+ Year Member



 
Msg#: 4092020 posted 12:13 pm on Mar 5, 2010 (gmt 0)

Hi,

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 "3.2.0.1") 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?

Thanks

 

TravelSite

10+ Year Member



 
Msg#: 4092020 posted 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?

Frank_Rizzo

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 4092020 posted 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
unzip
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