How to Optimize WordPress Database & Troubleshooting

How to Optimize WordPress Database & Troubleshooting

List of Basic WordPress Tables

There are 11 tables found in brand new WordPress site-

(1) wp_posts, (2) wp_postmeta, (3) wp_options, (4) wp_users, (5) wp_usermeta, (6) wp_term_taxonomy, (7) wp_terms, (8) wp_term_relationships, (9) wp_links, (10) wp_comments, (11) wp_commentmeta

| Size |
+——————————————————–+——-+
| tble_actionscheduler_actions | 11 MB |
| tble_actionscheduler_claims | 0 MB |
| tble_actionscheduler_groups | 0 MB |
| tble_actionscheduler_logs | 8 MB |
| tble_bkash_transactions | 0 MB |
| tble_commentmeta | 0 MB |
| tble_comments | 3 MB |
| tble_gglcptch_allowlist | 0 MB |
| tble_links | 0 MB |
| tble_mailchimp_carts | 0 MB |
| tble_mailchimp_jobs | 0 MB |
| tble_op_user_templates | 0 MB |
| tble_options | 4 MB |
| tble_postmeta | 36 MB |
| tble_posts | 6 MB |
| tble_pprh_table | 0 MB |
| tble_revslider_css | 0 MB |
| tble_revslider_css_bkp | 0 MB |
| tble_revslider_layer_animations | 0 MB |
| tble_revslider_layer_animations_bkp | 0 MB |
| tble_revslider_navigations | 0 MB |
| tble_revslider_navigations_bkp | 0 MB |
| tble_revslider_sliders | 0 MB |
| tble_revslider_sliders_bkp | 0 MB |
| tble_revslider_slides | 4 MB |
| tble_revslider_slides_bkp | 0 MB |
| tble_revslider_static_slides | 0 MB |
| tble_revslider_static_slides_bkp | 0 MB |
| tble_smush_dir_images | 0 MB |
| tble_social_users | 0 MB |
| tble_sslcare_woo_alert | 3 MB |
| tble_term_relationships | 1 MB |
| tble_term_taxonomy | 0 MB |
| tble_termmeta | 0 MB |
| tble_terms | 0 MB |
| tble_tm_taskmeta | 0 MB |
| tble_tm_tasks | 0 MB |
| tble_usermeta | 6 MB |
| tble_users | 0 MB |
| tble_wc_admin_note_actions | 0 MB |
| tble_wc_admin_notes | 0 MB |
| tble_wc_category_lookup | 0 MB |
| tble_wc_customer_lookup | 0 MB |
| tble_wc_download_log | 0 MB |
| tble_wc_order_coupon_lookup | 0 MB |
| tble_wc_order_product_lookup | 1 MB |
| tble_wc_order_stats | 1 MB |
| tble_wc_order_tax_lookup | 0 MB |
| tble_wc_product_meta_lookup | 1 MB |
| tble_wc_reserved_stock | 0 MB |
| tble_wc_tax_rate_classes | 0 MB |
| tble_wc_webhooks | 0 MB |
| tble_wcpdf_invoice_number | 0 MB |
| tble_wdp_order_items | 0 MB |
| tble_wdp_orders | 0 MB |
| tble_wdp_rules | 0 MB |
| tble_wdr_order_discounts | 0 MB |
| tble_wdr_order_item_discounts | 0 MB |
| tble_wdr_rules | 0 MB |
| tble_wfblockediplog | 0 MB |
| tble_wfblocks7 | 0 MB |
| tble_wfconfig | 0 MB |
| tble_wfcrawlers | 0 MB |
| tble_wffilechanges | 0 MB |
| tble_wffilemods | 7 MB |
| tble_wfhits | 0 MB |
| tble_wfhoover | 0 MB |
| tble_wfissues | 0 MB |
| tble_wfknownfilelist | 3 MB |
| tble_wflivetraffichuman | 0 MB |
| tble_wflocs | 0 MB |
| tble_wflogins | 0 MB |
| tble_wfls_2fa_secrets | 0 MB |
| tble_wfls_settings | 0 MB |
| tble_wfnotifications | 0 MB |
| tble_wfpendingissues | 0 MB |
| tble_wfpklist_template_data | 0 MB |
| tble_wfreversecache | 0 MB |
| tble_wfsnipcache | 0 MB |
| tble_wfstatus | 0 MB |
| tble_wftrafficrates | 0 MB |
| tble_woo_wallet_transaction_meta | 0 MB |
| tble_woo_wallet_transactions | 0 MB |
| tble_woocommerce_api_keys | 0 MB |
| tble_woocommerce_attribute_taxonomies | 0 MB |
| tble_woocommerce_downloadable_product_permissions | 0 MB |
| tble_woocommerce_log | 0 MB |
| tble_woocommerce_order_itemmeta | 10 MB |
| tble_woocommerce_order_items | 1 MB |
| tble_woocommerce_payment_tokenmeta | 0 MB |
| tble_woocommerce_payment_tokens | 0 MB |
| tble_woocommerce_sessions | 1 MB |
| tble_woocommerce_shipping_zone_locations | 0 MB |
| tble_woocommerce_shipping_zone_methods | 0 MB |
| tble_woocommerce_shipping_zones | 0 MB |
| tble_woocommerce_tax_rate_locations | 0 MB |
| tble_woocommerce_tax_rates | 0 MB |
| tble_woodmart_wishlist_products | 0 MB |
| tble_woodmart_wishlists | 0 MB |
| tble_wpbkash | 0 MB |
| tble_wpbkash_refund | 0 MB |
| tble_wpfm_backup | 0 MB |
| tble_wpmm_subscribers | 0 MB |
| tble_ycd_subscribers | 0 MB |
| tble_yoast_indexable | 2 MB |
| tble_yoast_indexable_hierarchy | 0 MB |
| tble_yoast_migrations | 0 MB |
| tble_yoast_primary_term | 0 MB |
| tble_yoast_seo_links | 0 MB |
| tble_yoast_seo_meta | 0 MB |

