creating backup

[boogyman]

Hey, my boss just asked me to do a backup of our database.
It is running on a Debian Linux Server and he wants me to back it up to a local Windows IDE drive. I have looked online, but I cannot come up with a script / command to do this? Help? Please Thanks

[boxxertrumps]

You should find the files in /usr/lib/mysql or /etc/lib/mysql, you just need to copy the contents to the other HDD.

[NXArmada]

MySQL has some Tools that you can use to help maintain the MySQL server.

MySQL Administrator allows you to back up databases and you can even have it Auto back up to a schedule if you wanted.

MySQL Tool Downloads

[countll]

bout this info is what i reaaly need.but still got problem backup files.
anymore ways help .thanks

[Twey]

$ mysqldump -u <username> -p <database-name> > backup-`date --rfc-3339=date`.sql

[boogyman]

$ mysqldump -u <username> -p <database-name> > backup-`date --rfc-3339=date`.sql

do i insert a date? or just the uname/dbnam ?

[Twey]

No, just the username and database name. You'll be prompted for a password.

[boogyman]

thanks mate

now to repeat (run like every sunday) that I would need to write a "cron" file?

[Twey]

Indeed.

[DefaultName]

Sheesh, I had the same problem. Thanks!



_______________
<Signature Removed By Moderator>