Updating MySQL Database after install
| From: | Karl DeSaulniers | Date: | Tue, 04 May 2010 22:21:30 +0000 |
| Subject: | Updating MySQL Database after install | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47137@lists.php.net to get a copy of this message | ||
Hi,
I am wanting to get some pointers on how to update my MySQL database after there is already members.
For eg, I am trying to set some foreign keys that were not part of my database when I installed it.
There are members in that database. Can I update the database with the new .sql file without loosing my current info? If so, how?
Fields in the user table have not changed except foreign keys have been assigned to it.
TIA,
Karl DeSaulniers
Design Drumm
http://designdrumm.com