Hello.
If your tables are MyISAM and you think that they are damaged, I suggest you to stop the MySQL server, make a backup of the data directory (just copy to other place) and then run a myisamchk program to repair them. See: http://dev.mysql.com/doc/mysql/en/repair.html http://dev.mysql.com/doc/mysql/en/crash-recovery.html "Patrick Marquetecken" <[EMAIL PROTECTED]> wrote: > Hi, > > Snort had had problems to insert data into the table so, at i opened a > connection to the server and dit: use snort; > i got this error: > Din't find any fields in table 'data' > Din't find any fields in table 'event' > Din't find any fields in table 'tcphdr' > Database changed > > With phpmyadmin these tables are marked "in use" > > What can i do to get this back to work, had no time to create a backup > script witch i schall create as fast as possible now. > > Patrick > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]