Bookmark and Share
Last Updates
Display: 1 - 3 of 3, Total Pages: 1
1
[Work Notes] how to archive history data in mysql database [Original] 2009-6-10 1:14pm
1. crontab job #####archive two tables every two months######0 0 1 2,4,6,8,10,12 * /root/scripts/archive/archive.sh 2>&1 2. the content of archive.sh #!/bin/bash y=`/bin/date +%Y`m=`date +%..

Read Full Article...

Section:MySQL DBA | Read:1946 | Comment:0 | Rating:0%

[Blog] mysqlsnapshot [Copied] 2006-12-24 10:17pm

mysqlsnapshot is best used to back up an entire database server without taking it offline. It has no options for specifying particular databases or tables to include or exclude in the process. It copies everything.

Read Full Article...

Section:MySQL DBA | Read:709 | Comment:0 | Rating:0%

[Blog] Making MySQL Binary MyISAM Backups [Original] 2005-11-20 9:55am

To make a binary backup of a MyISAM table, copy the .frm, .MYD, and .MYI files that MySQL uses to represent the table. When you do this, the table must not be in use by other programs (including the server) during the copy operation.

Read Full Article...

Section:MySQL DBA | Read:682 | Comment:0 | Rating:0%

1
Latest Comments
eozzrixrlo

on line..
- By admin, 2008-4-24 2:34am
rvaqlckrdu

free nud..
- By admin, 2008-4-24 2:33am
xndfjmwcpj

- By admin, 2008-4-5 1:02pm
vsjblsgatm

somali p..
- By admin, 2008-4-5 1:01pm
jknsdsmvyi

- By admin, 2008-3-12 1:48am
fkgyuchizk

tramadol..
- By admin, 2008-3-12 1:48am
wnniqpohsg

- By admin, 2008-4-24 2:32am
unxnmahoya

in phent..
- By admin, 2008-4-24 2:29am
bkgulrjbtt

- By admin, 2008-3-12 1:47am