Dobr� den,
sexta-feira, 22 de novembro de 2002, 13:26:01, napsal jste:
JC> What is MYI and frm files?
The MySQL tables in case of "MyISAM tables" are separated in :
.frm - The struct (header) of table
.MYD - The DATA of table
.MYI - The Indexes of table
in case of InnoDB , only .frm exists , the DATA and Indexes are
saved in tablespace. More information you see in
http://www.mysql.com/doc/en/InnoDB.html or http://www.innodb.com
JC> I am using MYISAM and when I want the whole
JC> database including data and want to move it to another computer (Win2K) do
JC> I use mysqldump with no parameters? Does one also dump the MYSQL database
JC> to get the username/password and all or just the users table?
To copy the "database of user" ( user , password , perm, etc... ) , you must dump the
database called
"mysql" ( all tables )
More information about mysqldump :
4.8.5 mysqldump, Dumping Table Structure and Data
http://www.mysql.com/doc/en/mysqldump.html
bye.
-------------------------------------------------------------------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-------------------------------------------------------------------------
E S C R I B A I N F O R M A T I C A
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
--
$ look into "my eyes"
look: cannot open my eyes
-------------------------------------------------------------------------
Reply: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
