
A Principled Technologies test report 20
Red Hat Enterprise Linux 6: Performance advantages with an
open source software stack
echo "CUSTOMERS start:"
mysql -u web --password=web < mysqlds2_load_cust.sql
echo "CUSTOMERS end: "
cd ..\orders
echo "ORDERS start:"
mysql -u web --password=web < mysqlds2_load_orders.sql
mysql -u web --password=web < mysqlds2_load_orderlines.sql
mysql -u web --password=web < mysqlds2_load_cust_hist.sql
echo "ORDERS end:"
cd ..\prod
echo "PRODUCTS start:"
mysql -u web --password=web < mysqlds2_load_prod.sql
mysql -u web --password=web < mysqlds2_load_inv.sql
echo "PRODUCTS end:"
echo ""
echo Done
4. Open a command window and start the first MySQL database instance:
sc start mysql01
5. Load the DVD Store data running these commands:
cd c:\DS2\mysqlds2
mysqlds2_create_all.bat
6. Stop MySQL and copy its data and log file to the gold or master file location to speed resetting DVD Store to its
original state.
sc stop mysql01
mkdir c:\DS2\MySQL-GOLD\dat
mkdir c:\DS2\MySQL-GOLD\log
xcopy c:\MySQL\log01 c:\DS2\MySQL-GOLD\log /e
xcopy c:\MySQL\dat01 c:\DS2\MySQL-GOLD\dat /e
7. Finally, copy the DVD Store web and PHP files to the three web-root directories.
cd c:\DS2\mysqlds2\web\php5
mkdir c:\inetpub\wwwroot\ds2-01\ds2
mkdir c:\inetpub\wwwroot\ds2-02\ds2
mkdir c:\inetpub\wwwroot\ds2-03\ds2
xcopy dsnewcustomer.php.sp c:\inetpub\wwwroot\ds2-01\ds2\dsnewcustomer.php
xcopy index.html c:\inetpub\wwwroot\ds2-01\ds2
xcopy ds*.php c:\inetpub\wwwroot\ds2-01\ds2
xcopy ds*.inc c:\inetpub\wwwroot\ds2-01\ds2
xcopy c:\inetpub\wwwroot\ds2-01\ds2 c:\inetpub\wwwroot\ds2-02\ds2 /e
xcopy c:\inetpub\wwwroot\ds2-01\ds2 c:\inetpub\wwwroot\ds2-03\ds2 /e
Comentarios a estos manuales