Page 1 of 1
Moved location - need to empty database
Posted: Sat Jul 27, 2019 7:16 pm
by 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?
Re: Moved location - need to empty database
Posted: Sat Jul 27, 2019 10:07 pm
by 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.
Re: Moved location - need to empty database
Posted: Sun Jul 28, 2019 11:24 am
by 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!