[Cse498-fall2000] MySQL and saving tables

Marcel Kunath kunathma@pilot.msu.edu
Tue, 17 Oct 2000 18:35:12 -0400 (EDT)


I don't know what my problem was with the permissions. I simply dropped the
user and added it again this time using advice from www.devshed.com. they got
pretty good starting mysql php stuff over there. scroll way down to mysql
administration.

BTW, what is everybody using for password authentication?

mk

> >
Ok, > I will be using mysqldump to save off the databases without shuttind down
> the server.  Also, I had some problems with user and password like Marcel.
> My solution was to use the REVOKE statement and then redo the GRANT, and
> eveything has turned up kosher.  Thanks for the help (Dan).
> -Cory
>
> Cory Spitz wrote:
>
> > Ok,
> > I'm not a big MySQL expert here so I'm going to ask for some help.
> > I think that you need to explicitly save the tables or else they will be
> > lost if mysqld crashes or is killed.  Is this right?  That seemed to
> > happen to me anyway.  So with that said, I think I need to run
> > myisamchk.  Every time I run this after adding new stuff to a db it says
> > that there are problems and to do a repair.  Is this because mysqld is
> > still running??  I don't want lost data if mysqld happens to be killed
> > or crashes.  Thanks.
> > -Cory
> >
> > _______________________________________________
> > Cse498-fall2000 mailing list
> > Cse498-fall2000@mail.cse.msu.edu
> > http://www.cse.msu.edu/mailman/listinfo/cse498-fall2000
>
> _______________________________________________
> linux-user mailing list
> linux-user@egr.msu.edu
> http://www.egr.msu.edu/mailman/listinfo/linux-user
>


--
Marcel Kunath

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

 Montie House Network            Greater Lansing Linux Users Group
  http://www.montiehouse.com      http://www.gllug.org

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*