4 messages in com.mysql.lists.mysqlRe: Ho do I backup
FromSent OnAttachments
Barry Zimmerman28 Oct 2004 04:23 
Rhino28 Oct 2004 06:21 
Michael Satterwhite28 Oct 2004 08:02 
Kevin Spencer28 Oct 2004 09:55 
Subject:Re: Ho do I backup
From:Michael Satterwhite (mich@weblore.com)
Date:10/28/2004 08:02:03 AM
List:com.mysql.lists.mysql

On Thursday 28 October 2004 08:22 am, Rhino wrote:

----- Original Message ----- From: "Barry Zimmerman" <bar@fishingvenues.com> To: <mys@lists.mysql.com> Sent: Thursday, October 28, 2004 7:24 AM Subject: Ho do I backup

Hi there,

I am a novice with mysql on the terminal side using shell.

Basically I need to back up a database and have it saved locally from my server. I have tried using phpmyadmin but it fails as I think the data is too large.

I have tried the following:

mysqldump -u admin -p --databases yabbse > yabbsebackup.sql

It seemed to work, but where can I find the yabbsebackup.sql file? Not

very

You might want to specify the full path to write your backup. for example:

mysqldump -u admin -p yabbse > /backups/yabbsetbackup.sql

This would put the backup into directory /backups. Substitute the directory of your choice.