question about moving datadir around

2001-03-21 Thread STIBS

Hi list!

I try to change my data dir from the default /var/lib/mysql to /usr/mysql .

On a standard Suse install I did the following:

- copying all databases cp -R * /usr/mysql
- changing the datadir in /etc/my.cnf to /usr/mysql
- mysql restart
- works fine

On my ded. server I have RedHat 7 running, I installed the downloaded
3.23.32 rpm and now I tried to move the datadir.

My steps on RedHat:

- copying all databases cp -R * /usr/mysql
- there is no my.cnf in standard install, so I changed in the start script
/etc/rc.d/init.d/mysql the line $datadir=/usr/mysql
- mysql restart
-> demon gives up with the following statement in error log: "Can't find
./mysql/host.frm"
but the file is there, also chowned to mysql:mysql ...

next thing I did was setting up a symlink in /usr/mysql to the
/var/lib/mysql/mysql directory ... that the demon gets the original data ...
same comment in error log.

Do you have a solution or a step by step manual for me?

Any help is appreciated.

Thanx alot!
Michael


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Problem with UPDATE table ... can u help plz?

2002-10-16 Thread STIBS

Hi from Dresden, Germany!

I have a littlebig problem:

I want to UPDATE table1.fields with data from table2.fields WHERE the id (in this
case a product number) is the same in both tables.

OK, I did this:

UPDATE table1 SET table1.field1 = table2.field1, table1.field2 = table2.field2,...
WHERE table1.id = table2.id;

The answer from MySQL is: Unknown table 'table2' in WHERE clause .

Heading to MySQL.com the docs tell me nothing than there is a INSERT ... SELECT.

In my case this would be an UPDATE ... SELECT coz I don't want a new table, just
updating records of an existing with data from another.

I'm sure I just miss the right topic to look at. Point me please.

Second try:

I used

UPDATE table1, table2 SET table1.field1 = table2.field1, table1.field2 = 
table2.field2,...
WHERE table1.id = table2.id;

It still gives me an error, now  in the SQL Syntax when I set the table1.field2 value. 
It doesn't find the second tables name [You have an error... near ... table(2.field2 
should be here)].

Could someone give me the right direction?

TIA!

Michael Stibane (STIBS)
[EMAIL PROTECTED]
Training, Linux, Admin, Programming, Web
http://www.stibs.cc

Escapade Server-Side Scripting Engine Development Team
Pensacola - Dallas - Dresden - London
http://www.escapade.org


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Problem with UPDATE table ... thx 4 your help

2002-10-17 Thread STIBS

Thanx guys!

but:
I'm not in the mood to try Greg's suggestion ... LOL!
I think I'll work around that with Escapade programming language. It's much easier to 
handle.

If not:
I run a script that checks record by record in the first table if an update in the 
second table is available then I query the second and update the first.

STIBS


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Connecting to MySQL on Linux from a Windows machine.

2002-10-18 Thread STIBS
Will,

|||)So I still need some more ideas.

I have to learn your problem each time again when I setup a new machine every half a 
year.

I try each time the following hostnames:

