Re: Backup in mysql - response

Re: Backup in mysql - response

 

  

Hi Gurus,


uptill now i was using DOS pormpt for mysql. and using same but now
phpmyadmin is good tool to handel the mysql.

but my problem is in dos.

whenever i use the mysqldump utility for backup, my service are down and
they are down uptill the process for mysql is not stop atuomatically.

most of it happens with mysql utilities.



Regards
Rahul Chuadhari

----- Original Message -----
From: "Hugh du Toit "
<mysqldba-ezmlmshield-x32057875.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, May 11, 2005 9:19 PM
Subject: RE: Backup in mysql - response


> You need to run a .bat file or something using the mysql file "mysqldump".
This .bat file you can then schedule using normal windows scheduler.
>
> The command needs to be run for each database like such:
>
> C:\mysql\bin\mysqldump --quick --user
mysql_username --password=thepassword databasename1 >
C:\mysql\dumps\databasename1.sql
>
>
> This is the method I've been using. There may be other, better methods.
>
> I actually go one step further and zip the new .sql file using winzip's
command line feature:
>
> "c:\program files\winzip\wzzip" C:\mysql\dumps\AllMysqlDatabases.zip
C:\mysql\dumps\databasename1.sql
C:\mysql\dumps\datatabasename2.sql -spassword -x*.tmp
>
> then I delete the .sql file:
> del C:\mysql\dumps\databasename1.sql
>
> PS: this is all windows based - not sure how to do this is all in a linux
environment.
>
> -----Original Message-----
> From: Matthew [mailto:mysqldba-ezmlmshield-x72167928.[Email address
protected]
> Sent: Wednesday, May 11, 2005 17:35 PM
> To: LazyDBA Discussion
> Subject: RE: Backup in mysql - response
>
> What is the best method to backup a database using MySQL-Front? Thanks.
>
>
>
> Matthew Soldan
>
>
>
>
> "Hugh du Toit " <mysqldba-ezmlmshield-x23692540.[Email address protected]
> 05/11/2005 08:59 AM
>
> To
> "LazyDBA Discussion" <[Email address protected]
> cc
>
> Subject
> RE: Backup in mysql - response
>
>
>
>
>
>
>
> I've been using mysql-front for quite some time now. Not being web based,
> its much faster than phpmyadmin. Can connect to multiple hosts and
> transfer data between them.
>
> http://www.mysqlfront.de/
>
>
> -----Original Message-----
> From: Steve Gallo [mailto:mysqldba-ezmlmshield-x6819856.[Email
> address protected]
> Sent: Wednesday, May 11, 2005 15:48 PM
> To: LazyDBA Discussion
> Subject: RE: Backup in mysql - response
>
>
> The phpMyAdmin site is:
>
> http://www.phpmyadmin.net/home_page/index.php
>
> They have fairly extensive and easy to follow documentation at:
>
> http://www.phpmyadmin.net/documentation/
>
> Steve
>
>
> > -----Original Message-----
> > From: Rahul
> > [mailto:mysqldba-ezmlmshield-x68771512.[Email address protected]
> > Sent: Wednesday, May 11, 2005 1:19 AM
> > To: LazyDBA Discussion
> > Subject: Re: Backup in mysql - response
> >
> >
> > Hi All,
> >
> > can you please list the setup steps to install PHPMyAdmin.
> >
> > thankx in advance................
> >
> > Regards
> > Rahul Chaudhari
> >
> > ----- Original Message -----
> > From: "Lincoln Milner "
> > <mysqldba-ezmlmshield-x27764252.[Email address protected]
> > To: "LazyDBA Discussion" <[Email address protected]
> > Sent: Tuesday, May 10, 2005 10:43 PM
> > Subject: RE: Backup in mysql - response
> >
> >
> > > The best I've used thus far is PHPMyAdmin. It's very intuitive (the
> setup
> > can be complicated with MySQL v4.1+, mostly because of the new password
> > hashing), and will do just about anything you need to do (backups,
> exports,
> > imports, etc.).
> > >
> > > You do need a web server set up with PHP, so if you don't have access
> to
> > that, that's a problem. But if you do have access to a server, I
> haven't
> > found a better product that really lays it all out very well.
> > >
> > > My 2¢...
> > > Lincoln Milner
> > >
> > > -----Original Message-----
> > > From: Matthew [mailto:mysqldba-ezmlmshield-x7843465.[Email address
> > protected]
> > > Sent: Tuesday, May 10, 2005 10:39 AM
> > > To: LazyDBA Discussion
> > > Subject: Re: Backup in mysql - response
> > >
> > > Does anyone know of a good free admin tool for MySQL version 3? I
> tried
> > > MySQL Administrator, but it only supports version 4 and up. Thanks.
> > >
> > >
> > >
> > > Matthew Soldan
> > >
> > >
> > >
> > >
> > > "Mike Parry " <mysqldba-ezmlmshield-x28463977.[Email address
> protected]
> > > 05/06/2005 02:48 AM
> > >
> > > To
> > > "LazyDBA Discussion" <[Email address protected] cc
> > >
> > > Subject
> > > Backup in mysql - response
> > >
> > >
> > >
> > >
> > >
> > >
> > > Rahul,
> > >
> > > If you are looking for Free GUIs for administering MySQL you could
> look at
> > the MySQL GUIs on the MySQL website -
> > >
> > > http://dev.mysql.com/downloads/
> > >
> > > Look at the Graphical Clients section - they all do the jobs they are
> > designed for very effectively.
> > >
> > > If you want to spend some cash on a solution then the EMS products at
> > >
> > > http://sqlmanager.net/products/mysql/
> > >
> > > are quite good.
> > >
> > > Hope this helps.
> > >
> > > Mike Parry
> > >
> > > --------------------------------------------
> > > Quote:
> > > "Life without you would be like a broken pencil." "How's that?"
> > > "Completely
> > > pointless." (Blackadder, Series II)
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
> > unsubscribe, e-mail: mysqldba-[Email address protected] Website :
> > http://www.LazyDBA.com
> > >
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
> > unsubscribe, e-mail: mysqldba-[Email address protected] Website :
> > http://www.LazyDBA.com
> > >
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > > To unsubscribe, e-mail: mysqldba-[Email address protected]
> > > Website : http://www.LazyDBA.com
> > >
> >
> >
> >
> > ---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > To unsubscribe, e-mail: mysqldba-[Email address protected]
> > Website : http://www.LazyDBA.com
> >
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mysqldba-[Email address protected]
> Website : http://www.LazyDBA.com
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mysqldba-[Email address protected]
> Website : http://www.LazyDBA.com
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mysqldba-[Email address protected]
> Website : http://www.LazyDBA.com
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mysqldba-[Email address protected]
> Website : http://www.LazyDBA.com
>


MySQL LazyDBA home page