The phpMyAdmin config can be found in \wamp\alias\nf Alias /phpmyadmin "D:/wamp/apps/phpmyadmin4.7. 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. The phpMyAdmin alias contains these parameters for this very purpose and of course will override the standard php.ini setting of these parameters. If you must use phpMyAdmin then you will need to amend the correct configurations to do that. Shorthand notation, as described in this FAQ, may also be used. When an int is used, the value is measured in bytes. If you are still unable to import your file, the. Contact hosting provider (medium) Reach over to the customer support of your hosting provider and ask them to increase these limits for you. Generally speaking, memorylimit should be larger than postmaxsize. There are 4 ways that you can choose to increase the maximum upload file size in WordPress. 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 To upload large files, this value must be larger than uploadmaxfilesize. 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. After several tries, I ended up solving the problem.With a database backup file that big it would be easier to use the MYSQL Console to restore this database. When doing a « build-all-reload » on symfony, I suddenly had the following error message : « Couldn’t locate driver named mysql ». Now you will be asked to enter by hand your db name and password, and this it, you can acces to PhpMyAdmin !!!!īy the way, I faced another problem and couldn’t find the solution on the net so it might be useful for some one facing the same issue. What worked for me on WAMP was modifying file: nf, lines: phpadminvalue maxexecutiontime 600 phpadminvalue maxinputtime 600 I did not have to change the library file. $cfg = 'cookie' // Authentication method (config, http or cookie based)? Then, you will still be unable to connect to phpMyAdmin, so you have another thing to do, its to change the authentification setting from ‘config’ to cookie.įor this, go to /MAMP/bin/PhpMyAdmin/ on line 84 and change the line to this : //./MAMP/bin/PhpMyAdmin/ Go to /MAMP/bin/MAMP/index.php and change line 15 to this : //./MAMP/bin/MAMP/index.php You just have two things to change.įirst, give MAMP the new password you set up for your database. This is easy to do, you just have to go to « preferences » (when you click on the MAMP icon) then « apache » and upload the root directory.īut then I changed the sql password… and I was unabled to access to PhpMyAdmin any more !! I had a message error of the following type : « sql error, cannot find sql server on localhost » or something like that… So after hours of searches on the net and in my brain, I finally solved this problem. I relocated my web projects in a different directory from the one used by mamp (the htdocs directory). I won’t come back with installation process and symfony compatibility, there are several good posts, the best one being this one (according to me !)īut even if this post, I was unable to set up properly virtual hosts, which is unconvenient but doesn’t prevent you from using MAMP. PHP CONFIG you have to edit the php max upload file size to be able do it with you PHP I think that by default its like 2 MB (not sure) change it for a big value if you need it. sql files called bigdump it will stagger the import process. Even if I am not 100% satisfied, I did not find any other solution and I must admit it is pretty simple to install. There is a great little tool written in php, to help you import large. I use MAMP to run all the things needed to develop web sites with symfony (php based framework).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |