Jump to content

Archived

This topic is now archived and is closed to further replies.

jana

How to make backup for a particular database

Recommended Posts

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.