backup without using mysqldump

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rei
Forum Newbie
Posts: 13
Joined: Mon Jul 26, 2004 9:51 pm

backup without using mysqldump

Post by rei »

i was told that it takes days if i need to backup a databases with large tables using mysqldump

what other ways i can backup the whole database and recover it in short time?

i heard about myisampack but not too sure about it..
still new to database & mysql..
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I've never had mysqldump take a while, it was more the file-system not being able to keep up because the dump builds a huge file that slowed things.. Even then, it never took days.. maybe 5 minutes.
Post Reply