CiviCRM Community Forums (archive)

I imported several hundred contacts from a csv file.  I can see the new contacts when I search from them from the drupal web site.  However, if I use phpmyadmin or shell commands to search for the new contacts directly in the mysql database, I cannot find them!  I am at a loss as to what is going on.  I am absolutely certain that I am looking in the correct mysql database using phpmyadmin or shell.  I search the civicrm_contacts table, last_name field, for one of the new contacts in phpmyadmin, or using a simple mysql select statement on the shell.  I do not find the record, even though I can successfully search for it from our drupal/civicrm web site.

Any ideas?

Thanks!  Leslie, Vermont Workers Center

Thanks for your reply.  Tried your suggeston.  Still don't find the record so I guess I must have the wrong database.  Will have to work with the server administrator, I guess, to figure this out. 

FYI, the reason I am looking in the backend is because I run my own SQL update query to add data to the county field in the address table, for my contacts.  I created my own table with Vermont zipcodes and their corresponding counties, and I run a query off this table to add counties to the contact addresses, based on zip code.  This is necessary for us, because we are organized by counties for our organization's work so my users need to be able to search for contacts based on county - which didn't seem to be available in CiviCRM.  I don't have the coding time and knowledge to figure out the CiviCRM php/java etc. to add this function to the CiviCRM codebase, but I do know mySQL, so I just go into the backend and run my update query.  Eventually I'm planning to just add the update query to cron on the server.

This was all working fine until we recently moved to a new server and since then, I've not been able to do it, apparently because the browser is accessing a different database then I thought it was supposed to

Thanks again for your help,

Leslie