Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
rei
Forum Newbie
Posts: 13 Joined: Mon Jul 26, 2004 9:51 pm
Post
by rei » Fri Feb 18, 2005 3:30 am
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..
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Fri Feb 18, 2005 7:55 am
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.