Skip to content
  • Home
  • About

Recent Posts

  • Hadoop: namenode and datanode
  • Hadoop: track which data block in which data node
  • Hadoop : run a mapreduce job
  • Elasticsearch: Running text search
  • SSH: execute local script on remote machine

Recent Comments

Archives

  • August 2016
  • July 2016
  • December 2015
  • August 2015
  • July 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • May 2014
  • April 2014

Categories

  • apache
  • backup
  • bash
  • debian
  • django
  • dns
  • git
  • grub
  • gui
  • LDAP
  • Linux
  • Linux Hadoop
  • mysql
  • mysqldump
  • nameserver
  • nginx
  • perl
  • python
  • python2.7
  • restore
  • route
  • secureCRT
  • sshd
  • timezone
  • ubuntu
  • Uncategorized
  • vim
  • virtualbox
  • web browser

Meta

  • Create account
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

palatana

Wandering technophile

Menu
Widgets
Search

restore

Mysql backup and restore

How to take backup of mysql database and restore it ?

….

Backup –

mysqldump -u user -p databasename > backupname.sql

Create – empty database should be created before restoring.Database has to be created in mysql console

create database databasename;

Restore –

mysql -u user -p databasename < backupname.sql

January 22, 2015dazedmonk backup, linux, mysql, restore, ubuntu Leave a comment
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • palatana
    • Already have a WordPress.com account? Log in now.
    • palatana
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
Design a site like this with WordPress.com
Get started