WebFaction
Community site: login faq

Hello. I have installed a django application and a mysql database. I am using phpMySqlAdminInterface to connect to my database and I have noticed that there is an export database option which dumps my database in a .sql file. So, my question is, is there any way to configure my database to export its data automatically, lets say once per day?

asked 09 Feb '12, 13:04

alex_wf
515
accept rate: 0%


We have some documentation here http://docs.webfaction.com/user-guide/databases.html#backing-up-a-database-automatically that you can use to backup your database automatically.

permanent link

answered 09 Feb '12, 13:11

bmeyer71 ♦♦
1.5k3613
accept rate: 33%

Thank you for your immediate response. I will check it and I will let you know.

(09 Feb '12, 13:12) alex_wf

Yep, it worked fine for me. I followed the instructions and I had no problem.

(11 Feb '12, 12:25) alex_wf

Because with webfaction you have shell access, you can also use mysqldump db_name -u username -p > bak.sql You can thus configure a cronjob that runs this every day.

permanent link

answered 10 Feb '12, 02:08

markusbarth
1127
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×84
×5
×5

question asked: 09 Feb '12, 13:04

question was seen: 2,548 times

last updated: 11 Feb '12, 12:25

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2019 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM