True Light Designs Blog

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

Page 3 of 11

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

Categories

Recent Posts