Converting the blog from WordPress to Hugo

Yesterday, I shutdown the VPS that has been hosting all my websites for the last ~10 years. I’ve moved everything to static content, including this website. 📝 WordPress Since the very beginning (~2008) this blog has been powered by WordPress, it served me well, it worked, had a nice backend to make the posts, plugins and themes. After a couple years I moved from shared hosting to a VPS, I had other websites and services I needed running and all in same machine was better and cheaper. But WordPress needs a lot of things, PHP, MySQL, maintenance in all those moving parts. ...

January 27, 2024 · 6 min · 1253 words · David Amador

Search and Replace in MySQL

I found something very handy today, search and replace on Mysql databases. You can do it on phpmyadmin or make a php script with this. After moving a wordpress site from server I discovered that all image links were broken because they are placed directly inside each post. They were still linking to the old server. Changing it manually would be a nightmare. Luckily MySql is your friend. To search and replace a text string, start up phpMyAdmin, and click on your database name that you want to run the search and replace through. At the top of the window, click on the “SQL” tab. ...

October 22, 2009 · 1 min · 123 words · David Amador

WordPress Gallery

During my efforts to combine Rita’s website to wordpress and with a cool gallery I came up with a few problems. Mainly because the top navigation bar was built using J-Query, which I’ve already made quite some time ago, and even after switching to mootools I didn’t want to be rebuilding it again. So yesterday after a few searches I managed to install NextGen gallery plugin for wordpress and using LightBox for popups. It even has a watermark option. I recommend anyone having a gallery on their website to give it a try. It’s really cool and free for use. ...

April 22, 2009 · 1 min · 100 words · David Amador