Hi, Snehal Desai schrieb:
Hello,
I am trying to extract data from mysql database using mysql tools. I am a newbie(new college-grad), so I can't seem to find the data in the inventory(config item) that I have loaded. I have tried a sql dump, but the .sql file is not readable. Do you know under what schema/table this is under so I can extract it? Also, how can I extract it? I have tried xml_storage and all the config items tables.
What type of installation are you using? (Windows etc) Did you try PHPMyAdmin?
Second problem, I can't seem to connect to the mysql database (using the tools) which is located on a server from my local computer. I have full admin rights and it keeps telling me the local computer is not allowed to connect o mssql. Right now i'm accessing directly from the server.
I have tried variety of sol. provided in the OTRS archives, but have had no luck.
Thanks.
------------------------------------------------------------------------
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
-- Shawn Beasley ((otrs)) :: OTRS AG :: Norsk-Data-Straße 1 :: 61352 Bad Homburg Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Geschäftssitz: Bad Homburg Amtsgericht Bad Homburg, HRB 10751 Steuernummer: 003/240/97521 Aufsichtsratsvorsitzender: Burchard Steinbild Vorstandsvorsitzender: André Mindermann