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

[Jim Michaels]

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 
> <mailto: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
>     <mailto: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.org
> http://www.crosswire.org/mailman/listinfo/sword-devel
> Instructions to unsubscribe/change your settings at above page


-- 
jmichae3 at yahoo.com
JimM at RenewalComputerServices.com">JimM at RenewalComputerServices.com
http://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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.crosswire.org/pipermail/sword-devel/attachments/20140914/69bfb067/attachment.html>