Keyhelp remote mysql access
Leave a reply
CSS libraries for me
I’m not frontend programmer. Yes, I can implement any idea into project but again I’m not frontend programmer…because my designing skills are not that great but my brain is way to fast for systems designing and programming 🙂
That’s why I use this libraries:
DirectAdmin SFTP admin backup
I have found nice little script for this problem I have for years. I did made my own backup script, really simple one, but it worked fine so far…but this is better.
Imagick Ghostscript changing png alpha
vi /usr/local/etc/ImageMagick-7/delegates.xml
Increase SWAP in Centos
PHP bash version change
CPU steal time – how to check
You can easly check steal time of your VPS if you run top command and take a look at the info there.
At the end of the cpu line you should see this:
Now, if you want to make sure steal time readings are correct use something like:
dd if=/dev/zero | md5sumThis command will make sure your cpu is actually doing something. That way CPU steal time readings will be correct. After running this command on other vps I’m using I have got this:
Now you get the idea. This other VPS is oversold. Without using upper command I get this:
Let’s try again…
You should always make sure CPU is being used at that moment in order to get correct CPU steal time numbers…
Nick
Crontab wget and curl
Let’s say you want to cron something.
BitBucket laravel initial commit
I have found it here but since I have older phpstorm there is a way to do it easier
https://stackoverflow.com/questions/47613209/how-to-set-up-bitbucket-in-phpstorm-2019
Step 1: Install Bitbucket Linky using this guide. Note Bitbucket Connector is no longer being developed.
Step 2: Set up a new private repository on Bitbucket. If you’re using WordPress, I’d recommend creating a repository for each plugin you are developing, rather than for the entire install. Leave it empty for now.
Step 3 Create a new project in PHPStorm or use an existing one. Click VCS>Create Git Repository. Select the path of your project.
Step 4 Now the repository is properly set up, I then added – using Finder – all of my files into the local repository folder.
Step 5 Select all of your project – which should be in red text – and click VCS>Git>Add. This will have added these files to the project, but not yet pushed them to the remote server.
Step 6 Now select the root directory of your project and click VCS>Git>Commit Directory.
Step 7 Go to VCS>Git>Remotes and add a new remote. You need to get this in Bitbucket by clicking ‘I will be starting from scratch’ and then copying the URL (https://youraccount@bitbucket.org/youraccount/yourrepo.git) and pasting it into PHPStorm.
Step 8 Click VCS>Git>Push. This actually moves the files to the server.
Hope that helps some one – took me ages to figure out. You’re now in the capable hands of many guides on how to use Git.
After step 6 I couldn’t find Remotes so I just clicked on project folder, right click, git->repository->push and then clicked on top remote and then added bitbucket link (https) and all the files were being pushed there.
That’s it.
MySQL import/export dump timestamp problem
I have just lost 4 hours today for a simple export import problem. Why it always has to be that way?!?!?
I had to transfer ip of the domain with the data and of course db. Like always everything was smooth but after trying domain (after dns change) I had to pictures online?!
I have tried everything. Problem was simple (after the battle everyone are generals) – it was mysql :
Dump TIMESTAMP columns in UTC (enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones)
Mysql columns were using timestamps because of the start and end date (23:59:59) for local time BUT when exporting that option was clicked and made strange dates on the importing mysql server.
After unchecking this box time was still strange but at least dates were not going -1 day.