MySQL Backup tool | Mysqldump | Logical backup | Part 1

preview_player
Показать описание
In this video, I have explained the MySQL database backup process using the tool "mysqldump". I have covered the following options. The rest of the options will be explained in the coming parts.

--databases
--tables
--all-databases
--add-drop-database
--add-drop-table (skip)
--no-create-info ,--no-create-db
--complete-insert
--extended-insert ( skip )
--insert-ignore
--replace
--source-data 1,2
--dump-slave

If you have any questions, please comment or reach me directly. Thanks!
Рекомендации по теме
Комментарии
Автор

Make video how to restore from dump, please, exactly how to restore specific database from all database dump.

alemamangeldinov
Автор

Excellent. U have explained ver clearly....no more doubts.... thanks and please post more videos on
Small request explain CRONTAB to schedule a backup

Автор

🔥🔥🔥 I'm speechless.
And this is too much to say 💥💥💥
I love those videos, keep going

matteraf
Автор

Can do a video on crontab schedule for mysqldump, thanks!

Medhun
Автор

I couldn't find the part2 video in your videos

ramya
Автор

When it is working Mysqldump there are locks. Is there option make mysqldump without locks?

alemamangeldinov
Автор

Is this mysql enterprise edition? Please let me know anyone

balakrishnam