Question: How to Optimize WordPress Database & Troubleshooting

Answer: (1) Your database is very bloated. The options table is at 25MB (I’d expect no more than 4MB) (2) The autoloaded dats is over 1MB (I’d expect about 600KB).

Question: How can I optimize a database of wordpress?

Answer: You can optimize under cPanel>>phpmyadmin>>select the database>>select all tables>>optmize.

2. Optimize WordPress Database with Plugins

Advanced Database Cleaner Plugin Features

Clean Database: WordPress database accumulates a lot of extra data such as spam comments, revisions, trashed comments, etc.

Optimizing database will reclaim unused space in tables, which will reduce storage space & improve efficiency when accessing tables. It does not run any code that break down site or delete posts, pages, comments, etc

Revision: WordPress record called “revision” of each saved draft or published item. It allows to see what changes were made in each post &  page over time. It consumes a lot of space. SQP query to clean all revisions is: DELETE FROM posts WHERE post_type = ‘revision’

Auto Draft: WordPress saves your post/page when you are editing it before publish called an auto-draft. The sql query used by the plugin to clean all auto-drafts is: DELETE FROM posts WHERE post_status = ‘auto-draft’

Pending Comments:  Pending comments are published by users & waiting for your. SQL to clean all pending comments is: DELETE FROM comments WHERE comment_approved = ‘0’

Spam Comments: It is a comment that marked as spam. SQL to clean all spam comments is:
DELETE FROM comments WHERE comment_approved = ‘spam’

Trash comment: A trash comment that you have deleted from your WordPress & have been moved to the trash. SQL  to clean all trash comments is: DELETE FROM comments WHERE comment_approved = ‘trash’

Trackbacks: Trackbacks allows you to notify other websites have linked to their article on your website. These trackbacks is used to send huge amounts of spam. That is why they should be cleaned if you do not use them. The sql query used by the plugin to clean trackbacks is:
DELETE FROM comments WHERE comment_type = ‘trackback’

Pingbacks: Pingbacks allow you to notify other websites owners that you have linked to their article on your website. Trackback is basically the same things as a pingback. These pingbacks can be used to send huge amounts of spam. SQL to clean pingbacks is: DELETE FROM comments WHERE comment_type = ‘pingback’

Orphan post meta: The post meta data includes the author of the post, when it was posted. Sometimes post meta data information becomes orphan & does not belong to any post called “orphan postmeta” & should be cleaned since they are not useful. SQL to clean all orphan postmeta is: DELETE pm FROM postmeta pm LEFT JOIN posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL

Orphan comment meta: Orphan comment meta concern comments & not posts. SQL to clean all orphan comment meta is:
DELETE FROM commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM comments)

Orphan user meta: The user meta data is the information provide to viewers about each user. This information usually includes additional data that is not stored in the users table. Sometimes user meta data information becomes orphaned are called “orphaned usermeta” . SQL to clean all orphan comment meta is: DELETE FROM usermeta WHERE user_id NOT IN (SELECT ID FROM users)

Orphan user meta: It includes additional data that is not stored in the terms table and sometimes meta data information becomes orphaned. SQL to clean all orphan comment meta is:
DELETE FROM termmeta WHERE term_id NOT IN (SELECT term_id FROM terms)

Orphan Relationships: Sometimes the wp_term_relationships table becomes bloated with many orphaned relationships. This happens particularly often if you’re using your site not as a blog but as some other type of content site where posts are deleted periodically. Over time, you could get thousand of term relationships for posts that no longer exist which consumes a lot of database space. SQL to clean all orphan relationships is: DELETE FROM term_relationships WHERE term_taxonomy_id=1 & object_id NOT IN (SELECT id FROM posts)

Expired Transients: A way of storing cached data in DB temporarily by giving it a name. Expired transients are expired & still exist in the database.

