Hi !
> -Original Message-
> From: Alexander Shaw [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 23, 2002 11:19 PM
> To: MySQL List
> Subject: RE: MySQL, MyODBC and MS Access
>
>
> This seems to be a very common question that appears very
> frequently on the
> group, in fact one I have
Have a look at MyAccess available from http://www.accessmysql.com it has
worked for me
Alex
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2002 09:14
To: [EMAIL PROTECTED]
Subject: MS Access to MySQL conversion
We have a Unix server which in addition to
This seems to be a very common question that appears very frequently on the
group, in fact one I have asked in the past too.
Could I stick my head over the parapet and suggest a person or persons with
experience of Access front ends and MySQL backend puts together an FAQ for
this, or better still
Interesting comment in the manual, though, where someone says they tried
both methods and found the multiple statements to be faster than
SQL_CALC_FOUND_ROWS.
--jeff
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Fletcher Sandbeck" <[EMAIL PRO
Great work!! I have been digging around for the same thing for awhile and
now I can finish a job I had been on.
Thanks
M;)
-Original Message-
From: BD [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 23, 2002 5:13 PM
To: Ricardo Striquer Soares
Cc: [EMAIL PROTECTED]
Subject: Re: ER Prog
/sbin/service httpd restart
Then
tail /var/log/httpd/error_log
should show
[notice] Apache/1.3.22 (Unix) (Red-Hat/Linux) mod_ssl/2.8.5
OpenSSL/0.9.6b PHP/4.0.6 mod_perl/1.26 configured -- resuming normal
operations
or something like that
Ken
Andy Cheng wrote:
> Hi all,
>
> I am using RH
Just get the same version src rpm from any redhat mirror.
Ken
[EMAIL PROTECTED] wrote:
>hi,
>
>i have install mysql using binary installation on linux redhat 7.2.
>but due to some software which require access to source files of mysql, i
>guess i have to reinstall through source distribution.
>
hi,
i have install mysql using binary installation on linux redhat 7.2.
but due to some software which require access to source files of mysql, i
guess i have to reinstall through source distribution.
how shud i go abt it..do i have to uninstall and then install.
in that case how shud i uninstal
At 06:21 AM 3/21/2002, you wrote:
>i am looking for a ER Design Freeware tool, i'd like to konw if does
>someone here knows about something like that, the tool name and,
>if possible, the url for download.
>
>currently i am using a DDT (Database Design Tool) V1.5, however
>i think it's too simple
Hi all,
I am using RH linux 7.2. I do have these lines:
AddType application/x-httpd-php .php
LoadModule php_module modules/mod_php.so
AddModule mod_php.c
AddModule mod_php4.c
in my httpd.conf. I think Windows version's of http.conf is different. How
do I check if the module is load
From: "Othmar Stehlik" <[EMAIL PROTECTED]>
> I´m writing a simple Guestbook in Java, but I´m not quite sure which SQL
> Datatype I should use for the user´s comments.
> VARCHAR is not big enough,
Try TEXT or TINYTEXT.
However, you may want to have a check in place before it goes into the
datab
If you are having trouble getting it all to install correctly, you might
resort to Apache Toolbox at:
http://www.apachetoolbox.com
This is an interactive script that will take your input as to what you
want to install and with what options. It will then download all
necessary files, configure an
Sounds like php isn't compiled correctly. Make sure the module for php
is installed in apache
-Original Message-
From: Andy Cheng [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 23, 2002 1:48 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: mysql/php on linux
Hello all,
T
Hi
I´m writing a simple Guestbook in Java, but I´m not quite sure which SQL
Datatype I should use for the user´s comments.
VARCHAR is not big enough,
Thanx in advance!
Othmar
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net
Hello all,
Thanks for the help. I move my php test script to \var\www\html When I call
the php script from my browser, It shows me:
and not result of the phpinfo() function. When I run "php phpinfo()" at the
shell command, it out puts the html result. What is problem, my Apache not
underst
Jim, I use Perl. But I was looking for an SQL function/query for doing
that. If there isn't any, I welcome any suggestions though.
Thanks
On 23 Mar 2002, Jim Philips wrote:
> Are you really looking for SQL to do this? Or do you need PHP functions
> that will help you to achieve the same resu
I have downloaded mysql 3.23.49a source. When I run ./configure
--without-server it hangs. After several minutes I interupt it with
Cntrl - C. No makefile has been created neither has config.cache. I
then try ./configure --help and the exact same thaing happens. Can
anyone give an idea as
Hi,
It seems JDBCRealm implementation calls Conneciton.setAutoCommit() method
automatically. So your MySQL Server need to be able to accept SQL statements
"SET AUTOCOMMIT=1;" or "SET AUTOCOMMIT=0;"
Please check it with mysql console client.
In my case, MySQL-Max(InnoDB) 3.23.49 and gweMys
Is there a function or a way to find out how many days/hours/mins/secs
have elapsed since date n?
For example, i need to be able to get the answer like: "2 days and 3
hours have passed since date [some_date]"
Thanks
sherzodR
--
sql, query
Hello list,
I am attempting to run:
>perl -MCPAN -e 'install DBD::mysql'<
I am having a similar problem as the message that is in this subject line,
reported by Jon Ingason in a message dated March 1, 2002. I must have
tried the install routine at least 15 times, varying different settings that
At 10:53 -0500 3/23/02, MySQL wrote:
>Greetings,
>
>This is my first post to this list, hope you can help me.
>
>I'm trying to automate nighly exports from MySQL to a Filemaker Pro database.
>
>I figured out that the following syntax will get me a tab delimited
>export file:
>
>mysqldump -u root
Greetings,
This is my first post to this list, hope you can help me.
I'm trying to automate nighly exports from MySQL to a Filemaker Pro database.
I figured out that the following syntax will get me a tab delimited export file:
mysqldump -u root --tab=/directory MyDataBase
This is great excep
Hello,
I am running 3.23.49-nt on Win2K advanced server w/ 2GB of RAM. When I try
to make a connection from our web server using JDBC, it takes about 30
seconds to connect to MySQL. There is nothing wrong with network connection
or something else.
In mu opinion the main result is the number of
Hi all!
I am having a "problem" with some SELECT statements to MySQL together with
Perl, and I hope that anyone of you gurus here might give me a push in the
right direction.
Since I currently only have a modem connection, I can't subscribe to this
list and therefore I would be grateful if repli
Hi,
What is the correct syntax to use to backup all databases in the
/usr/local/mysql/var directory.
We tried a number of different options, but at best we get only 1 database,
backup completely. Using a wildcard, *, only creates the directory, but
doesn't copy the tables.
There are a number
You don't need samba you can do it from a command line...
...mysql -u user -h hostname or ip -p
Sorry for the ... Thast is not part of the command just outexpress like to
make things captial where they shouldn't be.
Chuck
on 3/23/02 10:02 AM, Paul Gilbert at [EMAIL PROTECTED] wrote:
> Hi Egor
Pjotr,
have you tested a speed of mutexes and the availability of adaptive
mutexes ...
Testing can be done with super-smack ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime
Hi Egor !
My question should have been like this ?
I am running Apache, MySql and PHP on a Linux server.
What I want to do is to open a MySql database that
reside on a Windows2000 computer. I don't want to
use Samba for security reason.
In other words, every thing run's on Linux but the
databa
> > So NGPT shows almost linear salability winning several times over
> > MySQL optimized Linux threads in some cases.
> >
> > --
> > Best regards,
> > Peter mailto:[EMAIL PROTECTED]
> >
>
>
> Thanks Pjotr !
>
> What about URL ??
>
http://freshmeat.net/proj
Quick newbie question...I am storing dates in my mysql table records,
how can i select the record with the most recent date?
bonus question (more of a scripting question)...
I need to use perl or php to list the dates out in ranges. in the table
they look like:
2002-02-17
2002-02-24
2002-03-02
I am using MySQL version 3.23.47 on Win ME with Apache Tomcat 4.0. I am
using JDBC realm but the error reported is :
java.sql.SQLException: Cannot disable AUTO_COMMIT
at org.gjt.mm.mysql.Connection.setAutoCommit(Connection.java:396)
at org.apache.catalina.realm.JDBCRealm.open(JDB
Peter Zaitsev writes:
> Hello mysql,
>
> I've found benchmark for MySQL on Linux with NGPT - the Solaris-like
> pthread compatible threads for Linux, the stable version 1.2.0 of
> which just was released.
>
> The user tested mysql server from binary distribution vs self
> compiled with
Hello mysql,
I've found benchmark for MySQL on Linux with NGPT - the Solaris-like
pthread compatible threads for Linux, the stable version 1.2.0 of
which just was released.
The user tested mysql server from binary distribution vs self
compiled with NGPT. 2.4.19-pre3 kernel was used.
Or simply create a symbolic link as suggested in the documentation:
ln -s /usr/local/mysql-3.23.49a-pc-linux-gnu-i686 /usr/local/mysql
cd /usr/local/mysql
./bin/safe_mysqld &
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 23, 2002 2:46 AM
To: [EM
First make a backup of your MYD file if you haven't already done so.
Then delete the useless index file (MYI) and run myisamchk with the
--quick flag which will hopefully recreate the index file. Also consult
the chapter on crash recovery with myisamchk at
http://www.mysql.com/doc/T/a/Table_maint
hello lister,
I'm new here and very newbie in mysql. I couldn't
start mysql :
[root@localhost mysqll]# Starting mysqld daemon with
databases from /var/lib/mysql020323 19:12:59 mysqld
ended
COuld anyone give me some suggestions to do in order
to run mysql daemon ...
___
I'm assuming you're on a UNIX box? If so, you might first check to see
if the data files exist and then look at the permissions on them. My
data files are in:
/usr/local/var/
Let the list know what you find.
On Sat, 2002-03-23 at 06:10, Andy wrote:
>
>
> When trying to execute a simple "Sele
When trying to execute a simple "Select" statement from the mysql command
prompt I'm getting the following Message:
ERROR 1016: Can't open file: 'wishes.MYD'. (errno: 144)
As far as I can see the database exists . Any ideas ?
Andy C
R2 project
http://www.r2-dvd.org
-
Hi,
I've got a 300 MB database file with a useless MYI file and I cant seem to
reconstruct it. Anyone know how I can get the data back.
if I use myisamchk -o it destroys all the data in the file so I'm kinda
stumped.
Cheers
Andy
PS I need to enter SQL and Query cos this mail bouced at first.
srividya,
Friday, March 22, 2002, 9:55:50 PM, you wrote:
ss> I installed the binary version of (MySQL)
ss> mysql-3.23.49a-pc-linux-gnu-i686.tar.gz.
ss> The steps followed to install are:
ss> tar xvzf mysql-3.23.49a-pc-linux-gnu-i686.tar.gz.
ss> cd mysql-3.23.49a-pc-linux-gnu-i686
ss> ./confi
Kathy,
Friday, March 22, 2002, 9:26:54 PM, you wrote:
KR> I am still a new to mysql. What is the syntax for backing up a table and how
KR> do I make it no-lock while doing so. I need the tables to still be able to
KR> be written to. I know that this will make my backup a little unaccurate but
KR>
Paul,
Friday, March 22, 2002, 9:51:51 PM, you wrote:
PG> I am running Apache on Linux and MySql database is running
PG> on a windows200 server.
PG> Is there a way to connect to that database using the IP address ?
Yes, when you connect to the remote MySQL server you should specify host
where mys
I am using MySQL in windows 98...it runs fine...I think u need only MYSQLD
to run everything...be sure to check ur MY.CNFit should be filled with
some...
R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)
-Original Message-
From: Winston
43 matches
Mail list logo
