Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Taking Backup of MySql automatically

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 04-06-2009
Member
 
Join Date: May 2008
Posts: 35
Taking Backup of MySql automatically
  

Hi,

I want to know how to take backup of MySQL database on a lo0cal machine & on the server automatically?

If you guys know any application then please let me know about the same.

Reply With Quote
  #2  
Old 04-06-2009
Member
 
Join Date: Feb 2009
Posts: 133
Re: Taking Backup of MySql automatically

I think you need to go through this tutorial by MySql
http://dev.mysql.com/doc/refman/5.0/...-recovery.html

I hope this helps.
__________________
IF YOU CAN'T Convince THEM ...

CONFUSE THEM ...
Reply With Quote
  #3  
Old 04-06-2009
Member
 
Join Date: Jan 2009
Posts: 40
Re: Taking Backup of MySql automatically

A MySQL dump is a bit slower than a raw backup because it creates all the SQL queries required to create the tables of that database, as well as all the insert queries required to place the information back into the database's tables.

If you want to perform the mysql dump manually, without the assistance of your hosts control panel, then run SSH to your web server and do the following (taken from MySql.com):

* mysqldump --tab=/path/to/some/dir --opt db_name
Reply With Quote
  #4  
Old 04-06-2009
Member
 
Join Date: May 2008
Posts: 35
Re: Taking Backup of MySql automatically

Is there any Software I mean application that will enable me to backup my SQL database periodically?
I am on Mac environment. (Windows based GUI will also do.)
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Taking Backup of MySql automatically"
Thread Thread Starter Forum Replies Last Post
please help in taking backup from USB flash drive sophisticated Portable Devices 1 02-04-2012 05:50 PM
Got error - 0x80070020 while taking backup from Windows 7 64 bit Enos Operating Systems 7 27-10-2011 02:10 PM
0X800423F0 error while taking system backup Harnoor Operating Systems 4 04-12-2010 10:22 PM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 08:36 PM
Taking backup of D: Drive Chandran12 Operating Systems 2 12-08-2008 03:25 PM


All times are GMT +5.5. The time now is 11:02 AM.