localhost (didn't work 4u)
127.0.0.1 (IP for localhost)
hostname (e.g. databaseserver.mydomain.com- what you called the machine)
192.168.0.x  (Your real network IP, can also be in 10.* or 172.25.*)
localhost.localdomain (results to same as hostname)

one of them fit's ;o) ... if not I install webmin from www.webmin.com and connect via 
Browser to the machine (http://IP.ADD.RE.SS:1 - login as root). In Webmin's server 
section you have a complete webbased MySQL administration. There I make all settings 
and forget about it. It just works after this setup.

STIBS


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: ENABLE KEYS

2002-10-21 Thread STIBS
>mysql>alter table a_log ENABLE KEYS;
>ERROR 1064: You have an error in your SQL syntax near 'ENABLE KEYS' at
>line 1

What version are you running, I think I read ENABLE/DISABLE KEYS just work in 4.0.

STIBS


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Re: phpmyadmin (OT)

2002-10-25 Thread STIBS
Mitchell,

I run phpmyadmin at a freewebhost on RH 7.0/ Apache 1.3.22/ PHP 4.0.6/ MySQL 3.23.46 
in multiuser mode with about 300 users for one year. Zero problems at all with the 
software. The box got hacked but not because of vulnerabilities in phpmyadmin.

In time I use Usermin (plugin for Webmin see webmin.com - good as hosting-console) or 
MySQLman (http://www.gossamer-threads.com), both Perl/DBI based. Neither any security 
problems though MySQLman has it's problems displaying HTML code in database fields 
e.g. from CMS db's.

STIBS


=== At 2002-10-25, 11:56:00 you wrote: ===

>Hrm.
>
>Yes, php can be vulnerable, but I was more worried about phpmyadmin and the
>potential of direct access to my databases.
>
>This particular server runs red hat 7.3, and they bundle php with their
>distro. They also patch everything in their distros fairly regularly and I
>subscribe to their update services, I feel fairly secure in their offerings.
>
>I was mostly fishing for any horror stories out there from people that
>installed phpmyadmin and were hacked because of it. I like the convenience,
>but am not willing to sacrifice security. I am however willing to run php,
>so the security concern is purely with phpmyadmin.
>
>Any advice would be most appreciated,
>
>Mitchell
>
>On 10/25/02 11:47 AM, "Thomas Seifert" <[EMAIL PROTECTED]> wrote:
>

= = = = = = = = = = = = = = = = = = = =

2002-10-25, Best regards, Freundliche Grüße

STIBS (aka Michael Stibane)
Training, Consulting, Development
(Linux, Network, Internet, Database)
http://www.stibs.cc

Escapade Server-Sided Scripting Language Development Team
Pensacola - Dallas - Dresden - London
http://www.escapade.org

Mandrakesoft Linux-Campus Trainer
http://www.mandrakesoft.com/training

= = = = = = = = = = = = = = = = = = = =
No HTML mails please!



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Fehler beim Zugriff von Java auf mysql datenbank

2002-10-25 Thread STIBS
Hi!

sind alle Rechte an den entpackten Dateien an den Benutzer übertragen worden, unter 
dem der MySQL Server auf RH gestartet wurde? ps -uax zeigt den an.

Beispiel: User mysql, Group mysql

als root:

bash# chown -R mysql:mysql /var/lib/mysql

Das hatte ich schon mal nach einem Restore von db's (ohne Java).

STIBS



=== At 2002-10-25, 20:42:00 you wrote: ===

>Hallo,
>
>ich habe auf einem laufenden webserver mit mysql das verzeichnis
>var/lib/mysql als tar file mit czpf erstellt und auf einem anderen
>rechner an die selbe stelle entpackt.
>Auf dem Quellrechner (System: Suse 7.2 als webserver mit apache 1.3.26
>und tomcat 402) läuft mysql 3.23.49a-1und mysql-client 3.23.49a-1.
>Auf dem Zielrechner (System redhat 7.3 als webserver mit apache 1.3.26
>und tomcat 402) läuft  mysql-3.23.49-3
>mysqlclient9-3.23.22-6 , mysql-devel-3.23.49-3 und
>mysql-server-3.23.49-3. als rpm installiert.
>
>Wenn ich mit der webzugriffsseite mit benutzer und pw drauf zugreiffen
>will erscheint die folgende Webmeldung:
>
>java.lang.NullPointerException
>at
>genericDatabaseAccess.utilities.GenericAccess.selectRow(GenericAccess.ja
>va:
>at
>accountManagement.databaseAccess.UserFlatView.getUserForLogin(UserFlatVi
>ew.
>at userAccess.LoginFilter.processLogin(LoginFilter.java:75)
>at userAccess.LoginFilter.doFilter(LoginFilter.java:46)
>at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
>tionFilterChain.at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
>erChain.at
>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
>e.
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
>72)
>at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
>at
>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
>e.
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.ja
>va:
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
>72)
>at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
>at
>org.apache.catalina.core.StandardContext.invoke(StandardContext.java:234
>3)
>at
>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
>:
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
>lve.
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
>:
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
>72)
>at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
>at
>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
>72)
>at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
>at
>org.apache.catalina.connector.warp.WarpRequestHandler.handle(WarpRequest
>Handler.at
>org.apache.catalina.connector.warp.WarpConnection.run(WarpConnection.jav
>a:
>at java.lang.Thread.run(Thread.java:536)
>
>Wer kann mir helfen oder tipps geben wo ich eine antwort finden kann.
>
>Mit freundlichen Grüßen
>
>Erik Lang
>goetzfried ag - Ihr Projektpartner
>
>Windmühlstraße 14
>60329 Frankfurt
>Telefon 069.263-59064
>Telefax 069.263-51587
>Handy  0174.342 77 92
>www.goetzfried-ag.com
>eMail: [EMAIL PROTECTED]
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

= = = = = = = = = = = = = = = = = = = =

2002-10-25, Best regards, Freundliche Grüße

STIBS (aka Michael Stibane)
Training, Consulting, Development
(Linux, Network, Internet, Database)
http://www.stibs.cc

Escapade Server-Sided Scripting Language Development Team
Pensacola - Dallas - Dresden - London
http://www.escapade.org

Mandrakesof

Re: First time MySQL user needs help using/understanding mysqlimport

2002-10-20 Thread stibs-pi
With a similar case I had my problems because the exported database records
from Sage KHK, a german biz management software, had " and other special
chars in it that made it not possible to run a proper import from a CSV file and
manual cleaning with 35.000 records was out of question ;o)

I did the following: exported an Access db from KHK, Opened it in M$ Access,
made an ODBC connection to MySQL and exported the tables to the MySQL db.
Some lines SQL and I got rid of duplicates, etc.

Does Filemaker has the feature to connect to an ODBC source and if yes to
export tables there?

I have no clue with Mac's.

STIBS


> At 17:28 -0400 10/19/02, Paul Melia wrote:
> >Hello,
> >I am newbie to MySQL and I having some problems transferring my 
> >existing data to MySQL. Could someone tell me what I am doing wrong?
> >
> >I started by exporting certain fields from Filemaker 5.5 to a 
> >comma-separated .txt file. I then opened the file in BBedit, deleted 
> >duplicates and made other adjustments (like sorting the output 
> >properly) and then saved the file (with unix line breaks).
> >
> >I then opened a Terminal on a my Mac running OS 10.2.1 and issued 
> >the following command:
> >
> >mysqlimport -v omomain
> /Users/paul/Desktop/omostuff/csv_files/aproducer.txt
> >
> >This is what I got in return:
> >
> >Connecting to localhost
> >Selecting database omomain
> >Loading data from SERVER file: 
> >/Users/paul/Desktop/omostuff/csv_files/aproducer.txt into aproducer
> >mysqlimport: Error: Can't get stat of 
> >'/Users/paul/Desktop/omostuff/csv_files/aproducer.txt' (Errcode: 
> >13), when using table: aproducer
> >
> >I have tried other permutations that I have found at listsearch.com 
> >and at mysql.com and but I keep encountering the "Error: Can't get 
> >stat of '/Users/paul/Desktop/omostuff/csv_files/aproducer.txt' 
> >(Errcode: 13), when using table: aproducer"
> 
> % perror 13
> Error code  13:  Permission denied
> 
> This means the server can't read the file.  Most likely the permissions
> you have on it don't allow other users to read it, and the server probably
> runs as a different user than you.  You can either make the file world
> readable, or use the --local option to have the client send the file to
> the
> server over the connection.
> 
> I'm assuming the server is on the same machine; if it's not, only the
> --local approach will work.
> 
> >
> >The table exists, the database exists, and the spelling is correct 
> >so I am stumped.
> >
> >All files, servers and the Terminal  are on the same machine. 
> >(nothing is remote)
> >The version of MySQL I am running is: 3.23.46
> >
> >Any help is greatly appreciated!
> >
> >Thanks,
> >Paul Melia
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

-- 
-
PLEASE NO HTML EMAILS! THANX ALOT SAYS MY KMAIL CLIENT.
-
Best Regards/ Freundliche Grüße
Michael Stibane (STIBS)
[EMAIL PROTECTED]
Training, Linux, Admin, Programming, Web
http://www.stibs.cc

Escapade Server-Side Scripting Engine Development Team
Pensacola - Dallas - Dresden - London
http://www.escapade.org


+++ GMX - Mail, Messaging & more  http://www.gmx.net +++
NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen!


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Re: content design / database design help

2002-10-20 Thread stibs-pi
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
> 
> sql,query
> 
> If you just reply to this message, and include the entire text of it in
> the
> reply, your reply will go through. However, you should
> first review the text of the message to make sure it has something to do
> with MySQL. Just typing the word MySQL once will be sufficient, for
> example.
> 
> You have written the following:
> 
> Let me add a bit to this
> 
> > Relations will make sense for items like
> > 'project notes' which would work something like.
> > table 'notes'
> > project_id | create_date | note | author
> 
> my tabledesign would be
> 
> note_id(primary) | project_id(foreign) | create_date | note | author
> 
> in order to have a primary that not only one note for each project is
> possible.
>  
> > table 'project_contacts'
> > project_id | name | company | address | phone |
> > description
> 
> same here, add a contact_id :o) ...
> 
> Though I'd go with the first advise. There is a good solution I often use
> for construction companies: http://www.phprojekt.com. Veryvery complete!
> :o)
> 
> -- 
> -----
> PLEASE NO HTML EMAILS! THANX ALOT SAYS MY KMAIL CLIENT.
> -
> Best Regards/ Freundliche Grüße
> Michael Stibane (STIBS)
> [EMAIL PROTECTED]
> Training, Linux, Admin, Programming, Web
> http://www.stibs.cc
> 
> Escapade Server-Side Scripting Engine Development Team
> Pensacola - Dallas - Dresden - London
> http://www.escapade.org
> 
> 
> +++ GMX - Mail, Messaging & more  http://www.gmx.net +++
> NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen!
> 
> 

