Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2012-04-06
4
365 Views
Last Modified: 2012-04-07
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
Comment
Question by:Cosmic_Cake
  • 2
  • 2
4 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 37818245
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
 

Author Comment

by:Cosmic_Cake
ID: 37818248
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
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 37818260
You would have to check your Plesk control panel.
0
 

Author Closing Comment

by:Cosmic_Cake
ID: 37819151
Not the answer I wanted to hear :-) but the REAL answer.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question