<div dir="ltr">Thanks for the help, but it's not a lack of knowledge about setting up the database. It's a lack of desire to put in the effort. I have also not restored my personal blog, as it was kept on the same database and I just haven't gotten around to restoring either of them.<div><br></div><div>--Greg</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Sep 15, 2014 at 12:15 AM, Jim Michaels <span dir="ltr"><<a href="mailto:jmichae3@yahoo.com" target="_blank">jmichae3@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>some of my understanding of SQL
databases is:<br>
- the .data files for mysql (or oracle, etc) are not to be moved
or copied. they are a fliesystem within a filesyetem, and position
within the filesystem it resides in is ctitical. better to dump
the old db as SQL using the "mysqldump" tool in the bin dir, or
use one of the workbench/administration GUI tools to dump. avoid
the mysql table and anything relating to what sounds like a data
dictionary. you can put your SQL data back in by loading it in to
the "mysql" client binary probably in the bin directory (see the
help command or whatever it's called. I have not gotten my db back
up since having to reinstall, so I am unable to give exact help on
the client commands.<br>
<br>
- mysql is free for web use and development. embedded db use (like
a C API, etc) costs $600 or soemthing for a license or something.
some have turned to the open source mariadb, which probably uses
the same syntax.<br>
<br>
- mysqld is the background database server process that needs to
be running in order for the db to be available over default port
3306 (or whatever port you assigned). if you have multiple db
servers, each should have a separate port - they can all use the
same IP. if mysql, web server, email, ftp if you use it, etc is
local, you can serve up over localhost, as long as you have:<br>
127.0.0.1 localhost #IPV4 router<br>
::1 localhost #IPV6 router<br>
in your hosts file.<br>
<br>
your db users will be something like someuser@localhost<br>
<br>
postgresql[.org] is an open source database with a somewhat
different syntax and more heirarchical structuring. it is an
alternative to mysql, not used as often.<br>
it's freely embeddable and source code is available (not easy to
build, you have to hand-configure the code first).<br>
<br>
the mysql manuals are at <a href="http://dev.mysql.com/doc/refman/5.7/en/index.html" target="_blank">MySQL
5.7 Reference Manual</a><br>
<br>
- <a href="http://mysql.com" target="_blank">mysql.com</a> has their freely available GUI tools that will
probably install over WINE (WINdows Emulator).<br>
<br>
- phpmyadmin can probably help you admin your db over the web if
you want to choose that route, if a GUI tool is not of choice and
commandline is out.<br>
<br>
hope this helps.<div><div class="h5"><br>
<br>
On 9/2/2014 9:13 AM, Greg Hellings wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<div dir="ltr">It was up and functioning until a few weeks back
when I reloaded the server with Ubuntu 14.04. I haven't gone
through the effort of setting the site back up again. There was
some database magic that I'm not sure I preserved.
<div>
<br>
</div>
<div>--Greg</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Tue, Sep 2, 2014 at 11:07 AM, David
Haslam <span dir="ltr"><<a href="mailto:dfhmch@googlemail.com" target="_blank">dfhmch@googlemail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">See <a href="http://crosswire.org/wiki/Frontends:No_longer_being_actively_developed" target="_blank">http://crosswire.org/wiki/Frontends:No_longer_being_actively_developed</a><br>
<br>
I don't know whether Greg did anything with it after the
domain transfer<br>
from David Trotz.<br>
<br>
David Haslam<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://sword-dev.350566.n4.nabble.com/http-swordreader-org-is-down-tp4654153p4654160.html" target="_blank">http://sword-dev.350566.n4.nabble.com/http-swordreader-org-is-down-tp4654153p4654160.html</a><br>
Sent from the SWORD Dev mailing list archive at Nabble.com.<br>
<br>
_______________________________________________<br>
sword-devel mailing list: <a href="mailto:sword-devel@crosswire.org" target="_blank">sword-devel@crosswire.org</a><br>
<a href="http://www.crosswire.org/mailman/listinfo/sword-devel" target="_blank">http://www.crosswire.org/mailman/listinfo/sword-devel</a><br>
Instructions to unsubscribe/change your settings at above
page<br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
sword-devel mailing list: <a href="mailto:sword-devel@crosswire.org" target="_blank">sword-devel@crosswire.org</a>
<a href="http://www.crosswire.org/mailman/listinfo/sword-devel" target="_blank">http://www.crosswire.org/mailman/listinfo/sword-devel</a>
Instructions to unsubscribe/change your settings at above page</pre>
</blockquote>
<br>
<br>
</div></div><span class="HOEnZb"><font color="#888888"><pre cols="72">--
<a href="mailto:jmichae3@yahoo.com" target="_blank">jmichae3@yahoo.com</a>
<a href="mailto:JimM@RenewalComputerServices.com" target="_blank">JimM@RenewalComputerServices.com</a>"><a href="mailto:JimM@RenewalComputerServices.com" target="_blank">JimM@RenewalComputerServices.com</a>
<a href="http://JesusnJim.com" target="_blank">http://JesusnJim.com</a> (personal site, computer repair info, programming, calculators)
<a href="http://RenewalComputerServices.com" target="_blank">http://RenewalComputerServices.com</a> (my computer repair/software business)
Computer memory/disk size measurements:
[KB KiB] [MB MiB] [GB GiB] [TB TiB]
[10^3B=1,000B=1KB][2^10B=1,024B=1KiB]
[10^6B=1,000,000B=1MB][2^20B=1,048,576B=1MiB]
[10^9B=1,000,000,000B=1GB][2^30B=1,073,741,824B=1GiB]
[10^12B=1,000,000,000,000B=1TB][2^40B=1,099,511,627,776B=1TiB]
Note: disk size is measured in MB, GB, or TB, not in MiB, GiB, or TiB. computer memory (RAM) is measured in MiB and GiB.
</pre>
</font></span></div>
<br>_______________________________________________<br>
sword-devel mailing list: <a href="mailto:sword-devel@crosswire.org">sword-devel@crosswire.org</a><br>
<a href="http://www.crosswire.org/mailman/listinfo/sword-devel" target="_blank">http://www.crosswire.org/mailman/listinfo/sword-devel</a><br>
Instructions to unsubscribe/change your settings at above page<br></blockquote></div><br></div>