R&P - Research And Program

Automatic MySQL Backup using Batch File on Windows

Backup of your database are important. You can do the backup manually but automatic backup with regular time interval are good and time saving. In this post I am specifically talking about Mysql. Unfortunately there is no free solution for auto Backup. So, There is a simple workaround available on windows platform to make MySQL backup automatically and freely. For this reason, you require a batch file and you have to write a batch script. And here are the steps for Mysql Database auto Backup:

1. Create a backup.bat file

2. Open the file in notepad and add this

echo off

start "" "C:\wamp\bin\mysql\mysql5.6.12\bin\mysqldump.exe(your my sql dump address)" --user root --password=(provide your db password here) databaseNameHere --result-file="D:\database backup location SqlFileName.sql" --database databaseNameHere

Now let's break down the string we have mentioned in the above file:

Post Processing and Unity WebGL

A common question asked several times about unity post-processing and WebGL, why post-processing is not working on my browser or some of post-processing features are not working in browser: The reason is that post-processing works with WebGL 2 (Unity Forum). Unity WebGL Post processing doesn't work on WebGL1. If your browser and GPU support WebGL 2.0 then PPS (Post Processing stack) should work within your browser. Unity Support graphics API WebGL 1 and WebGL 2 and if Graphic API settings are set to auto then WebGL 2 will try to run first (if supported in the browser) :

Remove Empty Unity Events - Do Empty Unity Events cause Performance Issues?

You definitely have noticed this thing that whenever you create a new script in Unity3D, the Unity scripting template adds two methods or unity events by default. The two methods are Start () &Update ().

using UnityEngine;
using System.Collections;

public class MyCustomScript : MonoBehaviour {

	// Use this for initialization
	void Start () {
	
	}
	
	// Update is called once per frame
	void Update () {
	
	}
}

How to create a Basic Glass & Mirror in Unity3D

In this game development unity tutorial i have explained how to create a glass or a mirror using reflections and shader settings.

How to Render Game View in Grayscale Mode in Unity3d

Welcome to another unity game development tutorial, today i will show you how to render your whole scene or game in grey scale mode. Gray scale mode help you to

Building a Traffic System in Unity - Game Dev Guide Tutorial Follow output

Visual Studio 2019 Tips for Unity Developers - 4 Coding Tips for Unity3d...

Unity Tips Collection - Videos, Tweets Collection

I have posted and gather several UnityTips and tricks into my blogs and youtube channel and in this post I again collecting all the links. Most of the tips are targetting beginners game developers. So here is the list without particular order:

1. 10 Worthy UnityTips that everyone should know

2. Isolate selected GameObject in scene/hierarchy

3. How to make gameobject/cube transparent in unity.

4. Unity Text Mesh Pro Always render on top

5. #Vector Graphics Package Missing Solution in #vectorart

6. Get All children of gameobject including inactive children in Unity3d

7. Unity coding Tips

8. Unity Shader Tips and Tricks

9. Scene Tips and Tricks

10. Editor, Performance, Build Tips and Tricks

#UnityTips #GameDev #Unity3d #Unity2019 #TextMeshPro #UnityTips #UnityCodingTips