Advanced Database Cleaner Plugin Benifits

  • Remove old Revisions of posts & pages: WordPress stores a record called revision of each saved draft or published update. This system allows you to see what changes were made in each post and page over time
  • Remove old Auto drafts : WordPress automatically saves your post / page while you are editing it. This is called WordPress auto draft. If you don’t hit the publish/update button, then the post/page will be saved as auto-draft and any modification to your post/page will not be visible in your public site. Over time, you could have multiple auto-drafts that you will never publish and hence you can clean them.
  • Remove trash posts
  • Remove pending comments
  • Remove spam comments
  • Remove trash comments
  • Remove pingbacks
  • Remove trackbacks
  • Remove orphan post metadata
  • Remove orphan comment metadata
  • Remove orphan user metadata
  • Remove orphan term metadata
  • Remove orphan relationships
  • Remove expired transients
  • Display & view orphaned information before making a database clean-up so you can be sure about what you are going to clean-up
  • Schedule database clean up to run automatically
  • Display database tables information such as the number of rows, table size, etc.
  • Optimize database tables
  • Repair corrupted database tables or damaged ones
  • Schedule database optimization &/or reparation to run automatically & specify what tables should be optimized &/or repaired
  • Empty database tables rows
  • Clean & Remove database tables
  • Display options list
  • Display options information such as option name, option value, option size, option autoload
  • Clean & Remove options
  • Set options autoload
  • Clean & Remove scheduled tasks

Plugins Garbage Collector (Database Cleanup)

Some plugins create & use its own database tables. Those tables are left in your database after plugin deletion.

Database Management (Managed WordPress)

Question: What is the user name and password of phpmyadmin

Answer: You can get that information from the panel > WordPress > managed WordPress > manage > show credentials under “manage database”

Question: How to get login credential to upload files?

Answer: You can get that information from the panel > WordPress > managed WordPress > manage > show credentials under “manage database”

Question: My site is very slow and It is difficult to work so can u check?

Answer: Cache is not working currently, ttbx3_options | 26 MB | The optionts able earlier was at 26MB, which is very big. I cleaned it up so it is now 4MB. No, you would need to continually optimize / clean up. The possible plugins that may cache to go down -woodmart-core, woo-order-export-lite, wp-hide-security-enhancer, google-captcha. The possible plugins that may cache to go down.

Would it be okay to toggle these plugins for testing?

Database Management (Shared Hosting)

Question: Currently My Database size is large which is 800 Mb. As far I know my I am able to download upto 500 Mb data from server in my current hosting plan. Since it exceed upto 800 Mb, please help me to download it in File Manager. When download will complete I will download it from File Manager

Question: Today I have copy a database and folder of halal.hadisquran.com to make another sub domain named as boi.hadisquran.com.

At first I rename all url inside of autogar1_halaldp from halal.hadisquran.com to boi.hadisquran.com

After that I configured everything excluding htaccess file. Instead that My newly created subdomain boi.hadisquran.com is not working

Answer: Yes . Also, I’ll be very happy if I can help you with Safeguarding your account from Hackers, malwares etc. We actually have a service where our team of experts help customers all day safeguarding their accounts. The service is called Sitelock, where our specialists will recommend you the exact plan as per your requirements for the website security. So, Could you please let me know your Phone Number and Timezone so that I can ask our Experts to contact you?

Question: Who will be admin on Dedicated and VPS server?

Answer: The Dedicated server is self managed server, so once you purchase it you will be owner of it and you have all access to manage the server (b)

WordPress SQL

  • Change Username: UPDATE wp_users SET user_login = ‘mashiur’ WHERE user_login = ‘admiin’;
SubjectLink
SSH Commandhelp.dreamhost.com/hc/en-us/articles/4404267062164
List of Basic Tableblogvault.net/wordpress-database-schema/
Displays database name and size.developer.wordpress.org/cli/commands/db/size/
Clean Databaseonlinemediamasters.com/clean-wordpress-database/#remove-trash
Clean Database Plugininmotionhosting.com/support/edu/wordpress/plugins/wordpress-advanced-database-cleaner/
Clean Database Plugin (Dh)wordpress.org/plugins/advanced-database-cleaner/
Advance Database Cleaner.youtube.com/watch?v=95kfb3bgRAI
Clean Database (Unused Table)youtube.com/watch?v=2Xg1KOLQOpU
How to Open SQL Query in WPyoutube.com/watch?v=Yv0FDEfUsKw
WP SQL Commandsknownhost.com/wiki/resources/manage-wordpress-posts-using-sql
Database Optimizationsigmaplugin.com

YouTube Video Marketing Tips for Small Businesses

Video Marketing Tips for Small Businesses

