Fix import huge database into Docker MySQL container
When I tried to import dump file using mysql command I saw ‘lost connection’ or ‘server has gone away’ error……
Tag: DevOps (page 5)
WP fix run site locally
WordPress has option(s) with site URL. To change them to new one use next SQLs: UPDATE `wp_options` SET `option_value` =…
WP set category to post within SQL
I have a stored procedure and want put posts in the MySQL event to some category (such Archive). wp_term_relationships (object_id,…
List of variables in log format NGINX
Variables: $ancient_browser equals the value set by the ancient_browser_value directive, if a browser was identified as ancient $arg_ argument in…
local to FTP sync
To sync local directory to FTP server use (Linux script): lftp -c “set ftp:list-options -a; open ftp://<ftpuser>:<ftppass>@<ftp.host.com>:<ftpport>; lcd…
FTP to local sync
To sync remote directory to local computer use (Linux script): lftp -c “set ftp:list-options -a; open ftp://<ftpuser>:<ftppass>@<ftp.host.com>:<ftpport>; lcd…
MP3 title charset change from CP1251 to UTF8
I have mp3 files with title in Windows CP1251 charset. When I copy them to MP3 player or play them…
Docker php+mysql+xdebug
Steps to create configuration: Create docker-compose.yml version: “2” services: web: image: nginx:latest ports: – “80:80” volumes: – ./apps/default:/apps/default – ./logs/nginx:/logs/nginx…
Extract all .gz in a directory- Linux
Next command helps to do that: find . -name ‘*.gz’ -exec gunzip ‘{}’ \; Note: source .gz files will be…
ls – How to sort files by date…
How to display newer files at the bottom of the ls output in Linux or Mac: ls -latr lLong list with more…
How to migrate GIT repository from bitbucket to AWS CodeCommit
Steps: Get code from bitbucket: git clone –bare https://<username>@bitbucket.org/<userdir>/<project>.git cd <project>.git git push –mirror ssh://git-codecommit.us-east-2.amazonaws.com/v1/repos/<project>
Ubuntu allow sudo su without password
Steps: Modify /etc/sudoers: from: sudo ALL=(ALL:ALL) ALL to: sudo ALL=(ALL:ALL) NOPASSWD:ALL