Thank you for your great videos. Every time I see the term drop tables all I can think of is little Bobby Tables from xkcd. I imagine that I'm not the only one.
Jeff, the guy who does the kernel panic podcast with me, REALLY knows MySQL...maybe I can convince him to do a few videos with me, setting up a highly available production cluster and talking about all the stuff that's important, all the gotchas, and all the hard-earned lessons. And how to get replication working again after your slave_exec_log_position gets all screwed up and you have evil parts of the binlog that have to be skipped before MySQL will work again. In production. ermagerd flashbacks
Thanks for you videos. But in this instance I disagree with this approach (i.e. the use of mysqldump), I would like to propose the use of Percona's Xtrabckup or the tool Mylvmbackup. These should be the de facto standard, tools for MySQL backups backups and restoring. Sure for your example, the a small database and my proposal is overkill, but if one of viewers is on the road to managing larger databases, least they can hit the ground running or learning and doing proper DBA tools / methodologies. HTH
Thanks, that's a valuable tip. I actually wasn't familiar with Xtrabackup -- the mechanism I saw used for large-ish databases (2-5TB) was streaming replication to other database nodes (hot standby, business intelligence, a 'backup' node where we actually run mysqldump, etc.). We also had frequent disk snapshots on the DB instances, but of course that's primarily useful as a last resort. Thanks again for the tip; it helps to hear from someone who's a better DBA than me!
Hi I'm stuck at 6:47 and get a permission denied statement when I execute the mysqldump. I'm doing this on Ubuntu 18.04.2 LTS. Anybody run into the same problem whilst following all the steps? Were you able to solve it?
Ok I solved it. Answer in this link. askubuntu.com/questions/1146220/permission-denied-after-trying-to-create-mysqldump-even-after-creating-my-cnf?noredirect=1#comment1905374_1146220
What about crontab -e Didn't have to deal with that for a while but if I'm correct this is how crontab should be edited. Anyway thanks for the video. It showed very useful. I'm working in a project where many people are involved and shit happened so here I am to quickly know how to backup my stuff.
just to be sure and on the safe side. Tomorrow they decide it is no more the default. Your script is still behaving as expected. Let me wonder why would there be an option then.
Thank you for your great videos.
Every time I see the term drop tables all I can think of is little Bobby Tables from xkcd.
I imagine that I'm not the only one.
Really enjoy watching your videos. It's really informative and easy to follow. Keep it coming!
I would love more tutorials for production/real world scenarios for n00b DBAs or someone setting out to build their own cluster etc.
Jeff, the guy who does the kernel panic podcast with me, REALLY knows MySQL...maybe I can convince him to do a few videos with me, setting up a highly available production cluster and talking about all the stuff that's important, all the gotchas, and all the hard-earned lessons. And how to get replication working again after your slave_exec_log_position gets all screwed up and you have evil parts of the binlog that have to be skipped before MySQL will work again. In production. ermagerd flashbacks
Thanks for you videos.
But in this instance I disagree with this approach (i.e. the use of mysqldump), I would like to propose the use of Percona's Xtrabckup or the tool Mylvmbackup.
These should be the de facto standard, tools for MySQL backups backups and restoring.
Sure for your example, the a small database and my proposal is overkill, but if one of viewers is on the road to managing larger databases, least they can hit the ground running or learning and doing proper DBA tools / methodologies.
HTH
Thanks, that's a valuable tip. I actually wasn't familiar with Xtrabackup -- the mechanism I saw used for large-ish databases (2-5TB) was streaming replication to other database nodes (hot standby, business intelligence, a 'backup' node where we actually run mysqldump, etc.). We also had frequent disk snapshots on the DB instances, but of course that's primarily useful as a last resort. Thanks again for the tip; it helps to hear from someone who's a better DBA than me!
Great guide, and excuse me if this has been mentioned before but how about a guide on tuning mysql. Oh and tuning mysql to run along side apache.
how do you keep database and web app files in sync? dump the sql to a version controlled git folder?
This method is also very fast for large databases (10Mi rows)?
Very helpful. Thank you.
Hi I'm stuck at 6:47 and get a permission denied statement when I execute the mysqldump. I'm doing this on Ubuntu 18.04.2 LTS. Anybody run into the same problem whilst following all the steps? Were you able to solve it?
Ok I solved it. Answer in this link. askubuntu.com/questions/1146220/permission-denied-after-trying-to-create-mysqldump-even-after-creating-my-cnf?noredirect=1#comment1905374_1146220
Hi Jordan, /home//backups/db
What your best games on linux?
How to migrate mysql user, host and password from old to new server?
What about crontab -e
Didn't have to deal with that for a while but if I'm correct this is how crontab should be edited.
Anyway thanks for the video. It showed very useful. I'm working in a project where many people are involved and shit happened so here I am to quickly know how to backup my stuff.
great video ... thank you
9:34 I got BAGUETTE from this one xD
why not just this? mysqldump -u username -p database_name > source_dump.sql why the --add-drop-table , I think by default drop table is add it.
--add-drop-table is on by default. You don't need to type it :)
just to be sure and on the safe side. Tomorrow they decide it is no more the default. Your script is still behaving as expected.
Let me wonder why would there be an option then.
Thanks for the information on backups and restores. But seriously, it's called "My-S-Q-L", not "My-Seequil": en.wikipedia.org/wiki/MySQL
hey
Very helpful. Thank you.