Question How can i change the upload limit of MySql import?

[zilon93]

I have to import a very important wordpress database for me but the limit is 2Mb and mine weighs more than 25Mb in gz format. I have changed the limit of the php.ini but it does not change the one of the database, how can I do it?

 

[IgorG]

I have changed the limit of the php.ini

Do you mean /usr/local/psa/admin/conf/php.ini ?

 

[zilon93]

I changed it in tools & Configuration, PHP Configuration and inside of 7.4 php.ini

 

[Kaspar]

Have you tried the native Plesk database Dump Import feature?

 

[zilon93]

Yes, this is the error code

 

[IgorG]

You have to configure your MySQL: How to set the value of max_allowed_packet or wait_timeout for MySQL on Plesk server?

 

[zilon93]

You have to configure your MySQL: How to set the value of max_allowed_packet or wait_timeout for MySQL on Plesk server?

Didnt appear this option

 

[Kaspar]

Yes, this is the error code View attachment 19012

Unzip/decompress you .GZ file and import the .SQL file directly instead.

 

[zilon93]

Unzip/decompress you .GZ file and import the .SQL file directly instead.

Same

 

[Kaspar]

Have you tried the solution @Igor suggested?

You have to configure your MySQL: How to set the value of max_allowed_packet or wait_timeout for MySQL on Plesk server?

 

[Bitpalast]

Here's what you need:

BigDump: MySQL/MariaDB Dump Importer

www.ozerov.de