I agree. It's a matter of "when" rather than "if" we do something stupid. I can't live anymore knowing I don't have any backup of my live DB. Thank you so much!!!
Thank you for explaining things in details and raise the awareness of what we need to pay attention to or look out for. Best tutorial ever!!! Much appreciate your works. Thank you again!
And how can I to backup a database that is a terabytes of size ? It is not possible to create a plane text backup of this kind of databases, please explain more on this
This is probably a bit far ahead of this stage you are teaching, but I have databases with, some millions of records. Numerous millions, with rather extensive data. Really, I have a couple TB of additional data I would like to parse, sort, and database. (No it's not porn hahah, all CSV data) I do have some serious hardware, that is not the problem, but either my efficiency in SQL is lacking, or there has to be a better system than SQL for super large data sets..... Question: What should I type into trusty old scroogle to educate myself how to best accomplish databasing, or database-like storage and accessibility of Terrabytes of records?? NoSQL? Or just build out a CSV parser to my needed specifications? I dunno...
Probably just have to work on writing cleaner queries and organizing my data more intelligently to maintain performance. But too much data is a new problem for me hahah
Thanks for this detailed tutorial, i have been struggling for ages. Many thanks and subscribed as gratitude ✌✌
I am a php dev who wants to get into dba in the future. this as a resource is brilliant. will be following this channel from now on
I agree. It's a matter of "when" rather than "if" we do something stupid. I can't live anymore knowing I don't have any backup of my live DB. Thank you so much!!!
Your videos are so helpfum man. You have a really good accent man. With a lot of explainations.
Thank you for explaining things in details and raise the awareness of what we need to pay attention to or look out for. Best tutorial ever!!! Much appreciate your works. Thank you again!
And how can I to backup a database that is a terabytes of size ? It is not possible to create a plane text backup of this kind of databases, please explain more on this
You are a great Tecaher
Could you please make a video on mysql triggers...
what language is the map in the back?
A little bit late, but it seems to be French.
So helpful brother!
Thank you so much!
by the time you've typed out a couple hundred thousand lines of code, you'll understand code better than English, or whatever your native language is.
DB is a good curse
This is probably a bit far ahead of this stage you are teaching, but I have databases with, some millions of records. Numerous millions, with rather extensive data. Really, I have a couple TB of additional data I would like to parse, sort, and database. (No it's not porn hahah, all CSV data) I do have some serious hardware, that is not the problem, but either my efficiency in SQL is lacking, or there has to be a better system than SQL for super large data sets..... Question: What should I type into trusty old scroogle to educate myself how to best accomplish databasing, or database-like storage and accessibility of Terrabytes of records?? NoSQL? Or just build out a CSV parser to my needed specifications? I dunno...
Probably just have to work on writing cleaner queries and organizing my data more intelligently to maintain performance. But too much data is a new problem for me hahah
@@JessieCrypto 0 fucks given.
just look up "big data" "data warehouse architecture design" "data lake" or "database type for big-data"
For terabytes of records or size of databases use oracle man
for anyone trying to load the file in windows powershell you have to use this scheme: the "