1 00:00:00,540 --> 00:00:07,270 Now that the entire project is complete we can upload it to our live production server to do so. 2 00:00:07,330 --> 00:00:10,000 Log into your land no dot com hosting account 3 00:00:16,030 --> 00:00:22,790 click on the myelin node server and click the boot button to start the server. 4 00:00:22,790 --> 00:00:24,050 If it's not already running 5 00:00:28,710 --> 00:00:36,570 now we'll just need to give this about a minute or so now that the server is running we'll need to open 6 00:00:36,570 --> 00:00:44,070 files Zilla with files Zilla open go to file site manager and click on the myelin node entry and click 7 00:00:44,070 --> 00:00:47,750 connect enter your passphrase 8 00:00:51,660 --> 00:00:56,820 now on our server we'll need to navigate to the HMO directory. 9 00:00:56,820 --> 00:01:01,800 So this is the path to the HMO directory and click enter. 10 00:01:01,800 --> 00:01:06,210 You may have a couple of files in your HMO directory you can go ahead and delete those 11 00:01:11,660 --> 00:01:13,360 now on your local machine. 12 00:01:13,370 --> 00:01:18,710 You're going to have to open the perfect cup directory in your web root folder. 13 00:01:18,710 --> 00:01:26,060 So this is the path to mine and I'm going to highlight all the files so you can click the first one 14 00:01:26,060 --> 00:01:32,690 and then hold shift and click the last file that'll highlight all of them and drag them over to your 15 00:01:32,690 --> 00:01:34,690 server and the upload will begin 16 00:01:42,700 --> 00:01:51,510 and once the upload is complete we'll go ahead and test to make sure that it's working. 17 00:01:52,630 --> 00:01:55,600 So in your web browser type in your domain name 18 00:02:00,780 --> 00:02:07,370 and at the end of the domain name just type in slash index dot BHP. 19 00:02:07,470 --> 00:02:09,420 So as you can see the web page is loaded 20 00:02:20,410 --> 00:02:22,390 and everything appears to be working correctly. 21 00:02:22,420 --> 00:02:28,150 If you haven't registered a domain name you'll have to use the IP address of your server to get the 22 00:02:28,150 --> 00:02:30,210 IP address go back to the node. 23 00:02:30,460 --> 00:02:38,560 Click on the link nodes tab and you can copy the IP address corresponding to the Miwa node server over 24 00:02:38,560 --> 00:02:39,380 here. 25 00:02:41,050 --> 00:02:47,320 So remember that your IP would obviously be different than mine and you'll see it brings up the same 26 00:02:47,500 --> 00:02:47,950 page 27 00:02:51,670 --> 00:02:52,750 when we click on blog. 28 00:02:52,750 --> 00:02:56,040 We have the logging and registration page. 29 00:02:56,170 --> 00:03:01,900 Now we won't be able to register new users because we haven't imported the database onto our production 30 00:03:01,900 --> 00:03:02,940 server. 31 00:03:03,070 --> 00:03:11,170 So that's the next thing we'll need to do so we'll need to log in to BHP my admin on our server. 32 00:03:11,190 --> 00:03:12,950 So just typing in my admin 33 00:03:17,250 --> 00:03:19,830 and then log in is the route user and enter your password. 34 00:03:23,400 --> 00:03:30,090 We'll need to create the perfect cup database on our production server before we import our members 35 00:03:30,090 --> 00:03:38,750 table so I'll just go ahead and click on the database tab. 36 00:03:38,760 --> 00:03:50,780 Now we're gonna type in perfect cup and choose UTF 8 Unicode S.I. is the collation 37 00:03:54,520 --> 00:04:00,430 now click on the perfect cup database on the left column next open. 38 00:04:00,550 --> 00:04:08,370 P My admin on your local machine and this will be done to the web or map menu BHP my admin 39 00:04:11,900 --> 00:04:17,970 click on the perfect cop database on the left column and could be export button. 40 00:04:20,780 --> 00:04:22,880 Just leave the default settings and click go 41 00:04:28,710 --> 00:04:30,420 and now open the text file 42 00:04:34,490 --> 00:04:41,020 copy all the content in the text file so right click and hit copy. 43 00:04:41,110 --> 00:04:51,980 Now go back to the production server P HP my admin and click the import button or sorry click the Eskew 44 00:04:51,980 --> 00:04:59,750 o button because we're gonna just paste the ESC you will into this text area so right click and hit 45 00:04:59,750 --> 00:05:09,940 paste and then click go now click on the perfect cup database again and you'll see we have the members 46 00:05:09,940 --> 00:05:17,450 table with the same with the test accounts we'd already created another database as it has been imported 47 00:05:18,050 --> 00:05:28,090 now we'll need to update the database connection string on a few of our HP pages so on the P check dot 48 00:05:28,270 --> 00:05:37,780 HP page just plug in the password for your production server for your production my est server and do 49 00:05:37,780 --> 00:05:39,760 the same for add user 50 00:05:43,320 --> 00:05:45,480 and send a message that BHP 51 00:05:49,010 --> 00:05:53,060 okay will need to re upload these pages so just go back to files Zilla 52 00:05:57,400 --> 00:06:04,840 and just please make sure you have saved the changes so once you inserted your password for your production 53 00:06:05,110 --> 00:06:07,900 server make sure you save the changes 54 00:06:12,220 --> 00:06:23,590 now in file Zilla we're going to re upload P check the IP HP send a message IP HP and add user dot BHP 55 00:06:28,830 --> 00:06:32,370 you're going to be asked if you want to overwrite the existing files. 56 00:06:32,370 --> 00:06:33,270 Just click OK 57 00:06:37,150 --> 00:06:38,710 and now they've been overwritten 58 00:06:42,410 --> 00:06:49,210 so that's an important consideration when you're testing your web page on your local machine. 59 00:06:49,250 --> 00:06:56,990 You typically won't have a password for your to connect to your database but of course on your production 60 00:06:56,990 --> 00:07:03,760 server security is very important and you will need to enter the password. 61 00:07:03,920 --> 00:07:08,380 So because we've entered a password here this will no longer work on our local machine. 62 00:07:08,390 --> 00:07:12,870 So when you're testing on your local machine remove the password to make this more efficient. 63 00:07:12,890 --> 00:07:21,410 You can also cut your connection string out of each document and put it into an external file and then 64 00:07:21,410 --> 00:07:27,780 use the p p require statement to included in each document you want to. 65 00:07:27,930 --> 00:07:30,410 That requires a database connection. 66 00:07:30,410 --> 00:07:32,560 But for now we'll just leave it as is. 67 00:07:32,630 --> 00:07:32,830 OK. 68 00:07:32,840 --> 00:07:36,970 So now we'll just pull the Web site backup 69 00:07:48,030 --> 00:07:55,820 and we'll click on the blog or register a new user to make sure that the registration page is working 70 00:07:55,820 --> 00:07:57,200 and connecting with our database 71 00:08:09,550 --> 00:08:11,140 so the account was processed. 72 00:08:11,140 --> 00:08:18,180 Let's go back to our database and make sure the record was added so there is Sarah Smith Sarah G.M. 73 00:08:18,180 --> 00:08:18,960 dot com. 74 00:08:19,020 --> 00:08:30,850 The encrypted password and now we'll log in so I'll go to the blog since we just registered we're automatically 75 00:08:30,850 --> 00:08:31,900 already logged in. 76 00:08:31,900 --> 00:08:34,550 Remember that the session variables were activated. 77 00:08:34,660 --> 00:08:39,170 So I'm going to click the log out button click on the blog again. 78 00:08:39,310 --> 00:08:40,840 And now it's asking me to log in 79 00:08:50,470 --> 00:08:55,950 so everything is working click on the contact form and just send a test. 80 00:08:55,940 --> 00:08:56,250 Email 81 00:09:07,120 --> 00:09:09,510 and we can see that the message has been sent. 82 00:09:09,530 --> 00:09:12,050 So this completes the project. 83 00:09:12,050 --> 00:09:18,770 You can go through the web page and just make sure that everything is working correctly once you've 84 00:09:18,770 --> 00:09:23,040 finished you can close the files in your text editor. 85 00:09:23,060 --> 00:09:25,920 So we have quite a bit of things open here. 86 00:09:26,000 --> 00:09:29,260 You can go ahead and close all this down make sure you've saved all your files 87 00:09:39,640 --> 00:09:48,210 going to close down this web page closed down the BHP my admin on our local machine BHP my admin on 88 00:09:48,210 --> 00:09:51,960 our server log out of your LAN node. 89 00:09:52,840 --> 00:09:54,630 Oh sorry before you log out. 90 00:09:54,630 --> 00:09:57,990 Make sure that you turn the server off. 91 00:09:57,990 --> 00:10:00,090 This is assuming you finished testing the page 92 00:10:03,170 --> 00:10:06,920 because you remember that your build whenever your server is running. 93 00:10:07,130 --> 00:10:12,590 So we just had it on for a couple of minutes. 94 00:10:12,740 --> 00:10:18,270 Make sure that you do wait until the system shut down shows a success alert 95 00:10:32,180 --> 00:10:41,030 now that the server has been shut down and went to log out of the node goes down the browser and that's 96 00:10:41,030 --> 00:10:41,180 it. 97 00:10:41,180 --> 00:10:44,510 So hopefully you enjoyed the project and we'll see you in the next lesson.