Video Marketing Tips for Small Businesses

  • Put a keyword into your YouTube channel name
  • Fill out the About Us page
  • Use channel keyword tags under Advanced Settings
  • Include related tags and hashtags
  • Update your channel trailer
  • Rename your video file using a target keyword.
  • Insert your keyword naturally in the video title.
  • Optimize your video description and write more than 300 characters with keywords
  • Publish long videos
  • Speak Keywords in Your Videos
  • Tag your video with popular keywords that relate to your topic
  • Focus on first 15 seconds of video to maximize watch time
  • Create playlists that enhance watch time
  • Say your keywords in the video
  • Strengthen user interaction signals
  • Categorize your video.
  • Customize video thumbnails
  • Include compelling language in titles and the year in description
  • Use Video Cards and End Screens for added context and SEO value
  • Use an SRT file to add subtitles & closed captions.
  • Embrace live YouTube videos
  • Add hashtags to increase reach.
  • Leave a pinned comment on your own video
  • Encourage Engagement
  • Build Backlinks

Tutorials for Video Marketing Tips for Small Businesses

TopicsLink
Customize YouTube Channel by Sohagyoutube.com/watch?v=rkhgY6uQYWE

Email Marketing for WordPress with Jetpack CRM, Contact and Subscriber Form

Email Marketing for WordPress with Jetpack CRM, Contact and Subscriber Form

Contact Form (WordPress)

You can use the form block. Click the + sign, search for form and add the form block. You can read more about it here: wordpress.com/support/wordpress-editor/blocks/form-block/.

Subscribe Form (WordPress)

Just to confirm, the contact form is specifically our own form block? This is typically used to send you messages through your site, but you could possibly add the email addresses of people who contact you, to your subscribers list: en.support.wordpress.com/import-subscribers-to-a-newsletter/

Jetpack CRM Form (WordPress)

Jetpack CMS isn’t needed if you only need a contact form. Read more about JetPack CRM Configuration

Akismet & Spam Protection (WordPress)

We have spam protection through Akismet which is a built-in plugin on your website. Akismet is a dedicated plugin only to protect from Spam. So it not just protects from spam form submissions but also spam comments. Other plugins like contact7, wpform etc they do not have a built-in mechanism to protect from spam. They give you DNS records to add for spam protection and its not 100% fool proof.

Mailpoet Email Campaign

It somewhat depends what you need! Should these email campaigns be separate from blog posts? While our “new post” notification emails can possibly work as a newsletter, there’s a sibling product called Mailpoet which may be useful for you to check out: mailpoet.com. Mailpoet are a separate product from WordPress.com, but in the same family! It’s also a service which stores the email addresses of your subscribers locally on your site; so they’re not being moved to a separate server.

Features

HOSTING
Self Hosted
Stand Alone CRM
SIMPLE TO USE
Welcome Wizard
Welcome Page
Modularised Features
CUSTOMERS
Default Fields (Name, Address, etc)
Add Custom Fields
Customer Tags
Customer Search
Standalone CRM Customers
Add/Edit Statuses (Lead, Customer, etc)
Delete Default Fields
Attach Files
Segment Contacts
Sync with PayPal, Stripe, WorldPay & More
QUOTES (PROPOSALS)
Quotes for Customers
Quote Templates
Online Quote Acceptance
Quote to Invoice
INVOICES
Itemised Invoices
Download Invoice as PDF
Email Invoice as HTML
Partial Payment
Invoice Templates
Power Tools (Export)
Pay online with PayPal
Pay online with Stripe
Recurring Invoices
Additional Payment Gateways
CLIENT PORTAL
Allow clients to access their own area
Accept Quotes via Client Portal
Pay Invoices via Client Portal
Share files with clients
TRANSACTIONS
Assign Transaction to Invoices
Log Incoming Transactions
Transaction Tags
Log Outgoing Transactions
DATA TOOLS
Import CSV
Export CSV
TEAM CRM
Overall Admin
Custom Team Roles
Custom Roles for Customers
B2B SALES
Enable B2B Mode
Create Companies
Assign Contacts to Companies
Assign Transactions to Companies
LEAD GENERATION AND MANAGEMENT
Lead Generation Forms
Conversion rate tracking
Gravity Forms Integration
Contact Form 7 Integration
Lead Automations
REPORTING
Individual Customer Activity Log
Summary Dashboard
Sales Reports
Growth Reports
Average Revenue Per Customer
New Customers Per Period
EMAIL OPTIONS
Email a contact directly
Send Targeted Emails
Send Group Emails (Mail Campaigns)
Emails sent individually (not bulk ‘to’)
Setup Custom SMTP Delivery Routes
Customisable Email Templates
Enable/Disable System Emails
Automatic Open Tracking
API & DEVELOPER SUPPORT
Connect other services to the CRM
API Connector Plugin
GitHub/Code Examples
INTEGRATIONS
Zapier Integration (connect hundreds of apps)
PayPal Integration
Stripe Integration
WooCommerce Integration
MOBILE READY
Responsive
iPhone App
Android App
MULTI-LANGUAGE, TRANSLATIONS, & LOCALISED
Use the CRM in your own language

