set name=pkg.fmri value=pkg://localhosts11/database/mysql-80/client@8.0.28.0.1,5.11-0.0.175.3.33.0.2.0:20220220T175457Z set name=pkg.description value="MySQL 8.0 community edition *read* https://sfe.opencsw.org/SFEmysql80 for detailed tipps and tricks. . . . . This package is currently in develompent, please expect some edges. . . If you have troubles or want a feature added, get in contact: sfepackages@gmail.com . . or got to IRC libera.chat channel #pkgbuild . . . Note: if mysql-57 is installed before, then you may need to set mediator, to get mysql-sfe version 8.0.28 be the default database. . . . . For /usr/bin/mysql client symlinked to the right version, you set mediator. . . See for available mediators: pkg mediator -a . . . . See the currently active MySQL symlink-target: . . pkg mediator mysql . . . . To set mysql symlinks to this version, run this command . . pfexec pkg set-mediator -I mysql-sfe mysql . . . . To enable the database enable SMF service mysql-80 . . . . svcadm enable -s mysql:version_80 . . This will initialize an *empty* database with a mysql root password (change this!) you can find in the Server logfile here: . . grep password /var/mysql/8.0/data/${HOSTNAME}.err . . . . You *may* add more instances in SMF with separate my.cnf and data . . . . If you *upgrade* your database, beware, pkg uninstall deletes your old Database Directory and moves files to /var/pkg/lost+found/ . . . . To Upgrade from mysql 5.7 to mysql 8.0 you move or copy all raw files from /var/mysql/5.0/data/ over to /var/mysql/8.0/data/ . . Alternatively you start with an empty database and you dump all data from 5.7 and import it into new 8.0 server. . . . . Compile-Options: ... -DBUILD_TYPE=Release" dir group=bin mode=0755 owner=root path=usr/mysql/8.0/man link facet.doc.man=all mediator=mysql mediator-implementation=mysql-sfe mediator-version=8.0 path=usr/share/man/man1/mysqladmin.1 target=../../../mysql/8.0/man/man1/mysqladmin.1 depend fmri=sfe/database/mysql-common@8 fmri=database/mysql-common@5 type=require-any file 69b046e43c8a39c48dda762942dd1a42e67c8e21 chash=f2d654fded709804d31804135a94c771c6828704 elfarch=i386 elfbits=64 elfhash=b8bd98cd36f055affb1356833ca2a1672d9121e4 group=bin mode=0755 owner=root path=usr/mysql/8.0/bin/mysql pkg.csize=2304394 pkg.size=7984368 dir group=bin mode=0755 owner=root path=usr/mysql/8.0/bin file df0424b439b841e96eab516cc46f772f983f3574 chash=5d5cdcbe6a94b6e2f35c50e8a9e9ef4f6136350e elfarch=i386 elfbits=64 elfhash=7e57c535d034b60c820510c31a5ffc43c082b1fc group=bin mode=0755 owner=root path=usr/mysql/8.0/bin/mysqlbinlog pkg.csize=2376495 pkg.size=8167208 set name=pkg.summary value="MySQL Server Community Edition 8.0 - mysql client" set name=net.sourceforge.pkgbuild,version value=1.3.104 license bc8701644e63e4f14c2104aa27dec2b887e178bf chash=e4d30e7b8ed41d0c640072900090406433e5aa26 license=unknown pkg.csize=116 pkg.size=135 set name=variant.arch value=i386 link facet.doc.man=all mediator=mysql mediator-implementation=mysql-sfe mediator-version=8.0 path=usr/share/man/man1/mysqldump.1 target=../../../mysql/8.0/man/man1/mysqldump.1 set name=build.tool value=pkgbuild file 9932346a67040500a884b2fd2f4f10d6a4d59669 chash=f48f820992f6f50f9cda343ccdc3e8f34d63bccb elfarch=i386 elfbits=64 elfhash=ea066e14511002660979b34ec3e528a8952afcce group=bin mode=0755 owner=root path=usr/mysql/8.0/bin/mysql_config_editor pkg.csize=1747238 pkg.size=6614024 dir group=bin mode=0755 owner=root path=usr/mysql/8.0 dir group=sys mode=0755 owner=root path=usr dir group=bin mode=0755 owner=root path=usr/mysql/8.0/man/man1 file ec33399ff6a8cc1a72d5d6eda01f948029b6169a chash=2186977149a6ec06abbaf47a821f2014d234c4e7 elfarch=i386 elfbits=64 elfhash=60c35c916e3d000fd51fc075ea435b5375e090e9 group=bin mode=0755 owner=root path=usr/mysql/8.0/bin/mysqlslap pkg.csize=2175459 pkg.size=7664584 file a823e4d93f8433f65799ef92611023ecabea8b18 chash=119b2e912e96dcfa4b7e831a9ea3c35e6f088f70 elfarch=i386 elfbits=64 elfhash=5219157783e05bbb589510d6673ca24106dafb31 group=bin mode=0755 owner=root path=usr/mysql/8.0/bin/mysqlcheck pkg.csize=2174521 pkg.size=7664768 link mediator=mysql mediator-implementation=mysql-sfe mediator-version=8.0 path=usr/bin/mysql target=../mysql/8.0/bin/mysql dir group=sys mode=0755 owner=root path=usr/mysql/8.0/share file 9f6a2d4a59dccd405a9aa638b5f22b81361d4702 chash=6251c1f7e1c4d29a83fe179948c1461d521f8016 group=bin mode=0644 owner=root path=usr/mysql/8.0/man/man1/mysql.1 pkg.csize=26688 pkg.size=104424 dir group=bin mode=0755 owner=root path=usr/mysql legacy arch=i386 category=SFE,application desc="MySQL Server Community Edition 8.0 - mysql client" hotline="Please contact your local service provider" name="MySQL Server Community Edition 8.0 - mysql client" pkg=SFEmysql80-client vendor=http://pkgbuild.sf.net/spec-files-extra version=8.0.28,REV=110.0.4.2022.02.20.18.40 depend fmri=database/mysql-80/library type=require link facet.doc.man=all mediator=mysql mediator-implementation=mysql-sfe mediator-version=8.0 path=usr/share/man/man1/mysql.1 target=../../../mysql/8.0/man/man1/mysql.1 link mediator=mysql mediator-implementation=mysql-sfe mediator-version=8.0 path=usr/bin/mysqladmin target=../mysql/8.0/bin/mysqladmin file b4abf5ef02492a9d2e6bcac64d439e082b5d228b chash=cf8157ac0b23071891e6eb6d3daa99cb5b899643 elfarch=i386 elfbits=64 elfhash=0f9b50cdc471df22e35175fa1203afd6009cf5cd group=bin mode=0755 owner=root path=usr/mysql/8.0/bin/mysqladmin pkg.csize=2166987 pkg.size=7650024 file bf0197635dcaeabe88077e9e638be40f9f3b0160 chash=aefd05d758955adcebbc239d97467e578202500e elfarch=i386 elfbits=64 elfhash=becb44aeab018e7131b58c999c53f23c35466ded group=bin mode=0755 owner=root path=usr/mysql/8.0/bin/mysqlshow pkg.csize=2163300 pkg.size=7642024 file 96d89222eda904c44abc51023211813dbc70b40f chash=0d7a32cd996061875cbbf61423568ae5d79ebefd elfarch=i386 elfbits=64 elfhash=37185d2dec93fe4db6befc1ab624741acb78410d group=bin mode=0755 owner=root path=usr/mysql/8.0/bin/mysqlimport pkg.csize=2164678 pkg.size=7646088 file 177bfdfd7674b5e3f0f8219d47ad7c14620ea8d1 chash=7567f213f4e052fad8ce7974061eda7297d8d464 group=bin mode=0755 owner=root path=usr/mysql/8.0/bin/mysqldumpslow pkg.csize=3239 pkg.size=7669 set name=info.source-url value=http://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-boost-8.0.28.tar.gz file 476ce3261c1ca26b267c83a8ce1014f4eb6628e5 chash=39dbe7f4729e4acffb8cf5e08f3a31dc12d40eff elfarch=i386 elfbits=64 elfhash=c0697a0fd4fbe8c4e2e95bab96eab108e8a730f0 group=bin mode=0755 owner=root path=usr/mysql/8.0/bin/mysqlpump pkg.csize=2435538 pkg.size=8453552 link mediator=mysql mediator-implementation=mysql-sfe mediator-version=8.0 path=usr/bin/mysqldump target=../mysql/8.0/bin/mysqldump file 37bc644a10f46fc35ed4e27172631bff906f7207 chash=9b9f69b279c3b1671e361e39db273d6fa70c22a5 elfarch=i386 elfbits=64 elfhash=1a35211cb409ee133ddbadc576ea0026c59b640b group=bin mode=0755 owner=root path=usr/mysql/8.0/bin/mysqldump pkg.csize=2203132 pkg.size=7731168