且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Linux机器上存储的mysql数据库中的实际数据在哪里?

更新时间:2023-10-22 18:57:46

它是特定于安装的,但是如果您使用/var/lib/mysql,则:

It is installation specific, but if you've /var/lib/mysql , then:

  • MyISAM表将存储在/var/lib/mysql/databasename/
  • 中的单个文件中
  • InnoDB驻留在/var/lib/mysql/ibdata中(除非您使用过innodb_per_table设置,在这种情况下,它的存储方式非常类似于MyISAM表)
  • MyISAM tables will be stored in individual files in /var/lib/mysql/databasename/
  • InnoDB resides in /var/lib/mysql/ibdata (unless you've used the innodb_per_table setting, in which case it's stored much like for MyISAM tables)