Hi,
I use php to connect to mysql server.
after that I check my table, myisamchk report that client not properly close
the connection
how to avoid this error?
where should I check?
thx.
-
Before posting, please check:
ht
Sir/Madam,
I am using MYSQL C-API to access MYSQL database .
I am having problems when i gave Unicode support to my code, as the API
functions accept parameters of the type "const char *" .With Unicode
support the values being passed are the of the type "unsigned short".
Is there any way I can m
On Wed, Jul 04, 2001 at 11:31:01PM -0700, Ken Sommers wrote:
> Hello,
>
> how do I download the Mysql manual to win 95?
>
> what is a Tarball?
It's sort of like a ZIP file on Windows. You can use WinZip to extract
it.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Fin
Hi all,
just a quick question .. has neone setup mysql on a cobalt RAQ4 before? If so
ne
recommendations on how to go about doing it?
thanx heaps
D
--- Send the right message ---
+ Today freemail +
Get your free, private email address at
http://www.today.com.au
Hello,
how do I download the Mysql manual to win 95?
what is a Tarball?
Ken
On Wed, Jul 04, 2001 at 11:03:25PM -0700, Ken Sommers wrote:
> Is there any way to get from chapter 7 MySQL Language Reference till
> the end of the MySql Manual,on my hard drive back home?
I'm a bit confused. Are you looking for the downloadable manual? It's
on www.mysql.com along with all the
HI,
Is there any way to get from chapter 7 MySQL Language Reference till the end
of the MySql Manual,on my hard drive back home?
using win 95,,cuz it was free..
Ken
-
Before posting, please check:
http://www.mysql.com/manu
On 4 Jul 2001, at 21:21, Jeremy Zawodny <[EMAIL PROTECTED]>
expounded about "Re: different subdir for database":
> On Thu, Jul 05, 2001 at 12:10:07PM +0800, Jaime Teng wrote:
> > Hi,
> >
> > I have mysql on NT4 (soon to be win2000). one question is that the
> > database files all reside under dr
Hi all,
Do you know how I can resolve the following errors which happened
when I ran 'make' after I sucessfully ran ./configure ?
ar cru .libs/libmysqlclient.a libmysql.o net.o password.o
get_password.o errmsg.o my_init.o my_static.o my_malloc.o my_realloc.o
my_create.o my_delete.o my_tempnam
> > Hi,
> >
> > I have mysql on NT4 (soon to be win2000). one question is that the
> > database files all reside under drive c. NT does not have symbolic
> > link
>
> I seem to recall Microsoft making a big deal out of the fact that they
> "invented" symbolic links and added them to Win2000. A
On Thu, Jul 05, 2001 at 12:10:07PM +0800, Jaime Teng wrote:
> Hi,
>
> I have mysql on NT4 (soon to be win2000). one question is that the
> database files all reside under drive c. NT does not have symbolic
> link
I seem to recall Microsoft making a big deal out of the fact that they
"invente
Hi,
I have mysql on NT4 (soon to be win2000). one question is that the
database files all reside under drive c. NT does not have symbolic link
is there a way to tell mysql that a particular database is located on
a different folder? where is the documentation for this one?
jaime
> Am I naive or is this a viable proposition?
Oh, I see, you would like to connect this information with the
pid, right? I wouldn't know how to do that. How do you get a pid?
Is this something MySQL could provide?
--
Herzlich
Werner Stuerenburg
If your box supports php, install phpMyAdmin. This really comes
easy. Look for an address in Google for download.
Sie schrieben am Donnerstag, 5. Juli 2001, 02:55:04:
> Hi, all,
> I am a newer to MySQL, being learning, i have installed the bianary 3.23.29
> into my pc which is running windows 2
127 means Record-file is crashed. See manual, run isamchk for
repair.
Sie schrieben am Donnerstag, 5. Juli 2001, 02:50:22:
> I got this error messages when I try to access my table
> "Got error 127 from table handler"
> -
How about tracking your own record until then? Create a table and
insert a record for each connection.
If you would use a class to connect like db_mysql.inc from
PHPLIB, it would be a snap to implement. From php, you know all
sorts of variables to identify your general setting.
I assume that the
At the mysql> type use firstdb; then type show tables;
-Original Message-
From: Shania Qiu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 04, 2001 8:35 PM
To: 'Mike'
Cc: '[EMAIL PROTECTED]'; Ken Sommers
Subject: RE: asking for teaching?
Thank you all for your help, i created a datab
Thank you all for your help, i created a database called 'firstdb' with one
table 'members' successfully. I opened WinMySQLadmin 1.1, databases, i cant
see the database 'firstdb' i just created sitting there, except mysql and
test that are system's example db's.
Any ideas,
Shania Qiu
-O
Yes
themember_id int(11) NOT NULL auto_increment, starts at 1 and goes up
automaticly and is maintained by MySQL
thePRIMARY KEY (member_id) just makes the member_id the PRIMARY KEY
Snip from Manual
A PRIMARY KEY is a unique KEY with the extra constraint that all key columns
must be defined
HI,
when you created table:
Create a table
CREATE TABLE members (
member_id int(11) NOT NULL auto_increment,
fname varchar(50) NOT NULL,
lname varchar(50) NOT NULL,
tel varchar(15),
email varchar(50) NOT NULL,
PRIMARY KEY (member_id)
);
is that primary Key also an index authoma
Try http://www.analysisandsolutions.com/code/mybasic.htm#creating for a nice
tutorial
and http://www.devshed.com/Server_Side/MySQL/Speak/page7.html has some
excellent tutorials
To Create a database and table
CREATE DATABASE member;
Create a table
CREATE TABLE members (
member_id int(11) NO
On Wed, 04 Jul 2001, Shania Qiu wrote:
> Thank you, Luis,
>
> I type in 'login mysql', the system responded me with 'Welcome to Microsoft
> Telnet Server', then back to c:\, according to your instruction, i typed in
> create database test, the message ' 'create' is not recognized as an
> internal
Thank you, Luis,
I type in 'login mysql', the system responded me with 'Welcome to Microsoft
Telnet Server', then back to c:\, according to your instruction, i typed in
create database test, the message ' 'create' is not recognized as an
internal or external command, operable program or batch fil
well you should read the man pages that come with it also there are alot of
book on mysql.
But you know what since your a newbie. I wills how you. I dont have mysql
installed on a windows machine, but on a linux box. i believe the commands
are the same.
log in
mysql
create database test; ---h
Hi, all,
I am a newer to MySQL, being learning, i have installed the bianary 3.23.29
into my pc which is running windows 2000. Can someone tell me where and how
to create tables in MySQL.
Thank you all.
shania.
-
Before p
I got this error messages when I try to access my table
"Got error 127 from table handler"
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arch
At 11:28 AM 07/04/2001 , you wrote:
>hi.
>
>w/r/t your first question: mysqldump just generates a text file containing
>the sql statements necessary to recreate the dumped table(s).
>if you use mysqldump -uuser -p > dumpfile.txt you can open it in vi or
>notepad and edit it if desired...
>the err
>Description:
MySQL 3.23.39 on FreeBSD 4.3.
Running the sql-bench/test-create script using BDB, mysql will fail
to create a table and will log the error "dbd: Metapage flush failed"
>How-To-Repeat:
sh# test-create --log --create-options=TYPE=BDB
Testing server 'MySQL 3.23.39 log' at 2001-07-05 0:
oh nevermind, i just tryed ftp.mysql.com (at random though) and found it
thanks
- Message d'origine -
De : <[EMAIL PROTECTED]>
À : <[EMAIL PROTECTED]>
Envoyé : jeudi 5 juillet 2001 0:40
Objet : problem with d/l
> Hi,
>
> I can't download
> http://www.mysql.com/Downloads/mysqlgui/mysqlg
Hi,
I can't download
http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-1.zip
Can you help?
Been trying several times and from several places
thanks
bye
greg
-
Before posting, please check:
http://www.m
I recently started getting this error from a query:
> Got error 'repetition-operator operand invalid' from
> regexp (SELECT id, IF(parents LIKE '_%',CONCAT(parents,'
> name),name) AS name, usergrp FROM Categories WHERE id > 10 AND id
> AND parents NOT RLIKE '^\* New Category \*(|$)' O
Bonjour,
I sent this post a few days ago but it didn't get a lot of contributions.
Wouldn't it be an interresting feature ?
> > > When you have a big web site with a lot of pages, programs,
> > > cronjobs, applications ... connecting to Mysql, it's sometimes
> > > difficult
I recently installed the MySQL driver for Java in my system with Win98.
I downloaded the mm binary version.
Then I copied the org directory in my PC and added the following line in my
Autoexec.bat :
classpath=\org;%classpath%
Is that right?
I could access the MySQL database from my Java classe
> I want Execute querys stored in file but from
> phpmyadmin interface, I want to use telnet to execute
> the command :
> # mysql mydb_name < file.sql
> but in telnet prompt its invalid command
So not from phpMyAdmin, right?
Use
mysql -hlocalhost -uUsername -p dbName < file.sql
You will have
> Can I copy a table (structure only) to another database? I've searched
> though my manuals without success so far.
use phpMyAdmin. It is a push of a button (you have to give a name
for the copy first).
--
Herzlich
Werner Stuerenburg
___
On Wednesday 04 July 2001 21:37, Christopher Brown-Floyd wrote:
> Is there a way to run a SQL command or create a database through a batch
> file?
jeez! for some one who is omniscient you don't know much
read the friendly manual
section 9.6 : Using mysql in batch-mode
also check out mysqldu
Hello. My name is Mike. I am writing a C++ program to access a MySQL database. I
have MySQL-3.23.36 server running on Linux Mandrake 8.0. I downloaded mysql++-1.7.9
version from the internet and installed it successfully. When I try to compile my C++
program using:
g++ /usr/local/lib/libsq
Is there a way to run a SQL command or create a database through a batch
file? If not, is there some kinda work around? I'm trying to make a batch
file that will create a skeleton database structure for deployment of a
website that I'm working on.
TIA
-Chris
--
Julien,
sorry that I did not notice your message earlier, but
I was running tests on new big BLOBs, and a stress test
passed now without errors :).
But the problem you have is probably the rollback bug in .38.
It has been fixed in .39. Upgrade to to .39 and try to start
the database again.
Rega
On 04-Jul-01 Ken Sommers wrote:
> Dynamic HTML (DHTML) promises to change radically the way developers build
> Web applications. It empowers the client end of the Web server/browser
> relationship. The DHTML feature most oriented to the needs of database
> developers is data binding. Data binding
On 04-Jul-01 Graham Nichols wrote:
> Hi,
>
> Can I copy a table (structure only) to another database? I've searched
> though my manuals without success so far.\
$ mysqldump -d db da_table | mysql newdb
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always
hi.
w/r/t your first question: mysqldump just generates a text file containing
the sql statements necessary to recreate the dumped table(s).
if you use mysqldump -uuser -p > dumpfile.txt you can open it in vi or
notepad and edit it if desired...
the error about the table existing is because the
At 1:45 PM +0100 7/4/01, matthew yee-king wrote:
>Hello
>sorry if this is old hat...
>
>i am trying to figure out a way to assign primary keys to my database tables.
>I have previously used ints with auto_increment but i am wondering
>what happens when you reach the highest number possible for an
At 10:52 AM 07/04/2001 , you wrote:
>I think you can check this link
>
>http://www.mysql.com/documentation/mysql/bychapter/
That's what I'm reading, and quoted from below, and what gave rise to the
questions in this email.
And, all of it deals with 3.23.29--unless you are referring to all the
I think you can check this link
http://www.mysql.com/documentation/mysql/bychapter/
- Original Message -
From: "Joe Taraba" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 04, 2001 1:47 PM
Subject: Replication, update log, mysqldump???
> Hi;
>
> I'm trying to learn M
Hi;
I'm trying to learn MySQL, having some difficulties understanding backup
strategies.
mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)
Where is the documentation (besides man pages) for mysql Ver 3.22.32
According to the the 3.23.29 online docs it appears that there are four
ways
When I need recreate a table structure I do it like
CREATE db_target.table_copy
SELECT * FROM db_source.table
WHERE 1=0;
The only thing that you have to do now is
DESCRIBE db_target.table_copy;
DESCRIBE db_source.table;
Since you need to manually reestablish the indices in the new table.
Alt
Mohan;
I'm also new to this database administration and development. There are
some excellent tutorials at Devshed.com.
Below is a link to the tutorial on Database Normalization, I think this
will give you some answers to your query:
http://www.devshed.com/Server_Side/MySQL/Normal/
Joe
At 0
Jane ...
(This is based on our own experience, and info found in the MySQL Manual
... http://www.mysql.com/doc/N/a/Name_case_sensitivity.html). We have used
this procedure to convert dozens of databases, and found that setting the
server's variable to lower-case tables also requires converting
hello,
I want Execute querys stored in file but from
phpmyadmin interface, I want to use telnet to execute
the command :
# mysql mydb_name < file.sql
but in telnet prompt its invalid command
Can you help me?
Thanx
___
Do You Yahoo!? -- Pour
Thanks for the note, I will determine if this applies to our situation.
However I believe I found the solution to my problems to be apache related.
I found that after upgrading to apache 1.3.20, MANY of our web server
requests were duplicated & some times tripled when using IE 5.5 (and
presumably
On Wed, 04 Jul 2001, Mohan Khurana wrote:
> database enthusiasts,
>
> I'm fairly new to database administration and development, I'm currently
> still learning about features of databases so that I can ensure that my
> design for the database that I create will be correct. I will be storing
> ge
database enthusiasts,
I'm fairly new to database administration and development, I'm currently
still learning about features of databases so that I can ensure that my
design for the database that I create will be correct. I will be storing
general pieces of information in an index table that wil
On Wed, 4 Jul 2001, Moonesh Suggun wrote:
> hi To All,
>
> Has anyone try to insert images e.h. gif into mysql database.. I
> have tried using blob type but how would I verify that it is OK.
It can be done, however general wisdom is that one should use the
filesystem to store images, simply beca
Hi,
How to create query to get data from tables of two different databases ?
Best regards, Andrey
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
GN> Hi,
GN> Can I copy a table (structure only) to another database? I've searched
GN> though my manuals without success so far.
you can use query
show create table TABLENAME
which will show what query recreates table named TABLENAME
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Hi,
Can I copy a table (structure only) to another database? I've searched
though my manuals without success so far.
kind regards, Graham
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
CREATE TABLE namelist (
name CHAR(60),
id SMALLINT AUTO_INCREMENT)
You will find much useful information at http://www.mysql.com - check
the documentation section. I also use the O'Reilly book "MySQL and
mSQL" by Yarger, Reese and King, which has detailed in
Well, i did that using Perl/CGI. I have no clue how to load it directly.
WHat i did was opened a *.gif file, and stored it into the BLOB column the same
way as you would text. That's it
Sent on Jul 4 by Moonesh Suggun to MySQL News Group
suggun> hi To All,
suggun>
suggun> Has anyone try to
I think you are looking for something like:
create table namelist (ID int not null auto_increment, name char(60), ...);
?!?
Cheers, Nessi
>At 15:21 04/07/01 , you wrote:
>>I move from MDB to mySQL, I got a question concern how to create a auto
>>digital number field in mysql table,
>>
>>crea
hi To All,
Has anyone try to insert images e.h. gif into mysql database.. I have tried using blob
type but how would I verify that it is OK.
Thanks in advance,
Regards,
Moonesh
You meaaan, auto incrementing field ???
If so
CREATE TABLE t_name (id INT AUTO_INCREMENT);
Workds.
But there's no "auto digital number" thingy
Sent on Jul 4 by Web Mailing List to [EMAIL PROTECTED]
websig> I move from MDB to mySQL, I got a question concern how to create a auto
digit
I move from MDB to mySQL, I got a question concern how to create a auto digital number
field in mysql table,
create table namelist ( name char(60), ID auto, date date());
sorry for asking this question here, i'm sure it's a myODBC question, but
i asked there a couple of days ago and got no responce
I was just wondering if anyone has much experience of using a MySql
backend for an approach APR, using of course myODBC. I've been playing
around wiht the idea of mig
Fournier Jocelyn [Presence-PC] writes:
> Hi,
>
> Does DELETE take advantage of index to locate more quickly row to be deleted ?
>
> Thank you :)
>
> Jocelyn Fournier
> Presence-PC
Of course.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL
Hello, I have mysdl 3.23.38 with innodb (dont know which version) support on Linux
RedHat 6.2
Mysqld crashed, and when I try to restart it, I have the following error:
010704 16:50:34 mysqld started
InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB:
Hi,
Use DBTools (http://dbtools.vila.bol.com.br) to convert/import from Access,
Excel, DBF, ODBC and TXT. You can also generate csv files and import them
into mySQL with LOAD DATA INFILE.
[]'s
Crercio O. Silva
-Original Message-
From: jake williamson 28 [mailto:[EMAIL PROTECTED]]
Sent:
Sorry, now I´m reading, through re-compiling and re-installing
mysql, the version info, and i´m running 3-23-22 beta.
Thanks.
> -Mensaje original-
> De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Enviado el: miércoles 4 de julio de 2001 13:41
> Para: Roberto Carlos S
> -Mensaje original-
> De: Roberto Carlos Sánchez Barroso
> Enviado el: miércoles 4 de julio de 2001 13:45
> Para: '[EMAIL PROTECTED]'
> CC: '[EMAIL PROTECTED]'
> Asunto: RE: Initial setup in Linux RH7.1
>
> I´m running mysql 3.23.39!!!
> Can anybody help me!!!
Roberto Carlos Sánchez Barroso <[EMAIL PROTECTED]> writes:
> I´ve got the same problem, installing mysql through RH7.0,
> "Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' and i´m trying all the solves you post, but
> anything help me, could anybody p
And What´s up with a RH7.0?
Thanks.
> -Mensaje original-
> De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Enviado el: miércoles 4 de julio de 2001 13:38
> Para: [EMAIL PROTECTED]
> CC: [EMAIL PROTECTED]
> Asunto: Re: Initial setup in Linux RH7.1
>
> Yi-chen
Hello
sorry if this is old hat...
i am trying to figure out a way to assign primary keys to my database
tables.
I have previously used ints with auto_increment but i am wondering what
happens when you reach the highest number possible for an int... is
there some way of 'reclaiming' primary key
Yi-chen Lan <[EMAIL PROTECTED]> writes:
> When I type "service mysql start", it gives me "mysql: unrecognized service"
Oops, typo :) - "service mysqld start"
--
Trond Eivind Glomsrød
Red Hat, Inc.
-
Before posting, please che
On Wed, 4 Jul 2001, Sherzod Ruzmetov wrote:
>
> That's what I'd do (assuming there's no other programs available, but aint
> sure). Save the excell spreadsheet as a *.csv file, then load it to mysql with
> LOAD DATA command
Be warned, Excel throws out some stupid looking CSV files. I've had it
On Wed, 4 Jul 2001, Caroline Leclerc wrote:
> Hi,
>
> Sorry to send this mail to the mailing list but I browsed all the
> archives concerning a secure connection without success.
> I did the following:
> ssh -l username mysqlserver -L 222:mysqlserver:3306 -N
a) Try using port 3306 locally if yo
It's more of a PHP than a MySQL 'problem' & certainly not a MySQL bug, but...
Upon processing "$res_insert_campaign=mysql_query($sql,$conn);" the script will insert
a line into your database.
Then, upon evaluating "if (!$res_insert_campaign) {" it will do "if
(!mysql_query($sql,$conn))" and ins
hallo!
With reference to Dawn H on 04.07 00:36:
> The error log says,
>
> Can't call method "do: on an undefined value. . .
>
> But the EXACT SAME code works on another script I'm running. I don't see any
> reason for it to suddenly have a problem. What does this error message MEAN?
>
> Co
If somebody could help to, this is the message that is shown in the
/va//lib/mysql/[domain server name].err
010704 11:07:58 mysqld started
010704 11:07:58 /usr/libexec/mysqld: Table 'mysql.host' doesn't
exist
010704 11:07:58 /usr/libexec/mysqld: Normal s
Hi,
is there a limit of concurrent connections or threads in MySQL? What do I have to
consider when many users (500 - 1000) want to use MySQL at the same time?
Greetings from Germany
Lutz Maibach
EasyCom GmbH
Thanks, but my directory /var/lib/mysql owner´s already mysql.
drwx-- mysql...
> -Mensaje original-
> De: oyun [SMTP:[EMAIL PROTECTED]]
> Enviado el: miércoles 4 de julio de 2001 11:06
> Para: Roberto Carlos Sánchez Barroso
> Asunto:
That's what I'd do (assuming there's no other programs available, but aint
sure). Save the excell spreadsheet as a *.csv file, then load it to mysql with
LOAD DATA command
Sent on Jul 4 by jake williamson 28 to [EMAIL PROTECTED]
jake.w>
jake.w>
jake.w> hello,
jake.w>
jake.w> does anyone k
Hi,
I have been using mysql fine on a win32 box.. but have now also installed it on Linux
box. The version details are below:
Red Hat Linux release 6.0 (Hedwig)
Kernel 2.2.5-15smp
I am using this version of mySQL:
mysqladmin Ver 5.3 Distrib 3.20.32a, for pc-linux-gnu on i686
TCX Datakonsult
hello,
does anyone know how/are there any help programs to convert a excel
spreadsheet into a mysql database?
i can get the spreadsheet into access - would it be a case of i can then
export that to mysql??
any ideas oh guru's???!!
cheers,
jake
28
23a great queen street
londo
TWIMC,
When I try to import a comma serparated flat file it usually works just
fine. The exception is if any of the records in the file end with a double
quote, [as records often do with CSV files] I lose all the data from that
point on or until MySQL finds another double quote at the be
When I type "service mysql start", it gives me "mysql: unrecognized service"
On Tuesday 03 July 2001 22:41, Trond Eivind Glomsrød wrote:
> Yi-chen Lan <[EMAIL PROTECTED]> writes:
> > When I try to run mysql, the system give an erroe message "Can't connect
> > to local MySQL server through socket
Greetings All:
Pardon the asp tags. I use frontpage extensions for Linux; Win2K client in a
VMWare session. It's easier for testing what Windoze users see. My client,
and, all...
The FORM:
...
...
ACTION executes the following PHP script:
$qry = "INSERT INTO Resumes
SET rid = '',
I´ve got the same problem, installing mysql through RH7.0,
"Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' and i´m trying all the solves you post, but
anything help me, could anybody post any other?
Thanks.
> -Mensaje original-
>
Hi,
Sorry to send this mail to the mailing list but I browsed all the archives
concerning a secure connection without success.
I would like to encrypt the connections using DBI modules with mysql
drivers(Or perhaps it is already encrypted?)
Anyway, I did not manage to connect to mysql when the
The only reason why that might happen (assuming it is working somewhere else),
the object isn't return. So connect() constructor couldn't return the object.
To read the error message from DBI, you'll have to read $DBI::errstr:
my $dbh = DBI->connect(dsn, login, password) or die $DBI::errstr;
On 04-Jul-01 Asha Ramaiah wrote:
> Hey! guys!
>
> I wanted a little help on the following : ..
>
> Scenario:
> I have 2 tables : one task and the other tasksequence
>
> desc task : (primary key taskId, varchar taskdesc)
> desc tasksequence (primary key (taskId,milestoneId))
>
> Now the que
90 matches
Mail list logo