Skip to main content



Using mysqldump in command line: Tutorial for beginners

mysqldump command utility is used to take copy of one or more MySQL databases for backup or transfer to another server. Using this command you take a dump of a database in different formats like SQL, CSV, text and XML.

A simple dump operation can be done using following command:

mysqldump -u username -p databaseName > "filename.sql"

This command will prompt for password and once you enter the password a copy of that entire database will be generated and saved with the given filename.

Now I will go deep into some very usefull mysqldump options and how to use them in real world with examples.

1. Take dump of all databases To take backup of all databases you can simply use the option name --all-databases .

mysqldump -u username -p --all-databases  > "filename.sql"

2. Take dump of single table To do this you just need to specify the table names.

mysqldump -u username -p databaseName tableName > "filename.sql"

3. Take dump without create table statement …
Recent posts

Everything You Need To Know About Lg Thinq

"Thinq" or "Lg Thinq" is a phrase that is already famous in the tech industry. Even though there are people who are still don't know what it means and why the South Korean multinational company LG use add this "thinq" tag with its latest devices. What is Thinq? Basically Thinq or LG SmartThinQ is brand launched by LG in 2007. But the specialty is every device that feature Thinq brand name will be equipped with latest Artificial Intelligence (AI) Technology. Thinq brand is originally launched for consumer electronics and home appliances such as air conditioners, TV and refrigerators. Also the first product to have Thinq branding is a smart refrigerator with features such as food management system and smart savings options.

In Feb 2018 the company launched its first smartphone with "Thinq" branding called the LG V30S Thinq. After that company kept on launching several smartphones with this branding like LG G7 Thinq, LG V40 Thinq etc.  Feature…

How to connect remote DB from localhost using PhpMyAdmin

