07 May 2011, 05:14
#1
New Zenner
- Join Date:
- May 2011
- Posts:
- 40
- Plugin Contributions:
- 0
database and backup question
a few questions about database, since I am not a DBA
I know all the order information are in the database
But as time goes by, the database's size goes larger and larger, will this affect the overall performance of the site?
and after I backed up all the db info, should I delete the old data on the server?
but when I deleted them, customers won't be able to find their old orders anymore, would that be a problem?
and, I plan to bring the site down, backup both the web site file and the db, then bring the site up, and repeat this every late night
I don't suppose there are scripts or programs that can automatically do that for me, right?
I know all the order information are in the database
But as time goes by, the database's size goes larger and larger, will this affect the overall performance of the site?
and after I backed up all the db info, should I delete the old data on the server?
but when I deleted them, customers won't be able to find their old orders anymore, would that be a problem?
and, I plan to bring the site down, backup both the web site file and the db, then bring the site up, and repeat this every late night
I don't suppose there are scripts or programs that can automatically do that for me, right?
