PDA

View Full Version : creating backup



boogyman
04-24-2007, 08:14 PM
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
04-24-2007, 08:23 PM
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
04-25-2007, 01:29 PM
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
04-27-2007, 02:17 AM
bout this info is what i reaaly need.but still got problem backup files.
anymore ways help .thanks

Twey
04-27-2007, 09:05 AM
$ mysqldump -u <username> -p <database-name> > backup-`date --rfc-3339=date`.sql

boogyman
04-27-2007, 12:33 PM
$ mysqldump -u <username> -p <database-name> > backup-`date --rfc-3339=date`.sql

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

Twey
04-27-2007, 05:26 PM
No, just the username and database name. You'll be prompted for a password.

boogyman
04-27-2007, 06:26 PM
thanks mate :)

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

Twey
04-27-2007, 06:49 PM
Indeed.

DefaultName
05-04-2007, 09:26 AM
Sheesh, I had the same problem. Thanks!



_______________
<Signature Removed By Moderator>

exipnos
05-05-2007, 02:46 PM
i prefer to use the " navicat"
it's the best tool for mysql

countll
05-11-2007, 05:02 PM
where to find the /usr/lib/mysql or /etc/lib/mysql???i cant see it ...help