Create Wordpress Website & MySQL Database Backup then Upload to Gdrive

It's easy to use plugin, but you only need few commands to run :D

Usually Wordpress user will just quickly find a plugin to backup the website and its databases. Is it to daunting to do it by ourselves?


Photo by Science in HD on Unsplash

I find plugin is easy in certain way, but for an admin myself, i prefer simple command / script to get the job done.

Create database backup

This is the command required to run a simple database backup in mysql.p/s you can change the destination path. I put in /tmp because i want to upload to gdrive later.

If you choose to upload to Gdrive

Normally a user might just want to backup the file to its host server. For this case i wanted to upload the backup file(s) to Gdrive. And im using a third party Gdrive command client. You might want to checkout tutorial on how to get it installed in your server~ **Use at your own risk! the third party cli will have access and write permission to your Gdrive files!**

I running below command to push my sql backup file to Gdrive.

Example usage : gdrive push -destination (path on google drive) (path on local drive)

You can verify that the file is uploaded successfully on Gdrive.

Why I backup to Gdrive?

One of the reason i want to share it around, have a secondary free cloud storage and I also want to reduce bandwidth usage of my internet. I'm using a mobile internet and really stingy about it. Thus using a server bandwidth is a better option to me. Why don't I push to Git? well that will be a better approach. But backing up the media files pushing to Git do no good.

Multiple revisions of large files increase the clone and fetch times for other users of a repository,

You can read more on this article from Git. I'll leave to expert to give thoughts on this. To be honest my website is not CI/CD compliant!

Next lets backup our Wordpress contents

First before we backup, probably we can remove any big log files. to reduced the backup size.

From above command theres two format of compressed file that we use. Gz and Zip. Depends on which is your preference. I made it two types so that Windows user has no issue decompress it :D

Of course i will push it to Gdrive again!

Done! Recheck your Gdrive to reconfirm everything has been uploaded successfully.

To see how to restore the Wordpress website and database check out my next post!

Comments

C# Serialization Tutorial Part 1 : Serialize object in file stream

Hello Peeps. Came across this topic while doing our game saving data feature. this post only cover basic serialization. basically serialization help us to convert our object into stream of bytes so that our object can be stored or transmit over in memory/file/database. before we can proceed with the serialization tutorial, we need to set the user permission to our target folder path. 1. Set the folder path to be accessible and can be override. This step is to avoid our program/apps from throwing unauthorizedaccessexception. - for my scenario, im choosing the path of D:\SelfLearning\c#\Serialization to store my data file. Right click the target folder, select on Security tab Select on Users and give full control or modify permission to the user. 2. Now we are going to write our code. First we need to setup our folder path. 3. We going to create our file. In this tutorial we are using FileStream type, other then FileStream, we can make use of MemoryStream i

Tutorial on Min3D framework using Android Studio

Salam peeps, UPDATES***, the model on the old link is no longer working. so i have create a github repo, where i put the source code in a project, you guys can try to clone in and run on your android studio device emulator or directly on your phone, Ive replaced the model with a cube. https://github.com/aliaramli/Min3DTutorial Previously i ve posted tutorial on min3D using eclipse IDE, i believe most of us has moved to Android Studio IDE in developing android apps? As previous tutorial shows a lot of support from readers and among hot post in my blog, i ve decided to post the same tutorial but this time using Android Studio. For those who are familiar with Eclipse/Android Studio migration they might not have problem in running this tutorial . For more detail explanation on min3D please visit this website page Ok lets get started. Step One Create a new android project in android studio. you may name it as what you like, below are how i defined my project settings.

Tutorial on min3d framework

Salam all. This time I want to share a bit, how I tried out the mid3d framework for the first time. Acknowledge that I am new to android development. I just follow the tutorial on Mat-d website but there are certain things that I don’t understand how they actually work. Thus I want to share what I did step by step to make this example work. For explanations on coding/steps or errors please visit Mat-d website here J you ll understand more …. mat-d original tutorial load a 3d obl model with min3d for android Step one . Download min3d into your eclipse . Select File>Import>SVN>Checkout projects from SVN Next. Choose radio button : Create a new repository location Next. Enter the svn location http://min3d.googlecode.com/svn/trunk the thing that we want to check out from the svn is the min3d framework code. Step two. Download obj file www.3dvia.com …you need to register first..it has free acc version.. and download the followin

Coding Codex

Search This Blog