Remove everyting after first / slash in mysql
[code lang=”php”]UPDATE my_table SET my_col = SUBSTRING_INDEX(my_col, ‘/’, 1)[/code] From: AAA/BBB/CCC To: AAA
Month: March 2014
Remove everyting before last / slash in mysql
[code lang=”php”]UPDATE `table` SET `column` = SUBSTRING_INDEX(`column`,’/’,-1);[/code] From: AAA/BBB/CCC To: CCC
Install VSFTPD and setup user
Install VSFTPD and setup user 1. Type this [code leg=”php”]# cd /tmp[/code] 2. Install VSFTPD [code leg=”php”]# yum install vsftp[/code] 3. Open vsftpd configuration file – /etc/vsftpd/vsftpd.conf [code leg=”php”]# vi /etc/vsftpd/vsftpd.conf[/code] 4. Make sure following line exists (and uncommented) [code leg=”php”]chroot_local_user=YES[/code] 5. Add user to FTP [code leg=”php”]# adduser -c ‘FTP USER Tom’ -m tom…