Updates from September, 2012 Toggle Comment Threads | Keyboard Shortcuts

  • Peter Mahoney 10:17 am on September 19, 2012
    Tags: database, , , sql   

    Easily search and replace throughout a (smallish) MySQL database 

    Every now and then I need to search through an entire MySQL database, to change a word, term, URL, or some other string.

    Rather than searching through the entire database to make the change, I just use phpMyAdmin to export the whole thing as an .sql file, which is of course just plain text.

    Open it in a text editor, find and replace in there, then re-upload to phpMyAdmin.

    In short, I get it done easily in a bout 45 seconds without having to worry about a typo in an SQL query destroying my data.

    Permalink | Reply
  • Peter Mahoney 7:22 pm on September 17, 2012
    Tags: donate, , paypal   

    Donate monthly via Paypal, and HTML 

    BINGO! This is just what I needed tonight. I was starting to create a PHP solution that would enable me to set up monthly donations (rather than a subscription) to Paypal.

    But then I thought, “Paypal must have a more elegant solution for this, and if not more elegant, than certainly simpler”.

    And while they didn’t, a quick Google search revealed someone else had. In HTML.

    Monthly Donations Button | PayPal.

    Permalink | Reply
compose new post
next post/next comment
previous post/previous comment
show/hide comments
go to top
go to login
show/hide help
shift + esc