Posted in Hosting & IIS7 | No Comment | 2,341 views | 27/12/2011 09:43
If you need to move your MySQL database from one server to another, you can use the following codes.
You can do this process live.
Posted in Linux Server | No Comment | 2,045 views | 27/12/2011 09:33
You can create MySQL database and user via command line.
That gives only localhost grant on MySQL server.
Posted in Linux Server | No Comment | 2,052 views | 27/12/2011 09:27
You can transfer data between two linux servers directly via SCP.
It transfer common directory from 10.10.10.2 to under production directory.
Posted in Linux Server | No Comment | 2,077 views | 27/12/2011 09:21
You can mount NFS share on a Linux Server with following commands:
After that, you should also add that to fstab.
Now you can see NFS share in /var/www/html.
Posted in Hosting & IIS7 | No Comment | 9,521 views | 27/12/2011 09:15
There is no quick way to drop all tables of a MySQL database. You can just drop the database instead. But if you just want to drop all tables, you can use following codes.
I found the code from another website but it was for password-less MySQL servers. I added password authentication.
Posted in Hosting & IIS7 | 1 Comment | 34,188 views | 26/12/2011 15:59
If you want to see arp table of Fortigate,
1. Login to Fortigate via SSH.
2. Go into VDOM (if you have)
3. Use the following command to see arp table.
Posted in Virtual Machine Manager, Windows Powershell | 1 Comment | 2,869 views | 20/12/2011 21:41
If you have a public Hyper-V Cloud and use SCVMM, your customers can install Linux VM and install Hyper-V LIS v3.1 on it, there is nothing you can do to stop them. If they install it, you will not be able to use SCVMM due to LIS v3.1 bug.
System.ArgumentException: Version string portion was too short or too long.
at System.Version..ctor(String version)
There are 2 options to prevent this.
If you have 0 – 50 VMs, it’s easy to deal with. But if you are a large Cloud provider, you can’t do it manually, you need scripting. So if you execute this command on SCVMM Powershell Interface, it’ll disable Data Exchange offer on all Linux VMs and save your SCVMM.
As you see, it just looks for non-Windows machines and disable their Data Exchange offer. Good luck!