![]() ![]() Specifically, I will be showing you how to remove the STRICTTRANSTABLES SQL. Log into your cPanel and then open phpMyAdmin. Given the occasional wonkiness of MAMP and general lack of support, Id be hesitant to mess about with it internally to upgrade it. In this video I will show you how to configure the MySQL that comes with MAMP.Then when you reinstall, create a new database with the same name, and import the data. The defaults for user and password in MAMP to access MySQL databases in your computer (localhost) are both root. Go into phpmyadmin, select the database, click on 'Export', select the 'custom' radio button, and save to a file. Searching and replacing old URLs in your database tables is accomplished with this command.įollow these steps to change the URL of all your tables using the phpMyAdmin replace string in all tables: I would assume that you will lose the data. It is very easy to replace old URLs with new ones using this MySQL search and replace script: update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, 'find string', 'replace string') ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |