![]() ![]() Now open the ‘bin > mamp > English’ folder. Mine is located at ‘Username > Applications > MAMP’. So now the absolute URL to Adminer would be: Now, open the MAMP folder. I renamed the default adminer.php file to index.php so that whenever the directory is hit within a browser, it automatically loads. Since all my PHP files are served from the Sites directory, I decided on ‘Sites/utilities/adminer’. Here’s how I did it… For the purposes of this tutorial, we’ll assume you’re using the English version.įirst, decide on where you’ll install Adminer. There’s Windows and Linux versions of the software too. When MAMP launches it loads the start page automatically in your default browser. I wanted to create a link from MAMP to Adminer just like you get for PHPmyAdmin on the start page. On my Mac, I run the program MAMP (Mac, Apache, MySQL, PHP). Most of my database management I do locally when I’m developing a new website. The English and MySQL-only version that I’m running is just 158kb too! Pretty awesome, right? ![]() You’ll get a login screen and be off and running. Just put it in a directory that’s accessible to run PHP scripts and hit the URL in your browser. While I’m not entirely sure that it will become my day to day database management tool, from what I’ve seen so far, I really dig it. It’s built to replace PHPmyAdmin and focuses on speed, security and user interface. So, thanks to a tip from a friend, I discovered a script called Adminer. Posted on JanuAugCategories WordPress Tags database, development, mysql, php, process, wordpress 13 Comments on Script to make WordPress site migrations easier Using Adminer with MAMP on Mac OS X Depending on the plugins you use, you may get PHP error notices about files not being included.Set the “New URL” field to the absolute URL you’d like the database updated to.If your wp-config.php file is setup correctly, the script will determine the current “old” website URL.Point your web browser to the script (like ).Upload the wp-migrate.php file into the root directory of your WordPress installation.Ensure your wp-config.php file has the correct database connection settings.When you’re done with your migration, delete the script. ![]() SECURITY NOTICE – This script should not be left on a live web server as it offers direct access to your database. You should make a full backup of your database before using this script. WARNING! This script modifies the database as configured in your wp-config.php file. Instead of doing a manual, find-and-replace of a MySQL text file, this script connects to your WordPress database and does all of the heavy lifting for you. The purpose of this script is to quickly and easily allow the user to update all database references for a WordPress website. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |