![]() Doing so, will include the SQL command to create a database with the same name as the one you are exporting. Optionally, you can check the box to Include Create Schema. For the independent project, you'll want to name your database dump file firstname_lastname.sql, where firstname is your first name and lastname is your last name. For now, the name doesn't matter - we just need to be able to find it so we can import it again. Select Export to Self-Contained File in the Export Options.Ĭhoose a file name and a place to export your database to. Choose Dump Structure Only in the drop down on the right. Select the to_do_list in the left hand Tables to Export window. Select Data Export from the list of available options. Select the Administration tab from the bottom of the Navigator window. Launch MySQL Workbench and open your local instance so that the Navigator window is visible. Let's create a test database for our To Do List. MySQL's user interface doesn't resize well to smaller windows causing some buttons to be hidden out of view. You will also use these instructions to export your database to include in your independent project for this course section.Īs you are working through the following steps, make sure that the MySQL Workbench application window is expanded to fit your entire screen. In the process, we'll create a test database for the To Do List. In this lesson, we'll learn how to export and import a database using MySQL Workbench.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |