mysql backup database code example
Example 1: mysql dump restore
mysql -u [user] -p [database_name] < [filename].sql
Example 2: mysql backup database
mysqldump database_name > database_name.sql
Example 3: mysql backup table
mysqldump db_name table_name > table_backup.sql
Example 4: mysql backup query
#Take backup of database
mysqldump database > backup-file.sql;
#Restore database
mysql database < backup-file.sql;
Example 5: mysql restore backup from multiple files
find . -name '*.sql' | awk '{ print "source",$0 }' | mysql --batc