I do think this is somthing all Threads 7 users should know.
Cron + Backup Database.

Hi ive been rummaging around the tinternet,
and looking for a solution to backup mysql database
and also make it into a cron job for nightly back ups.

Why?
Well coming from classic we didnt have to worry about databases and looking after them, so if there was documentation covering this with Thread 6 then i dont have that documentation.

So now i'm on V7 Threads, and its all new, i'm now getting worried about backups and making sure i have steps in place
if somthing was to go wrong or DIE.

Currently i'm manually downloading them via my server control panel not phpadmin but via Direct Admin.(cp)
But there only about 30mb .tar.gz
But that is sure to grow and grow and then my problems will start.

So i'm asking for help with this as i have read on numerous occasions that once your database gets to xx size or time out
your asking for problems, and i would like to at the least
begin to address this before its too late.



I want be able to make a cron job (Script) to automate this in the night.
Links or any Help and advice would be appreciated.


Rather than tears later.

Thanks.

I am using this script:


This generates 1 month of database backups in the /home/backup directory. I am additionally using rsync to mirror the backup directory on my second server.

Thank's
I'm going to play more than dumb, which isnt that dfficult
so it can help others who are curious.

The script about does need to be modified to suit your paths.
It needs to be saved in a file ending in .sh
uploaded to a directory to be used.

Is that about right?

Yes


No, the .sh ending is not necessary. I called the script on my installation "zbackup".

You need to copy the script to your /etc/cron.daily directory and chmod it to 755. All scripts in this directory will be automatically executed every day in the morning.

Thank you

I have the option via my cp (Direct Admin) to select the path
where the script would be located, and the cron can run from
there, well that's what I'm going to try.

What's your thoughts on this one?
I found it on a google search ?
Good or Bad ?

Its big but covers a lot of things too, e-mailing when done?
Or is it just over the top.

Link

Thanks for any help

I have a nightly cron job that backups the database and it is done through webmin.

Help i have a problem

Its either something stupid or something worse?

I'm in at root and i'm running the command just to test
the paths before a start any scripts.

I get this error and a google search shows 5 results

mysqldump: Got error: 1103: Incorrect table name 'test.sql' when doing LOCK TABLES

To get that error i'm typing in the following.
User name and passwords are changed.

mysqldump -uXXXX -p1234 my_table test.sql

Ive been trying to sort it for hours now

My Table name does have something similar too

my_table

but that's it?

i can connect in via the command line.
and if i run the mysqldump with out a file name
mysqldump -uXXXX -p1234 my_table
it wizzes past my screen in Putty and stops thankfully.

Any ideas Help !?

Working now (O the fool)

mysqldump -uXXXX -p1234 my_table test.sql

is now

mysqldump -uXXXX -p1234 my_table >test.sql

Added ">"

May help someone, ?

I use this (crafted her myself, modified as to not show all of my sites, since it can get extensive):



Basically:
Backs up webspace.
Backs up Database
Changes owner to the backup user.
Uploads to my home machine.
Deletes the backup on the server.
Emails me that its complete.

Now here my "backup MySQL" backs up the mysql data directory directly; you could easily just program in your MySQL dump paramaters in its place.

I'm finding all this very helpful, cheers
i'm sure its going to help others too.

I'm sure to post more lol...
Ive had to forget my script as ive been on with this and that
all day now and eyes are going fuzzy.