Export/Store table or database:
Suppose database name : College& Table name : Student , Courses
1.Exporting a single table from database
Syntax: mysqldump -u root -p < database_name > < table_name > > < backup_file >
Ex: mysqldump -u root -p College Student > backup.txt
2.Exporting multiple table from database
Syntax: mysqldump -u root -p < database_name > < table_1 > < table_2 > > < backup_file >
Ex: mysqldump -u root -p College Student Courses > backup.txt
3.Exporting a single database
Syntax: mysqldump -u root -p < database_name > > < backup_file >
Ex : mysqlsump -u root -p College > backup.txt
4.Exporting all database
Syntax: mysqldump -u root -p --all-databases > < backup_file >
Ex : mysqldump -u root -p --all-databases > backup.txt
0 Comments
Please don't enter any spam link in comment box.
Emoji