[MOBY] [MOBY-dev] bug(s) in method DUMP

[Mark Wilkinson]

On Fri, 2003-10-17 at 17:31, Martin Senger wrote:

> > > 3) [Annoying] The dump should have included lines 'use <database-name>'
> > > before dumping tables for that database. Otherwise it creates all tables
> > > into one databases.
> > 
> > I dont understand the objection...??  All of the tables *are* in one
> > database (for each database).
> >
>    I do not understand your answer either :-) But that may well be because
> I know little about sql. I think (I thought) that you have 5 databases and
> for each, when you want to work with the, you need to use statement 'use
> <database>', such as use mobycentral; or use mobyobject;. At least that
> how I installed moby databases on my site and it works. But for that
> arrangement I needed to unclude these statements (use mobycentreal;, use
> mobyobject; etc.) into the dump before sourcinf the dump within my 'mysql'
> command-line program. So what am I doing wrong?

all on one line; for each database in the dump:

mysql -u username -p databasename <
~/moby-live/Database/databasename.mysql

(taken from http://biomoby.org/InstallingMOBYCentral.html)

M

 
> > I have made the subroutine name DUMP_MySQL.  This is currently aliased
> > to DUMP so that the API is the same, but we can make other procedures
> > later.
> >
>    Perfect.
> 
>    Many thanks for your fixes.
>    Martin
-- 
Mark Wilkinson <markw at illuminae.com>
Illuminae