What is this? This is a post for those who have to move a Word Press installation (Specifically) from one ubuntu server to another, including: 1) DNS records2) files3) mysql database4) Let’s Encrypt bonus item All of these cute little moving cogwheels in the system can muck you up royally and so instead of piece-mealing it together I thought I’d…
Tag: mysql
HOW TO RESTORE A MYSQL DATABASE TO UBUNTU SERVER
Why this post? As always I post something when I find that something simple isn’t so simple. Here is the case again. I had done lots of MSQL dumps (for backups) but realized I never had to actually manually recreate one. So then I started and as always, mysql is a bit scary and sometimes counter intuitive. So that’s why…
Doing a Direct-to-Local MYSQL Dump
One of the most valuable things I learned in my ‘my-server-has-run-out-of-memory’ crisis was that I can dump my database directly to my local machine without having to first save it to the server and then download it from there. It is surprising that it took me well over 5 years to find it but what a gem for every person…
HOW TO VIEW AND CHANGE PRESTASHOP MYSQL TABLES IN UBUNTU SERVER
Learn a bit of MySQL while we manually force Prestashop to point to a new domain…
HOW TO VIEW AND CHANGE PRESTASHOP MYSQL TABLES IN UBUNTU SERVER
When your prestashop keeps pointing to the old domain….
How to Install Older PHP and Server Software with Digital Ocean
Why? Someone asked me to set up some old proprietary server software stuff that would no longer work in a modern server environment. I figured it might be possible if we match the mysql and php versions and give it a shot. Here is my documented journey in case anyone else needs to / wants to do something similar. Set…
How to Backup your Akaunting Installation
If you are like me, you were attracted to Akaunting accounting software because they are one of the first nice looking and open source accounting softwares around that operate in a similar way to the ‘friendly’ GUI systems like Quickbooks online. I was so upset about not having control of the data and / or price plans that I decided…
How to Overcome a Prestashop 500 Error on Front End
The Background I upgraded my ubuntu server last week and after I did so, the Prestashop front end went down – but not the back end! Everything seemed fine because no one was checking the front end so after someone changed something in the back and refreshed the front they thought they had killed the site (and so did I!).…
How to Backup your Prestashop Shop and Database on Ubuntu Server
Frankly the prestashop documentation on this is pretty good. This whole process is much like backing up any other server with ubuntu where you need to back up two things: your site files your database If you followed my how to install prestashop on ubuntu server blog then this is a similar setup. If this isn’t your setup, consider a…
How to Recover Admin Access and Password from Digital Ocean WordPress Install
What happened: I thought I had saved my admin user and password safely in my password manager. Two weeks later after installing a WP instance, I realized I had not. Oops… Obviously the first thing I did was try the ‘reset password’ link on the /wp-login.php page. Oddly this failed. It would not send me an email, whether I used…