Restore dump with cli - cuse $cfg['ExecTimeLimit'] = 0; not working in cyberpanel

[av_admin]

In CyberPanel version 2.3 Build 1 , I got problem in uploading big mysql file from PHPMYADMIN

With this tutorial I change the settings but still got problem

4 - Change Upload Limit for phpMyAdmin

To change phpMyAdmin upload limits to a higher value: Go to PHP → Edit PHP Configs → Advanced , and select php 7.3 [image] Search “post_max_size” , and change value from default 8M to size you wish , for example 100M [image] Search “upload_max_filesize” , and change value from default 2M to size you wish , for example 100M [image] Save changes [image] Restart LSCPD by following command: systemctl restart lscpd Now go to phpMyAdmin, upload size is raised with your setting. [i…

Then I search for that error and found many site that talking about adding the

$cfg['ExecTimeLimit'] = 0;

in your phpMyAdmin config.inc.php

phpMyAdmin config path in cyberpanel is : /usr/local/CyberCP/public/phpMyAdmin

after add the $cfg['ExecTimeLimit'] = 0; and restart the webserver by systemctl restart lscpd command, the cyberpanel wouldn’t load anymore, so I removed the code.

Is it possible to remove the limitation time for importing the database files? or tell us where should we put that code to work?

I used the CLI to import my database and this is how I was able to import that.

**1-**first of all I export my database form old host and then uploaded in cyberpanel from web.

The directory is like this: /home/mywebsite.io/backupdb.sql.gz

**2-**Then from SSH , I used this command:

mysql -u [user] -p [database_name] < [filename].sql

This is the tutorial of export and importing the dump file in phpMyAdmin.

How to Back Up and Restore a MySQL Database {Easy Tutorial}

Thanks all of you.