prayagupa · August 4, 2020 19:16
diff --git a/event_logs.md b/event_logs.md
diff --git a/mysql.bat b/mysql.bat
 ## credit http://muhammadhamed.blogspot.com/2013/01/install-mysql-as-windows-service-from.html

 @echo off
 set currentPath=%~dp0
 set mydump_file=%currentPath%mydb_dump-%date:~10,4%%date:~7,2%%date:~4,2%_%time:~0,2%%time:~3,2%.sql
 :: 
 ::  This script is to start and configure the database server.
 :: 
 echo "Starting to insall the mysql as a service in the windows "
 echo "The current path %currentPath%mysql-5.5.29-win32\ "

 :: Trying to stop the service, incase of changing the installtion path.
 sc stop MySQL

 :: Kill the process related to the srvice.
 for /f "tokens=2 delims=[:]" %%f in ('sc queryex MySQL ^|find /i "PID"') do set PID=%%f
 taskkill /f /pid %PID%

 :: wait 5 sec
 ping 127.0.0.1 -n 10 > nul
 :: Delete the service.
 sc delete MySQL

 :: wait 5 sec
 ping 127.0.0.1 -n 10 > nul
 :: Creating the service with autostart 
 sc create MySQL start= auto DisplayName= MySQL binPath= "%currentPath%mysql-5.5.29-win32\bin\mysqld.exe --defaults-file=\"%currentPath%my.ini\" MySQL"

 call "%currentPath%mysql-5.5.29-win32\bin\mysqld.exe" --install
 echo "Starting the MySQL server."
 call "%currentPath%mysql-5.5.29-win32\bin\mysqld.exe"
 :: Start the servie
 sc start MySQL

 :: wait 5 sec
 ping 127.0.0.1 -n 10 > nul

 :: Check if we should create or migrate

 IF EXIST "%currentPath%mysql-5.5.29-win32\data\mydb" (
 echo "Migrate me."
 echo "dummping the database to %mydump_file% "
 call "%currentPath%mysql-5.5.29-win32\bin\mysqldump.exe" -u root --password="password" mydb --default-character-set=utf8 > "%mydump_file%"
 call "%currentPath%mysql-5.5.29-win32\bin\mysql.exe" -u root --password="password" --default-character-set=utf8 < "%currentPath%/migration.sql">c:/migrate.log
 ) ELSE (
 :: Creating the schema
 echo "Creating the schema."
 call "%currentPath%mysql-5.5.29-win32\bin\mysql.exe" -u root --password="password" --default-character-set=utf8 < "%currentPath%/mydb.sql">c:\create.log

 )
 echo "Done!!"
 :: echo "Press any key to exit ..."
 :: pause > nul

 @echo on
diff --git a/mysql_procedure_loop.sql b/mysql_procedure_loop.sql
 -- https://www.brainbell.com/tutorials/MySQL/Working_With_Cursors.htm
 CREATE PROCEDURE processorders()
 BEGIN
   -- Declare local variables
   DECLARE done BOOLEAN DEFAULT 0;
   DECLARE o INT;
   DECLARE t DECIMAL(8,2);
   
   -- Declare the cursor
   DECLARE ordernumbers CURSOR
   FOR
   SELECT order_num FROM orders;
   
   -- Declare continue handler
   DECLARE CONTINUE HANDLER 
   FOR SQLSTATE '02000' 
   SET done=1;
   
   -- Create a table to store the results
   CREATE TABLE IF NOT EXISTS ordertotals
      (order_num INT, total DECIMAL(8,2));
      
   -- Open the cursor
   OPEN ordernumbers;
   
   -- Loop through all rows
   REPEAT
      -- Get order number
      FETCH ordernumbers INTO o;
      
      -- Get the total for this order
      CALL ordertotal(o, 1, t);
      
      -- Insert order and total into ordertotals
      INSERT INTO ordertotals(order_num, total)
      VALUES(o, t);
      
   -- End of loop
   UNTIL done END REPEAT;
   
   -- Close the cursor
   CLOSE ordernumbers;
 END;
