Page 1 of 1

Upload Large Database

Posted: Sat Mar 15, 2014 12:29 pm
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.

Re: Upload Large Database

Posted: Sat Mar 15, 2014 12:38 pm
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.

Re: Upload Large Database

Posted: Sat Mar 15, 2014 12:40 pm
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.