How to make Back Up and Restore from backup in MySQL Database.

-
In this tutorial i will show you easy ways to backup and restore the data in your MySQL database.

Back up From the Command Line: 

Here is the proper  syntax to backup in command>

$ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]

Here:
  1. [uname] Your database username
  2. [pass] The password for your database (note there is no space between -p and the password)
  3. [dbname] The name of your database
  4. [backupfile.sql] The filename for your database backup
  5. [--opt] The mysqldump option 
For example, to backup a database named 'ranger' with the username 'root' and with password 'root' to a file ranger_backup.sql, using command:

$ mysqldump -uroot -proot ranger > ranger_backup.sql
 
Above command store your back file in home directory. If you want to backup in specific directory then go to your desired directory and execute the above command.
 
With mysqldump command you can specify certain tables of your database you want to backup.Each table name has to be separated by space.For example:

$ mysqldump -uroot -proot ranger commission content > ranger_backup.sql
 
Here>
  1. ranger is the databasename
  2. commission and  content are table names separated by space.
Sometimes it is necessary to back up more that one database at once.Each database name has to be separated by space.For example:

$ mysqldump -uroot -proot --databases ranger student erp > ranger_student_erp_backup.sql

  1. ranger,student and erp are databases name separated by space.
If you want to back up all the databases in the server at one time you should use the --all-databases option.For example:

$ mysqldump -uroot -proot --all-databases > alldb_backup.sql 

 Back up your MySQL Database with Compress:

If your mysql database is very big, you might want to compress the output of mysqldump. Just use the mysql backup command below and pipe the output to gzip.For example:
 
$ mysqldump -u [uname] -p[pass] [dbname] | gzip -9 > [backupfile.sql.gz]

 Restoring your MySQL Database:

  1. Create an appropriately named database on the target machine
  2. Load the file using the mysql command: 
$  mysql -u [uname] -p[pass] [dbname] < [backupfile.sql] 
 
 
Enjoy.........
 
 
 


 

Comments

Post a Comment

Popular posts from this blog

How to run ofbiz as ubuntu Service.

-
Apache Ofbiz developer need write script to start and stop ofbiz server as Ubuntu service. In my projects production and test server management i need this, and after spending few times  i got this. Here below i share my experience. The script code given below. #!/bin/bash -e ### BEGIN INIT INFO # Provides:          ofbiz # Required-Start:    $syslog $time $remote_fs # Required-Stop:     $syslog $time $remote_fs # Default-Start:     2 3 4 5 # Default-Stop:      0 1 6 # Short-Description: start Apache Ofbiz # Description:       Debian init script for the Apache Ofbiz, #                    the open source enterprise automation software ### END INIT INFO set -e ############################################################...
Read more

JPA vs Spring JPA vs Spring Data JPA vs Hibernate

-
JPA is the Java Persistence API , which is Java 's standard API for object-relational mapping . JPA is only an specification - you need an implementation of it to be able to use it. Hibernate is one of the most well-known and most used implementations of JPA, but there are others, such as EclipseLink JPA . The Spring Framework is a large framework to help you write enterprise-grade software easier. It contains support for many Java technologies, including JPA. The Spring Framework consists of a collection of projects , and one of these projects is Spring Data . The goal of Spring Data is to make it easier to work with different kinds of databases, from traditional relational databases to NoSQL databases. Spring Data supports JPA via the Spring Data JPA subproject. To write a program that uses JPA, you need at least a JPA implementation, such as Hibernate. If you are using the Spring Framework for your application, you will most likely want to use Spring Data JP...
Read more

Java Array Interview Questions for Entry-Level Developers Part 01

-
1. What is a Java array? (Definition, purpose, characteristics: fixed size, contiguous memory) Definition A Java array is a data structure that allows storing multiple values of the same data type in a contiguous block of memory. It is a fixed-size collection of elements, each identified by an index. Purpose Arrays are used to efficiently store and manage a collection of data. They provide: Fast access to elements using an index. Memory efficiency since elements are stored contiguously. Characteristics Fixed Size When an array is declared, its size must be specified. The size cannot be changed dynamically (for dynamic collections, use ArrayList or other collections). Contiguous Memory Allocation Arrays are stored in a continuous block of memory, making access faster compared to linked lists. Indexed Access Elements are accessed using zero-based indexing, e.g., array[0] refers to the first element. Homogeneous Elements All elements in an array must be of the same data type. Efficien...
Read more