CODEWITHSUNDEEP
phpphpmyadminwamp
SkRoR
SkRoR

Reputation: 1199

how to import database in phpmyadmin if size is Large

in php.ini i tried to change like this but no use

post_max_size=1280M upload_max_filesize=1280M max_execution_time = 300

please give me a solution , my database size is 568MB

Upvotes: 0

Views: 267

Answers (4)

Marc Delisle
Marc Delisle

Reputation: 9012

You can upload your file to the web server and use the UploadDir phpMyAdmin directive to make this file available.

See http://docs.phpmyadmin.net/en/latest/config.html?highlight=uploaddir#cfg_UploadDir

Upvotes: 0

Shehary
Shehary

Reputation: 9992

you can't import large database in phpmyadmin by just changing the php.ini

Use Bigdump to dump database

Upvotes: 1

Rick Bakker
Rick Bakker

Reputation: 76

Use Bigdump (http://www.ozerov.de/bigdump/). On shared hostings you mostly don't have access to an SSH shell, so using bigdump, you can also do this without ssh access.

Upvotes: 0

D G
D G

Reputation: 13

Use command line

mysql -u username -p password dbname < yourdatabase.sql

where yourdatabase.sql is your sql file.

Upvotes: 0

Related Questions