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. 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 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
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 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 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? 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
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