mysql

  1. MMacD

    MariaDB still not reading my.cnf?

    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...
  2. formaltux

    Failed upgrade mysql 5.6.34 to 5.6.35 (portupgrade)

    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...
  3. IPTRACE

    10.3->11.0 (mysql does not start)

    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...
  4. G

    Problem starting MySQL

    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...
  5. FKEinternet

    Data no longer accessible after upgrade from MySQL 5.6 to 5.7

    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...
  6. Neveroldmilk

    Have problems to start MySQL 5.7

    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...
  7. L

    ZFS Benchmark for measuring storage performance

    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...
  8. F

    ERROR 2002 (HY00): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

    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...
  9. cytopia

    Porting mysqldump-secure (port maintainer?)

    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...
  10. nonTechnical

    MySQL installed - but without config example files - why?

    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...
  11. S

    FAMP Installation for Wordpress 4.4

    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...
  12. Itproman

    Solved FAMP -Info.php not decoding

    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...
  13. W

    ZFS settings are inherited inside of Jail?

    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...
Top