-- 
-
PLEASE NO HTML EMAILS! THANX ALOT SAYS MY KMAIL CLIENT.
-
Best Regards/ Freundliche Grüße
Michael Stibane (STIBS)
[EMAIL PROTECTED]
Training, Linux, Admin, Programming, Web
http://www.stibs.cc

Escapade Server-Side Scripting Engine Development Team
Pensacola - Dallas - Dresden - London
http://www.escapade.org


+++ GMX - Mail, Messaging & more  http://www.gmx.net +++
NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen!


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Access replacement...

2002-11-05 Thread stibs-pi
I had my own little investigation in this topic and found the following:

> A programming environment;
> A report builder

Kugar is a good choice for building reports and as a programming environment
ala VB. I is programmable via Python. It's not Open Source but relatively
cheap: http://www.thekompany.com

A more BASICalike Environment would be gambas but Benoit (the developer) has
no database component up yet. http://gambas.sourceforge.net He's busy with
acting school atm.

To the rest: Guys, anyone up for writing something?  I have no clue of C

> A database maintenance utility;
MyCC from mysql.com isn't a bad choice and it is cross platform

> A database query tool;
can't help you here, I ike SQL in ASCII mode

STIBS


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Access replacement...

2002-11-05 Thread stibs-pi
ooopps! ähm sorry... yes, Rekall, not Kugar!

