Moved location - need to empty database

[justinhow]

I have moved to another part of the UK and changed my existing meteotemplate site info/website to reflect this change and now the url is www.dumfries-weather.com (was www.eastberks-weather.com). This is going well.
Now I would like to empty my meteotemplate database as it is full of info about a different location. What is the best way to do this?

[dmgould]

I would just start over with a new database under a new database name. Change to the new database in the main setup, and you should be good to go. This is assuming your host allows multiple databases. Most do. If they don't, delete the old and start the new.

[justinhow]

Thanks for that info. I did just that:

• Created a new SQL database via PHPAdmin.

• Assigned the same user rights to it as the original database

• Changed settings in config.sys to point to new database name.

• Ran http://www.<mysite>.com/install/tableCreate.php

• Ran the Database Update Setup in the admin menu to reselect API

• Checked database was being written to in PHPAdmin

All seemed to work - not sure if any step were unnecessary, although I will apparently have to wait 24 hours for Steel Gauges to start working again.
Thanks again!