Sorry for my english I will try to translate as best as possible. This is my first time in this forum, sorry if the topic was already writen.
I am trying to import a MySQL DB in my phpmyadmin using MAMP. The DB is big (almost 600MB and 350 tables...!)
I have an error message saying the time limit for the script is reached. After is an uncomprenhensible code that a will paste further.
The first 75 tables are imported (in alphabetical order) but not the rest... (stops at c letter)
I have searched on the web for a solution and I found a lot of interesting parameters but nothing works for me.
I have modified file php.ini in mamp > bin > php > php7.4.33 > php.ini
- post_max_size = 2000M
- upload_max_filesize = 1000M
- memory_limit = 2000M
- max_execution_time = 3000
- max_input_time = 2000
- max_file_uploads = 2000
I have modified file config.default.php in mamp > bin > phpmyadmin (and also phpmyadmin5) > libraries > config.default.php
- $cfg['ExecTimeLimit'] = 0;
Have tried in zipping the DB and re-import... Have export again from the web hosting and re-import... Nothing works...
The error message was followed by this uncomprehensible code :
-- -------------------------------------------------------- -- -- Table structure for table pss_avalara_product_cache-- CREATE TABLEpss_avalara_product_cache(id_cacheint(10) UNSIGNED NOT NULL,id_productint(10) UNSIGNED NOT NULL,tax_ratefloat(8,2) UNSIGNED NOT NULL,regionvarchar(2) NOT NULL,id_addressint(10) UNSIGNED NOT NULL,update_datedatetime DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -------------------------------------------------------- -- -- Table structure for tablepss_avalara_returned_products-- CREATE TABLEpss_avalara_returned_products(id_returned_productint(10) UNSIGNED NOT NULL,id_orderint(10) UNSIGNED NOT NULL,id_productint(10) UNSIGNED NOT NULL,totalfloat(8,2) UNSIGNED NOT NULL,quantityint(10) UNSIGNED NOT NULL,namevarchar(255) NOT NULL,description_shortvarchar(255) DEFAULT NULL,tax_codevarchar(255) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
I tried to export the DB from web hosting without those two tables... but a get a new table with the same problem... I think this is not a good solution.
I hope someone can help me. Thank you