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