Setup VPN in Debian

In this case, using xfce and assuming Network manager is installed and configured, you need to then install the following;

sudo apt-get install network-manager-openconnect

You may need to install additional network-manager plug-ins and you can search those by;

sudo apt search 'network-manager-*'

then installing as;

sudo apt-get install network-manager-plugin-name

To change Netbeans C++ binary output location

RIGHT-CLICK PROJECT

PROJECT PROPERTIES > LINKER > GENERAL > OUTPUT

To enable MySQL logging during runtime.

 To enable MySQL logging...

Forgot MySQL root password

To recover a forgotten root password for MySQL

Connect to remote mySQL server from the command line.

mysql -u username -h xxx.xxx.xxx.xxx -p

where username is the username of the remote mySQL server.

The following can also be used to test connection;

nc -z -w1 xxx.xxx.xxx.xxx 3306

MySQL Master Slave replication setup

MySQL replication setup

mySQL info

A quick way to get some mysql information is to run

mysql --help --verbose

How to setup a ramdisk in Linux

Change temporary tables in mySQL to memory

To change the location of temporary tables in mySQL, we need to edit the tmpdir variable in my.cnf or which ever file contains the [mysqld] section.

Show sleeping process in Linux

ps -e S

and of course 

ps -e S | grep -i "processname"

Check for FULLTEXT INDEX in mySQL database

When converting from MyISAM to InnoDB;

It is important if running an older version of MySQL to first check for FULLTEXT INDEX as full-text indexing is not supported by InnoDB in older databases.

To run a check, execute the following query;

SELECT TABLE_SCHEMA, TABLE_NAME
FROM information_schema.statistics
WHERE index_type LIKE 'FULLTEXT%' 

Additionally, to convert multiple tables at once, do;

SELECT CONCAT('ALTER TABLE ',TABLE_NAME,' ENGINE=InnoDB;') 

FROM INFORMATION_SCHEMA.TABLES

WHERE ENGINE = 'MyISAM' AND table_schema = 'mydb';

You may need to use the options to show Full text in the results to avoid lines being truncated, also watch out from some dodgy table names, like group.

To update default browser in Debian Linux

To update the default web browser in Debian, do;

sudo update-alternatives --config x-www-browser

I noticed this had changed after I installed Chrome...

Exchange Web Services in evolution Mail

The below is a screen shot of how I managed to connect to Exchange Web Services in the Evolution Mail client.

MySQL copy table

MySQL copy table with and without data;

CREATE TABLE IF NOT EXISTS table_copy

SELECT * FROM table;