CRM Extensions

  • AKA Mode
  • API
  • Auto-log Events
  • B2B Mode
  • Click2Call
  • Client Files
  • Companies
  • Contact Image Mode
  • Contact Logs
  • Contacts
  • CSV Importer
  • Custom Fields
  • Dashboard
  • Developer Ready
  • DIY CRM
  • Dynamic Segments
  • Easy Pay
  • eCommerce Ready
  • Emails
  • Forms
  • Invoices
  • Mail Delivery
  • Mobile Ready
  • Multi Language, Your Currency
  • Multiple WooCommerce Stores
  • Quick Filters
  • Quotes
  • Rebrandr
  • Social Integrations
  • System Emails
  • Tags
  • Tasks
  • Tax Tables
  • Team
  • The easiest Client Portal for WordPress
  • Tools
  • Transactions
  • Welcome Tour
  • Welcome Wizard
  • WooCommerce
  • WordPress Override Mode
  • Zapier

How to Configure VPS Server ? How to Work with SSH Command

Log of Less Memory

04:23:33 35468 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
04:23:33 35468 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
04:23:33 35468 [ERROR] Plugin ‘InnoDB’ init function returned error.
04:23:33 35468 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
04:23:33 35468 [ERROR] Unknown/unsupported storage engine: InnoDB
04:23:33 35468 [ERROR] Aborting

View Memory Usage

root@server [~]# free -m
total used free shared buff/cache available
Mem: 1995 776 375 106 844 955
Swap: 0 0 0

How to input SSH Terminal

There are different types of tools which is used to access in SSH mode. Putty is most popular among them. To use it follow below steps

  1. First download Putty.
  2. Then install it.
  3. Then run it.
  4. Enter your Server IP in Host Name
  5. Set Port : 22
  6. Click Open
  7. Input user Name
  8. Input Password
  9. Now Ready to input SSH Command according to your requirement

Useful SSH Commands on Putty

  1. free : It shows free and occupied memory in your server in kb
  2. free -m : It shows free and occupied memory in your server
  3. free -h : It shows free and occupied memory in your server in Mb
  4. sar -r : To see previous memory log
  5. swapon -s : To see swap devices and sizes (where swapon is installed)
  6. top -c : Command to check the sever load and CPU usage
  7. mysqldump database_name > new_filename.sql : For backup
  8. backupdb aertgar1_hefgynp 162.221.233.112 : Blue host backup database
  9. exit : To close putty
  10. clear : To clear screen
  11. ls -l : details of the files, e.g. size, modified date and time, the owner, and the permissions
  12. ls -a : shows hidden files & directories.
  13. cd home/TestDirectory/AnotherDirectory : To switch directory
  14. cd ../.. : To access home directory
  15. mkdir myfolder : To create a folder
  16. touch myfile.txt. : To create a file.
  17. rm myfile.txt : Remove a file
  18. rm -r home/hostinger/myfolder : Remove all files
  19. history : for SSH history

free -m Command Explanation

Categorytotalusedfreesharedbuff/cacheavailable
Mem:1995776375106844955
-/+ buffers/cache
Swap:51193484771

total (Mem)= 1995 : It means you have 2Gb physical RAM. (excluding small bit reserve by kernel in startup)

used (Mem)= 776 : It means OS using 776Mb RAM

free (Mem)= 375 : It means not in use physical memory 375Mb RAM

shared (Mem)= 106 : It means shared by server kernel system/ specific purposes 106Mb RAM. It is include in used

buff/cache (Mem)= 844 : It means memory used by kernel buffers & memory used by the page cache and slabs 844Mb RAM. It is include in used

available (Mem)= 955: It means estimate of how much memory is available for starting new applications, without swapping

total = used + free = 776+375 = 1151Mb

The second line gives first line values adjusted. It gives the original value for used minus the sum buffers+cached and the original value for free plus the sum buffers+cached, hence its title. These new values are often more meaningful than those of first line.

The last line (Swap:) gives information about swap space usage (i.e. memory contents that have been temporarily moved to disk).

total (Swap): this is the total amount of disk space reserved for swap.
used (Swap): the amount of swap disk space that is currently being used.
free (Swap): the amount of swap disk space that is currently not being used

How to Backup Database & Host

Step1 : Connect to your server via SSH.
Step2 : In the command line enter the following code:
mysqldump -u dbusername -p databasename > nameofdbbackup.sql

mysqldump -p -u autogar1 autoga_hqrnp > nesfile.sql
Be sure to replace:
dbusername = with the database username for the database you want to export.
databasename = with the name of the database you want to export.
nameofdbbackup = enter a name for the exported database.
Step3: Hit the Enter key and it will ask you for your password. Type your password and hit the Enter key again, it will begin exporting, this may take some time to complete, depending how large your database is. Your SSH client will take you to a new line when this process completes.The database will now be available for download in your home directory

WordPress Managed Backup

Q: So how can I get backup in Managed WP at your server?

A. Billing and account > back up account > back me up

Q. So how can I download it in my pc

A. Just click on both files, will download automatically

WordPress > manage WordPress menu

where is my WordPress files

panel > domains > manage domains > webFTP

Restoring your database from your backup on the server

If you need to restore you database from the backup you have made using the instructions above, make sure yo are in the root of your website and enter the below command again making sure to change the strings to match your information. Again, you will be asked for the database user password, so make sure you have it ready.

