[Cse498-fall2000] MySQL and saving tables

[Cory Spitz]

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