How to make backup for a particular database

[jana]

I am new to mysql. can anyone tell me how to make backup database without using gui tools.

[jvrothjr]

you could do many different things.

1) stop the mysql server and copy the data folder

2) mysqldump to create a sql file backup

3) use a tool like phpmyadmin to create sql dump files

I use two of these nightly

1) on a site that is only used during bussness hours I use option [1] stop the server and copy folder.

2) on the other site used 24/7 factory support I use mysqldump (via a schedule) to auto backup the database to sql file.