unable to start Myth's database in MacOSX Yosemite

[jgandrade11@…]

After successful installation of Mythtv via Macports, I'm unable to intialize Myth's database despite following the cookbook from ​http://www.mythtv.org/wiki/MacPorts#Terminal_and_PATH
The answer that I get is: command not found.
The folder dvr under opt was not created despite running the command echo export PATH=/opt/dvr/bin:/opt/dvr/sbin:/opt/dvr/lib/mariadb/bin:$PATH" >> ~/.bash_profile. However, after running the command echo $PATH I do get the following:

/opt/dvr/bin:/opt/dvr/sbin:/opt/dvr/lib/mariadb/bin:/opt/local/bin:/opt/local/sbin:/opt/dvr/bin:/opt/dvr/sbin:/opt/dvr/lib/mariadb/bin:/opt/dvr/bin:/opt/dvr/sbin:/opt/dvr/lib/mariadb/bin:/opt/dvr/bin:/opt/dvr/sbin:/opt/dvr/lib/mariadb/bin:/opt/local/bin:/opt/local/sbin:/usr/local/git/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin

Please let me know where to find the log files you need to help me solve this issue. Thanks

[ctreleaven (Craig Treleaven)]

If you built Myth (as opposed to downloading the pre-built, all-in-one, installer, then you're following the wrong instructions. The pre-built installer puts everything under '/opt/dvr'; by default building with MacPorts puts everything under '/opt/local'. If that is the case for you, see the instructions at:

​http://www.mythtv.org/wiki/Building_Myth_for_Mac_with_MacPorts#Build_and_Install_Myth_0.27.4

You probably need to install mariadb-server.

Then adapt the configuration and set-up instructions--changing /opt/dvr to /opt/local ...

[jgandrade11@…]

Thanks for your advise. I tried again a clean install of macports and mythtv via macports. I installed "mariadb-server" and "logrotate +startupitem". Everything goes well. However, I am not able to start Myth's database. When I follow the instructions from "​http://www.mythtv.org/wiki/Myth_for_Mac_with_MacPorts" starting at the database section, I have no problem until I type "mysql -u root < /opt/local/share/mythtv/database/mythconverg_init.sql". I get the following error: "-bash: mysql: command not found". If you can please tell me step by step how to fix this issue I'll really appreciate it. Thanks for your help.

[larryv (Lawrence Velázquez)]

Replying to jgandrade11@…:

I have no problem until I type "mysql -u root < /opt/local/share/mythtv/database/mythconverg_init.sql". I get the following error: "-bash: mysql: command not found".

You may have to refresh your shell’s command cache to tell it about the newly-installed MariaDB executable (hash -r if you’re using bash or zsh). Also check port contents mariadb-server to make sure you’re trying to run the right binary.

[pixilla (Bradley Giesbrecht)]

Replying to jgandrade11@…:

I type "mysql -u root < /opt/local/share/mythtv/database/mythconverg_init.sql". I get the following error: "-bash: mysql: command not found".

The mariadb "mysql" is not in your path.

$ port contents mariadb | grep bin/mysql$
  /opt/local/lib/mariadb/bin/mysql

Using the full path to the mariadb "mysql" binary should resolve your error:

$ /opt/local/lib/mariadb/bin/mysql -u root < /opt/local/share/mythtv/database/mythconverg_init.sql

[ctreleaven (Craig Treleaven)]

No indication of an actual bug; closing as invalid.

If you are continuing to have problems, let's take this to the OSX forum on ​https://forum.mythtv.org/index.php or the mythtv-users mailing list.