How To Backup Databases Using mysqldump Tool | Creating Database Backups With mysqldump

In this video we’ll see

WHAT IS MYSQLDUMP
==========================
MySQL GUI tools such as phpMyAdmin, SQLyog and etc, often provide features for backup
MySQL databases with easy & simplest way.

MySQL provides a very useful tool for backing up or dumping MySQL databases locally on
the server very fast. The backup file is stored in the file system in the server so you
just need to download it when needed.

The mysqldump can be used to generate CSV, delimited or XML files. In this tutorial, we
will focus only on how to backup MySQL database using mysqldump tool.

HOW TO BACKUP A MYSQL DATABASE
================================

1. To backup a MySQL database, the database first has to exist in the database server
and you have access to that server as well.

SSH Login: ssh username@hostname
Password

ssh root@12.54.87.89

Syntax:
=========
mysqldump -u [username] -p[password] [database_name] {greater_than_symbol_here} [dump_file.sql]

SOCIAL :
===============
Subscribe : https://www.youtube.com/channel/UCB2flCo-gW6RhpVVXySqcMg
FACEBOOK : https://www.facebook.com/onlinewebtutorhub/
TWITTER: https://twitter.com/owthub
BLOG: https://onlinewebtutorhub.blogspot.in/

Other Tutorials
===============
Wordpress Customizations:
———————————
Wordpress Theme (Hindi): https://goo.gl/MZ8maF
Wordpress Widget (Hindi): https://goo.gl/Dc2htn
Wordpress Plugin (English): https://goo.gl/BA7dYG
Wordpress Theme Options (English): https://goo.gl/Vjv3Ub
Wordpress JSON Rest API (English): https://goo.gl/SVQRQR
Wordpress JSON Rest API (Hindi): https://goo.gl/NNWfKa
and many more…

Javascript framework:
———————————-
Learn backbone.js here! (English) : https://goo.gl/Qd2Pcs
Learn Vue JS here ! (Hindi): https://goo.gl/MVtsmh

PHP Frameworks:
———————————-
Laravel tutorial (Hindi): https://goo.gl/Nh9qJk
CakePHP tutorial (Hindi): https://goo.gl/uRsS3G

Tags
===================
Dumping Data in SQL Format with mysqldump – MySQL,
Use mysqldump to Back Up MySQL,
Downloading MySQL dump from command line,
Creating Database Backups With mysqldump,
How to Backup Databases Using mysqldump Tool,
how to use mysqldump,

Thanks
Online Web Tutor
Keep learning and Sharing 🙂

source

Leave a Reply

Your email address will not be published. Required fields are marked *