WEBVTT 00:00:04.000 --> 00:00:20.000 Okay. This is the monthly general meeting of Slug, the St. Louis Unix user. Users group. 00:00:20.000 --> 00:00:21.000 9. 00:00:21.000 --> 00:00:22.000 Hi. 00:00:22.000 --> 00:00:25.000 The date is Wednesday. August the eighth Is that today? Sorry. August the ninth, 2023. 00:00:25.000 --> 00:00:36.000 Our speakers this evening. We have Stan Reichardt doing the basic tutorial. And that's on, Vim side by side functionality. 00:00:36.000 --> 00:00:42.000 And then our main speaker tonight is Lee Lammert and he's talking about doing a hot restore of a Mysql database. 00:00:42.000 --> 00:00:45.000 And with that, I'll turn it over to Stan. 00:00:45.000 --> 00:00:53.000 Lee, would you slide this the display down to show the topics? 00:00:53.000 --> 00:00:54.000 There you go. 00:00:54.000 --> 00:01:09.000 Further. Hey, you go. Okay, share my screen. I can remember how to do that. 00:01:09.000 --> 00:01:17.000 Where am I? 00:01:17.000 --> 00:01:31.000 Well, stand setting up, I'll just make the comment for those of you who may. Not have been with us before the way we do our meetings is called the And now we've got the basic tutorial presentation on the front. 00:01:31.000 --> 00:01:43.000 Then in the middle of the meeting we do the announcements, the welcoming and the short question and answer. 00:01:43.000 --> 00:01:54.000 There will be time for a little more interactive question there. And explanation of what we're up to but first we'll let Stan do his basic tutorial presentation. 00:01:54.000 --> 00:02:10.000 Before we go any further, does anybody seen the transcripts, the captions? Okay. Hi, I saw a message said that they were captioning was on, but I didn't see any. 00:02:10.000 --> 00:02:13.000 Can anybody hear me? 00:02:13.000 --> 00:02:14.000 Well, I can hear you. 00:02:14.000 --> 00:02:15.000 Okay. 00:02:15.000 --> 00:02:20.000 If you had show captions on the bottom, it will pop up on your screen. 00:02:20.000 --> 00:02:27.000 I don't see him. I saw a message saying that they were on, but that nothing happened. 00:02:27.000 --> 00:02:28.000 I love Zoom. 00:02:28.000 --> 00:02:30.000 I, when I turn it on. 00:02:30.000 --> 00:02:33.000 Okay. 00:02:33.000 --> 00:02:36.000 Whatever. Anyway. 00:02:36.000 --> 00:02:39.000 This meeting is being recorded. 00:02:39.000 --> 00:02:45.000 That's good. 00:02:45.000 --> 00:02:46.000 Yeah, them side by side. 00:02:46.000 --> 00:02:50.000 No. She just had to say that. Yeah. Bye. 00:02:50.000 --> 00:02:52.000 It's gonna somebody needs to mute their hike. 00:02:52.000 --> 00:03:01.000 Alright, somebody needs to mute their, hikes. Oh 00:03:01.000 --> 00:03:07.000 Gary, your punching key is up. 00:03:07.000 --> 00:03:11.000 Yeah, it's kind of their reverse logic, since I'm here in the back cave. 00:03:11.000 --> 00:03:18.000 It was my speaker, but it's please Mike. It was picking that up. So I have it wasn't I had to mute I had to. 00:03:18.000 --> 00:03:21.000 I had to kill the speaker. 00:03:21.000 --> 00:03:23.000 Okay. Them side by. 00:03:23.000 --> 00:03:28.000 I'd worry, I'd worry Stan. I have to kill the speaker. 00:03:28.000 --> 00:03:37.000 Yeah. Well, I, I can't be co-host and record with anonymous coward and do the presentation. 00:03:37.000 --> 00:03:41.000 All at the same time. I can only do 2 things at once, not 3. 00:03:41.000 --> 00:03:44.000 Okay. 00:03:44.000 --> 00:03:57.000 Them side by side. This is gonna be a sample of useful features. Okay. 00:03:57.000 --> 00:03:58.000 You know. 00:03:58.000 --> 00:04:06.000 Now where my mouse go. Jeez. On the third of August, Bram Moular, the main programmer behind them died at age 62. 00:04:06.000 --> 00:04:14.000 I knew nothing about it when I volunteered to do the rest of this presentation, so. Just thought it would be. 00:04:14.000 --> 00:04:24.000 Mentioned that the main. Orchestrator that Packages passed away. 00:04:24.000 --> 00:04:39.000 Hey, I'm Stan Reichardt though. Current slug vice president current slack co chair and the current new Linux chairman and cantankerous dictator for life You want to know any of my other qualifications? 00:04:39.000 --> 00:04:45.000 Go ahead and hit that link above. As an overview here, the Vim text editors. 00:04:45.000 --> 00:04:54.000 As the abilities and. Tools that do a lot of neat things side by side is one thing that I'll concentrate on a little bit later. 00:04:54.000 --> 00:05:01.000 I'd like to mention if you started following the, the presentation that was done in June. 00:05:01.000 --> 00:05:11.000 . 23. By the way, this, this is a hyperlink Do their presentations archives. 00:05:11.000 --> 00:05:21.000 So if you, if your new person is started out using. Them based on that guidance that I tried to give. 00:05:21.000 --> 00:05:28.000 In that presentation, by now you might. No enough to. Follow along with what else we're doing here. 00:05:28.000 --> 00:05:37.000 It's gonna be a small sample of useful features. I'm gonna Try to hit on the points who, what, where, when, why, and how. 00:05:37.000 --> 00:05:45.000 Good relate. It's gonna be a demonstrations in terminals. And the recording of this session will be made. 00:05:45.000 --> 00:06:01.000 Later and. Like to also remind people that beginners, them tutor. And it's 7 lessons are very significant and getting you started and using them. 00:06:01.000 --> 00:06:09.000 And from the command line, you type in them tutor and it takes you right into the. All the magic that's involved. 00:06:09.000 --> 00:06:18.000 First point, who? Well, who's this session for beginners? Anybody curious about? Using them, the new users, the novices. 00:06:18.000 --> 00:06:28.000 Any level above that. They don't know about these particular features. You know, you could be using them for years and not know. 00:06:28.000 --> 00:06:36.000 One or 2 of the things that's going on. Hello, what am I gonna cover? Well, I'm gonna cover these items in particular, VIN plus. 00:06:36.000 --> 00:06:46.000 From the command line and then viewing of text file. Yeah. Protected mode where you don't. 00:06:46.000 --> 00:06:53.000 Actually modify it. And then there's a them def where you look at various. 00:06:53.000 --> 00:07:01.000 The differences between multiple files. And then what I think is really neat is a side by side editing that you can do. 00:07:01.000 --> 00:07:10.000 And this last item is what's called the easy mode. And I'm debated with myself whether or not to. 00:07:10.000 --> 00:07:19.000 Present this because it could be kind of shooting yourself on the foot kind of a thing. But we'll address that later. 00:07:19.000 --> 00:07:29.000 Where is, available? Yeah, where do you start learning? I left out the link that I wanted to put in here, but. 00:07:29.000 --> 00:07:42.000 How'll add that to the final PDF that be posted with the presentations. That'll go back to the what's on our archives. 00:07:42.000 --> 00:07:49.000 When? Maybe you have to first know about a feature before you can, No, whether you need it or whether you can. 00:07:49.000 --> 00:07:55.000 Use it or must use it or should use it or will use it, etc, etc, or maybe that you'll never use it. 00:07:55.000 --> 00:08:04.000 So this thing is trying to try to introduce you to some of those features. And then you can make a decision by yourself. 00:08:04.000 --> 00:08:17.000 Why use it? It's nearly on every Unix Linux system. It's often where you have to use it where the GUI infrastructure is not available. 00:08:17.000 --> 00:08:32.000 There are alternative editors that You may or may not be able to install on a system. But it does nice thing is it features is that it focuses on keyboard interaction rather than using a mouse. 00:08:32.000 --> 00:08:40.000 And that can be productive for a lot of people. And the navigation keystrokes are frequently used in other applications. 00:08:40.000 --> 00:08:45.000 And there's an extreme amount of help built into them. Extreme at a point where By golly, you can get lost in there. 00:08:45.000 --> 00:08:54.000 It's as bad as. Getting lost on Wikipedia and I find that the folding features really amazing. 00:08:54.000 --> 00:09:00.000 That's my favorite feature. On them. But that won't be covered on this meeting. How? 00:09:00.000 --> 00:09:09.000 Well, if you don't have it, you can on a Debian based system, you can do a set a pseudo app to install them runtime. 00:09:09.000 --> 00:09:19.000 And then we can run the Vim Tutor. And I'd always like to point out their Cap Lock key is your enemy in them and the escape key is your friend. 00:09:19.000 --> 00:09:25.000 There's always something good to know. The demonstrations, I'll do them concurrently as we go along. 00:09:25.000 --> 00:09:31.000 I'll try to demonstrate the material is covered and 00:09:31.000 --> 00:09:42.000 I'll try to refer back to any. Practical context and and I may get sidetracked, but I encourage people to participate as we're going along. 00:09:42.000 --> 00:09:52.000 And clarify questions during the demonstration and we'll have a period after everything where we can ask more questions if you think I'm of them later. 00:09:52.000 --> 00:10:04.000 First off, then plus. This is, Not, listed too much. Well, it's not listed in the internal help of them, but it's on the man page. 00:10:04.000 --> 00:10:18.000 Vim has a very extensive mant page. A lot of people don't realize. Essentially it says that, you say Vim plus and it'll take you to the a particular line number within the file. 00:10:18.000 --> 00:10:24.000 Or if you don't listen number, it'll just jump you to the last line of the file. 00:10:24.000 --> 00:10:33.000 And I find that very happy. Handy to use. And I've used it in a little script that I built recently for tracking my, blood pressure. 00:10:33.000 --> 00:10:43.000 I, track it to it, file that I keep to show to my doctor and And I run the script and it goes them plus. 00:10:43.000 --> 00:10:50.000 And the file name in. Sumps right to the end where I can add something new. 00:10:50.000 --> 00:11:05.000 Does anybody want me to demonstrate that this point? Guess I can do it. What do you do to think book them? 00:11:05.000 --> 00:11:06.000 Huh. 00:11:06.000 --> 00:11:07.000 I've used them, plus just to run arbitrary commands inside, since then opens up. 00:11:07.000 --> 00:11:08.000 So it does more than just those 2 things. Lots and lots of options. 00:11:08.000 --> 00:11:14.000 Yeah. It's quite a bit. Yeah 00:11:14.000 --> 00:11:18.000 That's real hard to read. 00:11:18.000 --> 00:11:22.000 Okay, give me a second here. 00:11:22.000 --> 00:11:23.000 Control plus maybe. 00:11:23.000 --> 00:11:27.000 I'm looking for the keyboards. 00:11:27.000 --> 00:11:30.000 There you go. Beautiful. 00:11:30.000 --> 00:11:35.000 Beautiful. 00:11:35.000 --> 00:11:42.000 Bim Plus looks at the 00:11:42.000 --> 00:11:46.000 I wrote a little script for 00:11:46.000 --> 00:11:53.000 Pinging multiple files and that jump to the last line with that plus sign. Or did I click on? 00:11:53.000 --> 00:12:04.000 Yes, I did. So it jumps to the last line. 00:12:04.000 --> 00:12:09.000 Oops. 00:12:09.000 --> 00:12:18.000 Okay, you notice over on the right bottom right it says a hundred 40 lines and I'm on setting on 140 the last line there. 00:12:18.000 --> 00:12:25.000 Okay. Jumping back to Wrong screen. There we go. Next screen. 00:12:25.000 --> 00:12:37.000 Yeah, that's them plus. And man page. Oh, let's look real quick at the man page while I him here. 00:12:37.000 --> 00:12:39.000 Man page? We don't need to stink at man page. Yeah. 00:12:39.000 --> 00:12:47.000 There's. Well, we don't necessarily need it. You just start digging around and pound it on the keyboard till something magical happens. 00:12:47.000 --> 00:12:55.000 You know, there's a whole room full of monkey somewhere. That's how they do them. 00:12:55.000 --> 00:13:01.000 And the descriptions, it goes down, it's one of the options further on down plus num. 00:13:01.000 --> 00:13:07.000 For the first file and the cursor will be positioned on the line. If it's missing, it goes to the last line. 00:13:07.000 --> 00:13:18.000 In the file. And general layout of the file, the synopsis is them with options and file. 00:13:18.000 --> 00:13:24.000 And can be multiple files. A lot of these options. 00:13:24.000 --> 00:13:37.000 I'll quit that. Yeah, jump back to. Wrong. Okay, next item. 00:13:37.000 --> 00:13:43.000 It's, starts in read-only mode. And there's an alternate name called view. 00:13:43.000 --> 00:13:55.000 Well, I can never remember the dash r. Or let alone whether or not it's a capital R or a lowercase r, but I can always remember view. 00:13:55.000 --> 00:13:58.000 And if you go within them. 00:13:58.000 --> 00:14:09.000 You can use the help, colon help and whatever this item is and it'll show. Here we go. 00:14:09.000 --> 00:14:21.000 Go them within them. I'll do a help. Dash car boom and that goes in that's it specifications on . 00:14:21.000 --> 00:14:26.000 Read only mode and it mentions in there somewhere Yeah, the alternative is view, I think it's mentioned there. 00:14:26.000 --> 00:14:36.000 I think it's mentioned in the man page, not necessarily there. But you can do a help. 00:14:36.000 --> 00:14:45.000 . And that is listed Starts in read only mode, see the dash. Capital R for view. 00:14:45.000 --> 00:14:59.000 And. You know, this jumps right to that area and. As I said, there is an extensive amount of help here that just goes on and on and on and on and it's all related. 00:14:59.000 --> 00:15:02.000 Bunch of things here so 00:15:02.000 --> 00:15:14.000 I always have trouble getting out of that recording mode. Anyway, jumping back. 00:15:14.000 --> 00:15:18.000 Alright, next one, them dash D option. Starts in a See again. 00:15:18.000 --> 00:15:27.000 I'm sorry, you said. You said, you said recording mode. 00:15:27.000 --> 00:15:31.000 I've had trouble getting out of recording mode. 00:15:31.000 --> 00:15:35.000 Okay. We were in recording mode. 00:15:35.000 --> 00:15:42.000 I, well, I hit a bunch of keys that I hit that started recording within. 00:15:42.000 --> 00:15:43.000 Oh, okay. 00:15:43.000 --> 00:15:50.000 And I have, you know, I get into that and that's usually a little difficult to get out is for recording macros. 00:15:50.000 --> 00:15:51.000 Way beyond the topics here. Okay. 00:15:51.000 --> 00:15:52.000 Okay. Okay. 00:15:52.000 --> 00:16:04.000 Yeah, them has a very powerful capability to record very complex macros or very simple macros too, but you initiated by hitting the Q key from normal mode and you also cancel it by hitting the Q key. 00:16:04.000 --> 00:16:08.000 In normal mode, but it does throw people off because they slam the escape, like, which normally works in VAM, but it doesn't work when you're in the macro recording mode. 00:16:08.000 --> 00:16:15.000 So. Try queue next time, might help. 00:16:15.000 --> 00:16:17.000 Yeah. Like I said, I get confused all the time. So I'll have to record what was just said here and play it back to myself. 00:16:17.000 --> 00:16:27.000 40 times and I might learn how to get out of recording mode. 00:16:27.000 --> 00:16:45.000 Anyway. If. Going into it what's called diff mode. And that what are the allows you to do it opens all those files that you that you have and you know they The option here is it's a them dash D file. 00:16:45.000 --> 00:16:51.000 One, file 2, and then multiple files. You could have 5 or 6 files, 8 files, up to 8 files, I think. 00:16:51.000 --> 00:16:56.000 In most cases. It'll open all those files and it'll show you the difference between them. 00:16:56.000 --> 00:17:06.000 Works like the so it says within the man page it or the it does say that it works like 00:17:06.000 --> 00:17:14.000 Hmm. Let me try something here. So you, you can either do the Vim dash D or the VIP. Okay. 00:17:14.000 --> 00:17:23.000 Within them, you've helped or the help base. Or space, Vim. Let me jump back here. 00:17:23.000 --> 00:17:27.000 Yeah 00:17:27.000 --> 00:17:35.000 Okay. 00:17:35.000 --> 00:17:37.000 Okay. 00:17:37.000 --> 00:17:42.000 Dash. 00:17:42.000 --> 00:17:45.000 And it talks about the 00:17:45.000 --> 00:17:58.000 What's listed in the actual help file for the dash D option. Also available. I think How do I get out of this? 00:17:58.000 --> 00:18:11.000 Oh. 00:18:11.000 --> 00:18:21.000 Bimdiff. And there's a whole section on Vim. Diff. Viewing the diffs and jumping around and copying and all kinds of options and I won't go into all of these. 00:18:21.000 --> 00:18:28.000 But like I said, it's quite extensive help in here, but this is just a cursory introduction to this stuff. 00:18:28.000 --> 00:18:36.000 They hear that's the first section on diff. Then it talks about viewing the diffs. This is a whole lot of information there and jumping between them. 00:18:36.000 --> 00:18:45.000 And, it was the, copying between different etc, etc. 00:18:45.000 --> 00:18:57.000 Nice. Diff options. I just use a r rudimentary, use of, Yeah. 00:18:57.000 --> 00:19:00.000 Okay, and alt. 00:19:00.000 --> 00:19:11.000 I mean not to hear what I want to do. Going back to the man page on him 00:19:11.000 --> 00:19:19.000 Hmm. At. Dash the option shown at the top of the. Page there. 00:19:19.000 --> 00:19:27.000 It starts the. Gift mode. And that What I said there, it, it works like, command. 00:19:27.000 --> 00:19:35.000 Alright. 00:19:35.000 --> 00:19:48.000 And this is my favorite, capital O. What that does is opens multiple windows. A window. Within your terminal. 00:19:48.000 --> 00:19:54.000 For each of the files that you specified. Okay. And. 00:19:54.000 --> 00:20:02.000 And. You can you can either do it stacked with a small And you'll have a file here. 00:20:02.000 --> 00:20:15.000 On the screen and the other file on the screen below it. Okay. What I prefer using with the Vim dash capital so that it stacks the files, displays them side by side. 00:20:15.000 --> 00:20:24.000 No, sometimes your system will start in the, depending what you've got installed. So let's see what I can do here. 00:20:24.000 --> 00:20:35.000 Let me jump real quick to. One 00:20:35.000 --> 00:20:41.000 There's that what it list in the help or the demand page. It talks about opening. 00:20:41.000 --> 00:20:52.000 Windows stacked capital O windows side by side. Okay, that's that's in the 00:20:52.000 --> 00:20:56.000 In the man page. 00:20:56.000 --> 00:21:05.000 And in Vim. Help. Okay. Hold? 00:21:05.000 --> 00:21:12.000 Okay, this is the help that's within the man page. It talks about the split horizontally. 00:21:12.000 --> 00:21:17.000 And stacking them one on top of the other. And split vertically where there's side by side. 00:21:17.000 --> 00:21:20.000 I prefer the side by side. 00:21:20.000 --> 00:21:23.000 Again, could I suggest, can we go to a larger font? 00:21:23.000 --> 00:21:28.000 I'm sorry. Harry, you need to buy some glasses. 00:21:28.000 --> 00:21:33.000 He's wearing 3 of them right now. 00:21:33.000 --> 00:21:34.000 Thank you. 00:21:34.000 --> 00:21:38.000 Okay. Alright. 00:21:38.000 --> 00:21:39.000 It's a little bit of screen on his laptop. 00:21:39.000 --> 00:21:46.000 Oh man. Well. Yeah, let me show this on the 00:21:46.000 --> 00:21:49.000 Trying to watch them by Dick Tracy watch. 00:21:49.000 --> 00:21:53.000 There you go. Yeah. There's a day in the help. 00:21:53.000 --> 00:22:01.000 The man page, them dash d starts in diff mode. Okay, and since like it says right there, it works like them diff. 00:22:01.000 --> 00:22:07.000 Okay. And if I remember correctly. 00:22:07.000 --> 00:22:15.000 I guess not is there I'm not sure I wonder if there's a separate page or them diff. 00:22:15.000 --> 00:22:26.000 I think there is. I was looking at yesterday as a matter of fact. Hey, on 2 update 8 files. 00:22:26.000 --> 00:22:31.000 Okay. 00:22:31.000 --> 00:22:35.000 Okay. 00:22:35.000 --> 00:22:42.000 Okay. 00:22:42.000 --> 00:22:56.000 Time to go. 00:22:56.000 --> 00:23:22.000 Let me jack this up a little bit. Let me do them. 00:23:22.000 --> 00:23:23.000 Thank you. 00:23:23.000 --> 00:23:27.000 Yeah, it's 00:23:27.000 --> 00:23:35.000 Okay. 00:23:35.000 --> 00:23:36.000 Oh, that's no changes. Okay. 00:23:36.000 --> 00:23:43.000 That's, that's the side, there's a duplicate files. And, She shows No changes, okay? 00:23:43.000 --> 00:23:51.000 That's the original file and the other is a duplicate of it. So. That's, there's actually a file, or, believe it or not. 00:23:51.000 --> 00:23:58.000 Oh. Let me see, 00:23:58.000 --> 00:24:06.000 Oh yeah. Let's, oh shoot, just say menu. 00:24:06.000 --> 00:24:12.000 Yes, H. 00:24:12.000 --> 00:24:15.000 Yeah, either. 00:24:15.000 --> 00:24:22.000 It's just the stuff in red is the stuff that's different. Between the left file and a write file. 00:24:22.000 --> 00:24:36.000 And further on down. On the right here is this or on the left this is all empty this is shows empty space whereas there's all this stuff that's on the right side is in the the other one. 00:24:36.000 --> 00:24:46.000 One file is not in yet the left file. And If you navigate, they kinda go along until they hit stuff that's. 00:24:46.000 --> 00:24:58.000 Similar. You know on the Left side I've got a line that starts with it. A parent, it's in a case statements, A parent, and digit an option. 00:24:58.000 --> 00:25:06.000 And there's no matching one in a previous version over here. Okay, or it's actually out of sequence. 00:25:06.000 --> 00:25:14.000 Or so. And it's slightly different. This has got a 0 and there's no A 0 over here, but there's an A and there isn't an A. 00:25:14.000 --> 00:25:25.000 And so I tries to go along sequentially. Very useful. Actually. 00:25:25.000 --> 00:25:27.000 Let me go back here. 00:25:27.000 --> 00:25:34.000 How do you switch from file to file if you're in neither of the? Side by side or stacked modes. 00:25:34.000 --> 00:25:43.000 Okay, what you do is you do a Let's see here. See where you cursor is, blanket, blinking on the left. 00:25:43.000 --> 00:25:52.000 You do a control WH. No, not. Control, WII told everybody L. 00:25:52.000 --> 00:25:56.000 My fingers know what to do, but I don't. 00:25:56.000 --> 00:26:06.000 Control. I can find the dog on button. 00:26:06.000 --> 00:26:07.000 Okay. 00:26:07.000 --> 00:26:08.000 There, I'm told WH or no control WL. And there's a whole sequence of these. 00:26:08.000 --> 00:26:13.000 And they used to have kind of the navigation, the, you know, the HJ KL kind of. 00:26:13.000 --> 00:26:15.000 He's in with the control, proceeded with the control W. 00:26:15.000 --> 00:26:22.000 Well, the arrow keys work after controlled W. 00:26:22.000 --> 00:26:23.000 Okay. 00:26:23.000 --> 00:26:28.000 I never, I've never used that. I probably would. Let me try this. Control W. 00:26:28.000 --> 00:26:29.000 Left air. 00:26:29.000 --> 00:26:33.000 Left arrow. No, apparently not. 00:26:33.000 --> 00:26:36.000 You'd have to. Add it and make it if you wanted it. 00:26:36.000 --> 00:26:44.000 You could pro. Yeah, you could probably add it as a macro or something like that. Our dash knows, I don't know how. 00:26:44.000 --> 00:26:45.000 I haven't. 00:26:45.000 --> 00:26:55.000 But let me say for those who may not be familiar in the in the old old days before there were arrow keys in the early version of EI. 00:26:55.000 --> 00:27:09.000 The 4 keys right next to each other the Hj KL. Was the up arrow down arrow left arrow right arrow so that's what stands talking about is you can use the. 00:27:09.000 --> 00:27:17.000 H to go to the left. L key to go down. 00:27:17.000 --> 00:27:24.000 Oh, one of the neat things is Here, let me see. One of the really neat things is you can. 00:27:24.000 --> 00:27:31.000 Jump between the 2 of them. I can do it yank why why with this and then jump back. 00:27:31.000 --> 00:27:38.000 Yeah, the other side. And insert it. What I just shanked. 00:27:38.000 --> 00:27:52.000 Okay, I duplicated it. But I don't wanna say that. Get out of this mode with the multiple, share, Shared screens, and either vertical or horizontal, stacked or. 00:27:52.000 --> 00:27:58.000 Or not. You do a queue. A, Pell. 00:27:58.000 --> 00:28:08.000 And I just, by habit, do queue all. And that quits both of them. And I, 00:28:08.000 --> 00:28:19.000 Since I had started the. Let me go back into that. You don't make any changes, you do, or you save your changes or whatever, the new queue all. 00:28:19.000 --> 00:28:25.000 And then it dumps you out of both of them. 00:28:25.000 --> 00:28:35.000 Okay. Alright, now. Yeah, that was now here is the shoot yourself on the foot kind of thing. 00:28:35.000 --> 00:28:43.000 Okay, you hear a lot about. Oh, people get confused because VI starts in an insert mode is the command mode. 00:28:43.000 --> 00:28:58.000 And so you start typing in it. What is all these strange things happening? Happen because people are used to they're thinking they're not well lot of novices or Way back when, he, they were used to typing on a typewriter. 00:28:58.000 --> 00:29:07.000 So you just start and a lot of editors, you just start typing. Sometimes they call it typewriter mode. 00:29:07.000 --> 00:29:18.000 Or insert mode. So, or sometime they call it easy mode. It's just like the. 00:29:18.000 --> 00:29:32.000 There's, there's some. Anyway, it starts in the navigation mode within them called insert mode and it behaves like a Click and type editor. 00:29:32.000 --> 00:29:41.000 Okay. There's a, you know, technically it runs with that. The. Source script. 00:29:41.000 --> 00:29:54.000 Control factor there. I'm not sure exactly what that is. I just copied it over. But the mappings are set up to work like most click and type editors and there's a thing called them keys you can mess with. 00:29:54.000 --> 00:30:02.000 And the GUI is started when available. There's a major hint here. Because if you want to go. 00:30:02.000 --> 00:30:11.000 Back into normal mode. To be able to type a sequences, you use the control L to get out of the easy mode. 00:30:11.000 --> 00:30:19.000 Okay. Once back in the normal mode, you can use the normal Vim commands. When I first. 00:30:19.000 --> 00:30:35.000 Well, like I said, a lot of people don't know about this and I didn't know this existed until I started to do this presentation and I went and looked at the man page and went through all the I actually thought it was a good idea to read the entire man's page and I ran across this, dash y option. 00:30:35.000 --> 00:30:45.000 I didn't know that existed, but it does. And I played with it and I like I was telling Gary earlier I got into it and I couldn't figure out how to get out of it. 00:30:45.000 --> 00:30:58.000 Oh, I went back into the help. Within them and help. Dash why let me show Cause it's not in them. 00:30:58.000 --> 00:31:03.000 Well, in, in the man page. 00:31:03.000 --> 00:31:13.000 Let's see here. In the man page it wrong button. 00:31:13.000 --> 00:31:30.000 Yeah, dash why. It. Not, them in the Vim page just got it does have it listing for dashi. 00:31:30.000 --> 00:31:40.000 It talks about the easy mode dashi argument. And, again. 00:31:40.000 --> 00:31:54.000 Where is it? 00:31:54.000 --> 00:32:02.000 Where is it? Yeah, right there. It says, start to them in the easy mode just like, you know, blah, blah, like a click and type editor. 00:32:02.000 --> 00:32:08.000 But on the man page, it doesn't tell you how to get out of the, easy mode. 00:32:08.000 --> 00:32:18.000 Okay, this kind of sucks. So. But in Vim itself, you can do, help. 00:32:18.000 --> 00:32:30.000 Desh, why? And it'll tell you there. Let's see. Click and type, 00:32:30.000 --> 00:32:34.000 And then let me go to the. 00:32:34.000 --> 00:32:42.000 Yeah. 00:32:42.000 --> 00:32:50.000 Yeah, it does in there. Actually, I don't know where I did find that. 00:32:50.000 --> 00:32:58.000 Or at least I can't remember right now where I found it, but you have to do a a control L to get out of easy mode. 00:32:58.000 --> 00:33:03.000 And let me. 00:33:03.000 --> 00:33:25.000 Okay. 00:33:25.000 --> 00:33:31.000 Okay, now this happened to pop up in the graphical 00:33:31.000 --> 00:33:38.000 Version of them because I've got the graphical stuff loaded. And it's so. 00:33:38.000 --> 00:33:50.000 Usually you get that by saying, But, whatever thing I liked about this graphical mode is it's really handy because it learns. 00:33:50.000 --> 00:34:01.000 In the QT version of it. Cause I installed the Vim. There's QT 2 and or Vim dash. 00:34:01.000 --> 00:34:10.000 QT 3. Package from their repository and it pulled in this graphical mode and those using the QT version. 00:34:10.000 --> 00:34:21.000 A nice thing about it is. He's got these drop-down menus and over on the right side of the drop-down menu it's got the Command line items that you would type in. 00:34:21.000 --> 00:34:29.000 To. You can either go in here and do something and click it or if you were just Without the without the. 00:34:29.000 --> 00:34:39.000 Clicking on the graphical thing. You can, so one way to help. Learn the some of the features that are within. 00:34:39.000 --> 00:34:51.000 Them instead of having to read the entire man page or the or all the help files that are in them, which is probably take you 7 months. 00:34:51.000 --> 00:35:00.000 I don't know, I get I get lost in the, the Vim help pages. Anyway, one of one of the neat things is where is this? 00:35:00.000 --> 00:35:08.000 Color scheme. You can actually have different cover. 00:35:08.000 --> 00:35:15.000 I like desert. That's a little different. Where is it? File, caller scheme. 00:35:15.000 --> 00:35:26.000 Each, different color schemes that you can set. And you can use those commands within your dot VM RC file to set your color schemes. 00:35:26.000 --> 00:35:32.000 Anyway, I've gone into 00:35:32.000 --> 00:35:55.000 Here with. In easy mode so 00:35:55.000 --> 00:36:05.000 Now, this at this point. I'm Juan. Do an escape. And try and do a yank yank to jank that line and it won't Get out of easy mode. 00:36:05.000 --> 00:36:11.000 Oh no, what do I do? What I do? Well, you do a you, do a control L. 00:36:11.000 --> 00:36:20.000 That takes you. Back in the normal mode where you can do stuff with the. VI commands, navigation. 00:36:20.000 --> 00:36:29.000 Okay, so like I said, this is a Kind of a shoot yourself in the foot command. 00:36:29.000 --> 00:36:38.000 Let me control. 00:36:38.000 --> 00:36:43.000 Anyhow, back to the menus. 00:36:43.000 --> 00:36:46.000 Okay. 00:36:46.000 --> 00:36:52.000 And I went over this, the easiest way to learn VIP or VI itself is to use the V. 00:36:52.000 --> 00:37:00.000 And it takes you through that. You can install it with a V runtime. Within them you can use the these various help commands. 00:37:00.000 --> 00:37:08.000 For the V tutor, the. View VAMP, the side by side stuff and the control L. 00:37:08.000 --> 00:37:13.000 Yes, let's get you out of this easy mode right here. 00:37:13.000 --> 00:37:26.000 No, no privacy issues that I know of at this time. Then There were some. V in. 00:37:26.000 --> 00:37:34.000 That were discovered in them and they were listed in these CVAs. I think these have been fixed. 00:37:34.000 --> 00:37:48.000 I didn't have time to, I forgot I was gonna go verify. Whether or not they've been fixed but there's been a lot of since that happened there's been a lot of updates to to them and I remember seeing one or 2 of them that were. 00:37:48.000 --> 00:37:59.000 Security so I guess that's That's what's going on here and I'd like to say. 00:37:59.000 --> 00:38:03.000 Before I finish. 00:38:03.000 --> 00:38:11.000 Oh, and the PDF, Steve will be appreciate that, Steve Stegman. Anyway. 00:38:11.000 --> 00:38:18.000 In summary, the Use Vim Toater, Caplock. K is your enemy. Escape is your friend. 00:38:18.000 --> 00:38:28.000 Later on, after this feedback. People are invited to subscribe to our mailing list and discuss, etc, ask questions. 00:38:28.000 --> 00:38:37.000 If anybody sends me a question, I will more unlikely try to answer it and I will post my answer up on discuss. 00:38:37.000 --> 00:38:44.000 Because I'm not always right about a lot of these things and sometimes some of our people have better ideas than I have. 00:38:44.000 --> 00:38:48.000 Okay, and 00:38:48.000 --> 00:39:01.000 This whole thing is share and share like. Any further questions? I'm finished. Otherwise. 00:39:01.000 --> 00:39:10.000 As I say again, this recording will be up on our archives. My presentation archives along with the man page. 00:39:10.000 --> 00:39:16.000 Or, me the. A PDF of the slides. 00:39:16.000 --> 00:39:17.000 Is any? 00:39:17.000 --> 00:39:22.000 Stay on there was a question in chat earlier by Ron. I'm, I'm sorry. 00:39:22.000 --> 00:39:30.000 It was, by day. What's the difference between VI and then 00:39:30.000 --> 00:39:37.000 Well, VI is the old original one. And them is a lot of improved. Stuff has got a lot more options. 00:39:37.000 --> 00:39:44.000 And I've been using them for so long. I don't know the difference anymore. No, if you 00:39:44.000 --> 00:39:52.000 A lot of systems is link VI to VI M because you know, nobody cares about the older version. 00:39:52.000 --> 00:40:02.000 Right. And it does that link to give you the option to run it with the with the with fewer options just so you can test out. 00:40:02.000 --> 00:40:19.000 The differences between the 2. But, I mean, I think the thing is like the one of the things that the major thing that Vim has that VI doesn't have is the folding capability. 00:40:19.000 --> 00:40:27.000 Or you can take lines. Let me let me I can see if I can demo that. Let me go to. 00:40:27.000 --> 00:40:35.000 Oh. 00:40:35.000 --> 00:40:43.000 Go in here and. With folding. See all this this section right here, everything is contiguous. 00:40:43.000 --> 00:40:44.000 There's no blank spaces. 00:40:44.000 --> 00:40:46.000 Let's go to chat. 00:40:46.000 --> 00:40:56.000 And you could do a fold it. 00:40:56.000 --> 00:41:02.000 Yeah, I folded those 18 lines all into one. It's next thing down. I can fold these. 00:41:02.000 --> 00:41:13.000 17 lines all alone. Then. All, all are compressed into so I can. Unfold them. 00:41:13.000 --> 00:41:23.000 Or folding back up. You can and you can move these around and change the sequence. And it really helps in programming. 00:41:23.000 --> 00:41:27.000 If you can do this because I try to start out with a I've done stuff where I've. 00:41:27.000 --> 00:41:37.000 What? You very structured program together and I know I try to put the functions off the top and put them all with the. 00:41:37.000 --> 00:41:43.000 With no blanks in them so I can move the whole thing at once. 00:41:43.000 --> 00:41:47.000 That's the major difference that I that I really like. There's all. Probably a ton more. 00:41:47.000 --> 00:42:09.000 Just about every keyboard. Has some function within them. Either upper case or lower case. And I gave a diagram and in that June presentation that showed all the keystrokes that we're all at. 00:42:09.000 --> 00:42:18.000 The options that were. Related to different keys on the keyboard, both upper case and lowercase. 00:42:18.000 --> 00:42:25.000 If you know the You could go for months trying to figure out the difference between the VI and VAM. 00:42:25.000 --> 00:42:33.000 I just use them. Cause I started out using VI years ago when and 00:42:33.000 --> 00:42:42.000 I, you know, if the thing is, this the similarities are enough that if you're on a system that doesn't have them and you have to use theI, you can get by. 00:42:42.000 --> 00:42:45.000 You really can. 00:42:45.000 --> 00:42:51.000 I'm not even sure if there's, if it's not just a perfect superset, is it? 00:42:51.000 --> 00:42:52.000 I don't think there's anything in VI. Okay. 00:42:52.000 --> 00:42:59.000 Oh yeah. Always, as far as I know, it's got everything and Vim has everything that VI has. 00:42:59.000 --> 00:43:00.000 In it. Good. 00:43:00.000 --> 00:43:07.000 There's actually option called set compatible and if you have that turned on then it your editor is going to be compatible with VI. 00:43:07.000 --> 00:43:12.000 But I think set no compatible, which turns off that compatibility mode. I think that's the Now, nowadays, but you can. 00:43:12.000 --> 00:43:21.000 Turn that on if you want it to behave exactly like VI and limit them to what just only what VI had. 00:43:21.000 --> 00:43:28.000 Yeah, so, you know, I've been using. The I that you started using VI back and, well. 00:43:28.000 --> 00:43:40.000 1919 eighties. I'm sure. And Graduated to using them. 00:43:40.000 --> 00:43:51.000 And have not had a problem using them. Are going back to V when I, when I had to. 00:43:51.000 --> 00:44:00.000 I hope that's a good enough answer on what the differences between the 2 of them. Yeah. It seems like Vim has everything in VI. 00:44:00.000 --> 00:44:12.000 And VI does not have everything that Vim has. Bye, one of the major things that II really like is the folding. 00:44:12.000 --> 00:44:13.000 Any other questions? 00:44:13.000 --> 00:44:14.000 Okay. 00:44:14.000 --> 00:44:22.000 Bye. What I mean like is the plug in ecosystem, right? Because I don't think there's any plugins for VI or any way really way to extend it as far as I know. 00:44:22.000 --> 00:44:36.000 And so basically with them and with me of them, you have a gigantic, well, a large community of people writing plugins and things to make the editor even better and you just don't get that with VI, I don't think. 00:44:36.000 --> 00:44:46.000 Although there's been quite a quite an active. Group Cause, Bram, didn't. 00:44:46.000 --> 00:44:53.000 Do all the coding in the later years he he had health. 00:44:53.000 --> 00:45:03.000 Yeah. And it's hard to know exactly how much help, right? Because I think that he's still operated in the old model where people would email him patches or whatever and he would commit it under his name. 00:45:03.000 --> 00:45:04.000 Yeah. 00:45:04.000 --> 00:45:08.000 So it's hard to know exactly how many contributors there were on them, but there are apparently now that he's passed. 00:45:08.000 --> 00:45:16.000 Right. 00:45:16.000 --> 00:45:17.000 Hi. 00:45:17.000 --> 00:45:18.000 There are apparently he wasn't the only one with commit rights to the repo. So, there are other people that possibly could continue, them. 00:45:18.000 --> 00:45:22.000 Now that he's gone. 00:45:22.000 --> 00:45:31.000 I saw a posting that the one there was one of the participants said that he had most of the access. 00:45:31.000 --> 00:45:41.000 And he didn't think it would be a problem to get a complete access to taking over the, Source code base. 00:45:41.000 --> 00:45:48.000 It will probably continue. Maybe there might be a little speed bump here, but it will continue. 00:45:48.000 --> 00:45:49.000 If not. 00:45:49.000 --> 00:45:51.000 Well, what a hell of a legacy though, right? To leave behind this editor. I mean, who? 00:45:51.000 --> 00:45:54.000 Yeah. 00:45:54.000 --> 00:46:03.000 So few people have put that much work into open source is branded. You know, if you think about developing this editor for what, more than 30 years, I mean, dedication to open source. 00:46:03.000 --> 00:46:04.000 Yeah. 00:46:04.000 --> 00:46:07.000 Well, this guy's a legend. 00:46:07.000 --> 00:46:17.000 Yeah, I mean, I was I was really happy to use it because you could get it and you could put it on a Microsoft Windows if you had had to. 00:46:17.000 --> 00:46:28.000 And whereas, previously I had, I was using a, a bootleg copy of something called says Stevie or Silver or something, I forget whatever it was, but. 00:46:28.000 --> 00:46:37.000 I, you know. The Vim, you know, it's There's a copy, there's a version that will run under Microsoft. 00:46:37.000 --> 00:46:47.000 And when you when I had to well when I set up a When I have to run a Microsoft system, the first thing I put on it is V. 00:46:47.000 --> 00:46:55.000 Because I can't type. Anything hardly anymore, and our standard editor. On the Thunderbird is a good grief. 00:46:55.000 --> 00:47:08.000 I go into edit there and I'll start doing. Typing and look down and this got all garbage because Oh. 00:47:08.000 --> 00:47:11.000 It's just years of habit, you know. 00:47:11.000 --> 00:47:18.000 Yeah, yes, since you brought up the Eagle Empire, I found a real neat tool for wind blows last month. 00:47:18.000 --> 00:47:24.000 Called get for windows.org. Basically, it drops a bashell into Windows. 00:47:24.000 --> 00:47:34.000 It's got all the standard you tell them and you know, and all that, but it's also got a good implementation of get so you can. 00:47:34.000 --> 00:47:39.000 You know, drop it in in a couple of minutes and you've got a command line that you can do. 00:47:39.000 --> 00:47:43.000 Keep your fingers happy on Windows. 00:47:43.000 --> 00:47:44.000 Yeah. 00:47:44.000 --> 00:47:52.000 I think that's the official get. Binary that they. Advocate you use when you go to install. 00:47:52.000 --> 00:47:58.000 Yeah. And it's, you know, it's, it's an entire shell. It's not just, is the point I was making. 00:47:58.000 --> 00:48:04.000 It includes them and a bunch of other stuff. 00:48:04.000 --> 00:48:21.000 We're starting to run a little long, but, Sean had put in chat, would we mind if he did a quick little demo of favorite Vim command that he used this week. 00:48:21.000 --> 00:48:31.000 Yeah, I appreciate it. I won't take up too much time. I'm gonna take over the screen real quick. 00:48:31.000 --> 00:48:37.000 And I made the font big beforehand so you can hopefully see it. So, 00:48:37.000 --> 00:48:43.000 So what I've been doing this week, I've been I've actually got my new, and can pick it up where I can actually use it at work. 00:48:43.000 --> 00:48:49.000 And so I've been putting some time in so you can do. Down here, if you see down at the bottom, I'm typing in command mode down here. 00:48:49.000 --> 00:48:54.000 I can type re-split. And then I can put in the name of some file. So I'll just do my MRC and that opens it in a right split. 00:48:54.000 --> 00:49:02.000 Or, well, for my configuration, it's in the right spread for years, it might be in the left split. 00:49:02.000 --> 00:49:11.000 And then, this is the one time I like use the mouse using, is to click right here and you can resize. 00:49:11.000 --> 00:49:20.000 The 2 splits using your mouse so I don't know if you see this but I'm clicked on my mouse here on this line between the 2 splits and I'm able to resize them. 00:49:20.000 --> 00:49:30.000 With my mouse and the one reason why I am okay with doing this with my mouse is because if I wanted to do this with a keyboard I would do like Yeah, I'm doing to do right now. 00:49:30.000 --> 00:49:39.000 You see how a move like basically one pixel? So I had to put control W shift period. 00:49:39.000 --> 00:49:40.000 Okay. 00:49:40.000 --> 00:49:42.000 To make that one pixel happen, right? And so I'd have to control W shift period. 00:49:42.000 --> 00:49:46.000 Control W shift period. Control W shift period. You know, over and over and over again. 00:49:46.000 --> 00:50:01.000 And it would be very tedious. And so this is the one case where it's good to use your mouse because you can just Drag it to resize and then if you get to a size you don't like you can do control W equals sign and that will balance them back out. 00:50:01.000 --> 00:50:07.000 And then let's say that I'm over here, okay, so my mouse or my cursors over here in this left. 00:50:07.000 --> 00:50:14.000 Split over here and let's say I want to close this other one. I'm gonna close the other split that's open. 00:50:14.000 --> 00:50:22.000 The way you do that is you do control W. And that will close the other split. So if I open that back up. 00:50:22.000 --> 00:50:26.000 And now I'm gonna put my mouse over here. I'm gonna put my mouse or my cursor. 00:50:26.000 --> 00:50:34.000 Sorry, my cursor over here on the right one. And if I wanna just close this split that I'm in, I'll do Control WQ and that will close the one that I'm in. 00:50:34.000 --> 00:50:41.000 So it's control WQ to close the one that I'm in, control WO to close the other one. 00:50:41.000 --> 00:50:48.000 Now, let me get to my favorite feature that I've been messing with this. As tree splitter. 00:50:48.000 --> 00:50:57.000 So, tree center, sorry, it's, it's not a new, but it's a plugin for an E of M and what it does is it gives you a bunch of text objects. 00:50:57.000 --> 00:51:11.000 So what I'm able to do with Tree Sitter is Tree Sitter basically creates an apps like abstract syntax tree for my code and so it knows that this is the parameter for a method. 00:51:11.000 --> 00:51:27.000 And so what I do is I can have my cursor right here on this parameter and I can do VAA and that will highlight the entire parameter so it knows that this is the type and this is the name and then it knows that the comma is part of it. 00:51:27.000 --> 00:51:38.000 So I can do the same thing over here. VAA and it highlights everything, including the comma or if I did VIA, it will do everything but not the comma. 00:51:38.000 --> 00:51:46.000 And this just is something that you cannot get in VS code. Okay, you cannot get this in VS code because in VS code. 00:51:46.000 --> 00:51:54.000 . Code does knows nothing about your your code. It does not create an app. Sex, and text tree of your code. 00:51:54.000 --> 00:52:01.000 What it does is it sends the entire buffer to a language server and the language server then builds the AST and knows about your code. 00:52:01.000 --> 00:52:08.000 But VS code knows nothing about it. So this is one thing that is just flat out better than, then VS code. 00:52:08.000 --> 00:52:16.000 And what I can also do is I have this key binding. Right here. Where I can actually swap parameters. 00:52:16.000 --> 00:52:26.000 And And so here I have the start year month. And end year months here and these are 2 separate parameters for this method but if I do leader A that's my key binding for it. 00:52:26.000 --> 00:52:38.000 Then it switches them. So now you see the end as first and start a second. And if I'm honest, I don't use this super often and it wouldn't make sense here with starting end like start should always be on the left. 00:52:38.000 --> 00:52:56.000 But sometimes you, but it's just the fact that my editor is smart enough and knows enough about my code where it can where it can like with 2 keystrokes take this entire parameter and move it over here and then move this one over there and it doesn't like mess it up and put the calm on the wrong spot or anything like that. 00:52:56.000 --> 00:52:57.000 So Anyway, I'm in not gonna take any more time, but that's my favorite feature of That my favorite features I used in Ben this week. 00:52:57.000 --> 00:53:11.000 You want to take that Nice. 00:53:11.000 --> 00:53:12.000 Now we get the thumbs up from T-bones. 00:53:12.000 --> 00:53:18.000 Yeah, thank you. That makes my head swell. Yeah. Yeah. 00:53:18.000 --> 00:53:33.000 Alright. Okay. Anything else we need to, say on, on them at this point or should we move on? 00:53:33.000 --> 00:53:34.000 I say we move on. 00:53:34.000 --> 00:53:41.000 Okay. With that, thank you very, very much, Stan Reichardt. Stan always comes up with something really good and interesting for us. 00:53:41.000 --> 00:53:50.000 So we appreciate it. And, Let's see with that. As I said, this is an Oriole Cookie version of a meeting. 00:53:50.000 --> 00:54:00.000 We do the announcements and we do. Q&A in the middle and . Just a second. 00:54:00.000 --> 00:54:04.000 Get a hand up. Who's got their hand? Oh, put it down. 00:54:04.000 --> 00:54:07.000 That was a clap. I was clapping for Stan. 00:54:07.000 --> 00:54:08.000 Oh. 00:54:08.000 --> 00:54:15.000 Oh, thank you. Oh, there was a question in the chat about the So someone, let's see, Tommy T-bones. 00:54:15.000 --> 00:54:23.000 He used what he thinks is best for. I'm trying to do it. I use seldom uses them. 00:54:23.000 --> 00:54:29.000 What is it that you use, Toby? 00:54:29.000 --> 00:54:32.000 I've been using VS code and 00:54:32.000 --> 00:54:49.000 Okay. Yeah, I'm old school. I stick with the VI. Okay. 00:54:49.000 --> 00:54:50.000 Spirited. 00:54:50.000 --> 00:54:51.000 Who is someday we probably should have a not a nasty but a You know, just one of those gentlemen's debates of, you know, Yeah, yeah, little spirited confrontation. 00:54:51.000 --> 00:55:08.000 Maybe a 6 pack of beer is the, folks which way they want to go. But anyway, yeah, it could be a good comment or a good discussion some night is maybe just to have an advantages. 00:55:08.000 --> 00:55:16.000 Alright, announcements, next Thursday night. Is the St. Louis Log, St. 00:55:16.000 --> 00:55:33.000 Louis Linux user group. The speaker will be Robert, SITEECH, Hello, The topic will be a new shell, MUSH ELL. 00:55:33.000 --> 00:55:47.000 And the little teaser I have for it so far is you know how would you like an editor where instead of just having a text output it came out for instance as an SQL database coming out of. 00:55:47.000 --> 00:55:57.000 The editor. So with that, there'll be a better. Better abstract, better description, but, that's what topic will be next Thursday night. 00:55:57.000 --> 00:56:06.000 I believe it starts at 6 30. And, so keep your eye out. And, just say, a little bit better description coming. 00:56:06.000 --> 00:56:16.000 Any other, let's see, Lee or Stan, anything on the calendar that, Well, Stan's got it up or. 00:56:16.000 --> 00:56:18.000 One look at the calendar. 00:56:18.000 --> 00:56:24.000 Yeah. Well, we got the abbreviated calendar on this web page. Oh, 00:56:24.000 --> 00:56:26.000 Only a couple of times. 00:56:26.000 --> 00:56:32.000 Yeah, control. 00:56:32.000 --> 00:56:33.000 There you go. 00:56:33.000 --> 00:56:40.000 Yeah. And. 00:56:40.000 --> 00:56:47.000 Need to add that, but anyway, dead. So these are the dates. Or they are sponsored groups. 00:56:47.000 --> 00:56:51.000 And 00:56:51.000 --> 00:56:56.000 Whatever. 00:56:56.000 --> 00:57:11.000 And. 00:57:11.000 --> 00:57:20.000 On our main calendar. Here 00:57:20.000 --> 00:57:23.000 Back in there. 00:57:23.000 --> 00:57:26.000 Bigger, bigger. 00:57:26.000 --> 00:57:30.000 Trying to get the thing standards first. 00:57:30.000 --> 00:57:33.000 Oh, it'll auto center. 00:57:33.000 --> 00:57:34.000 Yeah. 00:57:34.000 --> 00:57:37.000 I know I'm looking for the keys. I don't have all the keys memorized, okay? 00:57:37.000 --> 00:57:38.000 Okay. 00:57:38.000 --> 00:57:40.000 Right. 00:57:40.000 --> 00:57:42.000 Much better. 00:57:42.000 --> 00:57:44.000 Yeah, and they got 00:57:44.000 --> 00:57:48.000 This, this is the ninth right here. 00:57:48.000 --> 00:57:52.000 Next week on Thursday. 00:57:52.000 --> 00:58:01.000 The St. Louis Clinic users group. 00:58:01.000 --> 00:58:05.000 Gary, you need to post that stuff. 00:58:05.000 --> 00:58:08.000 Yes. 00:58:08.000 --> 00:58:09.000 Very an easy clone. 00:58:09.000 --> 00:58:13.000 Yeah, or 2 or 2. 00:58:13.000 --> 00:58:17.000 Okay, or maybe 5 Indians. 00:58:17.000 --> 00:58:22.000 Whatever. Volunteers are always welcome. 00:58:22.000 --> 00:58:30.000 Nice thing about volunteering. You get to do what you the way you want to do it. It's how you do it. 00:58:30.000 --> 00:58:34.000 If somebody complains. 00:58:34.000 --> 00:58:40.000 Alright. Let's see. This is on that calendar. 00:58:40.000 --> 00:58:41.000 Scroll down a little. 00:58:41.000 --> 00:58:50.000 Oh, wait a minute. 00:58:50.000 --> 00:58:51.000 Okay, the 20 s is a new Linux users group. For Beginners, Novice People. 00:58:51.000 --> 00:59:16.000 Hey, Good. Okay. And, obviously the Sinkfield Cup just tournaments coming up. 00:59:16.000 --> 00:59:26.000 St. Louis has managed to become a world center in just in the last decade or so. Anyway, Let's see. 00:59:26.000 --> 00:59:35.000 Oh, there was a comment by, Ron BC in chat on the, on the, on stands talk. 00:59:35.000 --> 00:59:46.000 And he, he mentioned a gentleman named Michael. Paoli of San Francisco log is adamant that the VI is better than them. 00:59:46.000 --> 00:59:55.000 And, so Ron was looking for his ride up of, zoom Michael's ride up of why and what his reasons are. 00:59:55.000 --> 01:00:05.000 So, Ron, if you ever find that, by all means, pass it on to if you can probably Drop it to discuss, email list. 01:00:05.000 --> 01:00:16.000 That's. That's meeting. See any other announcements? 01:00:16.000 --> 01:00:27.000 Okay. Let's see, general QA. At this point, you can ask any question you would like. 01:00:27.000 --> 01:00:32.000 Probably only has a reasonable chance of being getting an answer if that's something to do with computers. 01:00:32.000 --> 01:00:41.000 And of course a lot of us hang around after the main presentation and, So that'll be more Q&A afterwards. 01:00:41.000 --> 01:00:48.000 If anyone has to leave. You know, I can't hang around late tonight and you, you wanna get out of QA. 01:00:48.000 --> 01:00:52.000 There a question of some kind ask now. And, see if somebody can't answer for you. 01:00:52.000 --> 01:00:54.000 Okay. 01:00:54.000 --> 01:00:57.000 Ask questions on a discussed mailing list. 01:00:57.000 --> 01:00:58.000 Okay. 01:00:58.000 --> 01:01:03.000 Cause there'll be a lot of people on there that aren't at this meeting tonight. 01:01:03.000 --> 01:01:04.000 Yeah, that's right. 01:01:04.000 --> 01:01:16.000 And there's some Ray Bird's out there, that know everything. I'm not one of them. 01:01:16.000 --> 01:01:20.000 3. 01:01:20.000 --> 01:01:21.000 Yeah. 01:01:21.000 --> 01:01:25.000 Boy, a lot of silence. Okay, well, like I said, there's certainly after the main presentation. 01:01:25.000 --> 01:01:36.000 We can certainly do just general questions after that as well but if I don't hear anything else that need to be done we'll move on. 01:01:36.000 --> 01:01:53.000 And moving on. Our next speaker is Lee Lammert. We is the. Treasurer of slook a long time member and somewhat frequent presenter so we're always happy to hear from way back in December. 01:01:53.000 --> 01:02:01.000 I believe it was 2020. Yeah, I think 2020 December. We did a presentation on my sequel. 01:02:01.000 --> 01:02:04.000 So, I did. I think so. You say so. Oh yeah. 01:02:04.000 --> 01:02:16.000 Anyway, this, this is not a repeat of that presentation, so, but anyway, with that, I'm going to turn it over to Lee. 01:02:16.000 --> 01:02:23.000 Oh, thank you, Gary. I've got a national presentation done here. 01:02:23.000 --> 01:02:31.000 Welcome everyone. I've had to do this a couple of times myself. So I've been taking notes. 01:02:31.000 --> 01:02:45.000 And the other presentation because it's interesting and it's a. Very significant problem. If, if you get into it and I'll show you why here in a minute. 01:02:45.000 --> 01:02:53.000 But basically I called a hot restore. Because you've got a server, a database on a server. 01:02:53.000 --> 01:03:01.000 Or you've also got 5, 1015, 20 or more other. Databases on that server in this case for websites. 01:03:01.000 --> 01:03:12.000 So if you blow up a database, you can't restore by Sequel. Because you kill every other database on there and set them back to what they were the day before. 01:03:12.000 --> 01:03:20.000 So by hot restore, I'm saying. I'm implying that you are restoring a single database. 01:03:20.000 --> 01:03:28.000 Out of however many are running on that server. 01:03:28.000 --> 01:03:32.000 In which case, and in this example. 01:03:32.000 --> 01:03:41.000 I run into this. I think 3 or 4 times over the last 5 years. On a share with many website. 01:03:41.000 --> 01:03:47.000 A lot of times there's an external tool involved, such as server pilot. There's other ones out there. 01:03:47.000 --> 01:03:56.000 Lot of times it's WordPress because There are millions and millions of websites out there managed by people that know how to. 01:03:56.000 --> 01:04:01.000 Click on mouse, they have absolutely no clue what's going on. The covers, which is fine. 01:04:01.000 --> 01:04:08.000 Because they're building a website with content. You know, they don't wanna care about everything else. 01:04:08.000 --> 01:04:16.000 Of course they learn their lessons pretty quickly about security and things like that. But for that website, you must have a WordPress instance. 01:04:16.000 --> 01:04:23.000 Basically you know you download it to the machine it runs and you configure it But that WordPress site. 01:04:23.000 --> 01:04:33.000 Has to have Okay. 01:04:33.000 --> 01:04:48.000 Yeah, I'm gonna. There it is. Let's take a look at one. This is a Droplet in digital ocean called snowman. 01:04:48.000 --> 01:04:58.000 It's probably the most active of the 5 that we've got out there that that I manage. 01:04:58.000 --> 01:05:08.000 We just, a definition. He said, I drop what. That is a virtual machine that digital ocean cells for. 01:05:08.000 --> 01:05:13.000 Anywhere from 30 to 100 bucks a month. 01:05:13.000 --> 01:05:18.000 Most of them are a bunch of. I don't know if that's going to continue, but. 01:05:18.000 --> 01:05:23.000 Historically everything I've seen is with a budget. 01:05:23.000 --> 01:05:41.000 Now this is a 4 core machine, it has 8 gig RAM. And I think there's about 15 websites on. 01:05:41.000 --> 01:05:49.000 It is a digital ocean droplet. This particular one. Is, 16 point oh 4.7. 01:05:49.000 --> 01:05:58.000 Which is an LTS version of I think that's one of the reasons, because you can run the same version for. 01:05:58.000 --> 01:06:10.000 What is the limit? Like 10 years or something like that before you actually have to upgrade it? It's extremely long lifestyle. 01:06:10.000 --> 01:06:13.000 So I'm gonna software on that machine. 01:06:13.000 --> 01:06:20.000 The way these WordPress sites are configured, you've got Engine X. You've got Apache. 01:06:20.000 --> 01:06:36.000 And you've got PHP. And. 12 different versions. Because each website has to be able to have a different version of PHP depending on what version of WordPress you're running. 01:06:36.000 --> 01:06:46.000 In this case, they're managed by server pilot. Which is kind of an interesting tool. It let's Let you manage. 01:06:46.000 --> 01:06:59.000 A web server and create it, manage it, update it. Without knowing anything other than how to use a mouse. 01:06:59.000 --> 01:07:06.000 So let's recap the problem for a minute. We're talking about a server with multiple websites. 01:07:06.000 --> 01:07:13.000 Every one of them has a database. There's one Mysql server on a machine. 01:07:13.000 --> 01:07:21.000 Those websites must be available, 24 by 7 by 3 65 because Obviously somebody's paying for it. 01:07:21.000 --> 01:07:27.000 They don't wanna disappear at all. Well, we had to revert the database to last week because somebody crashed her site. 01:07:27.000 --> 01:07:32.000 That this isn't gonna play, not in a commercial world. 01:07:32.000 --> 01:07:45.000 In this case, I'm backing up every machine nightly. There's a couple of different ways to back it up. 01:07:45.000 --> 01:07:48.000 A file backup. 01:07:48.000 --> 01:07:49.000 Is as simple as to manage basically. 01:07:49.000 --> 01:07:52.000 Good. Yeah. 01:07:52.000 --> 01:08:00.000 I run our snapshot job every night, backs up the database, grabs all of everything in the Mysql directory. 01:08:00.000 --> 01:08:08.000 And I'll show you here in a bit how to use that. But you've also got the ability to do a SQL backup. 01:08:08.000 --> 01:08:19.000 Which I do also every night. I do a Mysql dump of the entire server. Okay, you know, the entire server, which gets every database on the system. 01:08:19.000 --> 01:08:24.000 She pull backup is very cumbersome. It's a pain in the butt to edit. 01:08:24.000 --> 01:08:29.000 Although I will tell you from experience that Vim. Just a magnificent job. It'll take the biggest file you can come up with. 01:08:29.000 --> 01:08:42.000 I've had like 2 or 3 GB worth of file edited them. It might take 30 s or a minute to find the database you want. 01:08:42.000 --> 01:08:52.000 But then with a couple of key strokes, you can delete everything before. And find the next one, delete everything after it and save that off and you've got the actual SQL backup. 01:08:52.000 --> 01:09:01.000 Of that database. Is everybody comfortable with the difference between a sequel backup and a file backup? 01:09:01.000 --> 01:09:05.000 I am. Thanks for putting that out there. 01:09:05.000 --> 01:09:10.000 Cool. 01:09:10.000 --> 01:09:19.000 So let's talk about a file backup. Because it's the simplest. First thing we want to do is retrieve it. 01:09:19.000 --> 01:09:30.000 In fact, I can show you exactly what's going on here. 01:09:30.000 --> 01:09:34.000 This is where I keep them. 01:09:34.000 --> 01:09:44.000 3, 3 of them here. Let's look at bandit for second. 01:09:44.000 --> 01:09:52.000 You know, like here's the backup from last night, which was daily 0. 01:09:52.000 --> 01:09:59.000 And one bar. L. 01:09:59.000 --> 01:10:03.000 And there's your Mysql directory. 01:10:03.000 --> 01:10:16.000 It is possible. I've done it many times. To grab the drop it on another machine. With a similar version of my sequel. 01:10:16.000 --> 01:10:27.000 Now you can't do it with very disparate versions like you can't take a 5.7 version of my sequel and drop it on a on a server with my SQL 8 and expect it to run. 01:10:27.000 --> 01:10:29.000 It's not. 01:10:29.000 --> 01:10:37.000 We'll get to that here in a little bit. But by restoring that that directory. I can bring that database back and running. 01:10:37.000 --> 01:10:59.000 With a couple of caveats. 01:10:59.000 --> 01:11:11.000 Yeah. 01:11:11.000 --> 01:11:21.000 Every day. I also pull a copy. Of the sequel. 01:11:21.000 --> 01:11:26.000 On this machine is 680 meg. 01:11:26.000 --> 01:11:33.000 But this is an actual SQL backup. 01:11:33.000 --> 01:11:44.000 From this box which is Mysql 5 7 88. And then from here on down. It is a sequel backup. 01:11:44.000 --> 01:11:51.000 If you've never seen a SQL backup. 01:11:51.000 --> 01:11:59.000 No, it is just literally hundreds and hundreds of hundreds. Of tables and databases and stuff like that. 01:11:59.000 --> 01:12:11.000 Anyway. Back to the presentation. If I want to restore one of those single databases. I have to have a way to retrieve the backup. 01:12:11.000 --> 01:12:14.000 I just showed you where it would be. 01:12:14.000 --> 01:12:20.000 I have to know. The source Mysql version. 01:12:20.000 --> 01:12:32.000 Because if I'm going to restore that database. The main problem I have. Is separating the single database I want to restore from. 01:12:32.000 --> 01:12:36.000 The rest of the backup. 01:12:36.000 --> 01:12:40.000 Yeah, that's the main problem to solve. 01:12:40.000 --> 01:12:48.000 To do that, I have to build a Mysql instance somewhere. That's similar to that version. 01:12:48.000 --> 01:13:00.000 Again, using backup files is the quick quickest. And then once I get that running, I can go in and dump the required database that I need. 01:13:00.000 --> 01:13:07.000 Once I have that dog file, I go to the production server. Log in on the production server. 01:13:07.000 --> 01:13:16.000 Drop that work database. Then run the backup dump. You know, my sequel left carrot in case nobody seen it before. 01:13:16.000 --> 01:13:33.000 And the Dub file which will reload on the server, and then test it. Any questions on the process? 01:13:33.000 --> 01:13:41.000 Is that double? Left bracket or left That's not a pen that's. Just so 01:13:41.000 --> 01:13:44.000 Correct. It's a left carrot, matching the right carrot on dump file. 01:13:44.000 --> 01:13:45.000 Oh, okay. 01:13:45.000 --> 01:13:51.000 I couldn't come up with a simpler way to do that. So I just put 3 spaces in there. 01:13:51.000 --> 01:13:52.000 Okay. 01:13:52.000 --> 01:13:54.000 Good catch. 01:13:54.000 --> 01:14:01.000 That is a, but that is an input pipe, right? You're piping the contents of the file into the 01:14:01.000 --> 01:14:08.000 Right. And of course you, I just realized you probably have put your credentials in here. 01:14:08.000 --> 01:14:12.000 Minus you root minus p and password. 01:14:12.000 --> 01:14:21.000 Or at least minus you root and then I'll ask you for password. 01:14:21.000 --> 01:14:29.000 But that second left carrot as well as the right carrot is just a way of indicating the dump file is not. 01:14:29.000 --> 01:14:39.000 A particular file name, fill in dump file with what. Your actual cases. Yeah. 01:14:39.000 --> 01:14:43.000 But the first ones that redirect myself. Right. 01:14:43.000 --> 01:15:03.000 Alright, in this case, my sequel is 5 7 dot 33. 01:15:03.000 --> 01:15:08.000 We're going on a micro center and buy a new PC, load Linux on it. Yes, sales sales sales, back to school sales tax weekend. 01:15:08.000 --> 01:15:22.000 Yes, yes, buy one. Are you PC? Get it for a fraction of the cost. 01:15:22.000 --> 01:15:26.000 The only problem with there is you have to go out and spend money and a lot of time. 01:15:26.000 --> 01:15:32.000 I could install my SQL on my main workstation. 01:15:32.000 --> 01:15:38.000 Which I wouldn't do, cause,'ll mess up something else. I could build a VM. 01:15:38.000 --> 01:15:46.000 I could run it on a cloud VPS somewhere, a 10 bucks for a month to use it. 01:15:46.000 --> 01:15:52.000 In my estimation, all of these are total overkill. 01:15:52.000 --> 01:16:00.000 My solutions build the doctor instance. You know all those 6 or 7 classes we had years ago when Chuck was doing them? 01:16:00.000 --> 01:16:04.000 Yeah. Good place to apply. 01:16:04.000 --> 01:16:09.000 I can build a running. My sequel server in about 5 min with Docker. 01:16:09.000 --> 01:16:19.000 I can run on any machine. That's obviously some version of Linux. Because Docker containers are compatible with the Windows architecture. 01:16:19.000 --> 01:16:22.000 You have to have different versions. 01:16:22.000 --> 01:16:29.000 It's also the fastest and simple. It's just to blow out a tarball. I'll show you how it works here in a minute. 01:16:29.000 --> 01:16:38.000 The first problem though. Is finding a compatible Mysql version. 01:16:38.000 --> 01:16:43.000 Of. dot.com. That My Sequel. 01:16:43.000 --> 01:16:49.000 Show you the page here in a second. 01:16:49.000 --> 01:16:52.000 Yeah, sorry, I don't have it don't have a browser over here yet. 01:16:52.000 --> 01:16:59.000 Is that underbar between the docker.com and the Mysql? Is that on purpose? 01:16:59.000 --> 01:17:00.000 That was the link I copied. 01:17:00.000 --> 01:17:02.000 Okay, thank you. 01:17:02.000 --> 01:17:11.000 Sure. Hello, it's simpler just to do. 01:17:11.000 --> 01:17:15.000 Sure for Docker My Sequel. 01:17:15.000 --> 01:17:21.000 And the link here is the first one. 01:17:21.000 --> 01:17:27.000 Here's all the versions that you have as currently supported. 01:17:27.000 --> 01:17:39.000 Notice there's a lot of 5.7 because especially for the digital ocean world, these have been around for But 5, 6 years now so far. 01:17:39.000 --> 01:17:50.000 And then the current versions are, If you need to find more. There's other way other places to find them. 01:17:50.000 --> 01:17:55.000 Hello, luckily I haven't had to. 01:17:55.000 --> 01:18:04.000 Any question on the on what we're doing here? 01:18:04.000 --> 01:18:13.000 Alright, so If I want my sequel 5.7. The command I use is Jocker pull. 01:18:13.000 --> 01:18:16.000 My Sequel, in 5.7. 01:18:16.000 --> 01:18:26.000 And the Docker system built and on this workstation. We'll go out and pull that version from the Docker Hub. 01:18:26.000 --> 01:18:37.000 Pull all the components. And you're good to go. 01:18:37.000 --> 01:18:40.000 At that point you start the container. 01:18:40.000 --> 01:18:49.000 Dr. Run. Name of Miami, whatever you want. For me, I put to my sequel. 01:18:49.000 --> 01:18:58.000 Dot 5 dot 7 dot 33 whatever version it is. If you happen to be running a Mysql 8. 01:18:58.000 --> 01:19:06.000 It will pick up a root password from the environment. If you're running 5.7, it does not. 01:19:06.000 --> 01:19:13.000 That's what they asked your screen share. 01:19:13.000 --> 01:19:23.000 Then you wanna map a volume for. You are live my sequel. In the Mysql container. 01:19:23.000 --> 01:19:29.000 2, the actual path of those backup files. 01:19:29.000 --> 01:19:40.000 And I can show you that here. 01:19:40.000 --> 01:19:48.000 On this system, I keep all my data. Docker data and shared data. 01:19:48.000 --> 01:19:52.000 And you can see here. 01:19:52.000 --> 01:20:02.000 There's an old 5 7 85. Which I built 2 years ago for the last time I had to restore. 01:20:02.000 --> 01:20:06.000 And here's a new version I just did today. 01:20:06.000 --> 01:20:30.000 From. Do August eighth backup. From So in this directory here. 01:20:30.000 --> 01:20:37.000 You know, these are all the files. In the directory. 01:20:37.000 --> 01:20:53.000 And you'll notice that there are some names here. That kind of look like database names. 01:20:53.000 --> 01:21:01.000 Okay, one of the first things I tried. Which is copying that directory under a container. And try and load the database. 01:21:01.000 --> 01:21:10.000 . There's too much metadata splattered around here So if that idea ever occurs to you. 01:21:10.000 --> 01:21:14.000 Forget it. 01:21:14.000 --> 01:21:22.000 I'm sure. What was the issue there? Okay. This is the Mysql. 01:21:22.000 --> 01:21:34.000 Directory that just restored this afternoon. From the backup of last night. And these are all the files. 01:21:34.000 --> 01:21:47.000 These files here. Are actually individual databases. Okay, so when you look at this you might think well I can just drop this into a new Mysql and find it. 01:21:47.000 --> 01:22:01.000 Where's the metadata? Is it in that file? The Mysql system database. 01:22:01.000 --> 01:22:19.000 Okay, you know, there's a bunch of other metadata scattered in files that are not in Yeah, the actual directory where the database Okay, the metadata is in those other files for each of the, for each of the actual databases on the system. 01:22:19.000 --> 01:22:25.000 And a lot of it's in my Because that's where all the users and the permissions are. 01:22:25.000 --> 01:22:36.000 So I'm just mentioning that because That occurred to me 10 years ago and I tried it and didn't work so I've just passed the wisdom. 01:22:36.000 --> 01:22:42.000 Alright. 01:22:42.000 --> 01:22:52.000 There are some password problems. I found out the hard way. That When you're doing a restore. 01:22:52.000 --> 01:23:02.000 The root password. Gets linked to something that I don't know exactly what. That's a combination of. 01:23:02.000 --> 01:23:12.000 The hope that something is embedded in the install. And if you move that installed another machine, it breaks it. 01:23:12.000 --> 01:23:27.000 I haven't, I haven't taken the time to figure it out. But the point here Is that if you're doing exactly what I'm doing, all you need is the username and password of the database you want to go. 01:23:27.000 --> 01:23:34.000 You don't need a password. Okay. Unless you don't have that database name. User credentials. 01:23:34.000 --> 01:23:45.000 In which case, you'll have to go to plan B. Which means you need to run it on a VM, basically. 01:23:45.000 --> 01:23:56.000 For full database because You might, you know, if you go looking through all the docs on line, all you want to do is shut down My Sequel, run minus equal D safe and skip grant tables. 01:23:56.000 --> 01:24:02.000 And that will load the database with either password you went and set through password restarted. You're good to go. 01:24:02.000 --> 01:24:12.000 You got a new, password. But you can't do that in a container Because if you stop Mysql D, you kill the container. 01:24:12.000 --> 01:24:17.000 Okay. 01:24:17.000 --> 01:24:25.000 I've also tried forcing the root password as an environment variable. Are an it my sequel file. 01:24:25.000 --> 01:24:36.000 Have not had success with that so The caveat here would and my recommendation is Get the user credentials of the database you want to dump. 01:24:36.000 --> 01:24:43.000 From whoever broke it. And that'll save you a lot of work when it comes to book, you know, to restart. 01:24:43.000 --> 01:24:51.000 Good, and then you can restore. 01:24:51.000 --> 01:24:56.000 Once you're in there, dumping it's pretty easy. 01:24:56.000 --> 01:25:00.000 Okay. 01:25:00.000 --> 01:25:03.000 Here's here's a question for you. 01:25:03.000 --> 01:25:07.000 How do I? 01:25:07.000 --> 01:25:17.000 Connect 2. This dock this Docker container. My sequel 5 dot 7 that whatever. 01:25:17.000 --> 01:25:21.000 Got to use a client. My Sequel client or some other client. 01:25:21.000 --> 01:25:25.000 That's kind of a hard way, isn't it? 01:25:25.000 --> 01:25:31.000 Well, typically, or I guess the other way is you can exact into the container and use the My Sequel client built into the container. 01:25:31.000 --> 01:25:39.000 Right. 01:25:39.000 --> 01:25:45.000 You might have any questions about. What we're doing here. 01:25:45.000 --> 01:25:56.000 We're running a bash shell. In this container. By using the Docker exact. 01:25:56.000 --> 01:26:06.000 And when I do that. I have a command prompt. In the container. 01:26:06.000 --> 01:26:14.000 Yeah, I'm physically. Looking at what's inside the container. Cause here's the Docker. 01:26:14.000 --> 01:26:27.000 . The. You know, this is what the file system in the container looks like. 01:26:27.000 --> 01:26:35.000 Yeah, there are some. Remember the volume I mounted remotely? 01:26:35.000 --> 01:26:43.000 Where I live my sequel. Well, this is the physical file system. Into the Docker container. 01:26:43.000 --> 01:26:45.000 So flag go in here. 01:26:45.000 --> 01:26:51.000 Okay. Can you do a, 01:26:51.000 --> 01:27:03.000 Yeah, PS on PID one, it's gonna show batch or it's gonna show the Mysql D. 01:27:03.000 --> 01:27:10.000 There's only 3 processes running in this container. My Sequel D and bash and the PSI started. 01:27:10.000 --> 01:27:18.000 Which is a problem because you if you kill to run Mysql safe, which isn't even here. 01:27:18.000 --> 01:27:25.000 Because it's you can't use it. If you stop my sequel D, you kill the container. 01:27:25.000 --> 01:27:34.000 Cause that's all it runs in the container. 01:27:34.000 --> 01:27:42.000 Okay, what was that? Oh. 01:27:42.000 --> 01:27:49.000 You know, this is. 01:27:49.000 --> 01:27:56.000 Yeah, the actual. Files from 01:27:56.000 --> 01:28:00.000 The restor that I did, looking at the file system. 01:28:00.000 --> 01:28:05.000 Because this is actually. 01:28:05.000 --> 01:28:20.000 The that's interesting. Anyway. If I had the Password for data for a database. 01:28:20.000 --> 01:28:23.000 I could do a 01:28:23.000 --> 01:28:29.000 From inside the container. 01:28:29.000 --> 01:28:34.000 Okay, got some options here. An example. Okay. 01:28:34.000 --> 01:28:49.000 SQL dump username, password database. And. You might tell me why I need the redirect here. 01:28:49.000 --> 01:28:53.000 Does it be done at all? Go to the console. 01:28:53.000 --> 01:28:59.000 Which is because Mysql dove outputs to standard out. 01:28:59.000 --> 01:29:06.000 Which is the screen, which is the screen unless you redirect it somewhere else. Right. 01:29:06.000 --> 01:29:16.000 If you, may or may not have a space problem. In this in this particular one. 01:29:16.000 --> 01:29:23.000 We've got. 100 gig. Available in the file system. 01:29:23.000 --> 01:29:35.000 So. Yeah, I'm not even sure why it signed a hundred gig. But there's plenty of space there. 01:29:35.000 --> 01:29:44.000 So I can just, you know, to redirect that dump output to. My backup or my restore or something. 01:29:44.000 --> 01:30:00.000 If you don't have enough space, you can always add a larger volume on host. 01:30:00.000 --> 01:30:08.000 If you don't have usernames and passwords. It gets a little more complicated because you're gonna need a full version. 01:30:08.000 --> 01:30:11.000 Of my sequel. 01:30:11.000 --> 01:30:26.000 And probably the simplest way to do it this way is to. Restore the Mysql backup that you got. 01:30:26.000 --> 01:30:30.000 Alright, so in that container. 01:30:30.000 --> 01:30:44.000 I have a standard Mysql plant. 01:30:44.000 --> 01:30:54.000 Unfortunately, Since I haven't since this is I'm looking for the root password. I can't do anything. 01:30:54.000 --> 01:31:04.000 Because no matter how you try to set the root password. Oh. It doesn't work. You have to have an advance. 01:31:04.000 --> 01:31:18.000 So it's simpler, don't forget. To 01:31:18.000 --> 01:31:28.000 Use your actual database passwords. 01:31:28.000 --> 01:31:32.000 Credentials. 01:31:32.000 --> 01:31:41.000 And then you can actually. Either log into my sequel. Or you can do your Mysql top. 01:31:41.000 --> 01:31:47.000 That redirect it to a file in. 01:31:47.000 --> 01:31:55.000 In the root file system. 01:31:55.000 --> 01:32:06.000 Okay. Hello. Alright, what else? 01:32:06.000 --> 01:32:11.000 Why did you get that? Here. 01:32:11.000 --> 01:32:19.000 Because I put in dummy information. 01:32:19.000 --> 01:32:20.000 Okay. 01:32:20.000 --> 01:32:24.000 I use carrots in here because I New wasn't gonna work. Same thing up here. 01:32:24.000 --> 01:32:30.000 I thought you said the root password, when you started the Docker container, didn't you? 01:32:30.000 --> 01:32:38.000 Yeah, but it doesn't work when you use an existing. Where I live my sequel. 01:32:38.000 --> 01:32:39.000 Oh, okay. 01:32:39.000 --> 01:32:44.000 Yeah, that's what I was saying, but I don't know. I don't know what the magic combination is there. 01:32:44.000 --> 01:32:50.000 I've tried to set it when you start the container. I've tried to set it with an environment variable. 01:32:50.000 --> 01:32:57.000 I've tried to set it within it, my sequel. But nothing works. Nor does the root password work. 01:32:57.000 --> 01:33:21.000 That was valid for. You know, the existing database. You know, for example, if I go back on that machine. 01:33:21.000 --> 01:33:36.000 And I shoot out a route. 01:33:36.000 --> 01:33:45.000 Here are the list of databases on the machine. 01:33:45.000 --> 01:33:58.000 But the password here. 01:33:58.000 --> 01:34:05.000 Is this? 01:34:05.000 --> 01:34:14.000 And if I'm over here in the container. 01:34:14.000 --> 01:34:24.000 If I use that password. It's tonight. Is that because that was the password from? 01:34:24.000 --> 01:34:30.000 You know, this is the backup I. Bye, I've moved into place was banded from yesterday. 01:34:30.000 --> 01:34:42.000 And this is a password cached on that machine. But if I supply it here to. 01:34:42.000 --> 01:34:51.000 My Sequel client. And that is that is the same copy. Is it the same pace? It doesn't work. 01:34:51.000 --> 01:34:59.000 So is the. Dr. Providing a different user name. 01:34:59.000 --> 01:35:06.000 Or the my Would you be able to use that user ID? 01:35:06.000 --> 01:35:16.000 Good question. But I, in my mind, I'm thinking that The Mysql version in the container. 01:35:16.000 --> 01:35:24.000 Is is looking for credentials in the container not in the Mysql files. 01:35:24.000 --> 01:35:28.000 Right, that's what I'm saying, the docker is running. Different set of credentials. 01:35:28.000 --> 01:35:29.000 Yeah. 01:35:29.000 --> 01:35:36.000 Right. Yeah, but the question is how do I find out what those find out what their password is. 01:35:36.000 --> 01:35:43.000 There's supposed to be a password generated at the install. But I haven't found any documentation. 01:35:43.000 --> 01:35:50.000 That works in a container. That tells me how to find it. 01:35:50.000 --> 01:35:54.000 I could be wrong here, but I think that the root password is like above the data, but like it's like above the database. 01:35:54.000 --> 01:36:11.000 So you should be able to like. Imported database but still the root password should be what you Okay, so when you created the stocker container, did you do dash E My Sequel underscore root underscore password. 01:36:11.000 --> 01:36:12.000 Yep. 01:36:12.000 --> 01:36:19.000 Secret. And so now if you try to do Mysql P, or you root PP, secret. 01:36:19.000 --> 01:36:21.000 It doesn't work. 01:36:21.000 --> 01:36:25.000 Right. 01:36:25.000 --> 01:36:32.000 Okay, so I just did that and it worked fine for me, but I also didn't import anything so 01:36:32.000 --> 01:36:40.000 Yeah, that's what I'm saying. If If I was using 01:36:40.000 --> 01:36:52.000 Let's run a If I stop that version. 01:36:52.000 --> 01:36:53.000 Okay. 01:36:53.000 --> 01:36:59.000 Okay, I did not know the stop was a command for doctor. I just learned something. I always use RM dash F. 01:36:59.000 --> 01:37:01.000 Well, what good is that gonna do? You wanna stop it, not kill it. 01:37:01.000 --> 01:37:06.000 Well, I'll do both usually. 01:37:06.000 --> 01:37:11.000 And I wonder what I want her name. Oh. 01:37:11.000 --> 01:37:18.000 Do that. So I swap them. 01:37:18.000 --> 01:37:31.000 Started again. 01:37:31.000 --> 01:37:48.000 Yeah, see secret that work. 01:37:48.000 --> 01:37:51.000 Yeah. 01:37:51.000 --> 01:37:58.000 Good. Yeah, that's a good question. I was, 01:37:58.000 --> 01:38:07.000 Unfortunately, this cut part of the demo chart. Because there's about 4 ways to reset. The root password in my sequel. 01:38:07.000 --> 01:38:11.000 But not of them can be used in the container. 01:38:11.000 --> 01:38:20.000 At least not one year. Doing the file system restore like I did. 01:38:20.000 --> 01:38:27.000 Now, if you want to do the dump restore. 01:38:27.000 --> 01:38:47.000 It would probably work. 01:38:47.000 --> 01:38:52.000 Alright. 01:38:52.000 --> 01:38:58.000 Hey, my else? 01:38:58.000 --> 01:39:02.000 Well. 01:39:02.000 --> 01:39:06.000 I think I talked too fast. 01:39:06.000 --> 01:39:16.000 We really don't. We really have a solution to it then. If you don't have or if you need the root password. 01:39:16.000 --> 01:39:30.000 And you don't have it, you're gonna have to start with full version. Hello. Which is, you know, probably a VM because the only way to recover the, the root password that works. 01:39:30.000 --> 01:39:39.000 Is to shut down my SQL, run my SQL Safety, Skip Grant tables. 01:39:39.000 --> 01:39:49.000 Okay. You know, if you, even if you, if you have a sequel back or you can use it with the container. 01:39:49.000 --> 01:39:58.000 You know, just like you do otherwise. 01:39:58.000 --> 01:40:06.000 If in fact If you guys want to, we can probably. 01:40:06.000 --> 01:40:11.000 Where's my wrong command? 01:40:11.000 --> 01:40:28.000 ATM I do is the hard way. 01:40:28.000 --> 01:40:58.000 Okay, hold on a second here. Let me leave that up there. 01:41:13.000 --> 01:41:39.000 And before I do that. 01:41:39.000 --> 01:41:51.000 And. 01:41:51.000 --> 01:42:21.000 She's, a, a. 01:42:35.000 --> 01:42:46.000 Alright. 01:42:46.000 --> 01:42:47.000 Okay. 01:42:47.000 --> 01:42:55.000 Yeah, so you need the hash name, right? But you just need to change the name. So should we dash nash name and then you'll have to do some other name right like. 01:42:55.000 --> 01:42:56.000 There we go. 01:42:56.000 --> 01:43:01.000 Yeah, I missed it was 2, it was 2 dashes on the name. Yeah. Okay, so now I've got 2 running. 01:43:01.000 --> 01:43:04.000 I've got. 01:43:04.000 --> 01:43:06.000 They both have the same name. That's one's cap. 01:43:06.000 --> 01:43:22.000 No, my cap's my sequel 5 7. 01:43:22.000 --> 01:43:25.000 Yep, that works. 01:43:25.000 --> 01:43:28.000 Yep. 01:43:28.000 --> 01:43:31.000 And that's because you didn't import it. You didn't import the thing. 01:43:31.000 --> 01:43:41.000 Right, because The the first time I did it. 01:43:41.000 --> 01:43:54.000 Or for the I have done it before. Basically, or I took this. Back up. From yesterday. 01:43:54.000 --> 01:44:01.000 You know, you know, target up on the backup server. Brought it over here and blew it out. 01:44:01.000 --> 01:44:11.000 As this version here. And it works. But the root password does not work. 01:44:11.000 --> 01:44:20.000 And. The last what I've done this I did have the credentials to the individual database I want to know. 01:44:20.000 --> 01:44:30.000 So what I was saying, what other point I was making is in the presentation. If I do the Mysql dump with a username and password of the database. 01:44:30.000 --> 01:44:34.000 The dump, you know, it will authenticate. 01:44:34.000 --> 01:44:39.000 The problem is the root password won't authenticate. 01:44:39.000 --> 01:44:46.000 Yeah, and I was just testing that today and I could not find a way around it. 01:44:46.000 --> 01:44:52.000 So now that you have this one that you can log into, can't you do that whole like redirect thing into this one? 01:44:52.000 --> 01:44:55.000 Now that we have one you can log into. 01:44:55.000 --> 01:45:01.000 Hmm. As in, you're saying. 01:45:01.000 --> 01:45:05.000 Run Mysql client against that host. 01:45:05.000 --> 01:45:10.000 Are running Mysql and import the SQL backup. 01:45:10.000 --> 01:45:13.000 Yeah, the Sequel backup, the one that's like a billion 1 billion SQL statements. 01:45:13.000 --> 01:45:26.000 That's what 01:45:26.000 --> 01:45:41.000 Oh, I'm sorry. 01:45:41.000 --> 01:46:11.000 So if I take. This, I need to go out and get the other back. 01:46:25.000 --> 01:46:55.000 Current TVs. 01:46:55.000 --> 01:47:25.000 I think. 01:47:57.000 --> 01:48:05.000 You have a volume in that container that you're gonna be able to copy this SQL file into or is there no amount of volume? 01:48:05.000 --> 01:48:12.000 I was just gonna drop it into the Mysql directory. Which is already map. 01:48:12.000 --> 01:48:13.000 Yeah. 01:48:13.000 --> 01:48:21.000 Oh, sorry to map. Okay, so you got it. Great. 01:48:21.000 --> 01:48:25.000 That's interesting. 01:48:25.000 --> 01:48:32.000 Yeah. Where did, where did it go? 01:48:32.000 --> 01:48:55.000 What was the command you used to start that? Container again? Do you have it handy? 01:48:55.000 --> 01:49:08.000 Yeah, so you share data, Mysql. But where did you map that? Okay, I'm not that familiar with this, but don't you have to do like a the path colon path or not. 01:49:08.000 --> 01:49:09.000 No, okay. 01:49:09.000 --> 01:49:12.000 No. V is V is is a volume. 01:49:12.000 --> 01:49:13.000 Yeah, so where does that map on? 01:49:13.000 --> 01:49:19.000 Wait a minute, wait a minute, wait a minute, wait a minute, you're right. 01:49:19.000 --> 01:49:25.000 Does that you that you path right there that's on the host right not in the container 01:49:25.000 --> 01:49:29.000 Right. 01:49:29.000 --> 01:49:59.000 You are good catch. 01:50:07.000 --> 01:50:22.000 There. 01:50:22.000 --> 01:50:32.000 There we go. 01:50:32.000 --> 01:50:44.000 So I made a directory there. To use. 01:50:44.000 --> 01:50:47.000 And there it is. On host. 01:50:47.000 --> 01:51:17.000 Nice. 01:51:40.000 --> 01:52:03.000 Again. 01:52:03.000 --> 01:52:10.000 Now in here. 01:52:10.000 --> 01:52:32.000 I have the backup. 01:52:32.000 --> 01:52:36.000 Now the pants kick on. That way you said this is a droplet. So the 01:52:36.000 --> 01:52:37.000 Yeah. 01:52:37.000 --> 01:52:39.000 Huh. 01:52:39.000 --> 01:52:41.000 Now, but the disk light is all. 01:52:41.000 --> 01:52:47.000 Yeah. 01:52:47.000 --> 01:52:51.000 What's the smoky smell? 01:52:51.000 --> 01:52:55.000 Okay. 01:52:55.000 --> 01:52:58.000 I just want purple. Okay. 01:52:58.000 --> 01:53:01.000 On fire, printer on fire, printer on fire. 01:53:01.000 --> 01:53:05.000 Okay. 01:53:05.000 --> 01:53:06.000 He's 01:53:06.000 --> 01:53:14.000 Yeah, but believe it or not, I'm watching my CPU fan through the old floppy slot. 01:53:14.000 --> 01:53:29.000 Good I've been using these cases for 20 years and I got floppy slots in them 20 years ago. 01:53:29.000 --> 01:53:35.000 When something goes out of style, there's still a purpose for it. 01:53:35.000 --> 01:53:45.000 And I it almost looks like a A mouth up there. It does. In fact, you can look at it upside down and you got a green light, a red light. 01:53:45.000 --> 01:54:01.000 Yeah. It's artificial intelligence for the face. 01:54:01.000 --> 01:54:02.000 Hmm. 01:54:02.000 --> 01:54:05.000 Well, I have no idea how long restoring this 600 MB file is gonna take so If anybody has any questions or. 01:54:05.000 --> 01:54:09.000 Topics to yak about in the meantime feel free. 01:54:09.000 --> 01:54:17.000 Yeah, that's to be that guy, but I have something for this too. If I can share my screen for a second, I'd like to show a really cool Mysql client. 01:54:17.000 --> 01:54:19.000 Sure. 01:54:19.000 --> 01:54:25.000 I'm gonna take the screen again real quick. Over here. 01:54:25.000 --> 01:54:28.000 So this is. 01:54:28.000 --> 01:54:32.000 Okay, hopefully I can see this. 01:54:32.000 --> 01:54:35.000 Yeah, CBS code. 01:54:35.000 --> 01:54:36.000 Yeah. 01:54:36.000 --> 01:54:39.000 A lot bigger. Oh, okay there. 01:54:39.000 --> 01:54:47.000 Okay, so, there's this really cool extension and yes, it's made by Oracle, but if you could just get past that for a second. 01:54:47.000 --> 01:54:52.000 This extension is actually really cool. It's called My Sequel Shell or VS Code. 01:54:52.000 --> 01:54:59.000 And what it is, is it's like a notebook. Like if you, I know we've had a presentation before about, Jupiter notebooks. 01:54:59.000 --> 01:55:04.000 About how like you basically run commands and then you see the output in the notebook type of thing. 01:55:04.000 --> 01:55:16.000 Well, this is actually a notebook for your database. And it's really cool because it has some JavaScript built in so you can, you can create some graphs and stuff pretty easy. 01:55:16.000 --> 01:55:24.000 And I'm not like, that familiar with it, but this does like, Lauren, make me want to use my SQL instead of Postgres sometimes. 01:55:24.000 --> 01:55:29.000 So like, here's one, that I just, Here's one that I just fired up. 01:55:29.000 --> 01:55:37.000 Just while we were, while he was talking. And so I fired up on my sequel in a Docker container. 01:55:37.000 --> 01:55:46.000 And here you can see I created a table and here I'm typing in showtables here and it's and it has this nice output. 01:55:46.000 --> 01:55:56.000 Here in the notebook, if you can see that. And so a lot of times what you what you have to do is you have to do. 01:55:56.000 --> 01:56:07.000 Like data, like you have to search through databases, right? And you kind of like, it's nice to have like a record of 01:56:07.000 --> 01:56:27.000 Of like the things you did right there's a lot of times you'll want to get from one table get the primary key use that to search another table and then you want to look back like oh wait what was the other field in that first table again and so having it in like this note both layout in my opinion is super cool because it's also you can save this and give it to somebody else. 01:56:27.000 --> 01:56:30.000 And they're like, hey, how'd you track down that data issue at work? You could just literally save this off and give it to them. 01:56:30.000 --> 01:56:47.000 They see all the queries. They see all the results of all the queries and they literally have everything they need to retrace your steps for how you identified some data issue or if you were like Yeah, anyway, I think that gets the point across. 01:56:47.000 --> 01:56:56.000 But yeah, just something cool that I found a while ago where you can actually do like. Notebook style things against the Mysql database. 01:56:56.000 --> 01:57:01.000 And I guess the last part I'll say about is over here, there's this cool like browser. 01:57:01.000 --> 01:57:08.000 So like the IDB, that's the name of the database and then in here you can see the tables is users and then We can see the columns on the user table and the indexes and the foreign keys and stuff. 01:57:08.000 --> 01:57:18.000 So it's got this cool like browser thing over here too. I wish it was a little bit bigger, but. 01:57:18.000 --> 01:57:23.000 It's yeah, it looks a lot nicer than PHP my admin. 01:57:23.000 --> 01:57:31.000 Yeah, yeah. Anyway, so this is just a really cool thing. It's called, it's called Mysql shell for VS code. 01:57:31.000 --> 01:57:38.000 So just something cool to show the group while we're waiting on that import to happen. 01:57:38.000 --> 01:57:42.000 Yep, and it's still open. Nice. 01:57:42.000 --> 01:57:56.000 Very, very nice. Anybody else have a favorite Mysql tip or trick to show? 01:57:56.000 --> 01:58:02.000 Like I say, there's no progress far in in a, Mysql. 01:58:02.000 --> 01:58:09.000 Sequel. You know, processing, so. 01:58:09.000 --> 01:58:18.000 It could be done in 30 s. It could take 30 min. 01:58:18.000 --> 01:58:33.000 That's another one of those great quotes. There's no crying in baseball. There's no progress bar. 01:58:33.000 --> 01:58:45.000 I ran into a situation last month. Where I couldn't get to my backups all I could get to the raw files for the databases. 01:58:45.000 --> 01:59:03.000 I had 14 databases on the server. And 13 of them all I did. Is copy the files, to my home, And then when I rebuilt the server, my production server. 01:59:03.000 --> 01:59:18.000 I move the files back in. 13 of the 14 databases worked. One of the databases, all I could get looking at it through, PHPI, All but one table. 01:59:18.000 --> 01:59:24.000 Said in use and I couldn't do anything with it. I couldn't connect to the database. 01:59:24.000 --> 01:59:31.000 Is there something that I could have done to fix that? 01:59:31.000 --> 01:59:39.000 Did you think about grabbing the entire Mysql directory and putting it back? 01:59:39.000 --> 01:59:40.000 Oh, that's what you did. 01:59:40.000 --> 01:59:45.000 That's what I did. Yeah. 01:59:45.000 --> 01:59:51.000 Well, you could have well. 01:59:51.000 --> 01:59:57.000 So you have to catch 22 because to do anything like that you'd almost have to have a root credentials. 01:59:57.000 --> 02:00:08.000 And that is problematic with. Doing a file replacement. 02:00:08.000 --> 02:00:14.000 I did have, I copied them as route. 02:00:14.000 --> 02:00:16.000 No, I'm at in My Sequel. 02:00:16.000 --> 02:00:20.000 Yeah. 02:00:20.000 --> 02:00:29.000 What, what I did. Is I copied the files with files, it to the home server. 02:00:29.000 --> 02:00:35.000 And then when I put them back. They were all listed because I, you know, transferred him as route. 02:00:35.000 --> 02:00:47.000 They were all listed as ownership route. When I went into the individual directories. And change the information back to My Sequel, My Sequel. 02:00:47.000 --> 02:01:01.000 Owner and group They all worked. The, database for W HMCS, which is a provisioning and billing system. 02:01:01.000 --> 02:01:05.000 I couldn't get that to work. 02:01:05.000 --> 02:01:14.000 I couldn't for like a week. I could not find any information on the issue I was having. 02:01:14.000 --> 02:01:18.000 And your issue was, tables and use. 02:01:18.000 --> 02:01:28.000 Yeah. And I couldn't edit them. I couldn't get into them. 02:01:28.000 --> 02:01:32.000 I had no clue. 02:01:32.000 --> 02:01:33.000 Yes. 02:01:33.000 --> 02:01:38.000 I still have the, database. The backup that I have is 02:01:38.000 --> 02:01:48.000 It's old and missing some of the information. I was in the hospital for 28 days and didn't have access to a computer. 02:01:48.000 --> 02:01:55.000 Not that I would have had the strength to do anything, but. 02:01:55.000 --> 02:01:56.000 Good question. 02:01:56.000 --> 02:02:08.000 I know very little about this, but if the backup was taken while the database was running. There it could have been like one of these situations where it was riding to the files as it was being backed up or something. 02:02:08.000 --> 02:02:15.000 I don't know, I know very little about this, but I've heard there's something called a QES command or something like that that you can. 02:02:15.000 --> 02:02:22.000 Issue to the database and basically tell it, hey, don't write to the file for a little while because I'm taking a snapshot of it. 02:02:22.000 --> 02:02:29.000 And so like I said, I know very little about this, but that might be one possible thing. Maybe I don't. 02:02:29.000 --> 02:02:41.000 Those do databases have external lock files. 02:02:41.000 --> 02:02:47.000 The databases that I'm familiar with don't have external, the ones that I'm familiar with, I don't think they do know. 02:02:47.000 --> 02:02:48.000 Yeah, I don't think so. 02:02:48.000 --> 02:02:51.000 They're like. 02:02:51.000 --> 02:03:02.000 And this is kind of interesting. Look at what we ended up with. 02:03:02.000 --> 02:03:04.000 Good work. 02:03:04.000 --> 02:03:09.000 The command finished. 02:03:09.000 --> 02:03:18.000 And we've got 1, 2, 3, 4, 5, 6, 7. 9, 1011. 02:03:18.000 --> 02:03:28.000 Different websites on this guy. And interestingly enough, it created an empty database for the directory that had to back up in it. 02:03:28.000 --> 02:03:30.000 Yeah. 02:03:30.000 --> 02:03:39.000 What? 02:03:39.000 --> 02:03:41.000 So it mostly works. 02:03:41.000 --> 02:03:44.000 Yeah. Wow. 02:03:44.000 --> 02:03:49.000 So that's how you get every store with and the root password, right? This is the way. 02:03:49.000 --> 02:03:53.000 Right. 02:03:53.000 --> 02:03:58.000 Cool. 02:03:58.000 --> 02:04:07.000 And if you wanted to. 02:04:07.000 --> 02:04:12.000 Hey, how we need to dump right away. We need that lead database. I keep it. Yeah. 02:04:12.000 --> 02:04:25.000 Yeah. Let's see. 02:04:25.000 --> 02:04:30.000 Okay. 02:04:30.000 --> 02:04:33.000 Hey Lee, what you doing? 02:04:33.000 --> 02:04:36.000 Hey, mate. 02:04:36.000 --> 02:04:41.000 Yeah. 02:04:41.000 --> 02:04:42.000 Okay. 02:04:42.000 --> 02:04:49.000 Restore of a Mysql database. 02:04:49.000 --> 02:04:54.000 No, that didn't work. 02:04:54.000 --> 02:05:02.000 Is that an empty? 02:05:02.000 --> 02:05:09.000 Oh, wait, man. No, I put that in in the in the upper directory. 02:05:09.000 --> 02:05:18.000 Yep, there it is. 02:05:18.000 --> 02:05:19.000 Okay. 02:05:19.000 --> 02:05:22.000 There is 02:05:22.000 --> 02:05:23.000 Okay. 02:05:23.000 --> 02:05:30.000 The exact process we were talking about. 02:05:30.000 --> 02:05:41.000 I did a dump on a single database. In the from the container. After I restored it from the SQL backup. 02:05:41.000 --> 02:05:49.000 I say that file in the Mysql directory. Just because that's what was mounted from the container. 02:05:49.000 --> 02:05:52.000 And here it is. 02:05:52.000 --> 02:05:54.000 See. 02:05:54.000 --> 02:05:57.000 In that Mysql directory. 02:05:57.000 --> 02:06:03.000 Okay. Okay. 02:06:03.000 --> 02:06:08.000 I think I call it success, Gary. Yeah. 02:06:08.000 --> 02:06:09.000 Nice. 02:06:09.000 --> 02:06:12.000 Okay. 02:06:12.000 --> 02:06:32.000 No, I can, tar this up. 02:06:32.000 --> 02:06:38.000 And I have a tarball. Jack and SCP to the production server. 02:06:38.000 --> 02:06:48.000 And on a production server. I can just do the Mysql client. Drop that database. Or on, this drop the database. 02:06:48.000 --> 02:06:49.000 Okay. 02:06:49.000 --> 02:06:55.000 And running against the client to replace it with this version right here. 02:06:55.000 --> 02:07:01.000 Yeah. 02:07:01.000 --> 02:07:07.000 And by doing that, I will have restored one database. 02:07:07.000 --> 02:07:08.000 Out of everything. 02:07:08.000 --> 02:07:13.000 Okay. 02:07:13.000 --> 02:07:14.000 Okay. 02:07:14.000 --> 02:07:20.000 Interesting. Hey. 02:07:20.000 --> 02:07:25.000 Okay. 02:07:25.000 --> 02:07:35.000 They give you any ideas, Tommy, if you ever run into that problem again. Yeah, so spin up a container and just start dropping your databases into the container directory. 02:07:35.000 --> 02:07:43.000 You know, stop it and start it. And then you can, you know, play with it, play with them separately, maybe. 02:07:43.000 --> 02:07:51.000 Take that back up. Drop it into a new instance that you create. And see if it behaves any differently. 02:07:51.000 --> 02:07:59.000 If you can get it running, you can always dump it and then import it. Into your production server. 02:07:59.000 --> 02:08:10.000 Okay. 02:08:10.000 --> 02:08:11.000 Okay. 02:08:11.000 --> 02:08:16.000 Wow. Alright, anybody else? 02:08:16.000 --> 02:08:19.000 Okay. 02:08:19.000 --> 02:08:22.000 Stevie, this guy here for the credits. 02:08:22.000 --> 02:08:25.000 Ha! 02:08:25.000 --> 02:08:28.000 Well, it was a battle. 02:08:28.000 --> 02:08:31.000 You must have won it. You made it. 02:08:31.000 --> 02:08:34.000 Yeah, I made it. 02:08:34.000 --> 02:08:35.000 You watch rerun. 02:08:35.000 --> 02:08:44.000 Okay, the best quote of the night goes to Sean. If you check the, meeting chat, at 8 17. 02:08:44.000 --> 02:08:52.000 This meeting is great. Bunch of nerds, troubleshooting, watching another nerd, SCP databases, backups. 02:08:52.000 --> 02:09:04.000 Around. And leave Lee went right with it. And hey, that was the big grand finale. Getting that last backup database over there. 02:09:04.000 --> 02:09:12.000 Cool. 02:09:12.000 --> 02:09:18.000 Definitely best go to the nights. 02:09:18.000 --> 02:09:26.000 A little close runner up was I just gave free goodwill. I can just get goodwill 3 cases with floppy drive slots. 02:09:26.000 --> 02:09:29.000 Thank you, Yeah. 02:09:29.000 --> 02:09:35.000 Earth is good. We'll do those. 02:09:35.000 --> 02:09:40.000 Wonderful fish aquariums. 02:09:40.000 --> 02:09:41.000 Say what? 02:09:41.000 --> 02:09:46.000 Now, 2 of them, the one of the kids that, was taking the drop off said he was taking him. 02:09:46.000 --> 02:09:52.000 Oh 02:09:52.000 --> 02:09:57.000 Floppy drives or discs. 02:09:57.000 --> 02:10:06.000 The case. I switched over at all rack cases. 02:10:06.000 --> 02:10:08.000 Okay. 02:10:08.000 --> 02:10:10.000 I don't know. 02:10:10.000 --> 02:10:15.000 Not sure why anybody want them. Okay. 02:10:15.000 --> 02:10:28.000 I don't know why he'd want to meet her because Here's my cases. Shoot. 02:10:28.000 --> 02:10:29.000 Okay. 02:10:29.000 --> 02:10:33.000 Let me kill the background. Here's my cases. 02:10:33.000 --> 02:10:36.000 Say look at raspberry. 02:10:36.000 --> 02:10:42.000 They are. These are servers in the background. I got dozen of them. 02:10:42.000 --> 02:10:43.000 Cool. 02:10:43.000 --> 02:10:48.000 You use a heck of a lot less power than anything in a rack or a server. 02:10:48.000 --> 02:10:57.000 One rack mounted here that. Chuck left. Sucker weighs 60 pounds. 02:10:57.000 --> 02:10:58.000 Yeah. 02:10:58.000 --> 02:11:07.000 And. I have an, we measured the current draw on it, but. I think it must be 2 or 3 horsepower. 02:11:07.000 --> 02:11:08.000 Oh yeah. 02:11:08.000 --> 02:11:11.000 Just to generate the noise. 02:11:11.000 --> 02:11:16.000 I thought this why I thought that's why you wanted to warm the basement up in the winter time. 02:11:16.000 --> 02:11:20.000 No. 02:11:20.000 --> 02:11:42.000 It's fine down here in the winter. 02:11:42.000 --> 02:11:49.000 I had a question about, does anybody else use Butterfs rate one? 02:11:49.000 --> 02:11:58.000 Or has anybody else tried to use Butterfs and RAID one? In the, you know, recently. 02:11:58.000 --> 02:12:05.000 I don't know why you, you know, the only thing rate one is good for striping for swap. 02:12:05.000 --> 02:12:11.000 No, it's mirror in, right? I think one's mirroring. 02:12:11.000 --> 02:12:12.000 Well. 02:12:12.000 --> 02:12:25.000 Cause so what I what I what I research this if you put them in rate one That's mirroring and If One Drive tops, you can still access the data in the Butterfest file system. 02:12:25.000 --> 02:12:32.000 Cause it'll still work and give you So it's like a it's like a redundancy thing. 02:12:32.000 --> 02:12:35.000 Well, you have a default to read only mode. 02:12:35.000 --> 02:12:36.000 Does it? 02:12:36.000 --> 02:12:45.000 Yeah. In fact, if you lose one. Well, of a rate one, the file system will go read only or should. 02:12:45.000 --> 02:12:51.000 Oh, I think that's, but is that what Butterfest does or is that what like software rate does or hardware rates. 02:12:51.000 --> 02:12:58.000 I think My understanding was better off specifically and ZFS 2 actually both Butterfs and CFS would. 02:12:58.000 --> 02:13:09.000 Allow you to still read and write data to the working drive. Even though you had one disc out. 02:13:09.000 --> 02:13:21.000 I never use Raid one. Because there's no reason to. Yeah, yeah, the only rate worth doing is rate 6. 02:13:21.000 --> 02:13:30.000 Cause you put in, you know, 4, 4 TB drive, she got. Hey, If what if one disk dies. 02:13:30.000 --> 02:13:36.000 You, you know it, but you keep on trucking. Basically, you got rate 5 at that point. 02:13:36.000 --> 02:13:44.000 If the second disk dies, the ray will go read only. But as soon as you reactivate that third disc. 02:13:44.000 --> 02:13:52.000 You're back in business. 02:13:52.000 --> 02:13:53.000 Yeah. 02:13:53.000 --> 02:13:57.000 Yeah. But I only have 2 disks, so I can't really do that. Cause this is just for like my little home, my little home. 02:13:57.000 --> 02:13:58.000 Yeah. Yeah. 02:13:58.000 --> 02:14:03.000 Lab thing, you know? So I have 2 discs, so I can't do rate. I think I can only do right one. 02:14:03.000 --> 02:14:04.000 True, true. 02:14:04.000 --> 02:14:10.000 And anyway, I was just wondering if anybody else, cause I've heard horror stories about VTR FS. 02:14:10.000 --> 02:14:22.000 From the old days but I've also heard it's gotten a lot better and this is all just here say so I've never tried it myself so I guess I'm gonna do the experiment and I'll let you know how it goes. 02:14:22.000 --> 02:14:27.000 Okay, do I smell a presentation? Yeah. 02:14:27.000 --> 02:14:28.000 I think you 02:14:28.000 --> 02:14:35.000 Maybe, I don't know. I keep, I keep switching around what I'm doing so much that it's hard for me to stick to anything long enough. 02:14:35.000 --> 02:14:39.000 To get that deep on it. We'll see. 02:14:39.000 --> 02:14:44.000 Well, as soon as you get some interesting, put a note on your keyboard, do not change. 02:14:44.000 --> 02:14:48.000 And then we'll do, you'll do a presentation the next month. 02:14:48.000 --> 02:14:50.000 How about that? 02:14:50.000 --> 02:14:57.000 Yup. Yeah, I'm definitely interested in better FS like, like using it as grade one and then also doing the send receive stuff. 02:14:57.000 --> 02:15:08.000 Seems pretty interesting to like. Taking a snapshot sending it off site you know. We'll see. 02:15:08.000 --> 02:15:14.000 So are a lot of people still. Is better office still. 02:15:14.000 --> 02:15:23.000 Yeah, you know, climbing the peak there or is it as a peaked or? It seems like, people are migrating to ZFS nowadays. 02:15:23.000 --> 02:15:31.000 Well, but our f has been the default root file system on Sussi for about 5 years. 02:15:31.000 --> 02:15:38.000 One of the red hats is drop it, I think, right? In favor of CFS or in favor of 02:15:38.000 --> 02:15:42.000 . I think 02:15:42.000 --> 02:15:55.000 Like XFS doesn't have any fancy stuff like CFS or, XFS is just a very, robust, extensible file system. 02:15:55.000 --> 02:16:04.000 Yeah, the problem with ZFS is it's not in the kernel. So then you have to have a DKMS module and I've had bad luck with those in the past. 02:16:04.000 --> 02:16:05.000 Yeah. 02:16:05.000 --> 02:16:17.000 You know, I don't know. And I've heard, I've heard people having problems even recently where, oh, I updated my kernel and now the DKMS module didn't load and now I'm you know having to rescue my system. 02:16:17.000 --> 02:16:30.000 So, I don't know, for me, I'm just, I'd rather go with better FS, even though it's like a less battle tested file system, at least it's built into the kernel and I don't have to deal with TCMS. 02:16:30.000 --> 02:16:40.000 At being a Sussi fan, II would argue that Susie gives it plenty of animal testing. 02:16:40.000 --> 02:16:41.000 Yeah. 02:16:41.000 --> 02:16:46.000 That's true, but not in rate one, right? Hmm. 02:16:46.000 --> 02:16:56.000 Well, tell you what, do you have a standard chassis? 02:16:56.000 --> 02:16:57.000 Yeah, I know. 02:16:57.000 --> 02:17:00.000 No, I actually I have an outroid which is like a little it's like a raspberry pi size thing but it's actually okay you know about the yeah 02:17:00.000 --> 02:17:03.000 Yeah, in fact, I've got one. I'm in the back. That's my. 02:17:03.000 --> 02:17:10.000 Mail 0. No, because I had to have 4 giga memory to run spam assassin. 02:17:10.000 --> 02:17:26.000 Hmm. Or I wanted it because I got 3 mail servers using it. 02:17:26.000 --> 02:17:37.000 Yeah, I'd be interested in following what you're doing, Sean, because I've been a suite and for 20 years and I like to. 02:17:37.000 --> 02:17:38.000 Yeah. 02:17:38.000 --> 02:17:43.000 See what you can do with them. In fact, Sushi has an ARM. 64 distro does drop that on your 02:17:43.000 --> 02:17:50.000 Well, that's the thing about the O. It's actually X. 64. 02:17:50.000 --> 02:17:51.000 Oh, okay. 02:17:51.000 --> 02:17:57.000 So I got a Ojoid H 3. Which is actually x 86 board it's an intel 02:17:57.000 --> 02:18:08.000 And then it also it has to say the spots and the m dot 2 spot so my thought is I'm gonna install Butterfs on the M dot 2 as the basically the OS drive. 02:18:08.000 --> 02:18:15.000 And with that, I can do like snapshots and I can use snapper to like do. 02:18:15.000 --> 02:18:16.000 Yeah. 02:18:16.000 --> 02:18:22.000 Like roll backs so my My ideal setup would be basically what Sue has, but it's like really hard to set up if you're not on. 02:18:22.000 --> 02:18:25.000 I'm learning. It's like not easy to do that. 02:18:25.000 --> 02:18:36.000 Oh, I mean, there's 2 3 reasons I've been using S for 20 years. Number one, I got paid to teach it 20 years ago, so I learned it well. 02:18:36.000 --> 02:18:51.000 Number 2, it has the best tools in the marketplace. One of them is called gas. It's you know admin tool if you can run in in a shell so I can sheld any one of our boxes anywhere in the world and admin to box. 02:18:51.000 --> 02:19:02.000 And it has some neat stuff in it. And the third one is, licensed in Europe, which means There's no political pork or DRM issues. 02:19:02.000 --> 02:19:12.000 Unless you want. 02:19:12.000 --> 02:19:15.000 Hey, Lee, I gotta a suggestion. 02:19:15.000 --> 02:19:17.000 Shoot. 02:19:17.000 --> 02:19:25.000 Why don't you? Set up a presentation. 02:19:25.000 --> 02:19:34.000 Hi, my cursor back here. Why don't you set up a presentation and 02:19:34.000 --> 02:19:40.000 Teaches how to, you know, install and set up a system. How about now? 02:19:40.000 --> 02:19:50.000 I did, 10 years ago. Part 2, I hear a part too. 02:19:50.000 --> 02:19:51.000 10 min warning. 02:19:51.000 --> 02:19:52.000 I don't think I was here. 02:19:52.000 --> 02:19:56.000 Oh shit, maybe. I might do it on raspberry pi if you ask me nicely. 02:19:56.000 --> 02:19:57.000 10 min warning. 02:19:57.000 --> 02:20:03.000 That'd be fine. I mean, Susser runs the same everywhere. 02:20:03.000 --> 02:20:06.000 Yeah. 02:20:06.000 --> 02:20:11.000 No, I think one of the one of my problems with, I've got a machine that runs it. 02:20:11.000 --> 02:20:18.000 One of my problems is I really don't properly understand how to use yes. 02:20:18.000 --> 02:20:19.000 At least I don't think I do. 02:20:19.000 --> 02:20:24.000 You, type, yes, on your keyboard and hit enter. 02:20:24.000 --> 02:20:25.000 Yeah, I got that part of it down, Pat. 02:20:25.000 --> 02:20:30.000 Yeah. 02:20:30.000 --> 02:20:31.000 Smart ass. 02:20:31.000 --> 02:20:36.000 It's end curses. You hold your all key down and hit the letter of whatever's highlighted. 02:20:36.000 --> 02:20:41.000 Those your shortcut keys. 02:20:41.000 --> 02:20:51.000 Does yes actually output the commands that it's issuing because for me II guess it's just me being a, now, but I don't like magic and to me, yes. 02:20:51.000 --> 02:20:55.000 Feels a little bit like magic. Like, oh, it's doing something. II don't know. 02:20:55.000 --> 02:20:57.000 Under the hood was doing, I'm not sure, but it's doing something. 02:20:57.000 --> 02:21:04.000 Well, it, all, all, yes does, it used to be written in rails. I'm not sure what they use now. 02:21:04.000 --> 02:21:20.000 Or Ruby rather, but it basically parses the config files on your system. Organize them in, Let you edit them and then writes them back. 02:21:20.000 --> 02:21:30.000 And you know, it's only for the basic stuff. 02:21:30.000 --> 02:21:38.000 Hello, like to me and this is probably just like a anecdotal thing but every time I put S on my laptop it just feels slower. 02:21:38.000 --> 02:21:46.000 Slow that all the other distros. I know it's probably just like a anecdotal perception me thing, but that's just how it feels. 02:21:46.000 --> 02:21:54.000 And so it doesn't feel as snappy as something like fedora or arch to me. 02:21:54.000 --> 02:21:55.000 Yeah. 02:21:55.000 --> 02:21:58.000 I never heard anybody call the Dora snappy. 02:21:58.000 --> 02:22:15.000 Okay, the only real differences I've seen or window manager. You know, if you run ISWM or something like that, yeah, it's gonna run look at a split because you There's no, functionality there in the window manage other than putting up a window for you. 02:22:15.000 --> 02:22:22.000 But I like Gnome because I've gotten used to it. 02:22:22.000 --> 02:22:31.000 Yeah, I like them too. Did you see that article, recently about how they're planning to change Gnome a little bit and like a for our future release. 02:22:31.000 --> 02:22:36.000 Well, they're already working on Wayland. To me that's a solution looking for a problem. 02:22:36.000 --> 02:22:44.000 But it's getting a lot better than I was 4 or 5 years ago. I tried it a couple times and so much stuff didn't work. 02:22:44.000 --> 02:22:49.000 You know, basically threw it away. 02:22:49.000 --> 02:22:50.000 There you go. 02:22:50.000 --> 02:23:02.000 For those that are new here, a 10 min warning was to remind us that when we were doing live meetings, sometimes the restaurant would throw us out at 90'clock or The libraries would close at 9. 02:23:02.000 --> 02:23:12.000 We don't have to close here, but. We can keep going. 02:23:12.000 --> 02:23:13.000 Those are. 02:23:13.000 --> 02:23:16.000 You're gonna keep recording. 02:23:16.000 --> 02:23:19.000 It's 02:23:19.000 --> 02:23:20.000 Sure. 02:23:20.000 --> 02:23:24.000 Yeah, we'll appreciate the recording off at 90'clock. Sean, one thing in Susie, you might want to look at is Michael OS. 02:23:24.000 --> 02:23:41.000 Micro OS. It is the new edge. Operating system designed to be immutable. And that's theoretically what you want to run on your PIs and your odorids and things like that because if they blow up. 02:23:41.000 --> 02:23:47.000 You know, there's no change that's cached on a local machine unless you let it. 02:23:47.000 --> 02:23:54.000 When you say edge, does that mean it's a kernel that has Newer drivers in it and that kind of thing. 02:23:54.000 --> 02:24:11.000 Probably. But it is designed for Edge computing in the industry is. A term referring to purpose built machines out on the edge of the network doing stuff and you know for reality for real. 02:24:11.000 --> 02:24:20.000 You know, like, IoT stuff is a good example. All that kind of stuff. 02:24:20.000 --> 02:24:30.000 Those are edge devices. Where a server devices are no big are the ones inside or possibly out in the data center somewhere in the cloud. 02:24:30.000 --> 02:24:32.000 Okay. 02:24:32.000 --> 02:24:43.000 The other the other distinction with edge computers is you don't have You never have a You might have some kind of user interface with push buttons or something, but that's it. 02:24:43.000 --> 02:24:49.000 It's not general purpose. You're never running a word processor or a spreadsheet on or an email. 02:24:49.000 --> 02:25:01.000 Do we? 02:25:01.000 --> 02:25:12.000 Let me ask Steve for a minute here. I'll give you a quick run through on. Yeah. 02:25:12.000 --> 02:25:19.000 You know, the ones I use are system and network settings, that's the biggie. 02:25:19.000 --> 02:25:29.000 And if you see that green bar going across the bottom. Alright, shoot, I'm run a network manager on this. 02:25:29.000 --> 02:25:34.000 Basically this goes out there and reads all the config files. 02:25:34.000 --> 02:25:43.000 Although this is a workstation and I'm using network manager. So that I've got the GUI window. 02:25:43.000 --> 02:25:48.000 In fact, let me share the rest of my screen. 02:25:48.000 --> 02:25:55.000 Okay. 02:25:55.000 --> 02:26:01.000 Okay. Take care. Okay. 02:26:01.000 --> 02:26:07.000 See the pop up pop down here in the top right corner. 02:26:07.000 --> 02:26:19.000 Notice that I have. Configurations here for Ethernet and USB internet. The fact that I can manage them here in the GUI. 02:26:19.000 --> 02:26:26.000 Is why wicked is running on the machine. 02:26:26.000 --> 02:26:37.000 So the wicked network controller over here. And he asked. If I go to global options. Notice the G is highlighted here. 02:26:37.000 --> 02:26:42.000 It's a shortcut key. I had all G, it goes to global. 02:26:42.000 --> 02:26:47.000 But I can find the G. 02:26:47.000 --> 02:26:55.000 Hi, should your network manager or 02:26:55.000 --> 02:26:59.000 And somewhere on a mouse here. 02:26:59.000 --> 02:27:03.000 Can't use a mouse. Can you? 02:27:03.000 --> 02:27:14.000 Not really, but I can't. There. Yeah, you're right. You know, wicked is the system configuration tool, network manager. 02:27:14.000 --> 02:27:19.000 Is a user configuration tool. 02:27:19.000 --> 02:27:33.000 So since since I'm running. Use your tools. I run a network manager like you are on a laptop. 02:27:33.000 --> 02:27:41.000 Okay. Okay. 02:27:41.000 --> 02:27:48.000 I'm damn. Oh name routing. 02:27:48.000 --> 02:27:52.000 I don't know why it won't stay on the overview page. 02:27:52.000 --> 02:28:00.000 Which you can see what's behind it. These are where you configure your adapters. 02:28:00.000 --> 02:28:06.000 But some of the others, you know, here's, I hear, this practitioner. 02:28:06.000 --> 02:28:14.000 Okay. 02:28:14.000 --> 02:28:18.000 Yeah, I've got it. 02:28:18.000 --> 02:28:24.000 I do have one on this guy. 02:28:24.000 --> 02:28:29.000 Okay. 02:28:29.000 --> 02:28:36.000 Yeah, here's my butter FS partition, which is a root device. 02:28:36.000 --> 02:28:42.000 What else do we have here? 02:28:42.000 --> 02:28:47.000 Got 3 hard dis in here, A and B or the 2. 02:28:47.000 --> 02:28:51.000 Just system drives. 02:28:51.000 --> 02:28:57.000 You know, A and A and C is the 2 system drives. 02:28:57.000 --> 02:29:09.000 SSDs internally. Sdb is a 2 TB. Disc on a partition where I keep all the rest of the craft I'm using. 02:29:09.000 --> 02:29:12.000 Okay. 02:29:12.000 --> 02:29:20.000 What else? Users. Here's how you can do firewall. 02:29:20.000 --> 02:29:27.000 Here's got a GUI that reads all the files. 02:29:27.000 --> 02:29:39.000 Got your devices and the zones. So Ethernet 0. Is in the internal zone. 02:29:39.000 --> 02:29:48.000 And internal zone has. This configuration. It allows. I've got Samba running on here. 02:29:48.000 --> 02:29:55.000 So I need. Shamba and MDNS and SSH. 02:29:55.000 --> 02:30:02.000 Here's your trivia question for you. If you run SSH on a non-standard court. 02:30:02.000 --> 02:30:13.000 How do you tell the firewall? To allow that for. In a way that won't change when you update the system. 02:30:13.000 --> 02:30:18.000 I have no idea. 02:30:18.000 --> 02:30:23.000 Because your standard files. 02:30:23.000 --> 02:30:27.000 Okay. 02:30:27.000 --> 02:30:35.000 Yeah, there's a There's all kinds of firewall stuff. 02:30:35.000 --> 02:30:38.000 Scattered all over the system. 02:30:38.000 --> 02:30:58.000 Let's see. 02:30:58.000 --> 02:31:02.000 Use your share. 02:31:02.000 --> 02:31:11.000 Hey, they're scandal or system, but the point I was making is There is one place to put. 02:31:11.000 --> 02:31:24.000 A firewall. Rule. 02:31:24.000 --> 02:31:32.000 Etsy fire all these services. So if you want SSH to understand non-standard port. 02:31:32.000 --> 02:31:42.000 You put antsy firewall D services. And it will it will never get changed. Because the system updates. 02:31:42.000 --> 02:32:02.000 Always update. Things that are not in. At sea fire all these services. 02:32:02.000 --> 02:32:03.000 Okay. 02:32:03.000 --> 02:32:10.000 I used to drive me fruit 10 years ago because I basically make SSH. Is over in User lip fire OLD services. 02:32:10.000 --> 02:32:17.000 I change my port number. And I and I chatter this thing, So the system can change it. 02:32:17.000 --> 02:32:22.000 But then every time I did an update, I'd have to set it back to. Yeah. 02:32:22.000 --> 02:32:26.000 Yeah, I could see that. 02:32:26.000 --> 02:32:30.000 So that's why you put it in Etsy Fire, all these services. 02:32:30.000 --> 02:32:36.000 Because this will get even if it's not changed. An update will try to rewrite it. 02:32:36.000 --> 02:32:45.000 So if you've changed that, you're gonna lose it. That's why you put it over here. 02:32:45.000 --> 02:32:59.000 Nice. 02:32:59.000 --> 02:33:04.000 It's after 9, the library is closed. 02:33:04.000 --> 02:33:08.000 I recommend we stop the recording. 02:33:08.000 --> 02:33:11.000 Why is your disc full? 02:33:11.000 --> 02:33:12.000 No, at least. 02:33:12.000 --> 02:33:15.000 No, but to do that, I gotta find the button. 02:33:15.000 --> 02:33:18.000 Yeah. 02:33:18.000 --> 02:33:26.000 Gary, you want to close it? This has been the August, 2023 general meeting. 02:33:26.000 --> 02:33:34.000 Of the St. Louis, this is Wednesday, August 20, Wednesday, August. 02:33:34.000 --> 02:33:50.000 9, 2023. And the main speaker tonight has been Lee Lammert from Omni-tech who is a great benefactor and sponsor of Lee is also the treasure of the organization. 02:33:50.000 --> 02:34:02.000 And frequent presenter. Thank you very much, Lee. And, before that we had Stan Ricard doing talk on, them side by side. 02:34:02.000 --> 02:34:12.000 Great little handy tool and then and that was a really good talk we enjoyed it so with that, thank you all very much for coming. 02:34:12.000 --> 02:34:19.000 Next Thursday night is the, St. Louis Linux user group meeting. The topic is new shell. 02:34:19.000 --> 02:34:26.000 And all I know about that so far is you show allows you to put out something other than text. 02:34:26.000 --> 02:34:29.000 From 02:34:29.000 --> 02:34:30.000 What you're doing in Shell. So like I said, I don't know much about it. 02:34:30.000 --> 02:34:35.000 So we'll have an abstract. Out there, hopefully tomorrow. And, so look on the calendar. 02:34:35.000 --> 02:34:48.000 Or look on the, website. We'll get it out there and meet up eventually as well. 02:34:35.000 --> 02:34:48.000 But,