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.

The Fuzzy Bunny Compells you...

ive just learned how damaging this command is when not finished and hitting the return key too soon ?

Example : i hit it when it looked like this by mistake.
chown -R backups:backups /

I stopped it as soon as i seen it, but too late.
I've just changed most of the ownerships on my server
I cant log in to my server control panel now.

Looks like a re-install and a bill to match

Gutted

As i walk the street looking for a cat to kick
Please note no animals were hurt on my walk, it was too dark,
and they were too fast for me, and i really couldnt
be arsed running after one. I want to cry.

Some of these commands, especially if you have root access can be quite dangerous. I've had my fair share of blunders.

Its still alive (Just) so I'm backing up what i can
Forums are Still on line ha ha..

My customers think there getting new hardware lol...
Hence the downtime, when i get a re-install

What is the extra Hardware one may ask?
A FAN

haha, never ever do anything to / lol... Especially "rm -rf /".

At least it was just a chown issue, you can fix it as root, should you know the proper owners.

What're you re-installing?

The OS it sounds like

Lol, you don't need to reformat th eos, just go in and update things that you b0ged :x...

Ive decided to go for a re-install ;(

Its the only way to be sure about the ownership of the file being correct and preventing future problems too.

I tweaked one of my forums today and got a snotty reply.

/home/domains/mysite.co.uk/public_html/forums/libs/mysql.inc.php on line 210

As i'm still finding that ownerships are still messed up, but give me some credit ??

I fixed it went in and made the mysql permissions back to mysql,
and it seems to be working now.

In a spooky kind of a way ive learned so much in a short time,
and continue to learn

and annoy me on msn :x

ROFL - Come on you know you enjoy it.

Gives me someone, other than Glider, to bother during the day ;)...

This topic could kill me or save me again lol..

Server Online and settling down again.

So back to where i was, before i cocked it all up.

Now i'm going to be very careful.

lol, don't choke