Check Date and Time in mysql

Sometimes we may need to check the time when we are working with mysql.
To do this login to mysql and use the following command

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2010-09-28 14:49:57 |
+---------------------+
1 row in set (0.06 sec)

How to create SVN repository

Creating SVN repository on linux machine is  easy......
1. Install the subversion
        yum install subversion ( RHEL , Fedora, Centos)
        apt-get install subversion (ubuntu,debian)

2. Install open-ssh for secure connection (If repositoy on remote system)
# yum install openssh-server openssh-client (RHEL, Fedora, Centos)
# apt-get install openssh-server openssh-client (ubuntu, debian)

3. use svnadmin command to create the repositorty.....
# svnadmin create <path to repo>
ex:  svnadmin create /var/www/repo

4. Now change the directory to /var/www/repo
# cd /var/www/repo

5. Edit the configuration file
# vi /var/www/repo/conf/svnserve.conf
uncomment the following lines
anon-access = none
auth-access = write
password-db = passwd

6.create the users
# useradd -s /sbin/nologin user1

7.set the password for user1
# passwd user1
 
8.Now edit the passwd file
# vi /var/www/repo/conf/passwd

add the following line and save the file
user1 = password
 
9. Import your Project to repository
# svn import <path of project data> <path to repo>
ex: # svn import /home/sourcecode/project1 file:///var/www/repo/project1

10.Check out the data to your system
# svn co svn+ssh://user1@192.168.1.10/var/www/repo/project1