Hi everyone
My sql file is 1.5 G and have problem in importing DB. I have tried many way but I confused what is solution.
I have changed related lines in php.ini :
max_execution_time = 300000
max_input_time = 50000
max_input_vars = 50000
memory_limit = 1500M
post_max_size = 1500M
and changed phpmyadmin line code:
\phpmyadmin\libraries\config.default.php
$cfg['ExecTimeLimit'] = 300;
to $cfg['ExecTimeLimit'] = 0;
Script timeout passed, if you want to finish import, please resubmit the same file and import will resume
-- Table structure for table `mdl_backup_controllers`
--
CREATE TABLE `mdl_backup_controllers` (
`id` bigint(10) NOT NULL,
`backupid` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`operation` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'backup',
`type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`itemid` bigint(10) NOT NULL,
`format` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`interactive` smallint(4) NOT NULL,
`purpose` smallint(4) NOT NULL,
`userid` bigint(10) NOT NULL,
`status` smallint(4) NOT NULL,
`execution` smallint(4) NOT NULL,
`executiontime` bigint(10) NOT NULL,
`checksum` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`timecreated` bigint(10) NOT NULL,
`timemodified` bigint(10) NOT NULL,
`controller` longtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='To store the backup_controllers as they are used'--
-- Dumping data for table `mdl_backup_controllers`
--
INSERT INTO `mdl_backup_controllers` (`id`, `backupid`, `operation`, `type`, `itemid`, `format`, `interactive`, `purpose`, `userid`, `status`, `execution`, `executiontime`, `checksum`, `timecreated`, `timemodified`, `controller`) VALUES
(1, 'b7e8510b65f2f3023f653fb4fc1de61e', 'backup', 'course', 862, 'moodle2', 0, 10, 6, 1000, 1, 0, '70c78a4ecb57a1a1da62a462226dec0e', 1593496248, 1593496251, '')
would you help me how can I fix that?
Thanks in advance
Solmaz