Tagged Questions
0
votes
2answers
105 views
What should I backup on my linux server?
I want to setup a backup with rsnapshot, but currently I don't know what particularly I should backup?
I mean should I backup my data ONLY like:
/var/www
/home2/ftpdirs
/etc/httpd/hosts/
...
1
vote
1answer
35 views
Dumping a read-only (select) database
I need to download a database given to me with select-only permissions to import it at my localhost for editing.
How can I do that?
0
votes
0answers
55 views
Is it possible to use cron jobs to backup both the file system and database of a WP site to Google Drive?
Is it possible to use cron jobs to backup both the file system and database of a WP site to Google Drive?
Any ideas what a script like that would look like?
SU
1
vote
1answer
313 views
MySQL - Avoid table locks during backup
I am running nightly backups on my server using mysqldump. Unfortunately that pretty much kills my site for half an hour or so every night, since the tables are getting locked during the backup.
...
0
votes
3answers
303 views
How to set up backups for MySQL databases a windows server?
I am new to MySQL, I have used MS SQL Server up to this point, so forgive my ignorance.
We are hosting on a Rackspace dedicated server and they can set up nightly backups on a directory. Currently, ...
2
votes
5answers
5k views
How do I split a large MySql backup file into multiple files?
I have a 250 MB backup SQL file but the limit on the new hosting is only 100 MB ...
Is there a program that let's you split an SQL file into multiple SQL files?
It seems like people are answering ...
0
votes
4answers
413 views
Simple question about using mysqldump
I have a LAMP website with mysql backend with InnoDb engine for tables
I would like to be able to use mysqldump to take periodic dumps of the database - WITHOUT having to stop the mysql server (i.e. ...
0
votes
2answers
110 views
How good is it to use MySQL to store backup images of my server?
Right now, I have cron to run a backup of my server at certain intervals. I manually download this file right now onto my home computer. I was just thinking about making it so that all of my backup ...
0
votes
1answer
176 views
What is the most efficient way to implement a cron job to back up a MySQL database and e-mail it to myself?
What would be the most efficient way to automatically back up a MySQL Database, gzip it, and e-mail it to a specific account?
I am a bit paranoid about losing my forum's database and I'm usually busy ...
3
votes
2answers
540 views
Where Are Databases Located - MySQL File Location
I just installed a CRM application with a MySQL database. I thought I new the name of the database but I can't find it. Now I am trying to perform a mysqldump but I don't know the name of my ...
