Backup script – simple

Leave a reply

If you want to make backups all of your server files (home dir or whatever) you should first make connection without passwords (using ssh).

First choose username you will be using like user981129, make it in server A (with backups). Then do this:

ssh-keygen -t rsa

You have now .ssh folder with public key (id_rsa.pub). Now go to the second server (server B) where backups will be transferred. Go to the /home/someuser and type:

mkdir .ssh; vi authorized_keys;

and then copy .ssh/id_rsa.pub from server A to authorized_keys.

Then on server B chmod .ssh 700; chmod .ssh/authorized_keys 640;

Then on server A make file with chmod a+x something like in /home/user981129:

vi backup.sh

and then paste this:

#!/bin/bash
NOW=$(date +"%m-%d-%Y")
SER="ip of the server where you are transfering files or nameserver"
FILE="backup.$NOW.tar.gz"
echo "Backing up data, please wait..."
rsync -avz /home/user981129/admin_backups/admin.root.admin.tar.gz someuser@ipofserverforbackup:/home/someuser/backups/$SER/$NOW/

Then open crontab -e and paste this:

0 3 * * * /home/user981129/backup.sh >/dev/null 2>&1

YOU ARE READY TO GO

edit: this post is for me, to speed things up when needed

Copy from folder to folder preserving everything

Leave a reply

Either use

sudo cp -rp /home/folder /media/backup/folder

sudo cp -a /home/folder /media/backup/folder (UPDATE: use this one!!!preserves everything)

Or use:

 rsync -avz

-p     same as --preserve=mode,ownership,timestamps

 --preserve[=ATTR_LIST]
          preserve the specified attributes (default: mode,ownership,timestamps),
          if possible additional attributes: context, links, xattr, all

Source: https://unix.stackexchange.com/questions/43605/how-do-i-copy-a-folder-keeping-owners-and-permissions-intact

Note to myself – ODS and mysql

Leave a reply

When importing data you have got from the datacenter (statistical files) use first openoffice .ods format and import it into already built table (copied table with all the structure) and then just import files to that table. Make sure that openoffice sheet is the same name as db table.

If you previously made table (copied table from table you were using before) then the data will just be imported automatically. You might have some problems with columns number but predefined table (copied) must be the same fields count as with .ods file you are importing.

End of note to myself

Linux – copy all files from one folder to another with hidden (.dot) files

Leave a reply

Simple, use:

cp -r /source/. /destination

This command will transfer all files including hidden ones (for example I usually need .htaccess for my sites to be transfered as well).

MySQL rand function

Leave a reply

If you need to add some random number to some of the mysql columns then here it goes…

UPDATE tableSET column = FLOOR( 1 + RAND( ) *100 )

The last number (100) means you are about to add any value until 100. So 99, 1, 5, 33, 45…any between 1 and 100.
If you put 10 instead of 100 then you will get between 1 and 10 (2, 5, 6).

Returns a random floating-point value v in the range 0 <= v < 1.0.
RAND

That’s it.

Laravel paths explained

Leave a reply

For the reference because I tend to forget things sometimes.

// project's root folder    
echo base_path();

// 'app' folder    
echo app_path();        

// 'public' folder but inside app folder and not /home/admin/web/domain.com/public_html
echo public_path();

// 'storage' folder    
echo storage_path();

// 'storage/app' folder    
echo storage_path('app');

Dedicated/VPS test speed

Leave a reply

Very nice find. You can check various speeds from your server with this little script.

I have checked it and it’s working just fine. Kudos to the developer.

https://www.lowendtalk.com/discussion/134290/new-year-special-serverreview-benchmark-v3

I have just tried it with little vps from hetzner:

[root@snapshot-5553580-centos-2gb-nbg1-1 ~]

# curl -LsO git.io/bench.sh; chmod +x bench.sh && ./bench.sh -a

Benchmark started on 06-Jul-2019 07:16:24

## System Information

OS Name : CentOS Linux release 7.6.1810 (Core) N (64 bit)
Kernel : KVM / 3.10.0-957.21.3.el7.x86_64
Hostname : snapshot-5553580-centos-2gb-nbg1-1
CPU Model : Intel Xeon Processor (Skylake, IBRS)
CPU Cores : 1 core @ 2099.998 MHz
CPU Cache : 16384 KB
Total RAM : 1790 MiB (Free 1533 MiB)
Total SWAP : SWAP not enabled
Total Space : 20GB (5% used)
Running for : 23 minutes 6 seconds

## CDN Speedtest

## North America Speedtest

## Europe Speedtest

## Exotic Speedtest

## Asia Speedtest

## IO Test

CPU Speed:
bzip2 512MB – 83.2 MB/s
sha256 512MB – 261 MB/s
md5sum 512MB – 330 MB/s

Disk Speed (512MB):
I/O Speed – 495 MB/s
I/O Direct – 63.4 MB/s

RAM Speed (895MB):
Avg. write – 1654.5 MB/s
Avg. read – 4949.3 MB/s

Benchmark finished in 129 seconds
results saved on /root/bench.log

[root@snapshot-5553580-centos-2gb-nbg1-1 ~]

MariaDB/MySql server – load data infile

Leave a reply

When using php7.2 and onward make sure you are having:
mysqli.allow_local_infile = On
in php.ini setup or uncommented.

Otherwise this will not work. I’ve spent 2 days trying to make it working on mariaDB config file because few years ago I had the same problems and most of it were on DB end (optimization) but now this totally surprised me. It was on php end.

This is really nice stuff. Check it

https://stackoverflow.com/questions/13016797/load-data-local-infile-fails-from-php-to-mysql-on-amazon-rds?rq=1

Please not…ini_set is not always working so you might need to change allow_local_infile directly to the server’s php.ini for specific php version. I’m using directadmin almost every day. Have 3 php versions installed and testing everything there.

CodeIgnitier paths explained

Leave a reply

Simple, fast, easy…

SELF = if you need index.php

If you want to include something from your root folder
FCPATH = C:\xampp\htdocs\root\

If you need to include something from your application folder
APPPATH = C:\xampp\htdocs\root_folder\application\

If you need to include something from your system folder
BASEPATH = C:\xampp\htdocs\root_folder\system\

That’s it.

DirectAdmin skin upgrade/downgrade

Leave a reply

I have installed new vps with directadmin control panel. Tried to log in and got myself into new skin. I do like it but I’m old kinda type of programmers…I like it to be simple. All those ajax calls I don’t actually like.

To cut the long story short…go to resellers…skin manager…and then setup global skin and apply to all.

Nickos blog

Web development blog only

Backup script – simple

Copy from folder to folder preserving everything

Note to myself – ODS and mysql

Linux – copy all files from one folder to another with hidden (.dot) files

MySQL rand function

Laravel paths explained

Dedicated/VPS test speed

MariaDB/MySql server – load data infile

CodeIgnitier paths explained

DirectAdmin skin upgrade/downgrade