MySQL commands

1. Create a database named "linux".

create database <database name>

eg: create database linux;

2. CREATE TABLE named employee_data with coulumns emp_id , name, designation,
age,email address.

create table employee_data(emp_id int(10),name varchar(40),designation
varchar(40),age int(3),emailaddress varchar(50));

3. Enter atleast 10 entries to this table.

insert into employee_data values ('1','joy','linuxadmin','24','abc@gmail.com');

4. take a backup of this database.

./mysqldump -u {user name} -p {database name} > patht/backupname.sql

eg: ./mysqldump -u user -p linux > /root/backup/linux.sql (Note: you can specify any path)