Dev {Tricks}

You are here: Home / Archives for How to

by Leave a Comment

BigDump Usage | How to upload large database

Upload large sized database using BigDump.

  1. Download and unzip bigdump.zip on your computer.
  2. Open bigdump.php in a text editor.
  3. Update database configuration 
    // Database configuration

$db_server   = 'localhost';
$db_name     = '';
$db_username = '';
$db_password = '';
  4. Optional settings (For example, $filename) 
    // OPTIONAL SETTINGS 

$filename           = '';     // Specify the dump filename to suppress the file selection dialog
$ajax               = true;   // AJAX mode: import will be done without refreshing the website
$linespersession    = 3000;   // Lines to be executed per one import session
$delaypersession    = 0;      // You can specify a sleep time in milliseconds after each session
                              // Works only if JavaScript is activated. Use to reduce server overrun
  5. Create the working directory (e.g. tempFile) on your web server
  6. Upload bigdump.php and the database file (*.sql or *.gz) via FTP to the working directory.
  7. Run the bigdump.php from your web browser via URL like http://www.yourdomain.com/tempFile/bigdump.php.
  8. Now you can select the file to be imported from the listing of your working directory. Click “Start import” to start.
  9. BigDump will start every next import session automatically if JavaScript is enabled in your browser.
  10. Relax and wait for the script to finish. Do NOT close the browser window!
  11. IMPORTANT: Delete the working directory (e.g. tempFile) to remove bigdump.php and your dump files from your web server.

by Leave a Comment

Remove URLs from google search results using WebMaster tools

Sometimes it requires to hide or remove some pages or posts from google search results. Follow the below easy steps to do it successfully.

  1. Go to the link
    https://www.google.com/webmasters/tools/url-removal
  2. Choose a verified property or add your property (domain) if not added.
  3. Search your property in Google. For  example, site:bdtopten.com
  4. Copy the site link you want to remove from google search results
  5. Go to webmaster tools. For example, https://www.google.com/webmasters/tools/url-removal?siteUrl=https://bdtopten.com
  6. Click on the button “Temporarily hide” button and paste the copied URL of your site that you’d like to hide or remove (case-sensitive) for 90 days.
  7. To delete the url permanently from search engine, you may delete the page or post or you have to do followings
    1. Change title
    2. Change slug
    3. Make the page or post “noindex”, “nofollow

It may take few hours to execute the removal by google.

by Leave a Comment

How to install and setup DirectAdmin on CentOS 8 VPS.

DirectAdmin is one of the best alternatives of cPanel control panel due to its user friendly interface.

This article will show you how to install DirectAdmin on CentOS VPS. Please check DirectAdmin installation requirements first.

Easy steps of DirectAdmin (DA) installation for success are as follows:
Make sure your domain is running with the IP address (nameservers) before installation.

Step One

Login to your VPS root using SSH or KVM.

Step Two

Disable SELinux. This will disable the firewall.

setenforce 0
sed -i ‘s/enforcing/disabled/g’ /etc/selinux/config

Step Three

Run the pre-install commands before starting the install

yum install wget gcc gcc-c++ flex bison make bind bind-libs bind-utils openssl openssl-devel perl quota libaio \
libcom_err-devel libcurl-devel gd zlib-devel zip unzip libcap-devel cronie bzip2 cyrus-sasl-devel perl-ExtUtils-Embed \
autoconf automake libtool which patch mailx bzip2-devel lsof glibc-headers kernel-devel expat-devel \
psmisc net-tools systemd-devel libdb-devel perl-DBI perl-libwww-perl xfsprogs rsyslog logrotate crontabs file kernel-headers

This will ask you to confirm. Write “Y” and press enter.

Step Four

Download the DirectAdmin setup.sh file.

wget https://www.directadmin.com/setup.sh

Step Five

Change permissions of the downloaded setup.sh file to 755

chmod 755 setup.sh

Step Six

Run the script. It automatically installs everything for you, including the CSF firewall.

./setup.sh auto

The auto method will be best for most people. It can also be called as ‘./setup.sh’ without “auto” options, which requires input but allows for customization.

Important: The hostname must be a sub-domain without http, www. For example, server.hostbriz.com

System Security Tips

Follow this link https://help.directadmin.com/item.php?id=247

Enable SELinux

To enable SELinux, follow the instructions below ,

  1. Open the file /etc/selinux/config (You may use winSCP)
  2. Change option SELINUX from disabled to enforcing
  3. Restart the machine
  4. That’s all!