Tech tutorials, How To's & User guides

MENUMENU
  • Linux
  • Ubuntu
  • Python
  • NodeJS
  • Apache
  • Nginx
  • Website Administration
    • PHP
    • Django
  • Git

MySQL

How to Run MySQL Query from Command Line

February 18, 2022February 18, 2022 Team Fedingo Leave a comment CentOS/RHEL, Linux, MySQL, Ubuntu
run mysql queries from command line

Sometimes you may need to run MySQL queries from terminal or shell script. Here is how to run MySQL query from command line.

Continue reading


How to Extract Database from MySQL dump file

February 17, 2022February 17, 2022 Team Fedingo Leave a comment MySQL
extract database mysql dump file

Sometimes you may need to extract database from MySQL dump file. Here are the steps to restore or import single database in MySQL.

Continue reading


How to Extract Table from MySQL dump file

February 17, 2022February 17, 2022 Team Fedingo Leave a comment MySQL
extract table from mysql dump file

Sometimes you may need to restore specific tables from MySQL dump file. Here are the steps to extract table from MySQL dump file.

Continue reading


How to Automate mysql_secure_installation Script

February 10, 2022February 10, 2022 Team Fedingo Leave a comment CentOS/RHEL, Linux, MySQL, Ubuntu
Automate mysql_secure_installation Script

mysql_secure_installation allows you to make your MySQL installation secure. Here is how to automate mysql_secure_installation script in Linux.

Continue reading


How to Store JSON Data in MySQL

February 2, 2022February 2, 2022 Team Fedingo Leave a comment MySQL
store json data in mysql

MySQL allows you to save JSON data. Here is how to store JSON data in MySQL.

Continue reading


How to Do Incremental Backup in MySQL Using Binary Log

January 25, 2022January 25, 2022 Team Fedingo Leave a comment MySQL
incremental backup in mysql

It can be time-consuming to take full database backup every time in MySQL. Here is how to do incremental backup in MySQL using binary log.

Continue reading


MySQL Change Table Engine from InnoDB to MyISAM

January 25, 2022January 25, 2022 Team Fedingo Leave a comment MySQL
change innodb to myisam

MySQL supports InnoDB and MyISAM. Here is how to change table engine from InnoDB to MyISAM.

Continue reading


MySQL Datetime vs Timestamp

January 21, 2022January 21, 2022 Team Fedingo Leave a comment MySQL
mysql datetime vs timestamp

MySQL Datetime & Timestamp are two useful data types. Here are the key differences between the two data types in MySQL.

Continue reading


Python Script to Load Data in MySQL

January 21, 2022January 21, 2022 Team Fedingo Leave a comment MySQL, Python
python script to load csv into mysql

Python allows you to load data into databases and run SQL queries. Here is the python script to load data in MySQL.

Continue reading


How to Populate MySQL Table with Random Data

January 20, 2022January 20, 2022 Team Fedingo Leave a comment MySQL
populate mysql table with random data

Sometimes you may need to populate MySQL table with random data. Here are the steps to do it.

Continue reading


Posts navigation

Older posts
Newer posts

Recent Posts

  • How to Convert PDF to Text in Python
  • How to Convert Text to CSV File in Python
  • How to Split List Into Even Chunks
  • How to Split File in Python
  • How to Show File Without Comments in Linux

Follow Us

  • Facebook
  • Twitter
© 2021 Fedingo | About Us | Contact Us | Privacy Policy
dazzling Theme by Colorlib Powered by WordPress