Upload Large Database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
adriana252
Forum Newbie
Posts: 5
Joined: Tue Mar 11, 2014 11:41 pm

Upload Large Database

Post by adriana252 »

I have 5GB database that need to upload in phpmyadmin.There is any solution that can less time to upload it?Please do help me by showing step in uploading the sql file. I have search through internet but could not understand.
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: Upload Large Database

Post by Celauran »

5GB? You'd do much better with importing that via the command line. I can't imagine there's any way to get that to work via PMA without breaking that down into a large set of much smaller files.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Upload Large Database

Post by Christopher »

Export the data using SELECT INTO OUTFILE, upload the delimited file and then import user LOAD DATA INFILE. That is the fastest way to import data into a table. You need to put the delimited file somewhere where MySQL can access it.
(#10850)
Post Reply