|
NASA: 2012: Beginning of the End or Why the World Won't End? |
|
|
|
convert mysql table from MyISAM to InnoDB |
|
|
sysadmin
|
|
MyISAM is the default storage engine for MySQL. Unfortunately it doesn't support transactions or foreign keys (but it has some other nice features like compression). However, because InnoDB does support transactions and foreign keys you might want to change your tables from MyISAM to InnoDB storage-Engine If you are not sure which storage engine you should use you should also have a look at this great site: http://www.mysqlperformanceblog.com/2009/01/12/should-you-move-from-myisam-to-innodb/ Step 1: check your my.cnf configfile change this line skip-innodb
to # skip-innodb now restart mysql: # /etc/init.d/mysql restart the location of the mysql start script depends on your Linux distribution and mysql implementation. Step 2: convert the table to InnodB start the MySQL command-line interface, switch to your database and alter the table you want to convert: mysql> ALTER table mytable ENGINE=Innodb;
|
|
How to fake the mac address on Linux |
|
|
sysadmin
|
Step 1. shutdown the interface (e.g. eth0)
# ifconfig eth0 down
Step 2: change the mac address to e.g. 11:22:33:44:55:66
# ifconfig eth0 hw ether 11:22:33:44:55:66
Step 3. restart the interface
# ifconfig eth0 up
|
|
|