03-27-2007, 10:03 PM
|
|
Member
 1 posts this year. needs some grease! New user, who has not interacted much yet. |
|
|
Join Date: Mar 2007
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
|
|
What's in a MySQL database?
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
Code:
create database test
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'.
Consequences:- 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
|
Linear Mode
