mysql

Apologies if this isn't the right place for this. Am I doing something stupid, or not doing something I should be doing? Because if not, MariaDB still isn't interpreting my.cnf, although it complains if it's not in /usr/local/etc/mysql. The command: 13:59:57 Thu, 16 Feb...

Hi, Yesterday morning around 8 am (GMT+1), I performed what should of been standard MySQL upgrade from MySQL 5.6.34 to MySQL 5.6.35 using portupgrade, but ended up losing InnoDB tables completely and spending whole day getting them restored. I ran mysql_upgrade after database restart and...

Hello! Next problem after upgrade to 11.0-RELEASE. MySQL does not start. No data in logs. Reinstallation didn't help. @db1:~ % sudo service mysql-server status mysql is not running. @db1:~ % sudo service mysql-server start Starting mysql. @db1:~ % sudo service mysql-server status mysql is not...

Hi All, I have a problem starting MySQL, (5.7.13_1). From my err.log Shared object "liblz4.so.1" not found, required by "mysqld" Bit of background, this was an old FreeBSD 9.x server that I updated to 10.2 some time ago. I recently upgraded MySQL, all went fine at the time. Was forced to...

I upgraded my server from MySQL 5.6 to 5.7 via pkg install mysql57-server. After getting the changed configuration issues sorted out so I could run mysql_upgrade -u root -p successfully, it reported that practically all of my existing tables don't exist - because they are stored on disk with...

I used pkg to install MySQL 5.7 by this command: $ sudo pkg install mysql57-server Then I have problems to start MySQL, and the command and output is listed below: $ sudo sysrc mysql_enable=yes mysql_enable: -> yes $ sudo service mysql-server start /usr/local/etc/rc.d/mysql-server: WARNING...

Benchmark to measure the storage performance when I send database query. I install Mysql because it has its own benchmark mysqlslp. I use also sysbench. The problem is how to measuring storage performance when the query is sent, and what is the most important parameters to be put under stress...

How can I backup the databases in MySQL 5.6 if it will not run? It will not create an mysql.sock so I can't do a dump. I have also reinstalled MySQL 5.6 two times without errors and will not create mysql.sock to get the MySQL running to perform the dump / backup. I have the mysql directory...

Hi guys, I am trying to fully port mysqldump-secure over to FreeBSD. It is already at the state that the script itself is 100% fully working (POSIX shell without any bashism: #!/bin/sh). I have one request as well as one error and one problem. 1. The request I would like to get this as a...

I've just installed databases/mysql57-server on a new server, but can't see the example config files in /usr/local/share/mysql or anywhere to copy to run the server. I've used: $ sudo find / -name "mysql*" 2>/dev/null and /usr/local/share/mysql/ has: my-default.cnf mysql-log-rotate...

FreeBSD 10.2-RELEASE Apache24 MySQL 5.5 PHP-5.6 Installed Wordpress 4.3.1_1 from pkg repository, no issues in getting it set up and running. WordPress 4.4 gets released and I upgraded, then my installation couldn't create or write files (via WordPress FTP implementation; couldn't...

I followed this tutorial I found doing a search for FAMP and all is well, except for info.php. https://www.digitalocean.com/community/tutorials/how-to-install-an-apache-mysql-and-php-famp-stack-on-freebsd-10-1 1) www/apache24: "It works!" (sysutils/webmin sees it (after directory path...

Guys, Someone know if the settings from Host are inherited inside of Jail? For example, in the Host I have make an dataset like: zfs create -o compression=off -o exec=off -o recordsize=16k -o setuid=off zroot/var/db/mysql My concern is about the recordsize, since I dont know how to check it...