Linux Mysql, ubuntu

[zielok]

Hello,
I'm using Ubuntu 8.10 Server.

How to backup database? I don't want to do it by phpmyadmin. Is there any command to export it fast? Also is there any way to export it every day at the same time?

 

[xxgoosexx]

Hello,
I'm using Ubuntu 8.10 Server.

How to backup database? I don't want to do it by phpmyadmin. Is there any command to export it fast? Also is there any way to export it every day at the same time?

make a file named backup.sh
and paste in

#!/bin/bash
/usr/bin/mysqldump -u user -ppass --databases DB_NAME | gzip > /DIRECTORY/2/SAVE/IN/NAME_`date +%m_%d_%y`.gz

user . usually root
pass . your password
DB_NAME . database name
/DIRECTORY/..  directory to save in

so for example

#!/bin/bash
/usr/bin/mysqldump -u root -pmypass --databases goosioot | gzip > /home/goose/Desktop/2GoosioOT_`date +%m_%d_%y`.gz

that will put the database in a compressed file..to do it on a regular basis automatically you need to create a cron task, google it, you will find some info on it