Jump to content


Photo

How to make backup for a particular database


  • Please log in to reply
1 reply to this topic

#1 jana

jana
  • Members
  • PipPipPip
  • Advanced Member
  • 35 posts
  • LocationIndia

Posted 27 September 2006 - 10:34 AM

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

#2 jvrothjr

jvrothjr
  • Members
  • PipPipPip
  • Advanced Member
  • 300 posts
  • LocationOhio

Posted 27 September 2006 - 01:29 PM

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.
If you understand everything you know nothing!

http://rcchjr.awardspace.com/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users