If your files contain whitespaces in their names, it can sometimes be a real pain. Expressly if you are on Linux or Unix systems. I had some problems when running rsync for backup my files. Files with whitespace were causing problems. So bellow is simple command that will remove all whitespace and replace them with “_”. You can change to any symbol that you like. I example bellow, I was searching for all jpg files.
find . -type f -name "* *.jpg" -exec bash -c 'mv "$0" "${0// /_}"' {} \;
Here is a simple solution on how to create loop for curl requests.
Just replace 30 with number of requests you want to make.
curl http://www.mywebsite.com/?[1-30]
I am Mega user for quite some time now. I have VPS on which I run my blog. Idea was: can I upload my blog/website/database backups to my Mega account daily? So I wish to use Mega as some sort of backup service. It is possible as there is Linux tool that allows operations through your Linux machine to your Mega account. It is called megatools. Mega offers 50G of capacity for free! In most cases, this should be more than enough to backup your websites. You can backup your server to your Mega account! Downside is, that megatools currently don’t offer function such as is rsync – for archive purposes.
Sed is great command to use. I was writing some bash script and I needed to replace some strings in file with string saved in variable.
sed “s/string1/$string2/g; s/string3/$string4/g” $CFGFILE
When executed, script was returning this error:
[root@vincentvega]# ./myscript sed: -e expression #1, char 14: unknown option to `s'
After googling around for a while I figured out that / was causing the problem. So I replaced / with | and now works fine. I think that you can also use some other char than | if you want.
sed “s|string1|$string2|g; s|string3|$string4|g” $CFGFILE
Sometimes you may want to save output of some mysql query to a text file. Maybe even to Excel’s spreadsheet file so that you have more control with editing, sorting … MySQL offers many useful options there.
Below is an example on how to save some mysql query output to csv file. You can terminate fields with some key character which is super useful. This example has fields terminated with ; and lines with \n.
mysql> select firstname, lastname, email, phone from clients INTO OUTFILE '/tmp/outputfile.csv' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n';
Just make sure that mysql has suitable permissions so that it will be able to write to a file – chmod 777.
We all know how annoying those ^M-s can be all over your script or file. ^M is a carriage return, and is commonly seen when files are copied from Windows. All of them can be removed in one step, with vi editor. Open your file in vi and hit escape. Then do like shown below.
%s/{Ctrl+V}{Ctrl+M}//{Enter}
If you want to test if users can ssh to a server with their passwords but your attempt is overridden by your ssh certificate, this is how you can do it.
ssh user@my.hostname.com -o PreferredAuthentications=password
By default, if you try to chown symbolic link, e.g. symlink, it won’t work. User and group of symlink will stay the same after attempt. What you can do is add -h flag in your chown command. This flag stands for –no-dereference and it means »affect symbolic links instead of any referenced file«.
Example:
### symlink is owned by root [root@myserver www]# ls -l lrwxrwxrwx 1 root root 13 May 14 14:51 html -> /var/www/html ### try to chown directory with nginx user and group [root@myserver www]# chown nginx:nginx html ### no changes [root@myserver www]# ls -l lrwxrwxrwx 1 root root 13 May 14 14:52 html -> /var/www/html ### try chown with -h flag [root@myserver www]# chown -h nginx:nginx html ### ownership of symbolic link html is now changed [root@myserver www]# ls -l lrwxrwxrwx 1 nginx nginx 13 May 19 14:52 html -> /var/www/html
By default, WordPress won’t allow you to change username of your administrator account. There are several ways to do this. There are even plugins for this, but I think using plugins for this task is unnecessary and bad idea in general. WordPress is great but consider using as less plugins as you can. Especially bad ones, they are just calling to be hacked by evil guys with too much time. 🙂
Here is how to change administrators username with one simple mysql command.
First, select your wordpress database.
mysql> show tables; +-----------------------+ | Tables_in_sample-blog | +-----------------------+ | wp_commentmeta | | wp_comments | | wp_links | | wp_options | | wp_postmeta | | wp_posts | | wp_snippets | | wp_term_relationships | | wp_term_taxonomy | | wp_termmeta | | wp_terms | | wp_usermeta | | wp_users | +-----------------------+
So in this case I want to change username for my admin user.
mysql> select id, user_login from wp_users; +----+------------+ | id | user_login | +----+------------+ | 1 | admin | | 2 | someuser | +----+------------+
You just have to update user_login field in wp_users table with command below. Of course change id and user_login value to your needs.
mysql> update wp_users set user_login="igor" where id="1"; Query OK, 1 row affected (0.05 sec) Rows matched: 1 Changed: 1 Warnings: 0
Username is now changed. You can login in your wordpress with new username.
mysql> select id, user_login from wp_users; +----+------------+ | id | user_login | +----+------------+ | 1 | igor | | 2 | someuser | +----+------------+
© 2024 geegkytuts.net Hosted by SIEL
Recent Comments