root@kif:/var/db/mysql # uname -a
FreeBSD kif 10.3-RELEASE FreeBSD 10.3-RELEASE #0 r297264: Fri Mar 25 02:10:02 UTC 2016 firstname.lastname@example.org:/usr/obj/usr/src/sys/GENERIC amd64
Had databases/mysql80-server installed with www/nextcloud running. Wanted to add a www/phpbb3 instance...
mysql version: 5.6.38
I have a script the requires mysql, cron_create_tables.pl:
#!/usr/local/bin/perl -w --
my $dbh = DBI->connect('DBI:mysql:mymud', 'mymud', '') or die "unable to connect to MyMUD database";
Installed Powerdns and mysql57-server and client still I am facing this problem
#pdns_server --daemon=no --guardian=no --loglevel=9
Aug 19 09:26:46 Reading random entropy from '/dev/urandom'
Aug 19 09:26:46 Loading '/usr/local/lib/pdns/libgmysqlbackend.so'
Aug 19 09:26:46 Unable to load module...
I'm trying to upgrade databases/mysql55-server from 5.5.55 to 5.5.55_1.
This is the errors I am receiving. Is it safe to continue with the upgrade?
$ sudo portmaster mysql55-server-5.5.55
===>>> Currently installed version: mysql55-server-5.5.55
===>>> Port directory...
Apache 24 install,configuration and start successful.
Mysql install is the problem:
pkg install mysql57-server mysql57-client
http://http://pkg.freebsd.org/FreeBSD:11:amd64/latest/All/pkg.FreeBSD.org/FreeBSD:11:amd64/quarterly/All/mysql57-server-5.7.17_3.txz: Not Found
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.
13:59:57 Thu, 16 Feb...
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...
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
@db1:~ % sudo service mysql-server status
mysql is not...
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
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...
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.
$ sudo find / -name "mysql*" 2>/dev/null
and /usr/local/share/mysql/ has:
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.
1) www/apache24: "It works!" (sysutils/webmin sees it (after directory path...
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...