Search the web
Sign In
New User? Sign Up
phpexperts
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
:: Backing up large MySQL database ::   Message List  
Reply | Forward Message #12638 of 13326 |
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&#39;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&#39;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">&lt;<a href=3D"mailto:anm.saiful@...">anm=
.saiful@...</a>&gt;</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--
Tue Jul 14, 2009 6:03 pm

manchu_mahara
Online Now Online Now
Send Email Send Email

Forward
Message #12638 of 13326 |
Expand Messages Author Sort by Date

Which is the best way and format to backing up large MySQL (relational) database?...
$@!fulâ„¢
anm.saiful
Offline Send Email
Jul 14, 2009
5:19 pm

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...
Sabuj Kundu
manchu_mahara
Online Now Send Email
Jul 14, 2009
6:09 pm

you can do this, 1. log in to the server via ssh. 2. do a mysqldump. 3. Gzip/Bzip2 the output file. 4. download it. But make sure you put the dump file in a...
shiplu
staticint
Offline Send Email
Jul 15, 2009
2:59 am

Via shell command or cron job use something like this: shell:~$ mysqldump --opt --single-transaction --databases database_one database_two >...
Bobby Easland
bobby.easland
Offline Send Email
Jul 15, 2009
2:57 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help