mysql -u username -p tablename < backupfilename.sql.

Backup all files and directories

Obviously you will need to take a backup of for files as well as the databases from your site To make a backup of all of the files and directories, connect via SSH and cd to the root of your website. Once there you can run the below command, make sure to swap out the red string with your prefered backup name.

tar -vcf backup-name.tar .

TIP: When moving around into different directories via SSH, you can print out all of the files and directories in the current directory you are in so you can be sure you are in the right place. To do this simply type ls

Mail Server Configuration

Problem: I migrated hosting server 1 month ago. Everything works fine except email send and receive. My webmail is ok. Problem is in WordPress application. I have 200 WordPress users where users can not change their password themselves. I have install project management plugin. When I assign task and check on notification, expected users dont get notifications.

Solutions:

  • However, I could see that the email services of xyz.com is still pointing to old shared server
  • Please access the link for more information: https://dnschecker.org/#MX/xyz.com
  • I would humbly request you to set the MX record of the domain as “mail.xyz.com”
  • Login to the Cpanel of xyz.com. Search for the option, “Zone editor”
  • There you can update the MX record of the domain
  • Set priority as : 0
  • Destination: mail.xyz.com
  • Propagation time can vary depending on the geographical location. Normally, the domain DNS takes 0-8 hours and is known to take up to 48 hours maximum to completely propagate.

VPS Hosting Management

Questions: What is the meaning of VPS Hosting:

Answer: In a VPS hosting arrangement, a single server is partitioned as multiple servers, each of which can be independently rebooted

Question: What is the meaning by 1 IP address in VPS/Dedicated HOSTING?

Answer: 1 IP address is the main IP address of the account.

Question: What is the meaning by 2 IP address in VPS HOSTING?

Answer: In VPS Hosting having 2 IP address you can two different cPanel

Question: For example, I am running 10 website in your shared hosting. Now I am going to upgrade my service into VPS. Science VPS hosting which have 1 Chanel, then how can I run other 9 websites into one VPS account.

Answer: You can create separate subcPanel account for the domain in VPS/dedicated account, so that you can manage each domain cPanel account separately (b)

Question: What is the meaning by 2 Core in VPS HOSTING?

Answer: Cores of VPS are the number of Virtual Central Processing Cores you will receive , with the services you are purchasing. Each core operates in conjunction with other circuits such as cache, memory management, and input/output Operators. (s)

Question: Should we get Physical server under VPS Hosting?

Answer: Yes, you will get server for one user. (b)

Question: Should we get Physical server under Dedicate Hosting?

Answer: Yes, you will get. (b)

Question: If I purchase dedicated server from you, and if I change password to all admin user account, can you access there ?

Answer: Yes, we have access to the account to check if there is any issue with the account (b)

Question: What is the meaning of 1 TB Bandwidth? I mean how many Visitor = 1 TB Bandwidth?

Answer: It depends on website build, However 1 Tb is usually more than enough to handle more than 500,000 visitors per month. (b)

Answer:There is no option to convert them, because we are unable to provide the exact amount of bandwidth will be used by each vistiors. (s)

Question: Normally How many visitor can access at time with 2 Gb RAM?

Question: What is SiteLock Security? Please explain elaborately which services are included in SiteLock Security?

Answer: SiteLock Security is a Open source software, such as WordPress, Joomla, and Drupal, can be vulnerable to attacks by hackers. While keeping software up-to-date is a good defense, services that also monitor and protect your website is a more effective approach. SiteLock offers a range of products to ensure your website is always safe from malware and other malicious attacks. It provides daily scanning, automatic malware removal, web app firewall, etc.

Question: What is Codeguard Basic? How long backup will take by you.

Answer: Codeguard is a one-click website backup and restore solution that is integrated into your hosting account for ultimate efficiency and peace of mind. For basic plan Up to 5 websites, 1GB of storage. In codeguard basic the backup can be stored in daily, weekly and monthly basis. In codeguard you can search for the last six month if there is any. (b)

Question: Would we get cPanel/WHM feature in VPS hosting?

Question: Are you offering basic codegurard with VPS?

Answer: Yes that is the basic plan price for the codeguard. The next plans of the codeguard are Professional Up to 10 websites, 5GB of storage, Premium Up to 25 websites, 10GB of storage, Enterprise Up to 100 websites, 25GB of storage (b)

Question: Would we get free CDN feature in VPS hosting?

Answer: Yes you get free CDN feature in VPS hosting.

Question: If I purchase VPS hosting, with the configuration of 1 IP, 2 core, 2 GB RAM and 1 TB Bandwidth, So how many visitor can access at a time?

There is no limitation on the visitors on the website. However, you can increase the max user connection value on the server to higher numbers so there won’t be issue with users. You can have 5000 users

Question: If I purchase VPS hosting, with the configuration of 1 IP, 2 core, 2 GB RAM and 1 TB Bandwidth, So how many visitor can access per montth?

