0

I have Wordpress website. I am importing large database into "Php my admin" but showing an error.

You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit

Could you please tell me how to fix it? Thank You.

1 Answer 1

0

If you've got SSH access, you can import it via WP-CLI:

https://developer.wordpress.org/cli/commands/db/import/

wp db import file.sql

This can handle large imports fine.

Note: wp-cli must be installed on the server (check with wp --info) and target database must be empty (check with wp db check). You must manually upload the file.sql import file via sftp/plesk/cpanel first.

1
  • Could anyone tell me simple process because i have not deep knowledge but if someone guide me then it would be best. Thank You in advance.
    – 49 ideas
    Dec 12, 2020 at 10:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.