|
Next: Analyse - outil de recherche
|
| Author |
Message |
External
Since: Jan 19, 2007
Posts: 130
|
(Msg. 1) Posted: Mon May 19, 2008 11:28 am
Post subject: MySQL backup
Imported from groups: alt>php>sql (more info?)
|
|
|
|
| This message is not archived
|
|
|
| Back to top |
|
 | |
External
Since: Mar 03, 2006
Posts: 201
|
(Msg. 2) Posted: Mon May 19, 2008 8:00 pm
Post subject: Re: MySQL backup
Archived from groups: per prev. post (more info?)
|
|
|
Tom wrote:
> If I wanted to back up my database myself, can that be done from the
> system() or shell_exec() functions? Or any types of desktop programs
> that I could access the database remotely and save the backup to my
> PC? TIA
>
>
> Tom
MySQL Administrator will back up your database remotely. Or you can use
phpMyAdmin installed on the server. |
|
| Back to top |
|
| |
External
Since: Jan 22, 2008
Posts: 8
|
(Msg. 3) Posted: Tue May 20, 2008 9:51 am
Post subject: Re: MySQL backup
Archived from groups: per prev. post (more info?)
|
|
|
On May 19, 1:38 pm, "Paul Lautman" <paul.laut... DeleteThis @btinternet.com>
wrote:
> Tom wrote:
> > If I wanted to back up my database myself, can that be done from the
> > system() or shell_exec() functions? Or any types of desktop programs
> > that I could access the database remotely and save the backup to my
> > PC? TIA
>
> > Tom
>
> MySQL Administrator will back up your database remotely. Or you can use
> phpMyAdmin installed on the server.
Another utility that I have found very useful is Navicat. It is a
desktop application that gives you local access to a mysql database on
a server. It provides much of what phpMyAdmin on the server does,
with a somewhat more developed interface. It also adds the
convenience of being a local application, though I have found
sometimes that there can be annoying waits for the server to respond.
It does cost.
In addition, I have seen php scripts that will automate backups of a
mysql database, though I don't have a link to any just now.
--Kenoli |
|
| Back to top |
|
| |
External
Since: Mar 03, 2006
Posts: 201
|
(Msg. 4) Posted: Tue May 20, 2008 8:05 pm
Post subject: Re: MySQL backup
Archived from groups: per prev. post (more info?)
|
|
|
Kenoli wrote:
> On May 19, 1:38 pm, "Paul Lautman" <paul.laut....TakeThisOut@btinternet.com>
> wrote:
>> Tom wrote:
>> > If I wanted to back up my database myself, can that be done from
>> > the system() or shell_exec() functions? Or any types of desktop
>> > programs that I could access the database remotely and save the
>> > backup to my PC? TIA
>>
>> > Tom
>>
>> MySQL Administrator will back up your database remotely. Or you can
>> use phpMyAdmin installed on the server.
>
> Another utility that I have found very useful is Navicat. It is a
> desktop application that gives you local access to a mysql database on
> a server. It provides much of what phpMyAdmin on the server does,
> with a somewhat more developed interface. It also adds the
> convenience of being a local application,
MySQL Administrator does all this too.
> though I have found
> sometimes that there can be annoying waits for the server to respond.
> It does cost.
MySQL Administrator doesn't. |
|
| Back to top |
|
| |
External
Since: Apr 12, 2006
Posts: 61
|
(Msg. 5) Posted: Fri May 23, 2008 9:39 am
Post subject: Re: MySQL backup
Imported from groups: per prev. post (more info?)
|
|
|
This message is not archived |
|
| Back to top |
|
| |
External
Since: Jan 19, 2007
Posts: 130
|
(Msg. 6) Posted: Tue May 27, 2008 10:40 am
Post subject: Re: MySQL backup
Imported from groups: per prev. post (more info?)
|
|
|
This message is not archived |
|
| Back to top |
|
| |
External
Since: Jun 30, 2006
Posts: 20
|
(Msg. 7) Posted: Wed May 28, 2008 10:34 am
Post subject: Re: MySQL backup
Archived from groups: per prev. post (more info?)
|
|
|
Tom wrote:
> If I wanted to back up my database myself, can that be done from the system() or
> shell_exec() functions? Or any types of desktop programs that I could access the
> database remotely and save the backup to my PC? TIA
>
>
> Tom
There is a very good shell script 'automysqlbackup.sh' that I use. It
gives daily, weekly and monthly rotating backups.
It can be found at http://sourceforge.net/projects/automysqlbackup/ |
|
| Back to top |
|
| |
External
Since: May 30, 2008
Posts: 1
|
(Msg. 8) Posted: Fri May 30, 2008 10:46 am
Post subject: Re: MySQL backup
Archived from groups: per prev. post (more info?)
|
|
|
Ian Pawson wrote:
> Tom wrote:
>> If I wanted to back up my database myself, can that be done from the system() or
>> shell_exec() functions? Or any types of desktop programs that I could access the
>> database remotely and save the backup to my PC? TIA
>>
>>
>> Tom
> There is a very good shell script 'automysqlbackup.sh' that I use. It
> gives daily, weekly and monthly rotating backups.
> It can be found at http://sourceforge.net/projects/automysqlbackup/
I agree, I love this script. Ive modefied it to scp the backups to
another server as well. Cant be too careful. Btw if you are using a
debian server the cron setup is slightly different from the docs. Just
google 
Arjen |
|
| Back to top |
|
| |
Search
