Hi to all,

Can anyone help me on command how to take tar backup and restore in mysql,Iam new to mysql,i searched in google but i did not get the exact one.

Thanks,

Backup with mysqldump and use tar to archive it.
Untar and restore the database:
Note that after -p (password) there is no space! You can use any other user then root but the user must have the required privileges on the actual database.
This will overwrite your database so create backup of the actual database first. (Just for sure)

1 members found this post helpful.

But when i run in shell script iam getting the below error
Shell program:
#/bin/bash
mount -t cifs -o user="$1",password="$2" "$3"/"$1" "$4"
cd "$4""$5"
date=`/bin/date "+\%Y-\%m-\%d-\%H-\%M-\%S"`
mysqldump -u"$6" -p"$7" "$8" > $date.sql
tar -zcvf $date.sql.tgz $date.sql

command:
[root@itsupport Desktop]# ./newshell ramkannan Linux123@ //10.200.1.125 /MT /test root ecare2@ employeedb
tar: \2011-\005-\006-\020-%-\f.sql: Cannot stat: No such file or directory ------------------> ERROR
tar: Error exit delayed from previous errors ---------------------> ERROR

Can u help on the above error.

Thanks,

You would do yourself a service to lose the backslashes in the filename you are trying to compose. These will inevitably cause you grief, since these characters get specail treatment in shells and elsewhere. Also, your transcript of the output seems to differ from the code you posted. When I run
I get I don't know where you are getting the extra leading zero's and the mysterious '%-f' in your output. Did you manually transcribe your posting, or did you use a copy & paste method? Are you sure it is accurate?
Also, the use of the variable 'date' is asking for confusion with the date command. It is probably better practice to avoid the use of such overlapping uses; perhaps the name 'datestamp' is at least as meaningful.

--- rod.

Hi,

Shell program is working now,I have taken the \ from the date,tat is the problem,Thank u very much.

#/bin/bash
mount -t cifs -o user="$1",password="$2" "$3"/"$1" "$4"
cd "$4""$5"
date=`/bin/date "+%Y.%m.%d.%H.%M.%S"`
mysqldump -u"$6" -p"$7" "$8" > $date.sql
tar -zcvf $date.sql.tgz $date.sql
rm -rf $date.sql