Postgres Import from DB not working - fixed

[glen]

Just worked through an import and had to learn quickly so thought I
would post this for others

> > *Ah, got it:*
> >
> > The URL being called when I press the button did not have index.php part
> > in it. So I added it into line 1229 of wwwsqldesigner.js
> >
> > var url =
> >
"backend/"+this.dom.backend.value+"/index.php?
action=import&database="+name;
> >


Hi Glen,

cool! Note that the application is backend-agnostic so it is not
possible
to add "index.php" as a suffix to every backend call: people are free
to
use any serverside language for creating backends. Better solution is
to
re-configure your webserver to present index.php as a default document
for
directory requests.


Sincerely,
Ondrej Zara


> > Good code Ondrej
> >
> > Rgds
> >
> >
> > Glen
> >
> >
> > Ondřej Žára wrote:
>> >> Hi Glen,
>> >>
>> >> to import a schema, you have to properly setup the relevant server-side
>> >> backend. For instance, if you have MySQL server and PHP support, you
>> >> could
>> >> use the built-in php-mysql backend. Edit the backend\php-mysql\index.php
>> >> file and fill in all required connection fields. To test if importing
>> >> words, point your browser directly to
>> >>
http://localhost/sqldesignerlocation/backend/php-mysql?action=import&database=DBNAME
>> >> - where DBNAME is the name of database to be imported.
>> >>
>> >> You will need at least some minimal PHP skills for this.
>> >>
>> >> If you are not satisfied with the results, please send me the output of
>> >> the
>> >> URL mentioned above.
>> >>
>> >>
>> >> Sincerely,
>> >> Ondrej Zara
>> >>
>> >>
>> >> On Wed, 28 Jan 2009 10:54:38 +0000, Glen Bremner-Stokes
>> >> <gl...@openbusinessassociates.co.uk> wrote:
>> >>
>>> >>> Ondras,
>>> >>>
>>> >>> I run a small open source services company in the UK. I am onsite at a
>>> >>> customer and would like to use your sql designer but I cannot get it to

>>> >>> import a schema.
>>> >>>
>>> >>> I have been through the groups and worked through the javascript code
>>> >>> but I am stuck. Just trying to get it to import a basic schema from a
>>> >>> mysql database.
>>> >>>
>>> >>> I would really appreciate it if I could give you a call and talk this
>>> >>> through with you if you have a moment. Could you give me a number to
>>> >>> call you on ?
>>> >>>
>>> >>> Regards
>>> >>>
>>> >>> Glen Bremner-Stokes
>>> >>> Open Business Associates Ltd
>>> >>>
>> >>
>> >>