mysql在哪里放置数据库文件以及如何命名它们？ [英] Where does mysql put database files and how does it name them?

问题描述

我有一个名为credifree的数据库。我用mysql'的create

命令做到了。然而，除了a \

目录和名为credifree的gif文件之外，我在我的linux盒子上找不到任何文件。为什么？什么是mysql可能在其下创建数据库文件的名称是什么？b $ b

它存放在哪里？好奇。


xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxx

mlh @ appserver mlh $ mysql / -u root -p

输入密码：

欢迎使用MySQL监视器。命令以;结尾;或者\ g。

您的MySQL连接ID是4到服务器版本：4.0.22


键入''help;''或''\我向你寻求帮助。输入''\ c''清除缓冲区。


mysql>使用credifree

阅读表信息以完成表格和列名

您可以关闭此功能以便更快地启动-A


数据库已更改

mysql>显示表格;

+ ------------------------ +

| Tables_in_credifree |

+ ------------------------ +

| paylog |

| secure_pdf |

| systemlog |

| tbiccreceiptsefx |
| tbiccreceiptsexp |
| tbiccreceiptstu |

| tbladdrchangesefx |

| tbladdrchangesexp |

| tbladdrchangestu |

| tbladdressesequifax |

| tbladdressesexperian |
| tbladdressestransunion |
| tblaftermath |

| tblbureaus |

| tblcfclientchanges |

| tblcfnegchanges |

| tblcr_types |

| tblcredifreeclients |

| tblcredifreenegs |
| tblcreditreports |

| tblhits |

| tblinboundtypes |

| tblinstructions |

| tblmemberlogins |

| tblmerchandise |

| tbloutboundtypes |

| tblprefixes |

| tblreasons |

| tblremoved |

| tblsales |

| tblsleepers |

| tblsuffixes |

+ ------------------------ +

32行套装（0.00秒）


mysql> select * from tblhits;

+ ------------ + ---------- +

| DateHit | HitValue |

+ ------------ + ---------- +

| 0000-00-00 | 79417 |

| 2004-09-30 | 76 |

| 2004-10-01 | 16 |

| 2004-10-04 | 11 |

| 2004-10-06 | 24 |

| 2004-10-07 | 20 |

| 2004-10-08 | 37 |

| 2004-10-10 | 9 |

| 2004-10-11 | 4 |

| 2004-10-12 | 19 |

| 2004-10-13 | 13 |

| 2004-10-14 | 7 |

| 2004-10-15 | 8 |

| 2004-10-16 | 30 |

| 2004-10-17 | 31 |

| 2004-10-18 | 26 |

| 2004-10-19 | 3 |

| 2004-10-21 | 9 |

| 2004-10-22 | 10 |

| 2004-10-23 | 5 |

| 2004-10-24 | 7 |

| 2004-10-25 | 21 |

| 2004-10-26 | 12 |

| 2004-10-27 | 4 |

| 2004-10-28 | 4 |

| 2004-10-29 | 7 |

| 2004-10-30 | 4 |

| 2004-10-31 | 20 |

| 2004-11-01 | 11 |

| 2004-11-02 | 4 |

| 2004-11-03 | 4 |

| 2004-11-04 | 7 |

| 2004-11-07 | 1 |

| 2004-11-08 | 18 |

| 2004-11-09 | 11 |

| 2004-11-10 | 38 |

| 2004-11-11 | 41 |

| 2004-11-13 | 1 |

| 2004-11-15 | 18 |

| 2004-11-16 | 11 |

| 2004-11-17 | 9 |

| 2004-11-18 | 7 |

+ ------------ + ---------- +

42行（0.00秒） ）


mysql>退出

再见

mlh @ appserver mlh $ find / -name''* credifree *''2> / dev / null

/ home / mlh / public_html / credifree

/home/mlh/public_html/credifree/images/credifree.gif

mlh @ appserver mlh $ exit

I have a database named credifree. I did it with mysql''s create
command. Yet, I can find no files on my linux box except for a\
directory and a gif file that have the name credifree. Why? What''s
the name mysql might have made a database file under? Where is
it stored? Just curious.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxx
mlh@appserver mlh $ mysql / -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.22

Type ''help;'' or ''\h'' for help. Type ''\c'' to clear the buffer.

