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 (http://mysql.org/downloads/gui-tools/5.0.html) 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 (http://mysql.org/downloads/gui-tools/5.0.html)

[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>

[exipnos]

i prefer to use the " navicat"
it's the best tool for mysql

[countll]

where to find the /usr/lib/mysql or /etc/lib/mysql???i cant see it ...help