Copy File from Server to Local

> Current Directory
scp root@xxx.xxx.xxx:/root/filename.zip . 

Set Email and Username Github

git config --global user.email "test@mail.com"
git config --global user.name "username"

WinZip can't open folders containing any of the following characters: \ / : * ?

---Mac Terminal Command----

find /Users/Doc/xxxx/xxx/xx \

-depth \

-name '*[:\/\*\?"<>|]*' \

-exec bash -c '

for f; do

    dir=$(dirname "$f")

    base=$(basename "$f")

    new=$(echo "$base" | sed "s/[\\\\/:*?\"<>|]/_/g")

    

    if [ "$base" != "$new" ]; then

        mv "$f" "$dir/$new"

        echo "Renamed: $f -> $dir/$new"

    fi

done

' bash {} +

Proper Full Backup MYSQL Database

mysqldump -u myuser -p --single-transaction --routines --triggers --events database_name > full_backup.sql

Delete Plugin Wordpress Required FTP

 chown -R www-data:www-data /var/www/directory_name

Update Ubuntu Swapfile

---- create swapfile2---- 

sudo fallocate -l 4G /swapfile2

sudo chmod 600 /swapfile2

sudo mkswap /swapfile2

sudo swapon /swapfile2

--remove old----

sudo swapoff /swapfile

sudo rm -f /swapfile

Import backup file into MYSQL

For example, if your file is in your current folder and your username is root:

 mysql -u root -p dbname < backup_file.sql