mysql> use credifree
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+------------------------+
| Tables_in_credifree |
+------------------------+
| paylog |
| secure_pdf |
| systemlog |
| tbiccreceiptsefx |
| tbiccreceiptsexp |
| tbiccreceiptstu |
| tbladdrchangesefx |
| tbladdrchangesexp |
| tbladdrchangestu |
| tbladdressesequifax |
| tbladdressesexperian |
| tbladdressestransunion |
| tblaftermath |
| tblbureaus |
| tblcfclientchanges |
| tblcfnegchanges |
| tblcr_types |
| tblcredifreeclients |
| tblcredifreenegs |
| tblcreditreports |
| tblhits |
| tblinboundtypes |
| tblinstructions |
| tblmemberlogins |
| tblmerchandise |
| tbloutboundtypes |
| tblprefixes |
| tblreasons |
| tblremoved |
| tblsales |
| tblsleepers |
| tblsuffixes |
+------------------------+
32 rows in set (0.00 sec)

mysql> select * from tblhits;
+------------+----------+
| DateHit | HitValue |
+------------+----------+
| 0000-00-00 | 79417 |
| 2004-09-30 | 76 |
| 2004-10-01 | 16 |
| 2004-10-04 | 11 |
| 2004-10-06 | 24 |
| 2004-10-07 | 20 |
| 2004-10-08 | 37 |
| 2004-10-10 | 9 |
| 2004-10-11 | 4 |
| 2004-10-12 | 19 |
| 2004-10-13 | 13 |
| 2004-10-14 | 7 |
| 2004-10-15 | 8 |
| 2004-10-16 | 30 |
| 2004-10-17 | 31 |
| 2004-10-18 | 26 |
| 2004-10-19 | 3 |
| 2004-10-21 | 9 |
| 2004-10-22 | 10 |
| 2004-10-23 | 5 |
| 2004-10-24 | 7 |
| 2004-10-25 | 21 |
| 2004-10-26 | 12 |
| 2004-10-27 | 4 |
| 2004-10-28 | 4 |
| 2004-10-29 | 7 |
| 2004-10-30 | 4 |
| 2004-10-31 | 20 |
| 2004-11-01 | 11 |
| 2004-11-02 | 4 |
| 2004-11-03 | 4 |
| 2004-11-04 | 7 |
| 2004-11-07 | 1 |
| 2004-11-08 | 18 |
| 2004-11-09 | 11 |
| 2004-11-10 | 38 |
| 2004-11-11 | 41 |
| 2004-11-13 | 1 |
| 2004-11-15 | 18 |
| 2004-11-16 | 11 |
| 2004-11-17 | 9 |
| 2004-11-18 | 7 |
+------------+----------+
42 rows in set (0.00 sec)

mysql> exit
Bye
mlh@appserver mlh $ find / -name ''*credifree*'' 2>/dev/null
/home/mlh/public_html/credifree
/home/mlh/public_html/credifree/images/credifree.gif
mlh@appserver mlh $ exit

推荐答案

mysql / -u root -p

输入密码：

欢迎使用MySQL监视器。命令以;结尾;或者\ g。

您的MySQL连接ID是4到服务器版本：4.0.22


键入''help;''或''\我向你寻求帮助。输入''\ c''清除缓冲区。


mysql>使用credifree

阅读表信息以完成表格和列名

您可以关闭此功能以便更快地启动-A


数据库已更改

mysql>显示表格;

+ ------------------------ +

| Tables_in_credifree |

+ ------------------------ +

| paylog |

| secure_pdf |

| systemlog |

| tbiccreceiptsefx |
| tbiccreceiptsexp |
| tbiccreceiptstu |

| tbladdrchangesefx |

| tbladdrchangesexp |

| tbladdrchangestu |

| tbladdressesequifax |

| tbladdressesexperian |
| tbladdressestransunion |
| tblaftermath |

| tblbureaus |

| tblcfclientchanges |

| tblcfnegchanges |

| tblcr_types |

| tblcredifreeclients |

| tblcredifreenegs |
| tblcreditreports |

| tblhits |

| tblinboundtypes |

| tblinstructions |

| tblmemberlogins |

| tblmerchandise |

| tbloutboundtypes |

| tblprefixes |

| tblreasons |

| tblremoved |

| tblsales |

| tblsleepers |

| tblsuffixes |

+ ------------------------ +

32行套装（0.00秒）


mysql> select * from tblhits;

+ ------------ + ---------- +

| DateHit | HitValue |

+ ------------ + ---------- +

| 0000-00-00 | 79417 |

| 2004-09-30 | 76 |

| 2004-10-01 | 16 |

| 2004-10-04 | 11 |

| 2004-10-06 | 24 |

| 2004-10-07 | 20 |

| 2004-10-08 | 37 |

| 2004-10-10 | 9 |

| 2004-10-11 | 4 |

| 2004-10-12 | 19 |

| 2004-10-13 | 13 |

| 2004-10-14 | 7 |

