Reset MySql Root Password

first stop mysql service and start mysql in safe mode using the following command

service mysqld stop
mysqld_safe --skip-grant-tables &



now connetc to mysql using the following command
mysql  enter(return character)

mysql> use mysql
mysql> update user set Password=PASSWORD('passw0rd') where user='root';
mysql> flush privileges;
mysql> exit;

now password has be reset. kill mysqld_safe deamon and start mysql service using the following command

service mysqld start
now you can enter to mysql console using the new password

RAM DISK --- 2nd Porcedure

you can create RAM disk or temporary file system using the following command

mount -t tmpfs -o size=32M tmpfs /var/lib/asterisk/

the above command will mount /var/lib/asterisk/ directory in the RAM and its size will be 32Mb.

you normally use RAM disk for the applications that require intensive io operation. using ram disk will increase hardisk life and also increase performance of application by reducing access time.

MySQL PHP Exampler

   mysql_connect("localhost", "username", "password") or die(mysql_error());
   mysql_select_db("test") or die(mysql_error());
 
   echo " Step 1. Insert data
";
   $sql = "INSERT INTO users (name,city,web,age) VALUES ('Tom','Vegas','www.tom.com',5)";
   $result = mysql_query($sql);
 
   if ($result){
      echo "Data was inserted! ";   
   } else {
      echo "An error occured during insert! ";   
   }
 
   $result = mysql_query("SELECT * FROM users");   
 
   while($row = mysql_fetch_assoc($result)){
      echo "ID: ".$row['id'].", Name:".$row['name']
          .", City:".$row['city'].", Age:".$row['age']." ";
   }
 
   echo " Step 2. Update data
";
   $sql = "UPDATE users SET age=45 WHERE name='Tom'";
   $result = mysql_query($sql);
 
   if ($result){
      echo "Data was updated! ";   
   } else {
      echo "An error occured during update! ";   
   }
 
   $result = mysql_query("SELECT * FROM users");   
 
   while($row = mysql_fetch_assoc($result)){
      echo "ID: ".$row['id'].", Name:".$row['name']
          .", City:".$row['city'].", Age:".$row['age']." ";
   }
 
   echo " Step 3. Remove data
";
   $sql = "DELETE FROM users WHERE name='Tom'";
   $result = mysql_query($sql);
 
   if ($result){
      echo "Data was removed! ";   
   } else {
      echo "An error occured during remove! ";   
   }
 
   $result = mysql_query("SELECT * FROM users");   
 
   while($row = mysql_fetch_assoc($result)){
      echo "ID: ".$row['id'].", Name:".$row['name']
          .", City:".$row['city'].", Age:".$row['age']." ";
   }
 
?>

Asterisk Voice Prompts

you can download asterisk voice prompts in different language using the following link.

http://downloads.asterisk.org/pub/telephony/sounds/

MsSQL dump to remote server

was running out of disk space on a server today. The server had a large database table that was no longer used, so I wanted to archive it and then drop the table. But the server didn’t have enough disk space to dump it out to disk before copying it off to a remote server for archiving.
The first thought was to run mysqldump dump on the destination machine, and to access the database over the network. That however, doesn’t compress or encrypt the data. Plus I would have had to create a mysql user with permission to access the database remotely.
The solution I came up with worked out well: mysqldump directly to the remote host with this command:

mysqldump [mysqldump options] | gzip -c | ssh user@remotehost "cat > /path/to/some-file.sql.gz"

That pipes the mysqldump command through gzip, then to through and SSH connection. SSH on the remote side runs the ‘cat’ command to read the stdin, then redirects that to the actual file where I want it saved.

Audio Format Converter For Asterisk

you can convert audio format for asterisk ivr from the following links.

http://www.digium.com/en/products/ivr/audio-converter.php

other option is to use imagic audio editor or sox