Jack Wallen explains how to add data into a MySQL table from the command line. So you’re new to MySQL database administration.

Whether you're running a LAMP stack on Ubuntu or CentOS, you need to back up your MySQL databases. Learn how to do this with the help of the mysqldump command.

Create a new database with the CREATE DATABASE command. For example, if you want to create a database named mydatabase, you would run: CREATE DATABASE mydatabase; , use mydatabase ...

Also, I use MariaDB instead of MySQL in my examples, because that's what I have installed, and because I like the improvements MariaDB includes in both the command-line client and in the database ...