[sword-devel] http://swordreader.org/ is down?

[Greg Hellings]

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.

--Greg

On Mon, Sep 15, 2014 at 12:15 AM, Jim Michaels <jmichae3 at yahoo.com> wrote:

>  some of my understanding of SQL databases is:
> - 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.
>
> - 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.
>
> - 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:
> 127.0.0.1 localhost #IPV4 router
> ::1 localhost #IPV6 router
> in your hosts file.
>
> your db users will be something like someuser at localhost
>
> 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.
> it's freely embeddable and source code is available (not easy to build,
> you have to hand-configure the code first).
>
> the mysql manuals are at MySQL 5.7 Reference Manual
> <http://dev.mysql.com/doc/refman/5.7/en/index.html>
>
> - mysql.com has their freely available GUI tools that will probably
> install over WINE (WINdows Emulator).
>
> - 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.
>
> hope this helps.
>
>
> On 9/2/2014 9:13 AM, Greg Hellings wrote:
>
> 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.
>
>  --Greg
>
>
> On Tue, Sep 2, 2014 at 11:07 AM, David Haslam <dfhmch at googlemail.com>
> wrote:
>
>> See
>> http://crosswire.org/wiki/Frontends:No_longer_being_actively_developed
>>
>> I don't know whether Greg did anything with it after the domain transfer
>> from David Trotz.
>>
>> David Haslam
>>
>>
>>
>> --
>> View this message in context:
>> http://sword-dev.350566.n4.nabble.com/http-swordreader-org-is-down-tp4654153p4654160.html
>> Sent from the SWORD Dev mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> sword-devel mailing list: sword-devel at crosswire.org
>> http://www.crosswire.org/mailman/listinfo/sword-devel
>> Instructions to unsubscribe/change your settings at above page
>>
>
>
>
> _______________________________________________
> sword-devel mailing list: sword-devel at crosswire.orghttp://www.crosswire.org/mailman/listinfo/sword-devel
> Instructions to unsubscribe/change your settings at above page
>
>
>
> -- jmichae3 at yahoo.comJimM@RenewalComputerServices.com">JimM at RenewalComputerServices.comhttp://JesusnJim.com (personal site, computer repair info, programming, calculators)http://RenewalComputerServices.com (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.
>
>
> _______________________________________________
> sword-devel mailing list: sword-devel at crosswire.org
> http://www.crosswire.org/mailman/listinfo/sword-devel
> Instructions to unsubscribe/change your settings at above page
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.crosswire.org/pipermail/sword-devel/attachments/20140915/ba4ebba8/attachment-0001.html>