![mamp edit php.ini mamp edit php.ini](https://noltenet.de/wp-content/uploads/mamppro-624x557.png)
Afterall you dont want to amend the php.ini for a restore you will only run maybe once, and affect the whole PHP environment permanantly. If a dialogue box pops up, read it and confirm with OK. The phpMyAdmin alias contains these parameters for this very purpose and of course will override the standard php.ini setting of these parameters. Choose Menu > File > Edit Template > PHP 5.x.x php.ini / PHP 5.x.x php.ini. The php.ini file created from the template file and is located in /Library/Application Support/appsolute/MAMP PRO. Changes made to your template file will be reflected your real php.ini file. There are likely several versions of php available, each of them with their own template file. If you must use phpMyAdmin then you will need to amend the correct configurations to do that. PHP (php.ini) Open and edit your php.ini template file here. Now at the mysql> command prompt enter source C:/path/to/your/backup.sqlĪnd mysql will run the restore for as long as it takes to complete the restore
#MAMP EDIT PHP.INI PASSWORD#
If you have changed the root password enter the password and hit Enter
![mamp edit php.ini mamp edit php.ini](https://upload-images.jianshu.io/upload_images/2838971-d6f72c5f83b7ab5c.png)
It will challenge you for the root password first, so if you have not changed that MYSQL accounts password just hit enter
![mamp edit php.ini mamp edit php.ini](https://photo.minwt.com/img/Content/php/mamp-php-show-error/mamp-php-show-error_04.jpg)
Using the wampmanager icon in the system tray you do this wampmanager -> MYSQL -> MYSQL ConsoleĬlick the MYSQL Console menu and it will run mysql.exe in a command windows. It does not have any of the size and runtime limitations that a php script does. But when you are developing, it means tha. With a database backup file that big it would be easier to use the MYSQL Console to restore this database. MAMP may come with the displayerrors variable set to 'Off' because that is the preferred setting for production.