I have created a separate partition D. I now would like to store htdocs and MySQL data on the D-drive:
- d:\htdocs
- d:\mysql_data
Your help would be greatly appreciated!
First of all, it is not a good idea to install XAMPP into a folder with a space in the name - Program Files being such a folder which is not recommended - install to the root of a drive or partition like C:\ then XAMPP will be installed to C:\xampp folder. Spaces in folder names may give you some headaches down the track.Reveller wrote:I have installed XAMPP on my C-drive. Hence, Apache htdocs is located at c:\program files\xampp\htdocs and MySQL databases in c:\program files\xampp\mysql\data.
You can tell Apache where the DocumentRoot folder is in the xampp\apache\conf\httpd.conf file:Reveller wrote:I have created a separate partition D. I now would like to store htdocs and MySQL data on the D-drive:Is this possible, and if so, how do I have to configure this?
- d:\htdocs
- d:\mysql_data
Your help would be greatly appreciated!
C:\Program Files\xampp\mysql\bin>mysqladmin -h localhost 3306
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'
C:\Program Files\xampp\mysql\bin>telnet localhost 3306
Connecting To localhost...Could not open connection to the host, on port 3306: Connect failed
C:\Program Files\xampp\mysql\bin>mysqld /?
090427 11:16:25 [Warning] Can't create test file C:\Program Files\xampp\mysql\data\msi.lower-test
090427 11:16:25 [Warning] Can't create test file C:\Program Files\xampp\mysql\data\msi.lower-test
mysqld: Can't change dir to 'C:\Program Files\xampp\mysql\data\' (Errcode: 2)
090427 11:16:25 [ERROR] Aborting
090427 11:16:25 [Note] mysqld: Shutdown complete
[client]
port = 3306
socket = "C:/Program Files/xampp/mysql/mysql.sock"
[mysqld]
port = 3306
socket = "C:/Program Files/xampp/mysql/mysql.sock"
basedir = "C:/Program Files/xampp/mysql"
tmpdir = "C:/Program Files/xampp/tmp"
datadir = "D:/mysql"
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error = "D:/mysql/mysql_error.log"
skip-federated
server-id = 1
# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = "D:/mysql"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "D:/mysql"
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
Users browsing this forum: No registered users and 108 guests