Dismiss Notice
Welcome to Our Community
Wanting to join the rest of our members? Feel free to sign up today.

What's in a MySQL database?

Discussion in 'Server Administration' started by ForumJoiner, Mar 27, 2007.

  1. ForumJoiner

    ForumJoiner New Member Webmaster

    To put it simply, a MySQL database is a collection of tables, each organized into rows and columns. That is called the logical representation of the database.

    The physical representation is a folder. When you create a database in MySQL, the MySQL server actually creates an empty folder. You can try this by issuing the command
    [FONT=Verdana]create database test[/FONT]

    and seeing that an empty folder 'test' is created in the subfolder 'data' of the folder where you installed MySQL. All the tables you create inside the 'test' database will be stored inside the folder 'test'.

    • to backup a database on your computer you can simply copy the corresponding folder
    • to completely erase a database on your computer you can simply delete the corresponding folder
  2. Alam

    Alam New Member Webmaster

    Nice post to learn MySQL Database. Please keep it up :)

Featured Resources (View All)

Share This Page