Remote MySQL backup – Using Windows Batch Script
@echo off PATH=%PATH%;C:\temp\mysql\bin; cd c:\temp\backup_server\ set datetimef=%date:~-4%_%date:~7,2%_%date:~0,2%_%time:~0,2%_%time:~3,2%_%time:~6,2% echo Please wait , backup in progress... mysqldump --host="blahblah.com" --user="user" --password="password" databasename > backup_%datetimef%_.sql echo Backup is success pause
No comments yet.
340No trackbacks yet.
Export MySQL database in XML format
about 6 months ago - No comments
This small python program can export mysql database in a xml format import MySQLdb hostName="hostnamehere" userName="usernamehere" passWd="passwordhere" dbName="dbnamehere" print "Started…." #open file file = open("out.xml", ‘w’) file.write(""); file.write("\n\t<" + dbName + ">"); print "Connecting to " , hostName , "…"; conn=MySQLdb.connect(host=hostName,user=userName,passwd=passWd,db=dbName) cursor = conn.cursor () table_list = [] [...]
Monitor Energy Saver 0.1
about 1 year ago - No comments
This utility helps to turnoff monitor automatically when the user locks his computer / laptop . http://code.google.com/p/monitores Open Source / Apache 2.0 Share +