From owner-freebsd-questions@FreeBSD.ORG  Sat Aug 27 21:14:38 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 457BD16A41F
	for <freebsd-questions@freebsd.org>;
	Sat, 27 Aug 2005 21:14:38 +0000 (GMT)
	(envelope-from bobself@charter.net)
Received: from mxsf22.cluster1.charter.net (mxsf22.cluster1.charter.net
	[209.225.28.222])
	by mx1.FreeBSD.org (Postfix) with ESMTP id C002C43D45
	for <freebsd-questions@freebsd.org>;
	Sat, 27 Aug 2005 21:14:37 +0000 (GMT)
	(envelope-from bobself@charter.net)
Received: from mxip29a.cluster1.charter.net (mxip29a.cluster1.charter.net
	[209.225.28.188])
	by mxsf22.cluster1.charter.net (8.12.11/8.12.11) with ESMTP id
	j7RLEaxa018965
	for <freebsd-questions@freebsd.org>; Sat, 27 Aug 2005 17:14:36 -0400
Received: from 24-177-225-234.dhcp.spbg.sc.charter.com (HELO [127.0.0.1])
	([24.177.225.234])
	by mxip29a.cluster1.charter.net with ESMTP; 27 Aug 2005 17:14:37 -0400
X-IronPort-AV: i="3.96,146,1122868800"; 
	d="scan'208"; a="176586745:sNHT18005528"
Message-ID: <4310D7B6.8000302@charter.net>
Date: Sat, 27 Aug 2005 17:14:30 -0400
From: bob self <bobself@charter.net>
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Carstea Catalin <carstea.catalin@gmail.com>
References: <dc6701ba0508271404996f7b1@mail.gmail.com>
In-Reply-To: <dc6701ba0508271404996f7b1@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: freebsd-questions@freebsd.org
Subject: Re: backup and restore mysql
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 27 Aug 2005 21:14:38 -0000

Carstea Catalin wrote:

>how to backup and restore mysql databases?
>
>  
>
to backup:
# mysqldump --opt -u root -pxxxxxxxx -A >dbs.sql

to restore:
mysql> source dbs.sql;