I do understand your concern. There is no average since everyone’s sites are so unique and it is difficult to estimate how many visitors your site can handle, Simply too many variables, there is just no way to know how your site will run until it is on the server, It depends on what you upload to your site each thing consumes resources, Plugins, Themes, Databases, Scripts etc.. It is more up to the developer to determine the resources they need based on the content.

Question: My question, If I upgrade into VPS, who will manager my server and issues ?

Answer: We provide fully managed VPS services and we do not provide support with unmanaged services. However, since you will have the root access to the VPS, it needs to be managed from your end . We do provide assist with the server upgrades only. We do provide support with the VPS server issues if nay (s)

Question: Would you help to install additions software like anti malware , security service etc in VPS?

Answer: No, We do not provide support with the additional software installation, however, you may install the same from your end. Since the root access will be having the root access, you will have the access to install the modules, we do not provide support with the software installation or related issues (s)

Question: If I install a sofware , as a result a problem is occured . In this situation would you solve this issue

Answer: We can try providing the settings required for the installed software from server end (b)

Question: If I upgrade into VPS can I get this basic software and feature by default?

Answer: Unfortunately, on the VPS server, the softaculous feature is not installed and you need to purchase the feature separately (s)

Question: Can you tell me some software names thats are installed in our current shared server?

Answer: Softaculous is a software installation application, that is used by the customer across our platform. Using the sofatculous feature the accounts such as WordPress Drupal, Joomla,. Moodle etc are installed. Also, I am sorry for the incorrect information, the Softaculous will be installed on the VPS service as well, free of cost (s)

Question: Any other software is installed in our current shared hosing server except sofatculous ?

Answer: Softaculous is the main software installer, as a backup software installed quick install is also provided on the shared servers (s)

Dedicated Hosting Management

Question: What is the difference between VPS and Dedicated Hosting.

Answer: Users of VPS hosting have allocated resources just like Dedicated hosting users, however the amount of available resources on VPS servers may still not be what a website needs. For example, VPS servers often start at 2GB of RAM, whereas Dedicated servers often start with at least 4GB of RAM available. In short, Dedicated hosting allows for the same full customization and control of a VPS server, but with even more horsepower. (b)

Question: If I purchase VPS hosting now, Can we upgrade into Dedicated server anytime?

Change Log

Limit failed login attempts
Make the root user inaccessible via SSH by editing the sshd_config file
Don’t use a default port, edit the port line in your sshd_configfile
Use Captcha
Limit logins to a specified IP address or range
Two factor authentication
Unique login URLs
Monitor server logs

===============

I have successfully updated “max_user_connections =20000” at /etc/my.cnf file.

Tutorial

Subject URL
Server Swaptecadmin.net/enable-swap-on-centos-and-rhel
cmdhostinger.com/tutorials/ssh/basic-ssh-commands
cmdnamecheap.com/support/knowledgebase/article.aspx/9719/48/how-to-check-memory-usage-on-a-vps/
cmda2hosting.com/kb/developer-corner/linux/determining-a-servers-memory-usage
memoryserverfault.com/questions/85470/meaning-of-the-buffers-cache-line-in-the-output-of-free
SSH Enable bluehost.com/help/article/ssh-access#enable
SSH Enableyoutube.com/watch?v=hPkLYIscMSU
SSH Access bluehost.com/help/article/ssh-access
SSH Backupbluehost.com/help/article/mysql-import-and-export
Filezilabluehost.com/help/article/ftp-setup-using-filezilla
Bluehost Capacitybluehost.com/help/article/hosting-traffic-limitations

The Wheels of Garment Industry

Garment Industry

Garment Industry – Among the basic elements of industrial production–man, machine and materials–managing human beings is the most complicated one. It is at the core of the matter. Unfortunately, in most of the cases, this core element does not get proper attention from the top rank in the hierarchy of a management. Like any other organisations, the activities of readymade garment factories can be divided into two key functions:

Line – those are directly involved with production, the key function of the industry and Staff – those who provide assistance to production. Read more about RMG in Bangladesh- A Study on Social Compliance

According to the wage grade (Bangladesh Gazettes in 2006, 2010, 2013 on Minimum Wage Board) employees of the readymade garments (RMG) industry are divided into two categories, a) workers – those are differentiated into seven grades (1-7) according to their skills and experiences and b) employees – who are not directly involved in production but they help in production, delivering their services, divided into four different grades (1-4). There are many other important functions which have been skipped in the wage grade.

Readymade garment is a labour-intensive industry. Proper labour management is very important for the industry as cost of wages and salaries is the single highest cost in the manufacturing process.

The aim of human resource department (HRD) in an organisation is to improve performance of the employees as well as the organisation. The main focuses of human resource department are the following:

l Selection of the right person in the right place at the right time. The HRD is to prepare job description and specification against each position and to identify the required number of employees in any particular job to avoid over staffing.

l Training and development – To provide the employees with knowledge and skills needed to do a particular task or job and to make them ready for future challenges, adapting attitude with changes.

