Editing the database

[crystal +]

I have a test environment on my server, and I copied the database over from my site when there were about 100 members or so. The test system just started sending out expire notices... and they are going to the customers! How do I change all of the email addresses in the database to 'null' or to a test email? I would like to do this directly in the mysql database tables, but I'm a complete noob when it comes to databases. I am using PHPmyadmin.

Thank you for any help!

[Mike-N-Tosh +]

Do an export in "CSV" (Comma Separated Values) for your users table. (If you have Excel, you can do an excel export.) and choose the option to save a file to your computer. Name it appropriately. You can then edit the file with any text editor or Excel if you have that.

To do it properly, you will need to make sure that you have a list of each field (column) in the order that they are in the table. Then simply delete each email address or replace it with "NULL". Save the file after editing.

Go back to your phpMyAdmin and select the table. Choose "import". From the next window, click the from file option and choose your edited file. Also choose to replace data. This will delete your data and then import your new data.
MAKE SURE YOU HAVE A BACKUP OF YOUR TABLE BEFORE DOING ANY MODIFICATIONS!!!

Hope that helps!
-Mike

[Lhotch +]

You should be able to change them all with a single query like....

UPDATE class_users SET email = NULL;

I cant be any more specific since I dont use phpmyadmin.