search for: mysqlhotcopy

Displaying 4 results from an estimated 4 matches for "mysqlhotcopy".

2009 Jul 06
3
How to make big MySQL database more diffable/rsyncable? (aka rsyncing big files)
...se some 34G of disk space. My rsync took no less than two hours then, regardless of number of actual changes in the database. (Later I realized that my dump was perhaps not enough line-oriented, so I tried some --skip-extended-insert options of mysqldump, with no luck.) Currently I'm using mysqlhotcopy to rsync raw database data. It still takes no less than one hour (which is 50% of the previous results, mostly because the raw data of the database is just 17G. The single biggest file is 16909M). How to do it better? I thought that rsync would be magically able to extract changes from my data...
2012 Mar 24
5
your advice on backup procedure
...er. Many backup solutions and programs seem centered on a network of computers with file sharing. I do not have this and don't think I want to go that way on my host. My three thoughts, not sure which one to pursue... (involves certain folders, /home/ (which includes maildir), /var/www/, /mysqlhotcopys and bin files, and maybe a few more. I can rebuild the comp pretty quick and then restore, or maybe just do one big backup of each server, then work on the folders as a solution) 1- Amanda. I do not know much about it or how it would deal with mysql databases, but it look promising. I do not h...
2004 Nov 10
3
Copying Oracle data files
Can I copy an Oracle database by just copying that Oracle Database datafiles and moving them to another server with oracle? If possible can one back up a database using this same method. ============================================================= PLEASE NOTE: The provider of this email service, http://www.jislaaik.com, does NOT tolerate Spam and Fraud! If you receive an unsolicited email or
2012 Jan 19
1
Check for Open files during rsync
Hi All, I saw on previous mail thread under topic *"exclude open file in backup with rsync (2006)"* That Rsync can't handle open files and it sends all files without checking whether they are open.I want to know whether still Rsync have this problem or if their any solution for this. I really need to check open files and I want to sync without open files. if their any way do this