--- trunk/admin/install/libload.pl 2004/03/18 20:21:08 71 +++ trunk/admin/install/libload.pl 2004/03/18 20:33:37 72 @@ -37,26 +37,26 @@ # This part commented out for now - not a good idea to offer this capability? # print ("DNS name or IP of the mySQL host upon which to install lidata: "); -# my $mysql_host; -# $mysql_host = ; -# chomp($mysql_host); +# my $xx_host; +# $xx_host = ; +# chomp($xx_host); print ("mySQL user name capable of adding/dropping databases: "); -my $mysql_user; -$mysql_user = ; -chomp($mysql_user); +my $xx_user; +$xx_user = ; +chomp($xx_user); print ("mySQL password associated with the specified user: "); use Term::ReadKey; ReadMode('noecho'); -$mysql_pwd = ReadLine(0); -chomp($mysql_pwd); +$xx_pwd = ReadLine(0); +chomp($xx_pwd); ReadMode('normal'); # confirm for delete, display settings print ("\n\nYou entered:\n"); -print ("mySQL server name: $mysql_host\n"); -print ("mySQL user name: $mysql_user\n"); +print ("mySQL server name: $xx_host\n"); +print ("mySQL user name: $xx_user\n"); print ("Continue with install? WARNING: This will DROP any databases \n"); print ("named libdata, libstats, and session on the specified mySQL\n"); @@ -71,25 +71,25 @@ # dump existing libdata, libstats, session print ( "Dropping libdata, libstats, and session databases!\n" ); - `cat drop.sql | mysql -u$mysql_user -p$mysql_pwd`; + `cat drop.sql | mysql -u$xx_user -p$xx_pwd`; # create new databases print ("Creating new libdata, libstats and libsessions databases.\n"); - `cat create.sql | mysql -u$mysql_user -p$mysql_pwd`; + `cat create.sql | mysql -u$xx_user -p$xx_pwd`; print ("Populating libdata tables & data.\n"); - `cat libdata.sql | mysql -u$mysql_user -p$mysql_pwd libdata`; + `cat libdata.sql | mysql -u$xx_user -p$xx_pwd libdata`; print ("Populating libstats tables.\n"); - `cat libstats.sql | mysql -u$mysql_user -p$mysql_pwd libstats`; + `cat libstats.sql | mysql -u$xx_user -p$xx_pwd libstats`; print ("Populating libsession tables.\n"); - `cat libsession.sql | mysql -u$mysql_user -p$mysql_pwd libsession`; + `cat libsession.sql | mysql -u$xx_user -p$xx_pwd libsession`; # refresh/reload grants tables print("Reloading and refreshing the mySQL grants tables.\n"); - `mysqladmin -u$mysql_user -p$mysql_pwd refresh`; - `mysqladmin -u$mysql_user -p$mysql_pwd reload`; + `mysqladmin -u$xx_user -p$xx_pwd refresh`; + `mysqladmin -u$xx_user -p$xx_pwd reload`; # The "done" message print ("\nInstallation steps finished. Script terminated.\n");