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:
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 mysql
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
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 ./configure
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.
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
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/database name
Let the list know what you find.
On Sat, 2002-03-23 at 06:10, Andy wrote:
When trying to execute a
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 ...
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
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:
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.
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 NGPT.
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
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
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 ??
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
?php phpinfo(); ?
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
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
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,
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
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
database to
Hi all,
I am using RH linux 7.2. I do have these lines:
AddType application/x-httpd-php .php
IfDefine HAVE_PHP
LoadModule php_module modules/mod_php.so
IfDefine HAVE_PHP
AddModule mod_php.c
IfDefine HAVE_PHP4
AddModule mod_php4.c
in my httpd.conf. I think Windows version's of
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 with
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
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.
how
/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
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
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 PROTECTED]
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
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
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 asked in
43 matches
Mail list logo