Theres Light At The End Of Every Tunnel, Keep Moving
Let’s Encrypt Let’s Encrypt is a non-profit certificate authority run by Internet Security Research Group (ISRG) that provides X.509 certificates for Transport Layer Security (TLS) encryption at no charge. The certificate is valid for 90 days, during which renewal can take place at any time. The offer is accompanied by an automated process designed to …
Importing MYSQL Database Syntax $ mysql -u username -p database_name < path_to_mysql_file_here Importing existing MYSQL database with filename "wordpress.sql" stored at directory "/home/nishant/", Username is "root", terminal will prompt for asking password. $ mysql -u root -p wordpress < /home/nishant/wordpress.sql Exporting MYSQL Database Syntax $ mysqldump -p -u username database_name > path_to_mysql_file_here Exporting MYSQL database …
Introduction to Git Git is a source-code control system that allows multiple developers to work on the same project. Each developer has a copy of the repository on his workstation, and can check in changes to that repository and synchronize it with a central server. Other developers can then fetch those changes by synchronizing their …
MySQL database provides a beautiful feature of Auto Increment Column index. Database table can define its primary key as Auto Increment number and MySQL will take care of its unique value while inserting new rows. Each time you add a new row, MySQL increments the value automatically and persist it to table. But sometime you …
For setting up new hostname with WordPress database is required while moving site to new hostname. For this following SQL commands. In following example we are moving site with hostname dev.example.com to hostname www.example.com. UPDATE wp_options SET option_value = REPLACE(option_value,’http://dev.example.com’,’http://www.example.com’); UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,’http://dev.example.com’,’http://www.example.com’); UPDATE wp_posts SET guid = REPLACE(guid,’http://dev.example.com’,’http://www.example.com’);