Where is this happening?

We are a Coliving community, based in Colombia, a place where digital nomads, travelers, and freelancers share a lovely space to live and learn how is the culture of the country, every visitor shares willing to discover from each other. Check what some of our visitors think about this startup:

Magicbox notes

We have been building a lot of things during last 4 years, some of those have been server and programming related stuff, some were making physical stuff using tools and sometimes hacking and trying to come up with ideas, with this, we have decided to create a little blog where we will share problems and thoughts. Maybe these will help someone else.

Change WordPress Home and Site URL using MySQL

By whgandalf on June 21, 2018

When you are frequently working with WordPress installations, it is common to be migrating servers from and to different providers or registars. Some customers also like to change the URL or maybe add https support to the current backup. To explain this a little better I want to describe a migration from an old URL to a new URL as shown: Old url: http://myoldurl.com/ New url: https://newweb.com/ You usually start restoring the data backup in a database and set the old WordPress files into the original structure from the last installation, but when you try to open the website (in this case https://newweb.

Continue reading

mysqldump to Restore and Backup MySQL database

By whgandalf on June 20, 2018

When you need to handle MySQL databases, it is useful to have a tool which lets you create backup files and also restore them properly; this can be achieved by using mysql and mysqldump commands in the command line. To be able to use them, you have to make sure the user you will use has the privileges to manage the database you are working with, we will be using root MySQL user to go through the examples.

Continue reading

Create new MySQL User granting permissions to new database

By whgandalf on June 19, 2018

There are multiple systems where you need to set up a new database, Installing MySQL is always an option to achieve that, but after installation, you will have to follow some more steps to be able to provide the connection credentials to the system you are trying to connect, let’s try it following the next steps: How to create a database? First check if you have MySQL installed, you can do it running the command:

Continue reading

Compress and Extract files using SSH

By whgandalf on June 18, 2018

Sometimes we need handy lines to be able to compress or extract files in the command line using different extensions, here are some useful lines to achieve it: Compress Files Depending on the file extension and compression technology you have to use a different command line tool. The most commonly used however is the tar.gz format. An example of creating a file with this extension is: tar -zcf filename.tar.gz foldername/ You can also create zip files using:

Continue reading