Exemple #1
0
 public static function usage_extended()
 {
     $s = dbsteward::usage();
     $s .= "DBSteward Conversion and Comparison tools:\nSQL diffing\n  --oldsql=<old.sql> ...\n  --newsql=<old.sql> ...\n  --outputfile=<outputfile.ext>\nSlony utils\n  --slonikconvert=<slonyconfig.slonik>\n  --slonycompare=<database.xml> ...     generate table SELECT statements for database health comparison between replicas\n  --slonydiffold=<olddatabase.xml> ...  compare table slonyId assignment between two versions of a database definition\n  --slonydiffnew=<newdatabase.xml> ...\n  --slonyidin=<database.xml>            read this file's definition\n  --slonyidout=<compositeoutput.xml>    output it here with slonyids specified, based on requireslonyid and requireslonysetid\n  --slonyidstartvalue=1                 start slony IDs at this number\n  --slonyidsetvalue=1                   use this slony set ID for any unspecified slonySetId attributes\nDatabase definition extraction utilities\n  --dbschemadump\n  --dbdatadiff=<againstdatabase.xml> ...\n  --dbhost=<hostname>\n  --dbport=<TCP-port>\n  --dbname=<database_name>              for mysql5, specify a comma-separated list of databases. e.g. --dbname=one,two,three\n  --dbuser=<username>\n  --dbpassword=<password>\nFormat-specific options\n  --useautoincrementoptions             mysql5: Apply AUTO_INCREMENT tableOptions. By default these are ignored.\n  --useschemaprefix                     mysql5: Instead of merging schemas together (mysql5 default behavior),\n                                                prefix each database object with the schema name.\n";
     return $s;
 }