Results 1 to 4 of 4
  1. #1

    Most reliable way to backup a database?

    What's the most reliable way of backing up a large MySQL database?

    I'm considering phpMyAdmin. Under Export, what settings should I use?

    Specifically -

    Complete inserts
    Extended inserts
    Use delayed inserts
    Use ignore inserts
    Use hexadecimal for binary fields
    Export type

    Adventures in - Are you a parent? Listen to the free podcast and sign up for the newsletter!

  2. #2
    Join Date
    Jun 2004
    Boise, Idaho
    I have reliably for years run mysql backups from the command line:
      /usr/local/bin/mysqldump -A -u backup

    The user backup will have to have privileges to the mysql database.

    I then redirect the information into a file and then archive the file daily for 7 days, weekly for 4 weeks and then monthly forever.

  3. #3
    Join Date
    Nov 2003
    Newport Beach, CA
    if the database is closed (meaning nobody using it) you could also do a directory copy.

    if it's on a linux machine, /var/lib/mysql/databasename you can simply tar it, or even copy file for file.

    If it's a control panel situation the directory might change. For instance, if this is an Ensim box, it would be /home/virtual/

    I have used PHPMyadmin and had it time out backing up large databases (over 1 gb), resulting in a bad backup.

    Your best bet it to use the example matraex gave.

  4. #4
    Please, read articles about master-slave mysql servers.
    It is the most correct way to backup databases.
    Credit card processing, online check/ACH and EuroDebit payment solutions for the Internet merchants

Posting Permissions

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