To modify a database click on the database name in the left column under the structure tab.
We can modify any tables inside the database.
We can also create new tables by entering the table name and the number of columns we'd like to start
with.
Much of this area we've already worked with before in the Eskew will tab we can execute as well commands
to our database we'll explore Eskew well in much more detail later in this course
under this search tab we can search for words or values in specified tables or columns to do so enter
this search term
specify the search criteria.
In this case we'll select the first option at least one of the words selected table you want to search.
You can also specify the column if you'd like to we'll leave it at you at the table name and the go
button to start the search so you can see that it brought back one result and if I could the browse
button can see that it found one record with the value Ted inside one of the columns
we can export a database under the export tab.
To do so select the export method either quick or custom
and the format you'd like to export to BHP my admin supports many different formats.
Typically you'd use either the Eskew well or CSA for a Microsoft Excel compatible format we can import
a database as well.
First we specify the file we want to import and you can do that by clicking the choose file button and
then you can locate the file that you'd like to import the file must be in a compatible format and a
maximum size of 128 megabytes the file type must also be specified in this can be done from the format
select menu and you can see all the different file types here.
So again CSP and ESC You all are likely the most commonly used for best results you can leave the other
options as default.
For example the partial import and the format specific options just leave them as is
under the operations menu.
We can rename or delete a database to rename simply type.
The new name in the renamed field and click go to remove the database click the drop the database link.
Keep in mind that this will permanently delete the database with all its contents
we can copy a database by entering the new database name in this text field.
All the content of the existing database will be copied under the new names specified here.
This is a great way to create a backup of an existing database.
So if I were to click go
you can see that a duplicate of my web site database appears here.
And the only difference is is that the database name has changed so that's a great way to create backups
and I'm sure you'll be doing that quite often.