admin管理员组

文章数量:1315294

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.

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.

Share Improve this question edited Dec 12, 2020 at 9:54 fuxia 107k38 gold badges255 silver badges459 bronze badges asked Dec 12, 2020 at 9:44 49 ideas49 ideas 1
Add a comment  | 

1 Answer 1

Reset to default 0

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

https://developer.wordpress/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.

本文标签: phpmyadminImport large database in php my admin