Similar Posts
General | Plesk | WHM / cpanel
How can I RESTORE a MySQL database from the command line?
BySam
Importing a MySQLDUMP From your SSH command prompt type … mysqladmin -u {username} -p {password} create {databasename} mysql -u {username} -p {password} < {databasename.sql} Replace the parameters with the appropriate values {username} – this is your database username {password} – this is the password for your database {databasename} – the name of your database {databasename.sql}…
Listing Sizes in AWS S3 Buckets
BySam
Listing sizes in AWS S3 Buckets Getting the whole bucket size aws s3 ls s3://$BUCKETNAME/ –recursive –human-readable –summarize | tail -n2 Tail is used because otherwise all files will be printed on screen (but you may want that for some reason). Getting the size of a specific directory/file You just need to add the path…
sar output for Yesterday statistics
BySam
To check the load: sar -q -f /var/log/sa/sa$(date +%d -d yesterday) To check the CPU status: sar -p -f /var/log/sa/sa$(date +%d -d yesterday) To check the Swap Space usage: sar -S -f /var/log/sa/sa$(date +%d -d yesterday) To check the RAM memory usage: sar -r -f /var/log/sa/sa$(date +%d -d yesterday)
OpenCart Admin Login Loop
BySam
Method-1: First Check the Timezone in Settings > Store. Make sure you set to UTC. If you need to change it back you can in the SQL table “oc_setting” column “key” value “config_timezone” in the “value” column change it back to “UTC” UPDATE oc_setting SET value=’UTC’ WHERE key = ‘config_timezone’; If still issue, follow below method. Method-2: You…
Using Multiple SSL Certificates in Apache with One IP Address
BySam
About the TLS Extension Server Name Indication (SNI) When website administrators and IT personnel are restricted to use a single SSL Certificate per socket (combination of IP Address and socket) it can cost a lot of money. This restriction causes them to buy multiple IP addresses for regular https websites from their domain host or…
WP Contact Form 7 Split/Separate fields
BySam
Step-1: Add 2 hidden fields to the contact form [hidden your-first-name id:first-name-p] [hidden your-last-name id:last-name-p] Step-2: Write below jquery script in the footer $(“#name_field_id”).focusout(function(){ str = $(this).val(); if(str){ s = str.split(/(?<=^\S+)\s/); //split string in name field after first space found. $(“#last-name-p”).val(s[1]); //s[1] value after the first space set to hidden field. } }); Output will…