If you’re looking to find a particular column name on your MySQL server, you can use a query like the following: select...
Using rsync to keep a local copy or migrate data is very useful because it picks up where it left off if...
The following script can be used to create a mysqldump by schema name: #!/bin/bash TODAY=$(date +%m”-“%d”-“%Y) HOSTNAME=$(hostname -s) for db in $(echo...
1. Install MySQL (mysql-server) on the master and slave servers if it’s not already installed. You can do so using ‘yum install...
To find active queries in your Oracle database, you can use the following command: SELECT SID, Serial#, UserName, Status, SchemaName, Logon_Time FROM...
Having SQLPlus installed on your Mac is very handy! Follow the steps below to install it. 1. First you’ll need to go...
How do I set the default kernel for Oracle Enterprise Linux?
How do I determine which version of Amazon Linux I am running?
How do I remove old kernel packages on my CentOS/RHEL Linux server?
How do I show all grants for all users on my MySQL database?
How do I find duplicate values in my MySQL database table?
How do I delete unapproved WordPress comments from my MySQL database?
How do I reset my Symantec NetBackup OpsCenter password?
How do I update the firmware on my Quantum Scalar i80 tape library?
How do I disable the NetBackup VSP cache on my Windows server?
How do I kill a stuck service in Windows?
How do I copy members from one Active Directory security group to a new security group?
When did my Windows Service start?
Submit Article
How do I switch my default shell in Terminal on macOS Big Sur?
How do I get additional Google Photos storage if you are running out of free space with Google?
Affiliate Marketing Do’s And Don’ts
How do I create a Facebook Like button for my website?