mysql

[Net Llama!]

On Tue, 24 Mar 2003, Ted Ozolins wrote:
> Setting up permissions for user "ted" and "root" is where I keep getting
> things totally fragged. Untill I set perms I can create/delete databases
> no prob.But then more RTFM shed the light. I can start using
> mysql(sort-of)
>
> . One final hurdle. In setting up php-nuke the install indicates to use
> the command;
>
> mysql nuke < nuke.sql
>
> This goes nowhere. I can now connect to mysql create and delele dbases
> but I can't seem to fill the dbase "nuke" with the contents of nuke.sql.
> Am I still in the dark? You bet I am:)
>  Is there not a command  such as "mysqlshow" but perhaps a fill or
> inport function or something within mysql that would do this? Any
> insight would be greatly appreciated.

i realize that this doesn't solve your problem at all, but postgreSQL is
an order of magnitude easier to setup & admin than mysql, in my
experience.  unless you really, really need mysql, i'd suggest using
postgreSQL (which is far more mature & full featureed anyway).

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lonni J Friedman				netllama at linux-sxs.org
Linux Step-by-step & TyGeMo		     http://netllama.ipfox.com