#Mamp edit php.ini password

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. Maybe you want also activate some extensions and this requires edit the php. The phpMyAdmin alias contains these parameters for this very purpose and of course will override the standard php.ini setting of these parameters. Date Defines the default timezone used by the date functions Will be changed by MAMP to system timezone date.timezone 'Europe/Rome' Those are the base modifications you have to do to have a good development environment. If you must use phpMyAdmin then you will need to amend the correct configurations to do that. Or you may end up editing the wrong php.ini file and compounding the problem. 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 Where is the php.ini file located /Applications/MAMP/bin/php/php5.2.17/conf/php.ini or /Applications/MAMP/bin/php/php5.3.6/conf/php.ini Select phpInfo on your start screen of MAMP to see which version is running on your machine before editing.

#Mamp edit php.ini password

If you have changed the root password enter the password and hit Enter It will challenge you for the root password first, so if you have not changed that MYSQL accounts password just hit enter 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. With a database backup file that big it would be easier to use the MYSQL Console to restore this database.