For a single database: mysqldump –opt –user=root –password database1 > singledb.sql For multiple Backup of databases: mysqldump –opt –user=root –password –databases database1 database2 > multipledb.sql To import a MYSQL .sql file from one location to particular location : source /home/SSI/process_databases_backup.sql
Key ==> Code backspace ==> 8 tab ==> 9 enter ==> 13 shift ==> 16 ctrl ==> 17 alt ==> 18 pause/break ==> 19 caps lock ==> 20 escape ==> 27 page up ==> 33 page down ==> 34 end ==> 35 home ==> 36 left arrow ==> 37 up arrow ==> 38 right arrow […]
Check below on How to Add a Column to Mysql Table with Auto Increment and Primary Key You can achieve it by doing Alter Command: Add Column to Mysql To Modify Column and add Auto Increment with Primary Key Query: ALTER TABLE test MODIFY COLUMN ID INT(10) PRIMARY KEY auto_increment; ALTER TABLE users ADD id […]
