Amixa Technical Blog
Recently I was attempting to import a large (136mb) SQL backup for a new client. I first created a database and db user in PHPMYADMIN (most current version). Then using my Windows workstation, I launched MySQL Workbench 6.1 (my favorite tool for importing/exporting) and tried to do a Server–>Data Import. Pointed it to the 136mb…
I recently came across this situation on a client site where they wanted to change their domain from something like www.whatever.com to www.whatever-new-site.com and their site runs on WordPress 3.91. This is also applicable if you develop a site on a testing url like “testing.whateverdomain.com” and you want to change the site to run off…
I recently crossed my fingers and went through the upgrade process to upgrade MySQL from 5.6.14 to 5.6.17 on my Windows server. (also works for 5.5.x to current) NOTE – UPDATED 5/27/2016: If you are using the MYSQL Installer – Community (if that is in your Start -> program list, please use that to…
Here is the easiest process that I know of for migrating (and upgrading) from one version of MYSQL running on Windows server, to a new Windows server. Setup the new Windows server, give it a fixed IP address (we’ll change that later to be at the same IP as the old server). Run all Windows…