Cron Jobs 1

[kizmar2]

I'm trying to set up a cron job to automatically back up a mysql database on a web host account.

I have researched the script for mysqldump and I'm under the assumption that what I have should output the insert statements (data) as well as the structure of the DB. All I'm getting in the SQL file output is the structure though.

Here's the script:

#!/bin/sh

[i](the line below is all one line)[/i]
mysqldump --opt -e db_name --password='hidden' --user='hidden' > /home/path/to/file/backup.sql

Am I missing something?

KizMar
------------

http://www.kizmar.net

 

[KarveR]

mysqldump --user='user' --password='password' --complete-insert --quick database table [--where='where clause']

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[kizmar2]

What if I want all records in all tables?

KizMar
------------

http://www.kizmar.net

 

[KarveR]

add:
-A or --All-databases
to the end

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[kizmar2]

Awesome it's working, thanks! This is what I ended up using in case anyone else can use it: (all on one line)

mysqldump --user='username' --password='password' --extended-insert bd_name > /path/to/file/backup.sql

KizMar
------------

http://www.kizmar.net