‫All right, guys, so the domain still isn't set up.
‫So we're still waiting on that.
‫But we're going to proceed to import the database.
‫So in the last video we exported a dot SQL file.
‫So now we're going to go to back to our panel control panel and hosting our and we're going to go to
‫databases and then management.
‫And we're going to create a new database to import our data into.
‫Now when we create a database we give it a name username password.
‫The name and username will be prefixed with this right here.
‫And your your ID will be different.
‫But I'm just going to call this work Opia.
‫So it'll actually be called this underscore work Opia.
‫And then for the username let's do, we'll just do deploy again just like we did in development.
‫But we'll have this before it.
‫And then password F123.
‫All right.
‫Let me just write that down somewhere else.
‫So I remember it.
‫All right.
‫So let's click create.
‫So it says database created successfully.
‫And now down here you'll see we have a link to go to phpMyAdmin which is a web interface to manage our
‫database.
‫So I'm going to click that.
‫Now from here you can create tables, you can create columns.
‫Pretty much anything you can do in workbench, but you can do it from this web interface.
‫And if you wanted to redo everything, recreate the tables, insert the data you can, but importing
‫exporting it from workbench and importing it through here is a much easier way to get set up for production.
‫So what we can do is go to import and notice that the database name is a bit different.
‫So it has these characters before it.
‫So you're going to want to grab that.
‫So I'm just going to bring over that SQL file in Sublime Text.
‫And there's just a couple of things that we're going to want to change here.
‫So first off is the database.
‫So just make sure that whatever you have here you put on this line.
‫So where we where we're creating it, if it exists as well as this line where we're using it.
‫Okay.
‫In addition to that.
‫I got an error with this coalition right here.
‫So to fix that, we're just going to change this from this.
‫What is it, UTF eight MDB four and then zero 900.
‫We're going to change that to UTF eight me for underscore and then general.
‫Underscore CI.
‫And we're going to do the same with this one down here.
‫So it'll be just underscore general underscore CI.
‫So save that.
‫And now we can try to import that.
‫So let's go back to import.
‫Let's choose the file we're Copiar SQL.
‫We can leave all the defaults here.
‫Let's click import.
‫And we get a bunch of checks which is a good sign.
‫And now if we look at our database we have listings.
‫And if we look in listings all the data is there okay.
‫If we look in users we have our users there as well.
‫So our database is in the same state right now as it is on our local machine.
‫So in the next video we want to get our files onto the server now that we have our database set up.