diesel mysql

<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/platform.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar/1888076610204930038?origin\x3dhttp://dieselms.blogspot.com', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>

Sunday, January 13, 2008

upgrade mysql 4.1.15 to mysql 4.1.22

Download and install MySql 4.1.22

File name: mysql-noinstall-4.1.22-win32.zip

b. Just unzip it under 'C:\dev\tools'

Expoprt all existsitng databases (mysqldump -u root --all-databases > alldatabases.sql) Shut down mysql server

Copy my.cnf file from to Edit the copied my.cnf file and replace all directory references to point to the new Modify !MySql server start-up and shut-down shortcuts to point to the new

Test Startup/Shutdown scripts (Allow it in the firewall!!!)

Import all databases (mysql -u root < alldatabases.sql)

Restart Mysql server

Update computer's Environment path (if mysql command is to be global) (Allow it in firewall!!!)