create database test
on
(name = test_date,
filename = 'd:\test_date.mdf',
size = 10 mb,
maxsize = unlimited,
filegrowth = 10%
)
log on
(name = test_log,
filename = 'd:\test_log.ldf',
size = 5 mb,
maxsize = unlimited,
filegrowth = 10%
)存放在D盘
on
(name = test_date,
filename = 'd:\test_date.mdf',
size = 10 mb,
maxsize = unlimited,
filegrowth = 10%
)
log on
(name = test_log,
filename = 'd:\test_log.ldf',
size = 5 mb,
maxsize = unlimited,
filegrowth = 10%
)存放在D盘
/var/lib/mysql/my.conf是mysqld服务器的配制文件,在这个文件中,有数据库的存放位置等信息。比如象下面这样的:[mysqld]
datadir=/var/lib/mysql 这是数据库存放的位置
socket=/var/lib/mysql/mysql.sock
innodb_data_file_path = ibdata1:10M:autoextend2、windows下
在C盘windows下面有一个my.ini#This File was made using the WinMySQLAdmin 1.3 Tool
#25/8/2003 8:50:22
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions[mysqld]
default-character-set=latin1
basedir=C:\AppServ/mysql
#bind-address=
datadir=C:\AppServ/mysql/data
#language=C:/AppServ/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[client]
default-character-set=latin1
[WinMySQLadmin]
user=mysql
password=mysql
Server=C:/AppServ/mysql/bin/mysqld-nt.exe
安装的时候我就让他把数据文件放到D盘去,可不知道为什么他还是给我装在了C盘
我用他的config wizard改了n次都不行,郁闷。