Backup of Mysql Database

[DeCal]

I want to know How can I take a backup of mysql database? I want to take backup of database which is on the local machine and not on the server.

[decipher]

there is a file command i believe for doing so, but you need to have telnet

the other way is by using the PHPMyAdmin interface which you have to have installed on your server

i am not very experienced in doing this though, anyone done it before that could help?

[Super M]

yeh i rely on phpmyadmin but i am doing it from server...u should install it..you can get it simply from google search !!Read the instruction their after that..u might got it..

thanks..super M

[DeCal]

Yes you are right I am using from local machine so I am finding it difficult to get backup. I have got command sqldump but not even thats working well. Can anyone give me correct syntax for it?

yeh i rely on phpmyadmin but i am doing it from server...u should install it..you can get it simply from google search !!Read the instruction their after that..u might got it..

thanks..super M

[Kazel]

$ mysqldump -u username -h localhost -p database_name | gzip -9 > backup_db.sql.gz

there ya go =)

[bwfield]

glad i don't have to worry about this i have a guy that does it all for me