Results 1 to 4 of 4

Thread: mysqldump: How to backup a particular Database in MYSQL

  1. #1
    Junior Member
    Join Date
    Apr 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Default mysqldump: How to backup a particular Database in MYSQL

    Hi All,

    Thanks in Advance!!

    How to backup a particular Databases..through Bash script!!

    For example i have 6 databases;

    Anish
    linux
    Software
    Questions
    Rhce
    Google

    these are the databases i have from that i want to take "Anish" and "questions" database backup regularly.
    through script. Is it possible !!

    With Regards
    Anish Kumar.V

  2. #2
    Member Shell_Life's Avatar
    Join Date
    May 2011
    Location
    Bahia, Brazil
    Posts
    99
    Thanks
    0
    Thanked 11 Times in 11 Posts
    Rep Power
    5

    Default

    Members here have unix knowledge.

    How to backup MYSQL databases is a specific MYSQL question, not an unix question.

    You will have a better response if it is posted at a MYSQL site.

  3. #3
    Never say die nixcraft's Avatar
    Join Date
    Jan 2005
    Location
    BIOS
    Posts
    4,512
    Thanks
    17
    Thanked 799 Times in 511 Posts
    Rep Power
    10

    Default

    Use the mysqldump command as follows to backup a database called Anish:
    Code:
    mysqldump -u root -p'PasswordHere' Anish > Anish.sql
    mysqldump -u root -p'PasswordHere' Questions > Questions.sql
    All [Solved] threads are closed by mods / admin to avoid spam issues. See Howto mark a thread as [Solved]


  4. #4
    Junior Member
    Join Date
    Oct 2011
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Default

    You can also backup multiple databases to a single backup file:

    mysqldump -u root -p'PasswordHere' --databases Anish Questions > mybackup.sql

    Check the mysqldump docs for more information about the mysqldump parameters

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Database Backup Program
    By nikhilbabu in forum Web servers
    Replies: 0
    Last Post: 15th October 2011, 02:58 PM
  2. Replies: 4
    Last Post: 20th January 2010, 04:57 PM
  3. MYSQL database script
    By jerry in forum Databases servers
    Replies: 3
    Last Post: 15th July 2009, 08:14 PM
  4. how to do MYSQL online backup of huge database
    By manish_2479 in forum Databases servers
    Replies: 4
    Last Post: 12th July 2008, 12:36 PM
  5. ssh backup particular mysql table / database
    By brothers in forum Databases servers
    Replies: 11
    Last Post: 25th October 2007, 05:06 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •