CODEWITHSUNDEEP
mysqlphpmyadminphp-ini
user3786027
user3786027

Reputation: 1

Uploading Big MySql Files in Phpmyadmin

Im trying to upload a 3.8gb sql dump into phpmyadmin, in wamp. I set the max_file sizes among other things to 5gb and even restarted the server multiple times. The php_info(); also gives me 5gb as the file size. I would like to break the file into smaller chunks so that I can upload it bit by bit,if the entire thing isnt possible, and have looked for such tools. Used one though http://www.rusiczki.net/2007/01/24/sql-dump-file-splitter/ but it gives me an error at 2gb. Could anyone suggest anything that i could do to get my dump into mysql?

Thanks a lot

Upvotes: 0

Views: 147

Answers (2)

Joan-Diego Rodriguez
Joan-Diego Rodriguez

Reputation: 2547

You should really skip phpmyadmin and do it through the command line. The correct command is:

    $ mysql -u username -p -h localhost DATA-BASE-NAME < data.sql

If you are still unsure about that one (although try it, you'll be surprised how easy it is) you can have a go at mysql workbench.

Upvotes: 0

kiranSchool
kiranSchool

Reputation: 65

Traverse to your mysql bin directory (e.g. below)

D:\wamp\bin\mysql\mysql15.1.36\bin>

Then you can import any large database from your dump file giving the following command (e.g. below)

mysql -u username -ppassword database_name < dump.sql

Upvotes: 2

Related Questions