i am using mysqldump to backup the database available in MySQL using the PHP to the sql dump format which creates the .SQL file. if i want to view / check the backup file then i have to import it first in order to check/verify/view the data which takes a lot of time.
我正在使用mysqldump来备份MySQL中可用的数据库,使用PHP创建.SQL文件的sql转储格式。如果我想查看/检查备份文件,那么我必须先导入它以检查/验证/查看花费大量时间的数据。
the issue/question is whether there is some way to create the backup copy of the MySQL database in some other format like MS-ACCESS etc rather than sql dump .sql file ?
问题/问题是是否有某种方法以MS-ACCESS等其他格式而不是sql dump .sql文件创建MySQL数据库的备份副本?
it will make it easy to open and check the database backup files.
它将使打开和检查数据库备份文件变得容易。
2 个解决方案
#1
0
In basic terms you cannot do that, mysqldump is literally a sql file which has insert statements which would insert the data, where as a Ms-access has a accdb which is where the data is actually stored.
在基本术语中你不能这样做,mysqldump实际上是一个sql文件,它有插入语句,可以插入数据,其中Ms-access有一个accdb,这是实际存储数据的地方。
The import you are running actually takes the sql file and inserts it into your access db.
您正在运行的导入实际上采用sql文件并将其插入到访问数据库中。
#2
0
Mysqldump is only for sql files, you can also get the file zipped automatically. Compatible databases can restore your MySQL SQL backup file and create a database in the new engine, for example PostgreSQL
Mysqldump仅用于sql文件,您也可以自动压缩文件。兼容的数据库可以恢复MySQL SQL备份文件并在新引擎中创建数据库,例如PostgreSQL
If you want to backup your db in other formats you can use PhpMyAdmin here is an example on how to do this. http://dumpk.com/2013/05/16/how-to-backup-mysql-in-diferent-formats/
如果您想以其他格式备份数据库,可以使用PhpMyAdmin,这是一个如何执行此操作的示例。 http://dumpk.com/2013/05/16/how-to-backup-mysql-in-diferent-formats/
Good luck!
#1
0
In basic terms you cannot do that, mysqldump is literally a sql file which has insert statements which would insert the data, where as a Ms-access has a accdb which is where the data is actually stored.
在基本术语中你不能这样做,mysqldump实际上是一个sql文件,它有插入语句,可以插入数据,其中Ms-access有一个accdb,这是实际存储数据的地方。
The import you are running actually takes the sql file and inserts it into your access db.
您正在运行的导入实际上采用sql文件并将其插入到访问数据库中。
#2
0
Mysqldump is only for sql files, you can also get the file zipped automatically. Compatible databases can restore your MySQL SQL backup file and create a database in the new engine, for example PostgreSQL
Mysqldump仅用于sql文件,您也可以自动压缩文件。兼容的数据库可以恢复MySQL SQL备份文件并在新引擎中创建数据库,例如PostgreSQL
If you want to backup your db in other formats you can use PhpMyAdmin here is an example on how to do this. http://dumpk.com/2013/05/16/how-to-backup-mysql-in-diferent-formats/
如果您想以其他格式备份数据库,可以使用PhpMyAdmin,这是一个如何执行此操作的示例。 http://dumpk.com/2013/05/16/how-to-backup-mysql-in-diferent-formats/
Good luck!