If you use the Amazon Product In A Post Plugin on WordPress you might have either not upgraded yet or decided to not upgrade because the shortcode syntax has changed. You can get around not upgrading by updating the WordPress post content immediately after you upgrade the Amazon Product In A Post Plugin. Below I describe the version that I upgraded and the MySQL syntax used to update the shortcode syntax to display Amazon products in WP posts.
Last night I was working on a project for a customer where the application was going to reference external images after the changes I made. One of the custom parts of the project included modifying the thousands of rows that currently existed in the MySQL database. I needed away to modify one of the columns in a MySQL database table by adding data to the front of that column in each row.
I recently moved a WordPress site from one location on a server to another location on the same server for a client. Everything seemed to work fine after following the directions in this article I had previously published. That article was specifically published for changing the domain that points to the WordPress site which could include simply changing the domain only or actually moving the site to a new server or new location on the same server and a new domain. If you are performing the second of those two options you may also need to update the “upload_path” depending on the configuration of the new server and if the paths are the same as they were on the initial server the WordPress site was installed on.
Earlier I set up a development WordPress site that mirrored a live WordPress installation. To do this I dumped the entire WordPress database using mysqldump and then imported it into a new database with mysql. Among other things that needed to be changed I needed to update any links that referenced the live site’s URL with the development site’s URL. Below I provide the command to make such an update to only a matching portion of a column in row located in a MySQL database.
Google Docs is a great tool for storing spreadsheets and other documents because it provides an centralized storage space for all of your documents which can be shared with users and accessed from any where that has an Internet connection. One thing that can be really helpful when creating a Google Spreadsheet is having a unified format to the entire document. A format that can assist in making the data in the spreadsheet easier to read is alternating colors for every row. This way if you have lots of columns per row you can easily see which data belongs to each row. The directions below explain how to set up formatting for two rows and then apply that formatting to the rest of the Google spreadsheet.