Welcome to WebmasterWorld Guest from 54.145.208.64

Forum Moderators: Ocean10000 & incrediBILL & phranque

Message Too Old, No Replies

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)

10+ Year Member



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
1:28 pm on Mar 5, 2010 (gmt 0)

10+ Year Member



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)

WebmasterWorld Senior Member 10+ Year Member



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.