3

Is there a way to get Acquia Dev Desktop to save the MySQL data to a different location other than the one it chooses by default?

Imagine to reinstall Acquia and thus needing to save the MySQL data from a Drupal instance into an alternate drive.

Acquia Dev Desktop places the database in C:\Program Files (x86)\DevDesktop\mysql\data.

enter image description here

Looking into the preferences, the config files contain the following.

[client]
port=33067
user=drupaluser

[mysql]
max_allowed_packet = 128M

[mysqldump]
max_allowed_packet = 128M


[mysqladmin]
user=root
port=33067

[mysqld]
pid-file="C:/Program Files (x86)/DevDesktop/mysql/data/mysql.pid"
log-error="C:/Program Files (x86)/DevDesktop/mysql/data/mysql.err"

# The TCP/IP Port the MySQL Server will listen on
port=33067

#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files (x86)/DevDesktop/mysql"

#Path to the database root
datadir="C:/Program Files (x86)/DevDesktop/mysql/data"

#set innodb as default
default-storage-engine=InnoDB

innodb_log_buffer_size=32M
innodb_buffer_pool_size=512M
innodb_log_file_size=32M

innodb_file_per_table=1

#Max open files
open_files_limit=10000

#Max packets
max_allowed_packet = 128M

#The log buffer is written out to the file at each commit. Flushing on the log file takes place once per second 
innodb_flush_log_at_trx_commit=2

#Enable slow query log
long_query_time=1
slow_query_log=1
slow_query_log_file=slow.log

If the data directory is changed, then I get the following error.

enter image description here

  • 1
    Did you move the data files to the new location before starting up? It's usually super helpful to review the SQL error log. – cilefen Jan 22 '17 at 12:25
0

Stopping the Acquia Dev server and moving/copying the files form the original data directory to the new data directory appeared to address the issue - thanks to cilefen for help

The following lines were updated to reflect the new location of the data directory

[mysqld]
pid-file="<<new path>>/data/mysql.pid"
log-error="<<new path>>/data/mysql.err"

and

#Path to the database root
datadir="C:/Program Files (x86)/DevDesktop/mysql/data"

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.