Connecting to a remote database from localhost can be done in many ways. Here I am going to explain a very simple way to do so. That is, connecting a remote database using phpmyadmin in the local server. To do so you need to follow the simple steps given below, Note: Hope you guys have server installed in your local machine Xampp, Wamp etc. I am using xampp for the tutorial.
1.Open the XAMPP control panel. You can open it from the Xampp directory. (eg: C:\xampp ->xampp-control) 2.Click on the Config button on the right side of Apache and select PhpMyAdmin ( from the dropdown list. 3.Now you need to add the connection details in the document just before the php closing tag in the following format. Eg: $i++; $cfg['Servers'][$i]['host'] = ''; //provide hostname and port if other than default $cfg['Servers'][$i]['user'] = '';//user name for your remote server $cfg['Servers'][$i]['password'] = '';//pass…

How to Restore Accidentally Deleted Google Chrome Data

If you have accidentally deleted Google Chrome user data including bookmarks, saved passwords and search history, then you can restore the chrome data easily by accessing the User Data folder. Google Chrome automatically stores all your browser data including bookmarks, saved passwords, search history and settings in a hidden folder named User Data inside the AppData folder.
First you need access to the User Data folder. In order to view the folder, first enable the hidden files and folders.
For Enabling the Hidden files and folders view
Search for "show hidden files and folders" in the start menu. Check to enable the "Show hidden files, folders, and drives" option.
Then Click OK

To Restore the Chrome Data
Close the Google ChromeIn the Windows Explorer, navigate to the location "C:\Users\%USERNAME%\AppData\Local\Google\Chrome\" , where %USERNAME% is your system username Right click on the "User Data" folder and choose "Restore previous versions&q…

Nubia Z17 Mini with dual-rear camera setup launched in India at Rs. 19,999

ZTE Nubia has launched its Nubia Z17 Mini smartphone with dual rear camera setup in India. The device is priced at Rs.19.999 and will be available via Amazon from June 12.
The Nubia N17 Mini features a 5.2-inch Full HD display with 1920 x 1080pixels resolution. The screen also has a pixel density of 424ppi and it comes with Corning Gorilla Glass protection. The smartphone is powered by a Qualcomm Snapdragon 652 Octa-Core 64 bit processor coupled with 4GB RAM. The device possesses an internal storage of 64GB which can be expanded upto 200GB via microSD card. 
The Nubia Z17 Mini comes with a dual-rear camera setup consisting of two 13MP Sony IMX258 sensors - Sony full-light MONO sensor and a true color RGB sensor. The dual rear camera setup has a 3D mode that creates interactive 3D pictures. On the front the device has a 16MP sensor with 80° wide angle lens and F2.0 aperture. 
The phone runs on Nubia UI 4.0 based on Android 6.0 Marshmallow. The Connectivity options of this device inclu…

Moto C with 4G VoLTE launched in India at Rs. 5,999.

Lenovo owned Motorola has officially launched Moto C in India. The phone was launched in some foreign countries last month. The budget smartphone is priced at 5,999 and will be available through leading retailer stores across India. Moto C will be available in two colour variants - Pearl White and Starry Black. In Indian market the Moto C will go head to head with Xiaomi Redmi 4A which is also priced at Rs. 5,999. 
Key features of the device are 5-inch FWVGA (854×480) display5MP rear camera with LED Flash2MP front camera with LED Flash1.1GHz MediaTek MT6737M quad-core Cortex-A53 SoC 1GB RAM16GB internal storageExpandable up to 32GBDual SIM4G VoLTEAndroid 7.0 Nougat Operating system2350mAh Battery

Yu Yureka Black launched in India at Rs. 8,999.

YU Televentures are back with a latest smartphone called Yu Yureka Black. The smartphone is priced at Rs. 8,999 and the phone will be available for online purchase from Flipkart through a Flash sale scheduled at 12AM on June 6. Yu is continuing its online only strategy. The device will be avaiable in two color options- Chrome Black and Matte Black colour variants.
YU Yureka Black features a 5-inch Full HD IPS display (1080×1920 pixels) with a 2.5D curved glass design. The Yu Yureka possesses a metal unibody design. The device is powered by a 1.4GHz octa-core Qualcomm Snapdragon 430 MSM8937 64-bit processor coupled with 4GB DDR3 RAM. It comes with 32GB of internal storage and supports storage expansion up to 64GB via microSD card. 
The Yu Yureka black comes with a 13MP rear camera with dual-LED flash and supports different modes like Night, Panorama, and HDR. The device also possesses an 8MP front facing camera with selfie flash. The smartphone also features a fingerprint scanner embed…

How To Download Videos or Audio From Streaming Websites

Most video sites operate on streaming algorithms. These algorithms only allow the online streaming of videos and prevent the downloading of videos to your disk or memory. Although, downloading videos from these kind of sites are breaking the rules. But there are lot of ways to do so. 
In the case of YouTube, it allows you to save videos for offline streaming. But it doesn't allows to download the videos to local drive or memory. But there are lot of methods which let you to download videos or just extract the audio and save them to your local drive or memory. The simplest way you can do this is by removing three letters from the video URL. For example a YouTube video URL will look like this . Now remove the letters 'ube' from the word 'youtube' on the link and hit 'enter'. This will take you to a new website called ''. This site allows you to download the video or just the audio of the video as an…

Asus Zenfone Live Launched In India At Rs. 9,999

Asus has launched a new device in the ZenFone series called the ZenFone Live. The main feature of this smartphone is it comes with the worlds first real time beautification technology for live streaming videos. Company's new live beautification app called BeautyLive is used for this real time beautification. So this smartphone is mainly aimed at those who like shooting videos on social medias.
The device comes with a 5MP front camera with LED Flash, auto focus, 1.4 micrometer pixel size and 82 degree wide angle lens. It sports a 13MP rear camera with f/2.0 aperture lens and pixel master technology. 
The ZenFone Live comes with a 5-inch HD IPS display with 2.5D glass at a resolution of 1280×720 pixels. It also has a Bluelight filter for eye protection. The device is powered by a quad-core Qualcomm Snapdragon processor coupled with 2GB of RAM. It comes with 16GB of internal storage which can be expanded upto 128GB.
The connectivity options of this device include 4G VoLTE, WiFi 802.…

Xiaomi Redmi 4 :Second flash sale on Amazon is scheduled on 30th May at 12pm

The Chinese smartphone maker Xiaomi is continuing their success in Indian smartphone market with its latest device Redmi 4, successor to the Redmi 3S series. The device had its first flash sale today on Today Amazon witnessed record sale of Redmi 4. On its first flash sale 2,50,000 units of Redmi 4 has been sold within 8 minutes of the sale, Amazon India confirmed. 
Amazon has announced the date of second flash sale. The next sale is scheduled to be on 30th May 12PM. Amazon India is also providing a lot of launch offers to boost the sales. Offers include up to Rs. 5000 off on flights and hotel bookings on goibibo, 45GB free data for 5 months from Vodafone and Rs. 200 promotion credit for Kindle books on Kindle app. Also on the accessories the Mi cases for redmi 4 starts at Rs, 349 and Mi headphones will start at Rs 599.
Key features of the device are 5inch 720p HD displayFront 2.5D curved glass13MP rear camera with PDAF5MP front cameraSnapdragon 435 octa-core processor2GB/3G…

ZTE Nubia N1 Lite Launched In India At Rs. 6,999

ZTE sub-brand Nubia has launched an entry-level smartphone in India named Nubia N1 Lite. The N1 Lite was first unveiled at the MWC in February and it will be available from May 22 from the e commerce giant Amazon at a prize of 6,999.The device will be available in black color only.
The Nubia N1 Lite comes with a 5.5inch HD IPS display with 1280 x 720 pixels resolution. The device is powered by a 1.25GHz quad-core 64-bit MediaTek MT6737 processor coupled with 2GB of RAM. The phone also comes with 16GB of internal storage which can be expanded upto 32GB via a microSD card.
Camera on the Nubia device had been fantastic till now. Nubia Z11 mini is the best camera phone you can get under 20K in India. That shows how the Nubia cameras perform. Here the Nubia N1 Lite comes with an 8MP rear shooter with f/2.0 aperture and four element lens. It also has a LED flash. On the front the N1 Lite packs a 5MP camera with f/2.8 aperture, 84-degree wide angle lens and front flash. The smartphone also f…

Karbonn Aura Power 4G Plus with 4000mAh battery launched at Rs. 5,790

After the launch of Aura 4G smartphone last week Karbonn has now come up with an addition to its lineup called Aura Power 4G Plus. The main attraction of the new device is its battery. The Aura Power 4G Plus replaces the small 2150mAh battery in the Aura 4G by a large 4000mAh battery. This battery promises a stand by time of up to 400 hours and talk time of up to 16 hours.
The Karbonn Aura Power 4G Plus features 5-inch HD display with 720x1280 resolution. This dual SIM smartphone comes with 4G VoLTE support. The smartphone runs on the latest Android 7.0 Nougat and is powered by a 1.3GHz quad-core processor coupled with 1GB RAM. The device comes with an internal storage of 32GB which can be expanded upto 32GB using external microSD card. 
The smartphone features a 5-megapixel rear camera with dual-LED Flash and a 5-megapixel front-facing camera with LED flash. Connectivity options include Wi-Fi 802.11 b/g/n, Bluetooth 4.0, GPS and OTG support.
The Karbonn Aura Power 4G Plus is priced …

Vivo V5s with 20MP selfie camera is on for sale now at Rs 18,990

Vivo V5s, the successor to the V5 launched in November is on for sale in India at Rs. 18,990. This selfie smartphone was launched at an event in Gurugram earlier this month. Eventhough the phone was launched in two colors only the Matte Black variant of the device is available now. The Crown Gold colour variant will only become available starting May 20. The main attraction of this device is the 20MP front facing camera which makes the smartphone a selfie-centric one. 

The Vivo V5s has a 5.5inch IPS LCD display with a resolution of 1280x720 pixels. The display comes with a 2.5D Curved Glass, Gorilla Glass protection, and a pixel density of 267ppi. The phone is 7.6mm thick and features an all metal build. The device also features a fingerprint sensor on the home button. 

The device is powered by a 1.5GHz MediaTek MT6750 SoC coupled with 4GB of RAM. It comes with 32GB internal storage which is expandable upto 256GB using a microSD card. The dual SIM smartphone runs on Android 6.0 Marshmal…