Upload Large Database
Moderator: General Moderators
-
adriana252
- Forum Newbie
- Posts: 5
- Joined: Tue Mar 11, 2014 11:41 pm
Upload Large Database
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
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.
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: Upload Large Database
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)