[racktables-users]
- From: "Dahlstrom, Kishore M. (LNG-SEA)" <kishore.dahlstrom@xxxxxxxxxxxxxxxxxxxx>
- To: <racktables-users@xxxxxxxxxxxxx>
- Date: Mon, 21 Sep 2009 09:18:38 -0700
Does anyone know how to fix the File and FileLink tables.
I exported the racktables database tables via the Navicat application
and modified the tables and added additional entries and now the search
and some of the links no longer work.
I checked all the databases and so far these two are the only ones that
exist and are failing to repair.
I was able to fix the IPv4Network database table
[root@ADTUKIRTS01 ~]# mysqldump racktables File
-- MySQL dump 10.11
--
-- Host: localhost Database: racktables
-- ------------------------------------------------------
-- Server version 5.0.45
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0
*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
*/;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
mysqldump: Got error: 1033: Incorrect information in file:
'./racktables/File.fr
m' when doing LOCK TABLES
[root@ADTUKIRTS01 ~]# mysqldump racktables FileLink
-- MySQL dump 10.11
--
-- Host: localhost Database: racktables
-- ------------------------------------------------------
-- Server version 5.0.45
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0
*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
*/;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
mysqldump: Got error: 1033: Incorrect information in file:
'./racktables/FileLin
k.frm' when doing LOCK TABLES
[root@ADTUKIRTS01 ~]#
!Help
Thanks
Kishore Dahlstrom | Technology Services Manager - System Engineering
LexisNexis(r) Applied Discovery(r)
13427 NE 16th Street, Ste. 200
Bellevue, WA 98005
425.467.4515 Direct
425.737.1515 Mobile
425.467.3010 Fax
877.613.3010 Toll Free
www.applieddiscovery.com <http://www.lexisnexis.com/applieddiscovery>
------------------------------------------------------------------------
-----------------------------------
Applied Discovery, Inc., A member of the LexisNexis(r) Group
This communication (including any attachments) is intended for the use
of the intended recipient(s) only and may contain information that is
confidential, privileged or legally protected. Any unauthorized use or
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please immediately notify the
sender by return e-mail message and delete all copies of the original
communication. Thank you for your cooperation.
------------------------------------------------------------------------
--------------------------------------
Other related posts:
