使用PHP脚本备份访问数据库 [英] Backup ACCESS Database using PHP script
问题描述
是否可以备份access database
?我已经完成了有关如何通过php备份访问数据库的研究,但是我没有一个很好的答案.出现的大多数结果都与备份MySQL database
有关.谁能帮我:)谢谢
Is it possible to back up an access database
? I have done research on how to backup access database through php but I wasnt able to get a good answer. Most of the result that came out is about backing up MySQL database
. Can anyone help me :) thanks
推荐答案
re:实际执行备份
备份本机Access数据库仅是复制整个数据库文件(对于Access_2003和更低版本为.mdb,对于Access_2007及更高版本为.accdb)只是一个问题.您可以 为此使用PHP,但是任何脚本语言都可以使用,即使是简单的Windows批处理文件也可以执行类似的操作
Backing up a native Access database is simply a matter of copying the entire database file (.mdb for Access_2003 and earlier, .accdb for Access_2007 and later). You could use PHP for that, but any scripting language would work, even a simple Windows batch file that does something like
copy /Y d:\apps\databases\mydatabase.accdb z:\backups\databases\*.*
If you're really set on using PHP then you'll likely end up using the copy() function.
re:自动计划备份
Windows中的任务计划程序可以为您解决这些问题.创建脚本以复制数据库文件后,您可以创建计划任务以定期运行它.请参阅MSDN文章使用任务计划程序(Windows),以获取更多信息.
The Task Scheduler in Windows could take care of that for you. Once you've created your script to copy the database file(s) you can create a scheduled task to run it periodically. See the MSDN article Using the Task Scheduler (Windows) for more information.
这篇关于使用PHP脚本备份访问数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!