mysqladmin -u root -p password "newpassword"
0 Comments
mysqldump -h mysqlhost -u username -p mydatabasename > dbdump.sql
In MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption, since even though you might lose some data, you know exactly where to look for the beginning of the next record.
It compressed the MyISAM tables, which reduces their disk usage.
Much more conservative approach to disk space management - each MyISAM table is stored in a separate file, which could be compressed then with myisamchk if needed. With InnoDB the tables are stored in tablespace, and not much further optimization is possible. All data except for TEXT and BLOB can occupy 8,000 bytes at most. No full text indexing is available for InnoDB. TRhe COUNT(*)s execute slower than in MyISAM due to tablespace
Row-level locking, transactions, foreign key constraints and crash recovery.
1.Transactions:MYISAM doesnt support any database
transactions means if the transactions related to large amount of data transfer it will not provide because memory is less. But INNODB will provide transactions. 2.Locking:MYISAM provide the table level locking means if the data in one table has been modified by the other table ,the entire table will lock for the next process.But INNODB provide the row level locking only the row of the table that is being updated is locked. 3.Foreign keys – MYISAM tables do not support foreign keys. 4.Data Types:MYISAM provide a full variety of datatypes,but INNODB will not. MySQL set can take zero or more values but at the maximum it can
take 64 values describe Table-Name;
The ‘.frm’ file stores the table definition.
The data file has a ‘.MYD’ (MYData) extension. The index file has a ‘.MYI’ (MYIndex) extension, |