mysql

[Trevor Smith]

On Sat, 30 Aug 2003 19:54:36 GMT, "ARMANDO PADILLA"
<mando81@prodigy.net> wrote:

>Hello everyone I was wondering if anyone knew a software package that would
>graphically display my Mysql
>Database and its table structures.

Perhaps DBDesigner might do what looking for?
[url]http://www.fabforce.net/dbdesigner4/[/url]

Trevor

[Rod]

Hi,

do you know a free sowftware to manage a mysql db with InnoDB.
I need to be able to manage the foreig keys.

may thanks

Rod

[Andy Hassall]

On Fri, 10 Oct 2003 11:08:08 +0200, "Rod" <toto@toto.com> wrote:

>do you know a free sowftware to manage a mysql db with InnoDB.
>I need to be able to manage the foreig keys.

phpMyAdmin.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url])
Space: disk usage analysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])

[David Gillen]

An noise sounding like Rod said:

> Hi,
>
> do you know a free sowftware to manage a mysql db with InnoDB.
> I need to be able to manage the foreig keys.
>

Isn't there a lack of foreign keys in mysql?

Dave
--

I'm a dead man, and buggered to boot!

[Andy Hassall]

On 11 Oct 2003 10:49:34 GMT, David Gillen <Belial@RedBrick.DCU.IE> wrote:

>An noise sounding like Rod said:

>> do you know a free sowftware to manage a mysql db with InnoDB.
>> I need to be able to manage the foreig keys.
>>

>Isn't there a lack of foreign keys in mysql?

They were added a while ago.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url])
Space: disk usage analysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])

[Rod]

Hi,

thanks you.
I will test it.

Rod

"Andy Hassall" <andy@andyh.co.uk> wrote in message
news:h4feovkl8gn0f1uu31bqv8du05p03dhq0c@4ax.com...

> On Fri, 10 Oct 2003 11:08:08 +0200, "Rod" <toto@toto.com> wrote:
>

> >do you know a free sowftware to manage a mysql db with InnoDB.
> >I need to be able to manage the foreig keys.

>
> phpMyAdmin.
>
> --
> Andy Hassall (andy@andyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url])
> Space: disk usage analysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])

[Yanal]

I am not sure if i can use mySql on the solaris server i have an account on.

the following is the mySQL info that it gives, i am not sure how I can
figure out the parameters to use if i wanted to create a database and
tables.


thanks
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.39
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE
MYSQL_LIBS

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited

[Janwillem Borleffs]

"Yanal" <fake@byu.edu> schreef in bericht
news:sTmkb.1638$Pp1.1499@newssvr29.news.prodigy.co m...

> I am not sure if i can use mySql on the solaris server i have an account

on.

>
> the following is the mySQL info that it gives, i am not sure how I can
> figure out the parameters to use if i wanted to create a database and
> tables.
>

Start of by reading the manual pages at [url]http://www.mysql.com[/url] (search for
CREATE).


JW

[Webmaster \(Nemesis Services\)]

[url]www.phpmyadmin.com[/url]


"Yanal" <fake@byu.edu> wrote in message news:sTmkb.1638$Pp1.1499@newssvr29.news.prodigy.co m...

> I am not sure if i can use mySql on the solaris server i have an account on.
>
> the following is the mySQL info that it gives, i am not sure how I can
> figure out the parameters to use if i wanted to create a database and
> tables.
>
>
> thanks
> mysql
> MySQL Support enabled
> Active Persistent Links 0
> Active Links 0
> Client API version 3.23.39
> MYSQL_MODULE_TYPE builtin
> MYSQL_SOCKET /tmp/mysql.sock
> MYSQL_INCLUDE
> MYSQL_LIBS
>
> Directive Local Value Master Value
> mysql.allow_persistent On On
> mysql.default_host no value no value
> mysql.default_password no value no value
> mysql.default_port no value no value
> mysql.default_socket no value no value
> mysql.default_user no value no value
> mysql.max_links Unlimited Unlimited
> mysql.max_persistent Unlimited Unlimited
>

[Ivan Fiala]

Hello I'm using PHP v 4.0b3 and MySQL version 4.0.17 win and when I try to
connect to database I get this error 'unknown command on line...
mysql_connect()...' I know, that mysql is running and is functional, as well
as PHP. I tried to enable the module extension=php_mysql.dll in php.ini but
it didn't help. Anyone can help please?
Thanks.

