noob mysql ?

Hoopster <hoops_nospam444 DeleteThis @aol.com> altered the spacetime fabric by
disgorging news:ggq4d29ibku9g03pkpf2405693bejs7nfl@4ax.com:

> Do you just hit export to save your entire database?
>
>
> If so, what file is best to save it as to restore it?

How are you accessing your MySQL db ?

If it's from a shell account:

mysqldump -u username -p_password_ -A >completedbbackup20060803.sql

Once that's done, gzip it, if it's massive.
Then download to your local computer and burn it to a CD, so you've got a
separate backup, safe from ghoulies.

To restore it all, make sure your backup is uncompressed in your directory,
connect to mysql, type
use [databasename];
then
\. completedbbackup20060803.sql




--
Marc Bissonnette
Looking for a new ISP? http://www.canadianisp.com
Largest ISP comparison site across Canada.
 >> Stay informed about: noob mysql ? 

On Thu, 03 Aug 2006 21:27:31 GMT, Hoopster <hoops_nospam444 RemoveThis @aol.com>
opined:
> Do you just hit export to save your entire database?
>
>
> If so, what file is best to save it as to restore it?
>
No offense but you don't know what you don't know. I suggest that
your first venture is to your local bookstore.

--
"Black Hole": The economic effect of administering a DNSBL
Our DNSBL - Eliminate Spam at the Source: http://www.TQMcube.com
Don't Subsidize Criminals: http://boulderpledge.org
 >> Stay informed about: noob mysql ? 

Cpanel





On Thu, 03 Aug 2006 16:54:25 -0500, Marc Bissonnette
<dragnet\_@_/internalysis.com> wrote:

>Hoopster <hoops_nospam444 DeleteThis @aol.com> altered the spacetime fabric by
>disgorging news:ggq4d29ibku9g03pkpf2405693bejs7nfl@4ax.com:
>
>> Do you just hit export to save your entire database?
>>
>>
>> If so, what file is best to save it as to restore it?
>
>How are you accessing your MySQL db ?
>
>If it's from a shell account:
>
>mysqldump -u username -p_password_ -A >completedbbackup20060803.sql
>
>Once that's done, gzip it, if it's massive.
>Then download to your local computer and burn it to a CD, so you've got a
>separate backup, safe from ghoulies.
>
>To restore it all, make sure your backup is uncompressed in your directory,
>connect to mysql, type
>use [databasename];
>then
>\. completedbbackup20060803.sql
 >> Stay informed about: noob mysql ? 

Hoopster <hoops_nospam444.TakeThisOut@aol.com> altered the spacetime fabric by
disgorging news:rfs4d2hc9guoulj70vhaoi2s02o5v7a42g@4ax.com:

> Cpanel

Oh. Uh, keep clicking on links until something that looks like what you
want to happen happens ?

