Forum Moderators: mack

Message Too Old, No Replies

Executing a sql script? Need help!

         

NewDesigner

3:47 pm on Apr 6, 2005 (gmt 0)

10+ Year Member



I have a program that runs on a database. Changes were made and I need to excute this new sql database and I have no idea how to. How do you excute this file to replace the one currently there using phpmyadmin? Also the original sql script has users on it. By excuting this new file, will it erase my current users? I hope this makes sense and someone can help me.

BjarneDM

4:18 am on Apr 7, 2005 (gmt 0)

10+ Year Member



you are not making sense ;-) please give a more detailed explanation.

jatar_k

9:44 am on Apr 7, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



from what I am getting it would seem that you need to make some changes to your database.

Are you upgrading software that you are running?

Most times, but not all, upgrades come with database scipts that can be executed on your existing database. One thing is to always backup your database and current scripts before attempting upgrades or changes. If you don't and something breaks you could lose a fair amount of data.

If it is an upgrade script then you shouldnt lose data but, again, thats why we do backups.

you should be able to execute the upgrading scripts through phpmyadmin but I really couldn't tell you how, I don't use it.