terminal

How To Move A Large WordPress Website To A New Server

How To Move A Large WordPress Website To A New Server

Subscribe 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 Read More

MAXIMIZE ADSENSE REVENUE IN WORDPRESS

Subscribe 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 Read More

Install WordPress Shell Access Using wget Command Ubuntu Terminal

Install WordPress Shell Access Using wget Command Ubuntu Terminal

Subscribe 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 Read More

Postfix Release Emails From Hold With Terminal Command

RELEASE EMAILS FROM HOLD

Subscribe 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 [email protected] [code]postqueue -p | awk ‘BEGIN { RS = “” } { Read More

Custom Column Output Names Terminal MySql

Custom Column Output Names Terminal MySql

Subscribe Custom column output names in terminal. SELECT [column] AS [custom-column] FROM [table]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408

Update Records In MySql Terminal

Update Records In MySql Terminal

Subscribe 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

Select With Custom Order Limit Terminal MySql

Select With Custom Order Limit Terminal MySql

Subscribe 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

Select A Range MySql Terminal

Select A Range MySql Terminal

Subscribe 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

Select Records Starting & Ending With Value MySql Terminal

Select Records Starting & Ending With Value MySql Terminal

Subscribe 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

Export A database Dump Terminal MySql

Export A database Dump Terminal MySql

Subscribe 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 Read More

Import A Database Dump MySql Terminal

Import A database Dump Terminal MySql

Subscribe To import a database dump use this command. mysql -u [username] -p -h localhost [database] < db_backup.sql Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408

Delete Records MySql Terminal Command

Delete Records MySql Terminal Command

Subscribe To delete records in mysql use this terminal command. DELETE FROM [table] WHERE [column] = [value]; Delete all records without dropping the table. This will also reset the increment number value. DELETE FROM [table]; Delete all records in a table. truncate table [table]; Remove table columns. ALTER TABLE [table] DROP COLUMN [column]; Deleting tables. DROP Read More

Select Records Containing Terminal MySql

Select Records Containing Terminal MySql

Subscribe To find records containing something use this command. SELECT * FROM [table] WHERE [column] LIKE ‘%[value]%’; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408

Selecting Specific Records MySql Terminal Command

Selecting Specific Records MySql Terminal Command

Subscribe To select specific records in terminal use this code. SELECT * FROM [table] WHERE [column] = [value]; You can also use these selectors. Less Than < Greater Than > Not Equal To != And and Or or Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408

Counting and Selecting Group Records MySql Terminal Commands

Subscribe To count and select group records in terminal use this command. SELECT *, (SELECT COUNT([column]) FROM [table]) AS count FROM [table] GROUP BY [column]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408