MySQL - begginer

[Anon]

i'm a new user and i don't understand few things - whene i create new DataBase does it saves it to a file? (if it is please tell me wich ending does it has)

and if it's not, can i save it to file using some order? (if i can please write the order)

thanks...

[Anon]

MySQL is a databaseserver.
That means that you can use SQL statements to store and fetch data.
Everything you do with MySQL is automatically saved to disk.
MySQL will save your data to a file in it's own format.
You can't edit these files, or you might destroy your database.

[Anon]

and if i want to move all the infarmation to other server, what files do i have to copy?

[Anon]

The safest way to copy databases to a different server
is to make a dump of the whole database using MYSQLDUMP

This makes a textfile of everything that is in your database.
You can copy that textfile to your other server, and read it using mysqlimport.

there is more information about that in the mysql manual.