Backup and Restore MySQL DB Using mysqldump

mysqldump is a tool used to backup MySQL Database. It creates .sql file having DROP TABLE , CREATE TABLE , INSERT INTO TABLE sql Statements. To restore the database we have to execute the .sql file on destination database. Using mysqldump command you can backup a local database and can restore it on remote database.

Web Service at a Glance.

Web Service at a Glance. What is Web Service? A Web service is medium of communication between two electronic devices over a network. It is platform independent and programming language independent. They help us to exchange information across different machines.   What compromises Web Services? A web service generally composed of the followings. SOAP (Simple …Read More

How to use system commands in LUA

How to use system commands in LUA Lets assume we have some requirement to call Unix-commands on the click of a button by using LUA . To achieve this follow these steps : 1. First check your Lua page is working or not ?  > Run your lua page to ensure that there is no …Read More

JAVA POLICY FILE..

   JAVA POLICY FILE                                       The Java™ 2 Platform, Enterprise Edition (J2EE) Version 1.3 and later specifications have a well-defined programming model of responsibilities between the container providers and the application code.   The java.policy file is …Read More

Finding all the backedges in an undirected graph

Finding all the backedges in an undirected graph Finding cycles in a graph is an interesting problem. We say that a cycle is formed if there is a way to reach the source without visiting already visited vertices. In this article I will discuss about finding all the backedges in an undirected graph so that …Read More

DRAG AND DROP IN REACT (React DND)

DRAG AND DROP IN REACT This is an example of implementing drag and drop functionality using React. This is the first example where we’ll use an external library, in this case, React DnD. Components This example will have two major components: Bin, a component where objects can be dropped, and Item, an item that can …Read More

Staging DB in Datawarehousing – The WHYs and WHY NOTs

Staging DB in Datawarehousing – The WHYs and WHY NOTs   Whenever we talk about designing datawarehouses, staging database is one consideration we have to make. And it depends on many factors whether you choose to have one or not. I feel when we start small, like implementing small datamarts, we may not see the …Read More

What is a lookup? How is it different from the Merge Join component in ETL?

What is a lookup? How is it different from the Merge Join component in ETL? Lookup: A lookup is basically accessing data from a relational tables which are not sources in the mapping table. In SQL Terms, a lookup is a subquery of the main query. Lookups are used basically either for filtering data or …Read More

Introduction to Mango Automation(M2M)

What is Mango Automation (m2m)? Machine to Machine (M2M) refers to data communications between machines. The term also means the complexity of sensors which produce data, the communications channel which connects the sensors to a server computer and a software running on the server, having the task to analyze and report the collected data. Sometimes …Read More