The.dump command can also be used to back up a database table.
dump命令也可以用于备份数据库表。
Before any attempts to back up a database online, first and foremost, the logging mechanism needs to be modified from the default circular logging to archive logging.
在对数据库进行在线备份之前,首先需要将日志机制从默认的循环日志改为存档日志。
In this case, a redirected restore operation won't do the trick, because you can't usually back up a database on one operating system, and restore it on another operating system.
在这种情况中,重定向操作通常就无用武之地了,因为我们通常都不能在一个操作系统上备份一个数据库,然后将其恢复到另外一个操作系统上。
For instance, if you are performing a database upgrade to your reporting database, you should back it up and test the restore.
例如,如果执行报告数据库的数据库升级,那么您应该备份数据库并测试还原。
For a mixed MySQL database environment that comes with both MyISAM and InnoDB storage engines, perhaps a better choice to back up is to use innobackup.
对于具有MyISAM和in noDB存储引擎的混合式MySQL数据库环境,进行备份的更好的方法可能是使用innobackup。
Back up the test database AWT (use a sample database to test).
备份测试数据库awt(使用一个示例数据库来测试)。
One may render a database completely useless should he back it up at the filesystem level.
如果在文件系统级进行备份,就可能使数据库完全失效。
When you back up and restore a database, you must back up the data onto media (for example, tapes and disks).
备份和还原数据库时,必须将数据备份到媒体上(例如磁带和磁盘)。
However as a best practice, you should back up the entire configuration database, which includes the software-based RMS private key.
不过,作为最佳做法,您应该备份整个配置数据库,其中包括基于软件的RMS的私人密码匙。
Otherwise you'll want to either back up your data in advance or write a script to regenerate your test data any time you want to modify the model and recreate the database schema.
否则您会想要事先备份资料或撰写指令码来重新产生测试资料的随时想修改模型并重新建立资料库结构描述。
Otherwise you'll want to either back up your data in advance or write a script to regenerate your test data any time you want to modify the model and recreate the database schema.
否则您会想要事先备份资料或撰写指令码来重新产生测试资料的随时想修改模型并重新建立资料库结构描述。
应用推荐