Problems with importing and exporting database

Home

Forums

Feature Requests

Beta Issues

SysAid Resources

Documentation

Support

Hello Guest,

DOWNLOAD FREE EDITION

Recent Topics

Hottest Topics

Online Members

Member Listing

Advanced Search

Problems with importing and exporting database

Forum Index » SysAid Installation & Beyond

Author

Message

16/11/2011 16:50:41

Subject: Problems with importing and exporting database

sazuara
SysAider

SysAider from release 2

Joined: 16/11/2011
Messages: 1
Offline

Greetings from Mexico.
Hi, I need to move SysAid to a new server, so I need to install SysAid and import the database I was using. The database is in MySQL.
I exported the database with phpMyAdmin in a .sql file. Then I tried to import the database in the new server but I've been having trouble.

I tried at first exporting and importing with phpMyAdmin but the size doesn't allowed it. So then I tried using BigDump.php but got an error with the 'service_req_files' table (3.6 Mb), which is the one that stores the attachments in the services request.

Any ideas on how can I export and then import my database?

I have SysAid v8.0.06 Pro Plus Edition.

Thanks in advanced.

17/11/2011 15:30:51

Subject: Re:Problems with importing and exporting database

Elopez
SysAider

SysAider from release 7.5

Joined: 09/11/2011
Messages: 20
Offline

I have almost the same problem.

When I do the export of assets to a csv, the software column truncates in certain character number and make a breakline - I suppose is for the Office character limit allowed in the row. So in one line appear a truncated software name and is a mess so difficult to read the sheet.

Can you split the software column in two o three rows?

Forum Index » SysAid Installation & Beyond

Go to:

Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software

   SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Israel:+972-3-533-3675
   Email:helpdesk@sysaid.com
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   2002-2011

   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   03:00 AM - 05:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software