Category Archives: Programming

Laravel Homestead Database Export and Import

Wednesday, 16 May 2018 18:50

Tim Ramsey

0 Comments

SSH into your homestead box and run the two commands to export or import your databases via the Aliases below.

dbexport

dbexport

dbimport

dbimport

https://github.com/laravel/homestead/pull/542

Move Large cPanel Account to new Server

Friday, 04 May 2018 21:21

Tim Ramsey

0 Comments

I had an account that was over 100GB in size, and it would not transfer to a new server via the GUI. Step 1(current server):

/scripts/pkgacct USER

1	/scripts/pkgacct USER

Step 2(new server ):

scp -P PORT root@IP:/home/cpmove-USER.tar.gz /home/cpmove-USER.tar.gz

1	scp -P PORT root@IP:/home/cpmove-USER.tar.gz /home/cpmove-USER.tar.gz

Find Image name from Excel Cell

Monday, 23 October 2017 17:15

Tim Ramsey

0 Comments

The formula below will give you the image name from a cell string

=SUBSTITUTE(REPLACE(A1,1,LOOKUP(2^15,FIND("/",A1,ROW(INDIRECT("1:"&LEN(A1))))),""),".jpg","")

1	=SUBSTITUTE(REPLACE(A1,1,LOOKUP(2^15,FIND("/",A1,ROW(INDIRECT("1:"&LEN(A1))))),""),".jpg","")

Install Sphinxsearch 2.3.2-beta

Saturday, 16 September 2017 02:46

Tim Ramsey

0 Comments

Installing on a fresh DO instance.

cd /tmp
sudo apt-get install libmysqlclient-dev build-essential php7.0-cli
wget -q -O- https://github.com/sphinxsearch/sphinx/archive/2.3.2-beta.tar.gz | tar -xz -C .
cd sphinx-2.3.2-beta
./configure --prefix=/etc/sphinxsearch
make
sudo make install
cd ..
rm -rf sphinx-2.3.2-beta

mkdir /usr/local/etc/configs
mkdir /var/lib/sphinxsearch/data/sites
chmod 777 sites

cd /tmp

sudo apt-get install libmysqlclient-dev build-essential php7.0-cli

wget -q -O- https://github.com/sphinxsearch/sphinx/archive/2.3.2-beta.tar.gz | tar -xz -C .

cd sphinx-2.3.2-beta

./configure --prefix=/etc/sphinxsearch

make

sudo make install

cd ..

rm -rf sphinx-2.3.2-beta

mkdir /usr/local/etc/configs

mkdir /var/lib/sphinxsearch/data/sites

chmod 777 sites

Install Sphinx Search on cPanel

Monday, 11 September 2017 20:00

Tim Ramsey

0 Comments

Move into /tmp directory and get latest release. You can get the latest release from http://sphinxsearch.com/downloads/

cd /tmp
wget http://sphinxsearch.com/files/sphinx-2.3.2-beta.tar.gz

1 2	cd /tmp wget http://sphinxsearch.com/files/sphinx-2.3.2-beta.tar.gz

Uncompress

tar -zxf 'sphinx-2.3.2-beta.tar.gz'

1	tar -zxf 'sphinx-2.3.2-beta.tar.gz'

Create directory

mkdir /usr/local/sphinx

1	mkdir /usr/local/sphinx

Enter the Uncompressed directory

cd sphinx-2.3.2-beta

1	cd sphinx-2.3.2-beta

Configure to use the directory we created above and to use mysql and postgresql

./configure --prefix=/usr/local/sphinx --with-mysql --with-pgsql

1	./configure --prefix=/usr/local/sphinx --with-mysql --with-pgsql

Build

make
make install

1 2	make make install

Create Configuration File

cp -pr /usr/local/sphinx/etc/sphinx.conf.dist /usr/local/sphinx/etc/sphinx.conf

1	cp -pr /usr/local/sphinx/etc/sphinx.conf.dist /usr/local/sphinx/etc/sphinx.conf

Create Start-up Script

nano /etc/init.d/searchd

1	nano /etc/init.d/searchd

#!/bin/bash
case "${1:-''}" in
'start')
/usr/local/sphinx/bin/searchd
;;
'stop')
/usr/local/sphinx/bin/searchd --stop
;;
'restart')
/usr/local/sphinx/bin/searchd --stop && /usr/local/sphinx/bin/searchd
;;
*)
echo "Usage: $SELF start|stop|restart"
exit 1
;;
esac

#!/bin/bash

case "${1:-''}" in

'start')

/usr/local/sphinx/bin/searchd

;;

'stop')

/usr/local/sphinx/bin/searchd --stop

;;

'restart')

/usr/local/sphinx/bin/searchd --stop && /usr/local/sphinx/bin/searchd

;;

echo "Usage: $SELF start|stop|restart"

exit 1

;;

esac

Make Script Writable

chmod 755 /etc/init.d/sphinx

1	chmod 755 /etc/init.d/sphinx

Start the Service

/etc/init.d/searchd start

1	/etc/init.d/searchd start

Create chkservd file

nano /etc/chkserv.d/searchd
service[searchd]=x,x,x,/etc/init.d/searchd restart,searchd,root|searchd

1 2	nano /etc/chkserv.d/searchd service[searchd]=x,x,x,/etc/init.d/searchd restart,searchd,root\|searchd

Add to /etc/chkserv.d/chkservd.conf

searchd:1

searchd:1

Restart Tailwatch

/scripts/restartsrv_tailwatchd

1	/scripts/restartsrv_tailwatchd

Page 5 of 11

Category Archives: Programming

Laravel Homestead Database Export and Import

Move Large cPanel Account to new Server

Find Image name from Excel Cell

Install Sphinxsearch 2.3.2-beta

Install Sphinx Search on cPanel

Categories

Recent Posts