(It's faster in a shell environment)

Seriously, Google is your friend:

http://www.google.com/search?
client=opera&rls=en&q=mysql+backup+cpanel&sourceid=opera&ie=utf-8&oe=utf-
8

or

http://tinyurl.com/s2ddl


> On Thu, 03 Aug 2006 16:54:25 -0500, Marc Bissonnette
> <dragnet\_@_/internalysis.com> wrote:
>
>>Hoopster <hoops_nospam444.TakeThisOut@aol.com> altered the spacetime fabric by
>>disgorging news:ggq4d29ibku9g03pkpf2405693bejs7nfl@4ax.com:
>>
>>> Do you just hit export to save your entire database?
>>>
>>>
>>> If so, what file is best to save it as to restore it?
>>
>>How are you accessing your MySQL db ?
>>
>>If it's from a shell account:
>>
>>mysqldump -u username -p_password_ -A >completedbbackup20060803.sql
>>
>>Once that's done, gzip it, if it's massive.
>>Then download to your local computer and burn it to a CD, so you've
>>got a separate backup, safe from ghoulies.
>>
>>To restore it all, make sure your backup is uncompressed in your
>>directory, connect to mysql, type
>>use [databasename];
>>then
>>\. completedbbackup20060803.sql
>
>



--
Marc Bissonnette
Looking for a new ISP? http://www.canadianisp.com
Largest ISP comparison site across Canada.
 >> Stay informed about: noob mysql ? 

Hoopster wrote

> Do you just hit export to save your entire database?

More or less. The default settings are usually best for most cases.

> If so, what file is best to save it as to restore it?

Doesn't matter.

--
Charles Sweeney
http://CharlesSweeney.com
 >> Stay informed about: noob mysql ? 

On Thu, 03 Aug 2006 22:00:37 GMT, Hoopster <hoops_nospam444.TakeThisOut@aol.com>
opined:
> Cpanel
>

Terrible idea unless one knows what they are doing and finds CP a
convenient way of doing it - which is doubtful.

MySQL is not rocket science. It is very easy to learn (if I can, he
can). It really pays to learn the fundamentals which include
optimization. Doing so requires only a few hours of reading.
Personally, I am rather fond of Gilmore's "HP 5 & MySQL" which is
simple enough for a beginner and comprehensive enough to serve as a
reference for an advanced user.
--
"Black Hole": The economic effect of administering a DNSBL
Our DNSBL - Eliminate Spam at the Source: http://www.TQMcube.com
Don't Subsidize Criminals: http://boulderpledge.org
 >> Stay informed about: noob mysql ? 

Marc Bissonnette wrote

> Hoopster <hoops_nospam444 RemoveThis @aol.com> altered the spacetime fabric by
> disgorging news:rfs4d2hc9guoulj70vhaoi2s02o5v7a42g@4ax.com:
>
>> Cpanel
>
> Oh. Uh, keep clicking on links until something that looks like what you
> want to happen happens ?

lol!

In the meantime you would have created three forums, deleted two users, and
set up four cron jobs!

--
Charles Sweeney
http://CharlesSweeney.com
 >> Stay informed about: noob mysql ? 

Charles Sweeney <me.TakeThisOut@charlessweeney.com> altered the spacetime fabric by
disgorging news:Xns981538C83BA0mecharlessweeneycom@130.133.1.4:

> Marc Bissonnette wrote
>
>> Hoopster <hoops_nospam444.TakeThisOut@aol.com> altered the spacetime fabric by
>> disgorging news:rfs4d2hc9guoulj70vhaoi2s02o5v7a42g@4ax.com:
>>
>>> Cpanel
>>
>> Oh. Uh, keep clicking on links until something that looks like what
>> you want to happen happens ?
>
> lol!
>
> In the meantime you would have created three forums, deleted two
> users, and set up four cron jobs!
>

You know, that explains how an awful lot of sites on the 'net came into
being...



--
Marc Bissonnette
Looking for a new ISP? http://www.canadianisp.com
Largest ISP comparison site across Canada.
 >> Stay informed about: noob mysql ? 

On Thu, 03 Aug 2006 23:20:49 GMT, David Cary Hart
<Dr_Deming RemoveThis @BoulderPledge.org> opined:
> On Thu, 03 Aug 2006 22:00:37 GMT, Hoopster <hoops_nospam444 RemoveThis @aol.com>
> opined:
> > Cpanel
> >
>
> Terrible idea unless one knows what they are doing and finds CP a
> convenient way of doing it - which is doubtful.
>
> MySQL is not rocket science. It is very easy to learn (if I can, he
> can). It really pays to learn the fundamentals which include
> optimization. Doing so requires only a few hours of reading.
> Personally, I am rather fond of Gilmore's "HP 5 & MySQL" which is

s/HP/PHP

> simple enough for a beginner and comprehensive enough to serve as a
> reference for an advanced user.


--
"Black Hole": The economic effect of administering a DNSBL
Our DNSBL - Eliminate Spam at the Source: http://www.TQMcube.com
Don't Subsidize Criminals: http://boulderpledge.org
 >> Stay informed about: noob mysql ? 

David Cary Hart wrote

> On Thu, 03 Aug 2006 23:20:49 GMT, David Cary Hart
> <Dr_Deming.RemoveThis@BoulderPledge.org> opined:
>> Personally, I am rather fond of Gilmore's "HP 5 & MySQL" which is
>
> s/HP/PHP

Thank you...had me bamboozled there!

--
Charles Sweeney
http://CharlesSweeney.com
 >> Stay informed about: noob mysql ? 

Fleeing from the madness of the Internalysis jungle
Marc Bissonnette <dragnet_@_/internalysis.com> stumbled into
news:alt.www.webmaster
and said:

> Charles Sweeney <me RemoveThis @charlessweeney.com> altered the spacetime fabric by
> disgorging news:Xns981538C83BA0mecharlessweeneycom@130.133.1.4:
>
>> Marc Bissonnette wrote
>>
>>> Hoopster <hoops_nospam444 RemoveThis @aol.com> altered the spacetime fabric by
>>> disgorging news:rfs4d2hc9guoulj70vhaoi2s02o5v7a42g@4ax.com:
>>>
>>>> Cpanel
>>>
>>> Oh. Uh, keep clicking on links until something that looks like what
>>> you want to happen happens ?
>>
>> lol!
>>
>> In the meantime you would have created three forums, deleted two
>> users, and set up four cron jobs!
>>
>
> You know, that explains how an awful lot of sites on the 'net came into
> being...
>
>

Stoppit-at-once - I know you're absolutely right

cp will be the death of the web.

--
William Tasso

http://williamtasso.com/words/what-is-usenet.asp
 >> Stay informed about: noob mysql ?