Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 140
  • Last Modified:

MYSQL Find

Hi i have a value B1-1 somewhere in my database and I dont know what the table or column is.

What is the best way of searching for something so that I can locate where it is in the DB
0
ncomper
Asked:
ncomper
  • 2
1 Solution
 
RayCommented:
Try SQLYog (14 days free trial), it has the Data Search function to search values in tables/fields
0
 
GaryCommented:
PhpMyAdmin or Adminer will allow you to do a search thru the whole db.
0
 
HainKurtSr. System AnalystCommented:
dump it to a text file and do a text editor like notepadd++ to locate it :)

mysqldump -u myuser --no-create-info databasename > myfile.sql
0
 
HainKurtSr. System AnalystCommented:
Maybe this works for you

MySQL Workbench
http://dev.mysql.com/downloads/workbench/5.2.html
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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