[lallous]

Hello,

AFAIK, MySql is either embedded in PHP or enabled by default.

Try to show the code perhaps someone can help you.

--
Elias
"Ivan Fiala" <diif@chello.sk> wrote in message
news:fHcIb.321076$dt3.42379@news.chello.at...

> Hello I'm using PHP v 4.0b3 and MySQL version 4.0.17 win and when I try to
> connect to database I get this error 'unknown command on line...
> mysql_connect()...' I know, that mysql is running and is functional, as

well

> as PHP. I tried to enable the module extension=php_mysql.dll in php.ini

but

> it didn't help. Anyone can help please?
> Thanks.
>
>

[Pirkka Pirunen]

Hi,
did you compile your PHP with MySQL?
i.e. from command line
$> make etc.etc. with-mysql etc.
I do not remember the exact syntax, but you should be able to find it on
[url]www.php.net[/url]
Seemes that your PHP compilation doesn't have mysql routines.


"Ivan Fiala" <diif@chello.sk> wrote in message
news:fHcIb.321076$dt3.42379@news.chello.at...

> Hello I'm using PHP v 4.0b3 and MySQL version 4.0.17 win and when I try to
> connect to database I get this error 'unknown command on line...
> mysql_connect()...' I know, that mysql is running and is functional, as

well

> as PHP. I tried to enable the module extension=php_mysql.dll in php.ini

but

> it didn't help. Anyone can help please?
> Thanks.
>
>

[Useko Netsumi]

You can get the pre-compiled version of PHP4 with MySQL dlls/extension. Just
enable them in php.ini.


"Pirkka Pirunen" <r3t@ert.no> wrote in message
news:3ff51e35$1@news.rivernet.com.au...

> Hi,
> did you compile your PHP with MySQL?
> i.e. from command line
> $> make etc.etc. with-mysql etc.
> I do not remember the exact syntax, but you should be able to find it on
> [url]www.php.net[/url]
> Seemes that your PHP compilation doesn't have mysql routines.
>
>
> "Ivan Fiala" <diif@chello.sk> wrote in message
> news:fHcIb.321076$dt3.42379@news.chello.at...

> > Hello I'm using PHP v 4.0b3 and MySQL version 4.0.17 win and when I try

to

> > connect to database I get this error 'unknown command on line...
> > mysql_connect()...' I know, that mysql is running and is functional, as

> well

> > as PHP. I tried to enable the module extension=php_mysql.dll in php.ini

> but

> > it didn't help. Anyone can help please?
> > Thanks.
> >
> >

>
>

[Gordon McVey]

"Ivan Fiala" <diif@chello.sk> wrote in message
news:fHcIb.321076$dt3.42379@news.chello.at...

> Hello I'm using PHP v 4.0b3 and MySQL version 4.0.17 win and when I try to
> connect to database I get this error 'unknown command on line...
> mysql_connect()...' I know, that mysql is running and is functional, as

well

> as PHP. I tried to enable the module extension=php_mysql.dll in php.ini

but

> it didn't help. Anyone can help please?

You're running a 4.0 beta? That version is extremely obsolete. Try
upgrading to 4.3.x or at least 4.2.x. I seem to remember reading that older
windows builds of PHP don't have MyAQL support compiled in by default.

[Jonathan Harden]

Hello

Can anyone recoomend a good php admin tool that isnt phpmyadmin, it can be
an app, web based and linux, mac os or windows based.

[Martijn Tonies]

>
> Can anyone recoomend a good php admin tool that isnt phpmyadmin, it can be
> an app, web based and linux, mac os or windows based.

Perhaps our tool can help? It's a Windows based admin/development tool
for - amongst others - MySQL. Database Workbench at [url]www.upscene.com[/url]


--
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
[url]http://www.upscene.com[/url]
Database development questions? Check the forum!
[url]http://www.databasedevelopmentforum.com[/url]

[Dmitrie Volinschi]

alte Version von MysqlFront (2.5)

Gruß
Dmitrie

"Jonathan Harden" <eviljonny@eviljonnys.com> schrieb im Newsbeitrag
news:4343dea5$0$25903$db0fefd9@news.zen.co.uk...

> Hello
>
> Can anyone recoomend a good php admin tool that isnt phpmyadmin, it can be
> an app, web based and linux, mac os or windows based.
>
>