SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Evangelist barbara1712's Avatar
    Join Date
    Apr 2007
    Location
    India
    Posts
    509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Urgent help for mysqldump

    Hi

    I have MySQL database with size around 500mb. I want to set cron for my database. I am using mysqldump command for this.

    But the issue is with this command, it dumps the partial database having size around 270mb. The command I am using is

    mysqldump -umyuser -pmypass -h127.0.0.1 mydb > /root/backup/`date +%A`/mydb.sql

    Please help me with this.

    Your help will be appreciated.

    Thanks,
    Barbara
    Barbara

  2. #2
    SitePoint Addict
    Join Date
    Apr 2009
    Posts
    358
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    One guess, do you have enough disk space to hold the backup file? Maybe /root/backup is on a small partition.
    Doug G
    =====
    "If you ain't the lead dog, the view is always the same - Anon


Bookmarks

Posting Permissions

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