• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • Last Modified:

I changed length/values in DB via PHPMyAdmin and data disappeared

Using PHPMyAdimin I made some changes.
Basically a field called 'comments' wasn't showing all the data on awebpage. It was set to varchar but with no length/values set.
So I put in length/values of 1000 however no extra text was showing up on the webpage.

Then I changed length/values to a value of 5 just to see if it was taking effect on the webpage, it was, only 5 characters showed up.

Now when I changed the value back to a higher number it still only shows 5 characters on the webpage BUT more worrying within the database I can only see 5 characters, the rest of the data in the 'comments' field has disappeared. This doesn't make sense, it's as if the text in the field has been deleted from the database.

How can I restore everything the way it was before I change the value to 5?

(I am using Plesk if this is of any help)
0
Cosmic_Cake
Asked:
Cosmic_Cake
  • 2
  • 2
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
I'm afraid you can't unless you have a backup copy.  When you shortened the field, everything past the five characters was discarded.  Whatever the original size of the field, that was all that it would hold and changing the size to 1000 doesn't bring back the missing characters.
0
 
Cosmic_CakeAuthor Commented:
Oh dear. I didn't make any backups. Is it possible there could be automatic backups in place? Is there a way of checking this?
0
 
Dave BaldwinFixer of ProblemsCommented:
You would have to check your Plesk control panel.
0
 
Cosmic_CakeAuthor Commented:
Not the answer I wanted to hear :-) but the REAL answer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now