Dump Dumping from a remote database Restore or in one line mysql -u username -p db_name < /path/to/table_name.sql Dump and restore a single table from a compressed (.sql.gz) format Dump Restore
XAMPP is a helpful development tool. However, you may run into problems at some point, such as receiving the notification: “Apache shutdown unexpectedly”. This error might seem to come out of nowhere, so identifying the cause – let alone the solution – can be puzzling. See how Kinsta stacks up against the competition. Fortunately, there is a…
Disk Extend EXT2/3/4 and XFS root partition without LVM Looking for steps to grow your KVM VM/Container’s partition after extending root OS size or extending ext2/3/4 and XFS root partition without LVM at runtime. Steps to extend root partition without LVM are quite easy and can be followed without going into many technical details. This…
Find and replace text within a file using sed command The procedure to change the text in files under Linux/Unix using sed: Use Stream EDitor (sed) as follows: sed -i ‘s/old-text/new-text/g’ input.txt It tells sed to find all occurrences of ‘old-text‘ and replace with ‘new-text‘ in a file named input.txt The s is the substitute…
ConfigServer Security & Firewall (CSF) is an iptables-based firewall that provides high-level security to the Linux system. CSF includes a wide range of features, such as IP blocking, port blocking, and DoS protection. It also supports advanced security measures, such as rate limiting, connection tracking, and SSH login detection. In addition to its firewall features,…