Posts

Showing posts from November, 2010

Install SQL 2008 with MSXML on Window 2003

  Install Windows installer 4.5 Uninstall MSXML version 6.0 Install de Sql Server. … Install Windows installer 4.5 Uninstall MSXML version 6.0 Install de Sql Server.

Backup mbr on Linux

 dd if=/dev/sda of=/path/mbr_sda.img bs=512 count=1

Delete ^M file ASCII

  With perl perl -pi -e 's/\r\n/\n/' file With editor Vi [esc]:%s/[ctrl+v][ctrl+m]

Repair time service Windows

  w32tm /unregister w32tm /register

Reset passwd Mysql on Linux

  Stop Mysql service mysqld stop Restart with mysqld_safe --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid --skip-grant-tables Connexion mysql -u root mysql Change passwd UPDATE user SET password=PASSWORD('newpasswd') WHERE user="root"; exit Restart service mysqld restart Connexion with mysql -u root -p