If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > incremental or differential backup

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-04-07, 01:39
GongXi GongXi is offline
Registered User
 
Join Date: Jun 2004
Posts: 57
incremental or differential backup

how to do incremental or differential backup for MySql database?
we need save backup file in different server, is this possible to do?
Reply With Quote
  #2 (permalink)  
Old 01-04-07, 05:22
Yveau01 Yveau01 is offline
Registered User
 
Join Date: Dec 2005
Location: Tilburg, Netherlands
Posts: 73
... mysql.com ???
... manual ???

Good luck,
Yveau
__________________

> SELECT * FROM users WHERE clue > 0;
Empty set (0.00 sec)

Reply With Quote
  #3 (permalink)  
Old 01-28-07, 22:32
pakcik_kantin pakcik_kantin is offline
Registered User
 
Join Date: Jul 2004
Posts: 62
Type of backups
1. Incremental backup
You need to start the server with the --log-bin option to enable binary logging. You may find all the SQL statements created during transaction in the logs files.
2. Full backup
you can use mysqldump

For more info pls refer to http://dev.mysql.com/doc/refman/5.0/en/backup.html
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On