Kayako logo
SupportSuite, eSupport and LiveResponse Discussion, troubleshooting and feedback related to Kayako's flagship support desk products SupportSuite, eSupport and LiveResponse.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  (#1) Old
vineethshyam Offline
Member
 
Posts: 68
Join Date: Sep 2006
Repair/Optimize tables Will the data gets lost ? - 31-01-2007, 03:12 PM

Whats the difference between repairing and optimizing database tables ?


Will the data in that table get lost.


This might be a stupid question but please answer.


Thanks,

and Regards,
Vineeth
   
Reply With Quote
  (#2) Old
supportskins Offline
Senior Member
 
supportskins's Avatar
 
Posts: 3,850
Join Date: Aug 2006
Location: Mumbai, India
31-01-2007, 03:16 PM

In either case you will not loose out on any data.

MySQL Tables are optimized to reclaim the unused space and to defragment the data file. The command is usually executed if you have deleted a large part of a table while Repair Table repairs a possibly corrupted table.



Professional and Affordable Kayako Skins - Specialists in Kayako Skinning & Customization - Professional Paid Support
Our Skins and Services - http://www.supportskins.com/store/
SupportSkins.com - http://www.supportskins.com/
   
Reply With Quote
Reply

Tags
data, lost, repair or optimize, tables

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error Creating Tables Danym SupportSuite, eSupport and LiveResponse 1 03-11-2006 11:22 AM
Moving data to new domain suhailc SupportSuite, eSupport and LiveResponse 0 04-07-2006 07:49 PM
connection problem inteltechs InstaAlert 5 27-04-2006 01:23 AM



Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vBulletin Skin developed by: vBStyles.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46