Enable Imagemagick in PHP8 on Ubuntu 20.04 For WordPress. ImageMagick is a powerful open-source software suite that is used for creating, editing, and converting images. It is commonly used by WordPress developers and designers to enhance the visuals of their websites. If you’re running Ubuntu 20.04 and PHP8, and you want to enable ImageMagick in Read More
There are times when you need to find the largest files in your Linux Terminal. Here are a list of commands that you can use to find out what is bloating your website. Remember that every web page that you have should not load any more than 2 MB maximum. Use The List Command ls Read More
In this how to tutorial I will show you how to move a large WordPress website from one server to another. In this tutorial I assume that you already know how to SSH into your server. You must already know these following things, if you do not, click the link and learn them and then Read More
Maximize adsense revenue in your WordPress website. If you really want to increase your earning potential then we have the plugin for you! You are not going to find this plugin in the WordPress directory. This is a custom plugin programmed for people who monetize their WordPress sites with Google Adsense. Download The MAXIMIZE ADSENSE Read More
This article will help you install WordPress with Shell access ( ssh ) using the wget command in a Linux/Ubuntu terminal. Logging Into Shell If you do not know your shell or ssh login contact your hosting provider and they can provide you with that information. If you already have that information you can proceed. Read More
Most effective and easiest way of backing up your website is in terminal. The process that I am about to show you is very easy. It may look like it is past your capabilities but it is not. If you follow these easy step by step instructions you will have a full backup to download Read More
Use this command to release a single email message from on hold: [code]postsuper -H 070788B31[/code] Release all email messages from being on hold with this command: [code]postsuper -H ALL[/code] Use the following command to release on hold messages just from user@domain.com [code]postqueue -p | awk ‘BEGIN { RS = “” } { if Read More
Postfix is a popular open-source mail transfer agent that we use for routing and delivering email messages. It is a powerful tool that allows you to configure and manage email servers on Linux and Unix systems. However, working with Postfix requires familiarity with a number of command line tools and utilities. In this post, we Read More
For Custom Column Output Names Terminal MySQL, when selecting data from a table using the SELECT statement, you can customize the output column names. This can be useful when the column names in the table are not descriptive enough or when you want to format the output in a specific way. Custom Column Output Names Read More
To update a record you can use this command. UPDATE [table] SET [column] = ‘[updated-value]’ WHERE [column] = [value]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
To select with a customer order and limit the results use this command. SELECT * FROM [table] WHERE [column] ORDER BY [column] ASC LIMIT [value]; You can order by ascending. ASC Or you can order by descending. DESC Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
To select a range use this code. Take out the brackets and replace the values. SELECT * FROM [table] WHERE [column] BETWEEN [value1] and [value2]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
To find records that start and end with a certain value use this command. SELECT * FROM [table] WHERE [column] LIKE ‘[val_ue]’; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
To find something that starts with a certain string use this code. SELECT * FROM [table] WHERE [column] LIKE ‘[value]%’; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
To export a database use this command in terminal. mysqldump -u [username] -p [database] > db_backup.sql If that does not work for you then you may have created a user in cPanel or some other website management application. You may have to use the –no-tablespaces tag. The syntax looks like this mysqldump –no-tablespaces -h localhost Read More
A1WEBSITEPRO Social Media Pages
Here are my social media pages, lets hook up!