diff --git a/mysql_setup.md b/mysql_setup.md
diff --git a/oracle.md b/oracle.md
diff --git a/php.ini b/php.ini
 [MySQL]
 ; Allow accessing, from PHP's perspective, local files with LOAD DATA statements
 ; http://php.net/mysql.allow_local_infile
 mysql.allow_local_infile = On

 ; Allow or prevent persistent links.
 ; http://php.net/mysql.allow-persistent
 mysql.allow_persistent = On

 ; If mysqlnd is used: Number of cache slots for the internal result set cache
 ; http://php.net/mysql.cache_size
 mysql.cache_size = 2000

 ; Maximum number of persistent links.  -1 means no limit.
 ; http://php.net/mysql.max-persistent
 mysql.max_persistent = -1

 ; Maximum number of links (persistent + non-persistent).  -1 means no limit.
 ; http://php.net/mysql.max-links
 mysql.max_links = -1

 ; Default port number for mysql_connect().  If unset, mysql_connect() will use
 ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
 ; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
 ; at MYSQL_PORT.
 ; http://php.net/mysql.default-port
 mysql.default_port =

 ; Default socket name for local MySQL connects.  If empty, uses the built-in
 ; MySQL defaults.
 ; http://php.net/mysql.default-socket
 mysql.default_socket =

 ; Default host for mysql_connect() (doesn't apply in safe mode).
 ; http://php.net/mysql.default-host
 mysql.default_host =

 ; Default user for mysql_connect() (doesn't apply in safe mode).
 ; http://php.net/mysql.default-user
 mysql.default_user =

 ; Default password for mysql_connect() (doesn't apply in safe mode).
 ; Note that this is generally a *bad* idea to store passwords in this file.
 ; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
 ; and reveal this password!  And of course, any users with read access to this
 ; file will be able to reveal the password as well.
 ; http://php.net/mysql.default-password
 mysql.default_password =

 ; Maximum time (in seconds) for connect timeout. -1 means no limit
 ; http://php.net/mysql.connect-timeout
 mysql.connect_timeout = 60

 ; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
 ; SQL-Errors will be displayed.
 ; http://php.net/mysql.trace-mode
 mysql.trace_mode = On
	## credit http://muhammadhamed.blogspot.com/2013/01/install-mysql-as-windows-service-from.html

	@echo off
	set currentPath=%~dp0
	set mydump_file=%currentPath%mydb_dump-%date:~10,4%%date:~7,2%%date:~4,2%_%time:~0,2%%time:~3,2%.sql
	::
	:: This script is to start and configure the database server.
	::
	echo "Starting to insall the mysql as a service in the windows "
	echo "The current path %currentPath%mysql-5.5.29-win32\ "

	:: Trying to stop the service, incase of changing the installtion path.
	sc stop MySQL

	:: Kill the process related to the srvice.
	for /f "tokens=2 delims=[:]" %%f in ('sc queryex MySQL ^\|find /i "PID"') do set PID=%%f
	taskkill /f /pid %PID%

	:: wait 5 sec
	ping 127.0.0.1 -n 10 > nul
	:: Delete the service.
	sc delete MySQL

	:: wait 5 sec
	ping 127.0.0.1 -n 10 > nul
	:: Creating the service with autostart
	sc create MySQL start= auto DisplayName= MySQL binPath= "%currentPath%mysql-5.5.29-win32\bin\mysqld.exe --defaults-file=\"%currentPath%my.ini\" MySQL"

	call "%currentPath%mysql-5.5.29-win32\bin\mysqld.exe" --install
	echo "Starting the MySQL server."
	call "%currentPath%mysql-5.5.29-win32\bin\mysqld.exe"
	:: Start the servie
	sc start MySQL

	:: wait 5 sec
	ping 127.0.0.1 -n 10 > nul

	:: Check if we should create or migrate

	IF EXIST "%currentPath%mysql-5.5.29-win32\data\mydb" (
	echo "Migrate me."
	echo "dummping the database to %mydump_file% "
	call "%currentPath%mysql-5.5.29-win32\bin\mysqldump.exe" -u root --password="password" mydb --default-character-set=utf8 > "%mydump_file%"
	call "%currentPath%mysql-5.5.29-win32\bin\mysql.exe" -u root --password="password" --default-character-set=utf8 < "%currentPath%/migration.sql">c:/migrate.log
	) ELSE (
	:: Creating the schema
	echo "Creating the schema."
	call "%currentPath%mysql-5.5.29-win32\bin\mysql.exe" -u root --password="password" --default-character-set=utf8 < "%currentPath%/mydb.sql">c:\create.log

	)
	echo "Done!!"
	:: echo "Press any key to exit ..."
	:: pause > nul

	@echo on
	-- https://www.brainbell.com/tutorials/MySQL/Working_With_Cursors.htm
	CREATE PROCEDURE processorders()
	BEGIN
	-- Declare local variables
	DECLARE done BOOLEAN DEFAULT 0;
	DECLARE o INT;
	DECLARE t DECIMAL(8,2);

	-- Declare the cursor
	DECLARE ordernumbers CURSOR
	FOR
	SELECT order_num FROM orders;

	-- Declare continue handler
	DECLARE CONTINUE HANDLER
	FOR SQLSTATE '02000'
	SET done=1;

	-- Create a table to store the results
	CREATE TABLE IF NOT EXISTS ordertotals
	(order_num INT, total DECIMAL(8,2));

	-- Open the cursor
	OPEN ordernumbers;

	-- Loop through all rows
	REPEAT
	-- Get order number
	FETCH ordernumbers INTO o;

	-- Get the total for this order
	CALL ordertotal(o, 1, t);

	-- Insert order and total into ordertotals
	INSERT INTO ordertotals(order_num, total)
	VALUES(o, t);

	-- End of loop
	UNTIL done END REPEAT;

	-- Close the cursor
	CLOSE ordernumbers;
	END;
	[MySQL]
	; Allow accessing, from PHP's perspective, local files with LOAD DATA statements
	; http://php.net/mysql.allow_local_infile
	mysql.allow_local_infile = On

	; Allow or prevent persistent links.
	; http://php.net/mysql.allow-persistent
	mysql.allow_persistent = On

	; If mysqlnd is used: Number of cache slots for the internal result set cache
	; http://php.net/mysql.cache_size
	mysql.cache_size = 2000

	; Maximum number of persistent links. -1 means no limit.
	; http://php.net/mysql.max-persistent
	mysql.max_persistent = -1

	; Maximum number of links (persistent + non-persistent). -1 means no limit.
	; http://php.net/mysql.max-links
	mysql.max_links = -1

	; Default port number for mysql_connect(). If unset, mysql_connect() will use
	; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
	; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
	; at MYSQL_PORT.
	; http://php.net/mysql.default-port
	mysql.default_port =

	; Default socket name for local MySQL connects. If empty, uses the built-in
	; MySQL defaults.
	; http://php.net/mysql.default-socket
	mysql.default_socket =

	; Default host for mysql_connect() (doesn't apply in safe mode).
	; http://php.net/mysql.default-host
	mysql.default_host =

	; Default user for mysql_connect() (doesn't apply in safe mode).
	; http://php.net/mysql.default-user
	mysql.default_user =

	; Default password for mysql_connect() (doesn't apply in safe mode).
	; Note that this is generally a bad idea to store passwords in this file.
	; Any user with PHP access can run 'echo get_cfg_var("mysql.default_password")
	; and reveal this password! And of course, any users with read access to this
	; file will be able to reveal the password as well.
	; http://php.net/mysql.default-password
	mysql.default_password =

	; Maximum time (in seconds) for connect timeout. -1 means no limit
	; http://php.net/mysql.connect-timeout
	mysql.connect_timeout = 60

	; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
	; SQL-Errors will be displayed.
	; http://php.net/mysql.trace-mode
	mysql.trace_mode = On