I was trying to backup one day. To my astonishment it returned an error box reporting dumping failure. I was shocked as backup was so important. I checked the Tomcat\logs\stdout_(that day). It revealed:
"mysqldump: Error 1194: Table 'prescription_detail' is marked as crashed and should be repaired when dumping table `prescription_detail` at row: 175681"
I at once tried to find a solution from the web. Indeed there were. However I, being a novice, could not understand even 1% of the complicated dot prompt commands they mentioned!
I was desperate. Hey wait, I almost forgot my dearest Heidi....Heidisql. I ran it, found the prescription_detail table, Rt click and choose mainenace and then repair. It was fixed! I could do back up smoothly again! Thanks to Heidi, I love you!
introduction
-
After the automatic update of my Java RE to version 1.6.0_32, the CMS client can no longer connect to the local server. Even the Apache Tomc...
-
I found some error in the databases one day and I tried to fix it by restoring to the previous day's backup. "Failure to restore th...
-
Sometimes you may need to edit the databases. A graphical editor would help. Navicat is the most famous but it is expensive. I found a very...
-
To run HKMA CMS 3.0 smoothly, you need a robust computer. Mine is Sandy bridge quadcore i5 2500, 4 GB ram (only 3.2 GB usable under 32 bit W...
-
One morning, I tried to edit a client but the system failed to save the changes, namely "submission failed". So were all other edi...
-
Talking about free office suite, as an alternative to the costly M$ Office, many people think of Open Office. But it is quite slow to start ...
-
Windows firewall prevents foreign intrusions. However, if you want your client computers be able to connect and access the server, you need ...
-
If the Java runtime autoupdate is not turned off, it will urge you to update from time to time. If you allow it, you may not be able to conn...
-
On designing the drug label, I drew a line separating the header and the content. However when the labels were printed in sequence, the line...
-
The field "Alias" is not only for recording the alternate name of an object, but also rendering you more convenient to search it. ...
沒有留言:
張貼留言