|
| ||||||||||
| Tags: backup, mysql |
![]() |
| | Thread Tools | Search this Thread |
|
#1
| ||||
| ||||
| Taking Backup of MySql automatically
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. |
|
#2
| |||
| |||
| 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 ... |
|
#3
| |||
| |||
| 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 |
|
#4
| ||||
| ||||
| 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.) |
![]() |
|
| Thread Tools | Search this Thread |
| |
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 |
| iTunes 10.5 taking ages for backup and freezing | Bhudev | Windows Software | 6 | 15-02-2012 03:16 AM |
| 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 |