Not signed in (Sign In)

Categories

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.

Help keep Vanilla free:
Welcome Guest!
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.

Vanilla: DB Backup for vanilla

Bottom of Page

1 to 12 of 12

  1.  
  1.  # 1
    I have the cleanup extension and i've used the database backup function in there. But how can I check it has worked? I'm paranoid about losing my data.

    Is there a surefire way to backup, even a way to be able to do it automatically for me?

    Any help much appreciated.
    •  
      CommentAuthorMark
    • CommentTimeJan 3rd 2006
     # 2
    You can always set up something outside of Vanilla entirely.

    If you have shell access, you can write a script to do an hourly/daily/weekly dump for you.
    •  
      CommentAuthorMark
    • CommentTimeJan 3rd 2006
     # 3
    Here's a discussion on wordpress about how they accomplished it:

    http://www.tamba2.org.uk/wordpress/cron/
  4.  # 4
    Thanks for heads up on the cron jobs Mark. I took a look at the options my host has and it provides a cron job feature whereby I can a command or php page at on a regular schedule. I've opened a support ticket with them to see if they can help me out further.
    •  
      CommentAuthorMark
    • CommentTimeJan 4th 2006
     # 5
    Be sure to post on here with whatever you come up with. I'm sure others would be interested to know.
  6.  # 6
    ok i got a cron job set up with the following command.

    mysqldump -u DBUSERNAME --password=DBPASSWORD DBNAME

    i simply replaced the details in caps and then I selected the options for choosing the schedule it would run that command on. I now get an email with all the sql in it every day. Obviously this will vary depending on your own host.

    alternatively you can run a .php file using the following command...

    wget -q http://yourdomain.com/phpmysqlautobackup/run.php

    it doesn't matter where you upload the file to. but using this method you could get the php page to create an attachment to send to you via email rather than all the sql being posted into it directly.

    hope this helps someone along the line.
  7.  # 7
    N.B. On some (the majority, i believe), you can use php as a command line to execute phpscripts. i.e. php /home/me/dump.php. Not much different but just a little tidier imo.
    •  
      CommentAuthorercatli
    • CommentTimeApr 7th 2006
     # 8
    OK, this is good. I haven't actually done it yet, but I think I can.

    But if you do all that and your DB crashes, how do you use the dump info to restore?
    •  
      CommentAuthorADM
    • CommentTimeApr 7th 2006
     # 9
    Well if you have shell access you can restore a database backup quite easily, or if you don't you can use phpmyadmin to import the sql dump.
    •  
      CommentAuthorGhotcom
    • CommentTimeJun 15th 2006 edited
     # 10
    I am trying to back up my database from phpmyadmin. (vanilla 1.0..) I have the export panel in front of me, which options should I check to have a complete image of the database ?
    •  
      CommentAuthorDinoboff
    • CommentTimeJun 15th 2006 edited
     # 11
    from phpmyadmin, select the vanilla DB, click on export.
    Keep the default option, click on "select all" (table), tick "Add DROP TABLE" and "Save as file", and click on "go".

    Keep in mind that the import fonction in phpmyadmin is limited to files with a size < 2 Mo (that the php limit for upload by default).
    •  
      CommentAuthorDinoboff
    • CommentTimeJun 15th 2006
     # 12
    "But if you do all that and your DB crashes, how do you use the dump info to restore?"

    With a shell access, it is this simple command:
    mysql -u DB_user -p User_password -D Vanilla_db_name < /path/to/Vanilla_backup.sql

1 to 12 of 12

  1.  
Add your comments
    Username Password
  • Format comments as
 
Back to Discussions Top of Page