Database Administrators

Questions tagged [datadir]

Ask Question

In MySQL, "datadir" is an option describing the filesystem path to the folder where MySQL data is stored.

9 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
0
votes
2answers
2k 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 ...
1
vote
0answers
48 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 ...
0
votes
1answer
26 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 ...
9
votes
2answers
17k 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:\...
0
votes
2answers
25 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
0answers
81 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 ...
0
votes
1answer
8k 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=
1
vote
1answer
1k 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 ...
0
votes
1answer
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 (...