|
|
From manchumahara@... Tue Jul 14 11:09:05 2009
Return-Path: <manchumahara@...>
Received: (qmail 26537 invoked from network); 14 Jul 2009 18:09:04 -0000
Received: from unknown (69.147.108.201)
by m3.grp.sp2.yahoo.com with QMQP; 14 Jul 2009 18:09:04 -0000
Received: from unknown (HELO n38b.bullet.mail.sp1.yahoo.com) (66.163.168.152)
by mta2.grp.re1.yahoo.com with SMTP; 14 Jul 2009 18:09:04 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoogroups.com; s=lima; t=1247594943; bh=TEcPCkzHF49L7Fk8QqwgnXUZySV/XemTVOTw1JilTA8=; h=Received:Received:X-Sender:X-Apparently-To:X-Received:X-Received:X-Received:X-Received:MIME-Version:X-Received:In-Reply-To:References:Date:Message-ID:To:Content-Type:X-Originating-IP:X-eGroups-Msg-Info:From:Subject:X-Yahoo-Group-Post:X-Yahoo-Profile:X-YGroups-SubInfo:Sender:X-Yahoo-Marked-Not-Spam:X-Yahoo-Newman-Property:X-eGroups-Approved-By:X-eGroups-Auth; b=vUzeQPxcZFLJQ+jERVJqs4AglWW826k6B3DocP8bfHMQ/9tqwQ19We15EcalaLKx3qEmI7hZx8PFJHJRGA5ELsQMgmpmi1S48r+RQxEfi4O5ZNHHiClmcouRVsogjtfi
Received: from [69.147.65.172] by n38.bullet.mail.sp1.yahoo.com with NNFMP; 14 Jul 2009 18:09:03 -0000
Received: from [98.137.34.36] by t14.bullet.mail.sp1.yahoo.com with NNFMP; 14 Jul 2009 18:09:03 -0000
X-Sender: manchumahara@...
X-Apparently-To: phpexperts@yahoogroups.com
X-Received: (qmail 46255 invoked from network); 14 Jul 2009 18:04:32 -0000
X-Received: from unknown (69.147.108.200)
by m5.grp.sp2.yahoo.com with QMQP; 14 Jul 2009 18:04:32 -0000
X-Received: from unknown (HELO wf-out-1314.google.com) (209.85.200.169)
by mta1.grp.re1.yahoo.com with SMTP; 14 Jul 2009 18:04:32 -0000
X-Received: by wf-out-1314.google.com with SMTP id 27so1052580wfd.1
for <phpexperts@yahoogroups.com>; Tue, 14 Jul 2009 11:04:14 -0700 (PDT)
MIME-Version: 1.0
X-Received: by 10.142.49.4 with SMTP id w4mr1761933wfw.183.1247594653121; Tue,
14 Jul 2009 11:04:13 -0700 (PDT)
In-Reply-To: <243974.34548.qm@...>
References: <243974.34548.qm@...>
Date: Wed, 15 Jul 2009 01:03:53 +0700
Message-ID: <a031e0830907141103i3f5e0511gbc344352a23c811e@...>
To: phpexperts@yahoogroups.com
Content-Type: multipart/alternative; boundary=000e0cd2536c1f7dd3046eae440c
X-Originating-IP: 209.85.200.169
X-eGroups-Msg-Info: 2:4:8:0:0
From: Sabuj Kundu <manchumahara@...>
Subject: Re: [phpXperts] :: Backing up large MySQL database ::
X-Yahoo-Group-Post: member; u=329398292; y=Vw7aH9SGHIJAR6XWXTneRJeRR8SV_I5Z9V_wTkdFyxbD9XjW5HBagg
X-Yahoo-Profile: manchu_mahara
X-YGroups-SubInfo: t=0;f=20;g=none;
X-Yahoo-Marked-Not-Spam:
X-Yahoo-Newman-Property: groups-system
X-eGroups-Approved-By: opurahman via web; 14 Jul 2009 18:09:03 -0000
--000e0cd2536c1f7dd3046eae440c Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
I don't know what is best, but can tell some better solution from real life
experience
1.use ssh
2.to restore/import big dump if you don't have ssh then bigdump(
http://www.ozerov.de/bigdump.php) is a nice tool
3.for large database and slow bandwidth, take backup of large tables in
single.
4.Use high speed and dedicated internet con
........................
Sabuj Kumar Kundu
About Me: http://blog.manchumahara.com/about/
http:/blog.manchumahara.com
http://forum.amaderprojukti.com
http://gallery.amaderprojukti.com
http://mkabya.page.tl
On Tue, Jul 14, 2009 at 11:53 AM, $@!ful=E2=84=A2 <anm.saiful@...> wr=
ote:
>
>
> *Which is the best way and format to backing up large MySQL (relational)
> database?*
> [image: My Web Site] <http://anmsaiful.net/> [image: Feed Burner]<http://=
feeds2.feedburner.com/anmsaiful/anmsaiful/blog/posts> [image:
> Twitter] <http://twitter.com/anmsaiful> [image: Linked In]<http://www.lin=
kedin.com/in/anmsaiful> [image:
> Face Book] <http://www.facebook.com/people/Anm-Saiful/1051877161> [image:
> Yahoo Messenger]
>
>=20=20
>
--000e0cd2536c1f7dd3046eae440c Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
I don't know what is best, but can tell some better solution from real =
life experience<br><br>1.use ssh<br><a href=3D"http://2.to">2.to</a> restor=
e/import big dump if you don't have ssh then bigdump(<a href=3D"http://=
www.ozerov.de/bigdump.php">http://www.ozerov.de/bigdump.php</a>) is a nice =
tool <br>
3.for large database and slow bandwidth, take backup of large tables in sin=
gle.<br>4.Use high speed and dedicated internet con<br clear=3D"all">......=
..................<br>Sabuj Kumar Kundu<br>About Me: <a href=3D"http://blog=
.manchumahara.com/about/">http://blog.manchumahara.com/about/</a><br>
http:/<a href=3D"http://blog.manchumahara.com">blog.manchumahara.com</a><br=
><a href=3D"http://forum.amaderprojukti.com">http://forum.amaderprojukti.co=
m</a><br><a href=3D"http://gallery.amaderprojukti.com">http://gallery.amade=
rprojukti.com</a><br>
<a href=3D"http://mkabya.page.tl">http://mkabya.page.tl</a><br><br>
<br><br><div class=3D"gmail_quote">On Tue, Jul 14, 2009 at 11:53 AM, $@!ful=
=E2=84=A2 <span dir=3D"ltr"><<a href=3D"mailto:anm.saiful@...">anm=
.saiful@...</a>></span> wrote:<br><blockquote class=3D"gmail_quote=
" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0=
.8ex; padding-left: 1ex;">
<div style=3D"background-color: rgb(255, 255, 255);">
<div style=3D"width: 655px;">
<div style=3D"margin: 0pt; padding: 0pt 25px 0pt 0pt; width: 470px; float: =
left;">
<div>
=20=20=20=20=20=20=20=20=20=20=20=20
<br><br>
=20=20=20=20=20=20
<p></p><div style=3D"font-family: verdana,helvetica,sans-serif; font-=
size: 10pt; color: rgb(220, 209, 223);"><div></div>
<div><b><font color=3D"#7f3f00">Which is the best way and format to backing=
up large MySQL (relational) database?</font></b><br></div>
<div><a href=3D"http://anmsaiful.net/" rel=3D"nofollow" target=3D"_blank"><=
img alt=3D"My Web Site" border=3D"0"></a> <a href=3D"http://feeds2.feedburn=
er.com/anmsaiful/anmsaiful/blog/posts" rel=3D"nofollow" target=3D"_blank"><=
img alt=3D"Feed Burner" border=3D"0"></a> <a href=3D"http://twitter.com/anm=
saiful" rel=3D"nofollow" target=3D"_blank"><img alt=3D"Twitter" border=3D"0=
"></a> <a href=3D"http://www.linkedin.com/in/anmsaiful" rel=3D"nofollow" ta=
rget=3D"_blank"><img alt=3D"Linked In" border=3D"0"></a> <a href=3D"http://=
www.facebook.com/people/Anm-Saiful/1051877161" rel=3D"nofollow" target=3D"_=
blank"><img alt=3D"Face Book" border=3D"0"></a> <a rel=3D"nofollow"><img al=
t=3D"Yahoo
Messenger" border=3D"0"></a> </div></div><br>
=20=20=20=20=20=20
=20
</div>=20=20
=20=20=20=20
<div width=3D"1" style=3D"color: white; clear: both;"></div>
=09
</div>
=09
=09
=09
=09
=09
=09
=09
=09
</blockquote></div><br>
--000e0cd2536c1f7dd3046eae440c-- |
Sabuj Kundu <manchumahara@...>
manchu_mahara
Online Now Send Email
|
|