Changeset 34639 for platform/mysql/mprofile.php

Timestamp:

07/27/09 11:03:31 (4 years ago)

Author:

nowelium

Message:

 

Files:

• platform/mysql/mprofile.php/trunk/mpdump.php (modified) (3 diffs)

platform/mysql/mprofile.php/trunk/mpdump.php

@@ -5 +5 @@
 
 $options = Console::getOpt(array(
-    'host:',
+    'host::',
     'user::',
     'password::',
+    'port::',
     'interval::',
     'samples::',
     'help'
 ), array(
+    'host' => 'localhost',
     'user' => 'root',
-    'password' => 'password',
+    'password' => '',
+    'port' => 'localhost',
     'interval' => 0.1,
     'samples' => 1000,
@@ -23 +26 @@
 Usage: {$file} options
 Options:
-    --host={host}          database host
-    --user={username}      database connect user(default: 'root')
-    --password={password}  database connect password(default: 'password')
-    --interval={interval}  interval between samples (default: 0.1sec)
-    --samples={samples}   number of samples to take (default: 1000, infinite if set to 0)
-    --help       print this help
+    --host={host}           database host(default: 'localhost')
+    --user={username}       database connect user(default: 'root')
+    --password={password}   database connect password(default: no password)
+    --port={port}           database port(default: '3306')
+    --interval={interval}   interval between samples (default: 0.1sec)
+    --samples={samples}     number of samples to take (default: 1000, infinite if set to 0)
+    --help                  print this help
 
 __EOT__;
@@ -37 +41 @@
 $interval = (float) $options['interval'];
 
-$dsn = sprintf('mysql:host=%s; dbname=%s', $options['host'], 'mysql');
+$dsn = sprintf('mysql:host=%s; dbname=%s; port=%s', $options['host'], 'mysql', $options['port']);
 $handler = new PDO($dsn, $options['user'], $options['password']);
 $handler->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);