Questions tagged [datadir]
In MySQL, "datadir" is an option describing the filesystem path to the folder where MySQL data is stored.
11
questions
0
votes
1
answer
69
views
mariadb innodb file per table data location
I have the following settings:
datadir = /var/db/mysql/data
innodb_data_home_dir = /var/db/mysql/innodb
innodb_file_per_table = ON
My intention is to ...
- 101
0
votes
0
answers
17
views
How to configure non-mysql user for datadir in MySql/MariaDB?
Using it for testing purposes and the NFS datadir will be accessed by two or more non-concurrent independent mariadb-servers.
So far, mariadb only permits if its this way:
chown -R mysql:mysql /data/...
- 101
0
votes
2
answers
9k
views
Can't start mysqld service after changing datadir
I have an AWS EC2 instance with RHEL 7 on which I installed mysql-5.5 on xvda. Its datadir is under /var/lib/mysql (as is the default).
I am importing dumps from a database on version 5.5.29 and the ...
- 19
1
vote
0
answers
735
views
Viewing directory of a mapped drive
I'm using the following query to view files/folders in a given directory. It works locally, but when trying to view a mapped drive I get...
"The system cannot find the path specified."
I have the ...
- 11
0
votes
1
answer
28
views
In MySQL can I drop a database by moving the directory containing the database?
We ran ran into a problem where MySQL kept crashing because of corruption in one of our databases. MySQL would start, crash, and then restart. We determined that the corruption was in a database ...
- 3
10
votes
2
answers
23k
views
Changing Data Directory on MySQL DB Server
I have installed mysql server 5.6.24 on Windows Server 2012 R2.
I imported dump files and the data files are stored in C:\ProgramData\MySQL\MySQL Server 5.6\data
I want to change directory like D:\...
- 101
0
votes
2
answers
31
views
Keep mysql.socks
I moved mysql datadir to /storage-s01/mysql, but socket is still located at the same directory /var/lib/mysql/mysql.sock.
Do I have to keep socket at the same directory as datadir?
BTW, If I want to ...
2
votes
0
answers
82
views
selecting from information_schema increases free disk space
Some background: There are 3 database servers - two in a master/master replication config with only one server accepting writes. And one other slave replica replicating from the write-master. The ...
- 21
1
vote
1
answer
10k
views
How do I change the MySQL data folder path in a Mac?
How do I change the MySQL data folder path in a Mac?
I am running OS X 10.10 & MySQL 5.6
In Windows I can edit datadir in my.ini
For Mac, mysqld does not have parameter for --defaults-file=
- 11
1
vote
1
answer
2k
views
Moved MySQL datadir Now Server Will Not Run!
My problem yesterday (MySQL - Alter Table Fails As Workbench Tries To Create Existing Table) was caused by /dev/sda2 (/root) running out of space.
The cause of this was that, by default, MySQL had ...
- 339
0
votes
1
answer
3k
views
Moving datadir OK start, but socket error for mysql client [duplicate]
I'm trying to move my MySQL datadir from /var/lib/mysql over to /home/mysql (an ssd drive as I'm having iowait issues on /var/lib/mysql when MySQL is running on that drive).
The OS is CentOS 5.6 (...
