How to move large mySQL databases

Critic · 10-19-2007, 06:46 PM

Database importing and exporting is usually pretty easy using phpMyAdmin. But what is the database takes too long to import and phpMyAdmin times out? Also phpMyAdmin only takes files sizes up to 2mb.

I found a near little script called bigdump that takes care of importing large sql files for you.

This little script can be used to import your large mySQL dumps into a new db with ease. I'll run you through how to use it:

Here's how to do it:

-To begin with, you're going to have to export your old database to either a .sql file or .tar.gz. You can do this by using the export functions in phpMyAdmin.

-OK, so you have your database dump. Now go and download BigDump. Unzip the archive to a directory on your local computer.

-Now, login to your new server and create a directory in your html directory (usually public_html) called dump. Change the permissions to 777.

-Open up bigdump.php that your unzipped from the file you downloaded. At the top of the file, add your database login information (it's clearly marked in the file).

-Upload bigdump.php and your database dump into your dump/ directory.

-Go to your browser (hopefully it's Firefox, if not upgrade!) and load the bigdump.php script.

-Click start, and away you go! It should only take about 30 seconds to import a 20mb file. There you go, that's the easy way of uploading a large database to new server.

Enjoy!

Meti · 10-25-2007, 04:09 PM

Great walk-through,

I remember I had a phpBB based forum, and was in a middle of a server transfer, I believe I used BigDump to take care of my mySQL database. Reason was the DB was too big to manually be imported on phpMyAdmin (phpMyAdmin usually have a limit, I believe it was 10 MB or something, may vary from host to host)

Meti

directoryjunction.com · 10-26-2007, 11:35 AM

Thx for sharing.

Seems like a nice resource.

Actually I' got some of my own proprietary routines I use for merging, backing up and moving databases.

dotcompals · 10-26-2007, 12:23 PM

Thanks for sharing mate. This is exactly what I was looking for...

britishguy · 11-08-2007, 01:20 AM

Thats a great little application thanks for sharing

10-19-2007, 06:46 PM	#1 (permalink)
Critic Administrator Join Date: Aug 2007 Location: Australia Posts: 125	How to move large mySQL databases Database importing and exporting is usually pretty easy using phpMyAdmin. But what is the database takes too long to import and phpMyAdmin times out? Also phpMyAdmin only takes files sizes up to 2mb. I found a near little script called bigdump that takes care of importing large sql files for you. This little script can be used to import your large mySQL dumps into a new db with ease. I'll run you through how to use it: Here's how to do it: -To begin with, you're going to have to export your old database to either a .sql file or .tar.gz. You can do this by using the export functions in phpMyAdmin. -OK, so you have your database dump. Now go and download BigDump. Unzip the archive to a directory on your local computer. -Now, login to your new server and create a directory in your html directory (usually public_html) called dump. Change the permissions to 777. -Open up bigdump.php that your unzipped from the file you downloaded. At the top of the file, add your database login information (it's clearly marked in the file). -Upload bigdump.php and your database dump into your dump/ directory. -Go to your browser (hopefully it's Firefox, if not upgrade!) and load the bigdump.php script. -Click start, and away you go! It should only take about 30 seconds to import a 20mb file. There you go, that's the easy way of uploading a large database to new server. Enjoy! __________________ Professional Directory Submission Service

10-25-2007, 04:09 PM	#2 (permalink)
Meti CEO, Web Catalogue Join Date: Oct 2007 Location: Sweden Posts: 103	Great walk-through, I remember I had a phpBB based forum, and was in a middle of a server transfer, I believe I used BigDump to take care of my mySQL database. Reason was the DB was too big to manually be imported on phpMyAdmin (phpMyAdmin usually have a limit, I believe it was 10 MB or something, may vary from host to host) Meti __________________ Web Catalogue - Quality Web Directory

10-26-2007, 11:35 AM	#3 (permalink)
directoryjunction.com New Member Join Date: Oct 2007 Posts: 29	Thx for sharing. Seems like a nice resource. Actually I' got some of my own proprietary routines I use for merging, backing up and moving databases. __________________ Linkspub Business Web Directory \| Directory Junction Directory Forums \| Directory Lists \| Established Directories

10-26-2007, 12:23 PM	#4 (permalink)
dotcompals World-Click Web services Join Date: Oct 2007 Location: World-Click.com Posts: 57	Thanks for sharing mate. This is exactly what I was looking for... __________________ Unique Directory submission services Bid at PR 4 directory Bid at PR 3 directory

11-08-2007, 01:20 AM	#5 (permalink)
britishguy New Member Join Date: Nov 2007 Posts: 29	Thats a great little application thanks for sharing __________________ City Journalist Directory - Sell your photos to the press Forplex - Business Directory \|

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode