Change mysql data directory

[celview]

I am sorry if this question have been post. If yes can someone send me the link. If not, my problem is that after installing XAMPP, by default my MYSQL data directory is in the XAMPP folder. I am facing disk space issue soon and will like to migrate the MYSQL data directory ONLY to another disk. Is there a simple way to do this migration? I am only using localhost in Windows. Any help is much appreciated. Thanks.

[davidspan]

http://dev.mysql.com/doc/refman/4.1/en/ ... oting.html

[lyntuan]

Use AMPstart http://ampstart.com to start XAMPP
With AMPstart, you can set XAMPP at one place and PHP code + mySQL data at another place

You can never modify XAMPP, hence forget it

[celview]

Hi Lyntuan, thanks for the wonderful solution. But can you somehow describe a bit more how this little tool help my specific need? Tried to read the description in the AMPstart page but can't seems to see how to shift my MYSQL data directory to another location

[lyntuan]

Suppose your XAMPP at D:\xampp, your mySql data at Z:\web\data and your PHP code at Z:\web\mysite (Z is local drive)

Edit AMPstart.ini as followed:

[mysql]
folder=\web\data

[website]
website=\web\mysite

Put AMPstart.exe in D:\xampp, AMPstart.ini in Z:\ (or D:\xampp if Z=D)
Run AMPstart.exe.
That's all

You can modify many options in AMPstart.ini as you need

[celview]

Doesn't work....=(...My php still read from the original mysql directory...

[Izzy]

Doesn't work....=(...My php still read from the original mysql directory...

Go to directory xampp\mysql\bin\
Look for a file called my usually looks like a shortcut file.
May be called my.cnf

The only way I have found to open this file for editing is to open your text editor and drag the file into a blank page in your text editor.
(Save a copy of the original content in case things go wrong. You can then replace your edits from this original content file).

This is what mine looks like, yours may be slightly different:

Code: Select all

# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# C:/xampp/mysql/bin/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:/xampp/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
# password       = your_password
port            = 3306
socket          = mysql

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/mysql/data"

port            = 3306
socket          = mysql

old-passwords
character-set-server = latin1
collation-server = latin1_general_ci

skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
server-id   = 1

# Uncomment the following if you want to log updates
#log-bin=C:/xampp/mysql/data/mysql-bin

# Uncomment the following if you are NOT using BDB tables
skip-bdb

skip-innodb
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:/xampp/mysql/data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:/xampp/mysql/data/
#innodb_log_arch_dir = C:/xampp/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

[WinMySQLadmin]
Server="C:/xampp/mysql/bin/mysqld.exe"
#user=root
#password=


Look for this part:
# The MySQL server
[mysqld]
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/mysql/data"

Change the datadir to your choice.
(No need to change anything else at this stage as you are only after changing the location of your Data Directory).

Click Save

Stop and restart mysql for the changes to take effect.

You may copy over the directories and files from your existing data directory into your new location for testing purposes.

Read this my.cnf file to see and understand what other configuration items may be changed to suit any application of your XAMPP server.

HTH

=================================================
Take a look at the new DeskTopXampp launch control posted by ridgewood:
http://community.apachefriends.org/f/viewtopi ... 967#103967

The DeskTopXampp launch control for XAMPP and XAMPPlite (DTX.exe)
is available here:
http://zedfiles.com/DTX/

I highly recommend DTX.
=================================================