| 2004-10-15 | 8 |

| 2004-10-16 | 30 |

| 2004-10-17 | 31 |

| 2004-10-18 | 26 |

| 2004-10-19 | 3 |

| 2004-10-21 | 9 |

| 2004-10-22 | 10 |

| 2004-10-23 | 5 |

| 2004-10-24 | 7 |

| 2004-10-25 | 21 |

| 2004-10-26 | 12 |

| 2004-10-27 | 4 |

| 2004-10-28 | 4 |

| 2004-10-29 | 7 |

| 2004-10-30 | 4 |

| 2004-10-31 | 20 |

| 2004-11-01 | 11 |

| 2004-11-02 | 4 |

| 2004-11-03 | 4 |

| 2004-11-04 | 7 |

| 2004-11-07 | 1 |

| 2004-11-08 | 18 |

| 2004-11-09 | 11 |

| 2004-11-10 | 38 |

| 2004-11-11 | 41 |

| 2004-11-13 | 1 |

| 2004-11-15 | 18 |

| 2004-11-16 | 11 |

| 2004-11-17 | 9 |

| 2004-11-18 | 7 |

+ ------------ + ---------- +

42行（0.00秒） ）


mysql>退出

再见

mlh @ appserver mlh

mysql / -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.22

Type ''help;'' or ''\h'' for help. Type ''\c'' to clear the buffer.

mysql> use credifree
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+------------------------+
| Tables_in_credifree |
+------------------------+
| paylog |
| secure_pdf |
| systemlog |
| tbiccreceiptsefx |
| tbiccreceiptsexp |
| tbiccreceiptstu |
| tbladdrchangesefx |
| tbladdrchangesexp |
| tbladdrchangestu |
| tbladdressesequifax |
| tbladdressesexperian |
| tbladdressestransunion |
| tblaftermath |
| tblbureaus |
| tblcfclientchanges |
| tblcfnegchanges |
| tblcr_types |
| tblcredifreeclients |
| tblcredifreenegs |
| tblcreditreports |
| tblhits |
| tblinboundtypes |
| tblinstructions |
| tblmemberlogins |
| tblmerchandise |
| tbloutboundtypes |
| tblprefixes |
| tblreasons |
| tblremoved |
| tblsales |
| tblsleepers |
| tblsuffixes |
+------------------------+
32 rows in set (0.00 sec)

mysql> select * from tblhits;
+------------+----------+
| DateHit | HitValue |
+------------+----------+
| 0000-00-00 | 79417 |
| 2004-09-30 | 76 |
| 2004-10-01 | 16 |
| 2004-10-04 | 11 |
| 2004-10-06 | 24 |
| 2004-10-07 | 20 |
| 2004-10-08 | 37 |
| 2004-10-10 | 9 |
| 2004-10-11 | 4 |
| 2004-10-12 | 19 |
| 2004-10-13 | 13 |
| 2004-10-14 | 7 |
| 2004-10-15 | 8 |
| 2004-10-16 | 30 |
| 2004-10-17 | 31 |
| 2004-10-18 | 26 |
| 2004-10-19 | 3 |
| 2004-10-21 | 9 |
| 2004-10-22 | 10 |
| 2004-10-23 | 5 |
| 2004-10-24 | 7 |
| 2004-10-25 | 21 |
| 2004-10-26 | 12 |
| 2004-10-27 | 4 |
| 2004-10-28 | 4 |
| 2004-10-29 | 7 |
| 2004-10-30 | 4 |
| 2004-10-31 | 20 |
| 2004-11-01 | 11 |
| 2004-11-02 | 4 |
| 2004-11-03 | 4 |
| 2004-11-04 | 7 |
| 2004-11-07 | 1 |
| 2004-11-08 | 18 |
| 2004-11-09 | 11 |
| 2004-11-10 | 38 |
| 2004-11-11 | 41 |
| 2004-11-13 | 1 |
| 2004-11-15 | 18 |
| 2004-11-16 | 11 |
| 2004-11-17 | 9 |
| 2004-11-18 | 7 |
+------------+----------+
42 rows in set (0.00 sec)

mysql> exit
Bye
mlh@appserver mlh

find / -name''* credifree *''2> / dev / null

/ home / mlh / public_html / credifree

/home/mlh/public_html/credifree/images/credifree.gif

mlh @ appserver mlh

find / -name ''*credifree*'' 2>/dev/null
/home/mlh/public_html/credifree
/home/mlh/public_html/credifree/images/credifree.gif
mlh@appserver mlh

退出

这篇关于mysql在哪里放置数据库文件以及如何命名它们？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！