l Organisational development – To increase effectiveness and efficiency of an organisation and well-being of its members through planned interventions applying behavioural science concepts.

l Career management – To help the individuals to make their career plans according to their skills, ability and potential.

In any discussion or in an article on the Bangladesh RMG industry without mentioning the Desh Garments Ltd (DGL), the very first factory designed for 100 per cent export, would be incomplete. The state of HRD during the last decades in our RMG industry and its status at the DGL back in 1979 can be reviewed to set a present-time benchmark for the HRD in the RMG industry. An organisation is known by its management and it performs as its members do. Organisational culture is the culture of its owners. The man behind the initiatives at the DGL then had a clear vision about the industry. Mr Noorul Quader (Khan), a valiant freedom fighter, who discarded his title ‘Khan’ in protest against the role of the Pakistani rulers during the liberation war of Bangladesh, started with a single garment factory which ultimately produced hundreds of future entrepreneurs in the industry. The standard that he engraved in the HRD in his factory back in 1979 can still be the cornerstone of the present RMG industry.

Through an advertisement in the national dailies, Mr. Quader then recruited a group of meritorious students from different disciplines from across the country.  Some of the engineers whom he had recruited had overseas degrees and a few of them had overseas job experiences. A handsome remuneration package was offered at that time to attract the future entrepreneurs in the industries. Mr Quader arranged training for all his recruited staff in South Korea for six months under joint collaboration with the Daewoo Corporation. An orientation course was conducted at the ‘Institute of Business Administration’ (IBA), the University of Dhaka, the most prestigious academic institute in the country. This single example is more than enough to justify his HR approach. The DGL produced a number of successful RMG business leaders. Unfortunately many of them did not take any lesson from Mr Quader’s HR approach.

There were many favourable conditions, both national and international, behind the ‘hockey-stick growth’ of the industry. In 1984, the number of export-oriented readymade garments factories was 384 and within a decade in 1994, that number shot up to 2,182.

The dramatic decline of jute’s share in Bangladesh’s export earnings had a huge impact on the livelihoods of poor jute growers in the country. Uncertainty of regular works for the day labourers in agriculture sector had pushed them to urban areas where many alternative sources of employments were available. At the same time, growth of the RMG sector had pulled workers from rural areas to urban centres with a strong possibility for employment there. The supply of surplus workers from villages helped in the rapid growth of the RMG factories. All these had happened when ‘human side’ of the workers was hardly in consideration.

A chronological diagram can be drawn to explain the past and present status of the HRDs in readymade garments industry in the country.

The period from the beginning until 2000,  was a heaven for the production manager and hell for the workers.

Though garment business is always positive in terms of profit, the perception of the society about the sector still remains negative on account of working environment, workers’ wage etc. Once the term ‘garment factory’ was perceived as a place where anything was possible in terms of mismanagement. Breaking all the norms, values and principles of labour rights, maximum utilisation of labour with minimum expenses/benefits was given top priority to ensure highest possible profit. Qualified and adequate number of staff used to be considered as a waste of money by the businesses. A tendency continued to run the business with minimum possible number of staffs offering them lower package, never considering their quality and hard work. It was accepted to the management if any staff engaged himself/herself in line function contributed directly to the production and helped earn some extra profits to the owner.

From the very initial stage of the industry until the compulsion of compliance, as a precondition of business, there was nothing about human resource development (HRD). To maintain the payroll, a job of time-keeper was created to record workers’ ‘in-and-out’ time and to keep record of over time (OT) work. This core activity, associated with payment, was being controlled by the production manager (PM) concerned, the then most powerful and unchallenged authority. In most of the cases, the PM and the FM (Factory Manager) was the same. Keeping behavioural approach, human psychology, legal rational demand etc aside, most of the owners were dependent on so-called managers. When dependency and authority go to the persons of less capability and capacity, abuse of power and position could appear as a regular phenomenon. Unfortunately, those incidents in our readymade garment industry gave a negative message on work environment of the industry. No restriction on workers’ age, no control of working hours, disregarding of norms and values on working condition etc took the upper hand in the industry till the year 2000. Sexual harassment, deduction of workers’ hard-earned over-time (OT) hours, marking them absent even for a five-minute late arrival as a punishment and using them as personal workers were the managers’ common weapons to control the factory administration. In many cases, workers were asked to pay a percentage of their earnings from extra overtime (EOT) duty to their bosses. Both management and workers thought that the EOT was the privilege for the workers to earn more, so those workers who maintained a good relation with their bosses only were allowed in the extra earning net. For the workers it was difficult, even three decades back, to meet very basic needs without OT work. From the selection process to duty assignment to wages determination, all the activities related to personnel management were the functions of the production manager. In the first decade of the industry, in most of the cases, the production manager himself or his trusted one was assigned to keep the record of workers’ daily attendance and working hours. So, the production manager, apart from production duties, used to control the personnel issues as well.

Mohammad Hasan
email-mohammadhasanbg@gmail.com