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.
@acidrazor7 жыл бұрын
I would love more tutorials for production/real world scenarios for n00b DBAs or someone setting out to build their own cluster etc.
@tutoriaLinux7 жыл бұрын
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
@mattsnow78034 жыл бұрын
Really enjoy watching your videos. It's really informative and easy to follow. Keep it coming!
@xavierl33677 жыл бұрын
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.
@runnerwannabe907 жыл бұрын
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
@tutoriaLinux7 жыл бұрын
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!
@TahmidAzad-v1n7 ай бұрын
Very helpful. Thank you.
@uchitesting5 жыл бұрын
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.
@rogernevez51875 жыл бұрын
This method is also very fast for large databases (10Mi rows)?
@ko955 жыл бұрын
how do you keep database and web app files in sync? dump the sql to a version controlled git folder?
@sammygun845 жыл бұрын
What your best games on linux?
@Дмитрий-с3п4ы2 жыл бұрын
9:34 I got BAGUETTE from this one xD
@s.nikolic4977 жыл бұрын
great video ... thank you
@Dipesh1553 жыл бұрын
How to migrate mysql user, host and password from old to new server?
@Linuxbabeofficial5 жыл бұрын
--add-drop-table is on by default. You don't need to type it :)
@uchitesting5 жыл бұрын
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.
@JohnSmith-zl8rz3 жыл бұрын
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.
@jordannash44205 жыл бұрын
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?
@jordannash44205 жыл бұрын
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
@baniputri964 жыл бұрын
Hi Jordan, /home//backups/db
@southbayphotos5 жыл бұрын
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