STIBS


- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: "Brad" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 3:47 AM
Subject: Re: Access replacement...


> Brad wrote:
>
> >I am thinking of a move from a Windows network to Red Hat Linux at my
work. I
> >am happy with OpenOffice for spreadsheets, word  processing etc but the
main
> >problem is replacing MSAccess.
> >
> >MySQL provides a replacement for the database component but that still
leaves:
> >
> >A programming environment;
> >A database maintenance utility;
> >A database query tool;
> >A report builder
> >
> >Some of our users have had MSAccess training and are quite proficient in
> >producing simple but usable applications involving:
> >
> >The creation of a database and tables;
> >Forms to populate the database;
> >Queries and reports to display the data.
> >
> >All this in a graphical interface without needing to know SQL or doing
any
> >serious programming. They would need to be able to continue doing this in
the
> >new Linux environment - is there a suitable "Forms" utility?
> >
> >We also have some "serious" applications written in MSAccess by outside
> >professional programmers. This was partly done to allow the simpler
changes
> >(eg reports and screen layouts) to be made by the advanced users in order
to
> >reduce costs and delays. I would assume that a "Forms" utility would not
> >provide enough features to be used here. Does this mean that development
has
> >to be done in the opensource equivalent of "VB" which may shut out the
> >advanced users from making changes?
> >
> >Regards,
> >Brad
> >
> >
> We can both search together then :)
> I bought Kylix 1 and was extremely disappointed with it. Don't bother
> with that one...
> I considered using VB under wine but that isn't really a 'pure' solution
> that I can be proud of.
> I'm now looking into using Python. I installed boa-constructer (a Python
> IDE) last night. It looks interesting, but I don't think it's really
> geared towards database type stuff. I am also considering buying Rekall
> by TheKompany:
> http://www.thekompany.com/products/rekall/
> It combines Python and database aware stuff, but the currently only
> support very old MySQL client libraries and I haven't been able to get a
> demo version working on my box, so I'm not really sure. TheKompany have
> some interesting stuff though...
> Anyone got anything to add to this?
>
> --
> Daniel Kasak
> IT Developer
> * NUS Consulting Group*
> Level 18, 168 Walker Street
> North Sydney, NSW, Australia 2060
> T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
> email: [EMAIL PROTECTED]
> website: www.nusconsulting.com
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: How to port MS Access to MySQL ??

