Category: MySQL

  • Connect to a different database server within command line utility

    In sqlcmd, you can connect to a different server by this command: :connect MyServer The above command will attempt to use integrated / Windows Active Directory authentication. To use traditional Sql Server authentication, use this instead: :connect MyServer -U MyLogin You can do the same kind of thing in Oracle Sql Plus by using this […]

  • My WordPress backup and restore process

    As I am writing and publishing more and more blog entries, it becomes important that I have good and reliable backups. I know that if something happens and I cannot recover my entries and comments, I would be terribly upset. So I want to share my process here. Please feel free to share your backup […]

  • 64-bit, virturalization, and their impact

    VMWare recently released a freeware called VMWare Player that can play a pre-built virtual machine file. A virtual machine is an OS bundled with whatever the virtual machine creator put there. This is perfect for people to test-drive various operating systems and software, without going through the hassle of installing themselves. VMWare currently provides virtual […]

  • Find out uptime of server and MySql database

    This site had been unstable for the last couple of weeks, due to my hosting company’s issues with servers. My Apache and MySql database have both been moved to a different server. Hopefully things will be stable from now on. During the troubleshooting time, I used a few commands to find out the uptime of […]