Tag Info

New answers tagged

1

The problem you are having is that the default configuration for newer versions of MySQL do not work inside of an OpenVZ container. After the failure you can try adding innodb_use_native_aio = 0 to /etc/mysql/my.cnf and then run dpkg --configure -a.


1

Settings like this go into the MySQL configuration file (e.g. in /etc/mysql/my.cnf; the exact location depends on your system). The setting in question is datadir, see http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_datadir for more info.


4

You can either reconfigure MySQL to look for the data directory in a different location, or bind mount a new location over the original. Make sure that the mysql service is stopped before you carry out these changes. Then, move all the files and sub-directories from the original location into your new location. Reconfigure MySQL edit /etc/my.cnf and ...


0

You can set the MySQL root password in your bootstrap file by adding debconf-set-selections commands before running your apt-get install: #!/usr/bin/env bash debconf-set-selections <<< 'mysql-server mysql-server/root_password password MySuperPassword' debconf-set-selections <<< 'mysql-server mysql-server/root_password_again password ...


1

It looks like you want to use the -e option, short for --execte, right? From man mysql: --execute=statement, -e statement Execute the statement and quit. The default output format is like that produced with --batch. See Section 4.2.3.1, “Using Options on the Command Line”, for some examples. With this option, mysql does ...


1

The socket file is a way for processes to communicate with the running server. When the server is dead, there is no need for the socket. As you said, it would have been removed if the server had a chance to shutdown gracefully. MySQL fails to start if the socket is already there; hence the error message. Removing it, when a server isn't running, is fine. ...


0

I would add those lines to /etc/inittab That file runs at every boot. you can leave off the sudo and the restart. Make "damn sure" that /etc/inittab returns 0


0

TokuDB does not support foreign keys, so you'll only be able to use it with Magento if Magento can run without them. Prior to running your alter table commands you need to drop any foreign keys on the alterting table plus any reference it.


1

One common problem is firewalling. Another possibility would be that MySQL only listens on unix sockets rather than on IP.


0

How much RAM does your server have? On a mostly InnoDB database the 500M is too high for a key buffer size. I generally start with 32M. You can not run MySQL with it set to 0. If the innodb_buffer_size + the key_buffer_size = > RAM then you will have problems. Also I generally need this setting in a secure network: bind-address = ...


0

The /var/lib/mysql/aria_log_control file is open by another process and consequently, mysqld fails to start. Check who/what is currently has the file open with: lsof `/var/lib/mysql/aria_log_control` It should list the process(es) that has it open. COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME mysqld 1506 mysql 10uW REG 253,1 52 ...


1

Go to your /etc/my.cnf file, and check the datadir and tmpdir variables. Go to those directories, and check the permissions of the files within them. If there's any file owned by root, change the permissions to something like mysql:mysql and try again. Example: In /etc/my.cnf you found: datadir = /var/lib/mysql Try the following and then try to ...


1

The following solved my problem: sudo killall -9 mysqld


1

It is clearly telling that 403 error that means it maybe a network fault of you that your centos server is not getting Internet Connection or CentOS Repos are down.


2

You need quotes around the result of the command substitution, i.e. "$(command)" I think e.g. (simulating your query with an echo): $ IFS=$'\t' read min max rows <<< "$(echo -e "Wed Jul 30 15:40:38 EDT 2014\tThu Jul 31 15:40:38 EDT 2014\t27")" $ echo "$min"; echo "$max" Wed Jul 30 15:40:38 EDT 2014 Thu Jul 31 15:40:38 EDT 2014 or use a (more ...



Top 50 recent answers are included