2002-11-08 Thread stibs-pi
Yep, ODBC works great.
Make a connection from Access to MySQL and mirror the access db into MySQL.

STIBS

> myodbc works fairly OK for me.
>
> On Fri, 2002-11-08 at 14:17, tmb wrote:
> > Is there a tool for doing a quick port from MS Access
> > to MySQL?
> >
> > Or must you manually create all the tables & sql
> > statements in MySQL and then export the MS Access data
> > to a comma delimited file... then import it into
> > MySQL?
> >
> > Thanks for any help - tmb
> >
> >
> > __
> > Do you Yahoo!?
> > U2 on LAUNCH - Exclusive greatest hits videos
> > http://launch.yahoo.com/u2
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: perl dbi and mysql question

2002-11-08 Thread stibs-pi
No clue of dbi/dbd but the query SHOW DATABASES does what it tells.

STIBS

- Original Message -
From: "Shon Stephens" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 08, 2002 3:44 PM
Subject: perl dbi and mysql question


> i am using perl dbi with dbd::mysql. i know that using the dbi function,
> $dbh->tables (), will list all the tables in a database. is there a
function
> that will show all the databases on a server?
>
> thanks,
> shon
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




question for research (OT)

2002-11-16 Thread stibs-pi
Hi!

I saw Czech people posting here. Im doing research for a local computer
magazine and I'm looking for online fees in Czech Republic. The article
deals with chances for international companies after Czech EU accedence.
Nothing to find in Google database. Could you please feed me some data or
point me to (english/german language) websites?

I'm looking for providers, costs per minute, flat rates, leased lines,
technical differences (modem, isdn, xdsl, powerline, cable) etc.

Plz answer to my private mail address.
Thanx in advance and sorry for any inconvenience by this post.
Your help is highly appreciated!

sql query

STIBS


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php