oldserver$ mysqldump -u root –password={mysqlpassword} mysql > mysql.sql newserver$ mysql -u root –password={mysqlpassword} mysql < mysql.sql Restart mysql or flush priviledges. You may have to re-do the debian-sys-maint password after this. Get the password from /etc/mysql/debian.cnf Update: mysql -u root --password={mysqlpassword} use mysql; update user set password=PASSWORD("{debiansysmaintpassword}") where User='debian-sys-maint'; Or make new: > mysql -u […]
Month: April 2012
ls -1 *.sql | awk ‘{ print “source”,$0 }’ | mysql –batch -u {username} –password={password} {dbname}
Replace xx.xx.xx.xx with the IP of the client you want to connect with. Alternative: Using password instead of IP touch /etc/squid/squid_user htpasswd /etc/squid/squid_user YOURUSERNAME Fill in password twice, then restart squid /etc/init.d/squid restart
pm = dynamic pm.max_children = 5 pm.start_servers = 2 pm.min_spare_servers = 1 pm.max_spare_servers = 3
The one shipped with alot of vps hosts etc. is wrong, so; deb http://archive.debian.org/debian lenny main contrib deb http://archive.debian.org/debian-security/ lenny/updates main contrib If you want to, you can also add the dotdeb resources; echo “deb http://php53.dotdeb.org stable all” >> /etc/apt/sources.list echo “deb http://packages.dotdeb.org stable all” >> /etc/apt/sources.list echo “deb-src http://packages.dotdeb.org stable all” >> /etc/apt/sources.list cd […]
In order to get taskkill to work, and get rid of the “RCP server not available” error, run the following command on the target computer: netsh firewall set service RemoteAdmin enable And turn off UAC. I haven’t found a way to get this working with UAC turned on. Kept saying I was inputting an invalid […]