Welcome, Guest. Please login or register.

Author Topic: Table Interfaces is corrupt and needs repaired  (Read 3807 times)

lschafroth

  • Guest
Table Interfaces is corrupt and needs repaired
« on: January 25, 2010, 04:12:20 PM »
How do you do this using the Nediso45?

Dont I need the mysql username and pasword? phpmyadmin?

Lannie

oxo

  • Guest
Re: Table Interfaces is corrupt and needs repaired
« Reply #1 on: January 25, 2010, 11:04:16 PM »
From the cmd line, one could use the repair function in mysql.
Here is an example:
Code: [Select]
ob@ob-laptop:/srv/bzr/sf/odp/others/nedi/branches/nedi-1.05rc04oxo$ mysql -u root -p nedi
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 194
Server version: 5.1.37-1ubuntu5 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> repair table interfaces;
+-----------------+--------+----------+----------+
| Table           | Op     | Msg_type | Msg_text |
+-----------------+--------+----------+----------+
| nedi.interfaces | repair | status   | OK       |
+-----------------+--------+----------+----------+
1 row in set (0,00 sec)

mysql>

lschafroth

  • Guest
Re: Table Interfaces is corrupt and needs repaired
« Reply #2 on: January 27, 2010, 05:26:44 PM »
I was able to fix it as you showed.  thanks.

Now I get:

/bin/sh: cannot fork - try again

This is in the last run file.  A reboot fixes it for one run then it stops working again.

Lannie

lschafroth

  • Guest
Re: Table Interfaces is corrupt and needs repaired
« Reply #3 on: February 01, 2010, 03:44:23 PM »
Anyone know how to fix this?

Lannie

SteffenS

  • Guest
Re: Table Interfaces is corrupt and needs repaired
« Reply #4 on: May 05, 2010, 08:45:49 AM »
Try this:

mysqlcheck --auto-repair -u nedi -p nedi

"The default NeDi database password is 'dbpa55', and the system root user/pass should probably be
used as the mysql root user/pass."

This has rescued me 2 time until yet after system-crash's from corrupt database.