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.
Post by Greg HellingsIt 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
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
--
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>