Hi, I have database in MSSQL, and all the dates are DATETIME.
I would like to move it to MySQL, but using INT and UNIX timestamp.
Is there direct way to import/export or i have to write a script for it?
Thanx for any info :)
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus s
>Description:
mysql-test is set up with data in share, but mysqld expects data in
--datadir. So, mysql configured with --datadir=/usr/local/mysql/data
causes 'make test' to fail with
$make test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale
Make sure you have MySql running on the second machine!
mysqldump -h sourcehost -v -uroot --opt --compress sourcedb | mysql -h
targethost -uroot -C -w sourcedbCopy
More examples in the manual...
http://www.mysql.com/documentation/mysql/full/manual_toc.html#Upgrading-to-a
rch
http://www.mysql.com
Michael Widenius wrote:
> Hi!
>
> > "R" == R Talbot <[EMAIL PROTECTED]> writes:
>
>
>
> R> Below is My bug report...
> R> Mysql 3.23.40 is runjning after the compile but,
> R> after a compile with errors 3.23.42 or .43 won't run the
> R> server starts and fails so I guess we should conce
I don't have any experience with SQL, but I'm thinking that zero filling
both might work:
Although '5' <= '40' is false,
'0005' <= '0040'
is true.
But since you should be using some glue code to validate the field from the
web page anyway, can you just push the
On Mon, Oct 29, 2001 at 08:24:48AM -1000, Luis wrote:
> Why dont you use ssh to login to you sever .
SecureCRT is an SSH implementation for Windows.
[ It is useful for accessing SQL DATABASEs like MYSQL ]
--
Michael T. Babcock
http://www.fibrespeed.net/~mbabcock/
--
Hi all
i have a mysql database running on linux machine..i would like to have the
complete database to be transfered with all its properties and settings into
another linux machine..
how can i do that..
can anyone help me...
thanks in advance
Sai D Burra
___
On Mon, Oct 29, 2001 at 09:23:46AM -0500, [EMAIL PROTECTED] wrote:
> I am using SecureCRT to login to a remove MySQL server. I can get pass the
> initial login. However, a login screen displays on the screen asking for a
> second password. I have entered all information correctly, but the sy
Is there a better answer than making sure the mixed keys have enough leading
zeros in the numeric sub-field to suppress the string comparison effect?
ergo (if you know you will never have ten thousand records):
XY-0001-BLAH
XY-0002-BLAH
XY-0003-BLAH
XY-0004-BLAH
XY-0005-BLAH
XY-0006-BLAH
XY-0007
We have the same problem with MySQL (3.23.36) for SCO OpenServer, in script
mysql.server.
Here is the problem code, showing my workaround.
...
if test -z "$pid_file"
then
# pid_file=$datadir/`@HOSTNAME@`.pid
pid_file=$datadir/`hostname`.pid # changed @HOSTNAME@ to hostname
else
case "$pid_
Shomaail [SMTP:[EMAIL PROTECTED]] wrote:
> > I am using MySQL 3.23.22-beta
> > pls tell is there any way to define boolean variable in this db
> > what is the BOOL for ?
> > declaring a var BOOL make it TINYINT(1)! but not boolean
> >
> > thanks
> > Shomaai
--- Noel Clarkson <[EMAIL PROTECTED]> w
Hi Everyone,
After staring blankly at the mysql manual for a long time, I thought it
might be time to ask the list...
I have a table setup with a varchar(20) column, I am using this column to
store a price, the reason I chose varchar(20) is because the prices I am
dealing with are fairly lar
Michael Stassen I owe you my sanity!!!
THANK YOU THANK YOU THANK YOU!!!
(my wife is laughing at me for being such a dork)
I really appreciate your help thank you very much.
>From: Michael Stassen <[EMAIL PROTECTED]>
>To: Curtis Gordon <[EMAIL PROTECTED]>
>Subject: Re: persistant insert trouble
Hi there,
My understanding is that there is no BOOL type in MySQL but BOOL is allowed
in create table statements (or alter table etc) for compatibility with
other databases (but MySQL uses a tinyint for a bool because it doesn't
have bool).
You can use a tinyint and say that 0 is false 1 is t
I am using MySQL 3.23.22-beta
pls tell is there any way to define boolean variable in this db
what is the BOOL for ?
declaring a var BOOL make it TINYINT(1)! but not boolean
thanks
Shomaai
-
Before posting, please check:
ht
Hi All,
Ive been searching the archives and the documentation but dont really know
the terminology im looking for, or even if its do-able or not so I figure I
would just ask here instead..
I have a list of records in a table, and one of the fields is alpha
numeric. They look like this...
Hi.
Okay, my post was rejected because it was automatically suspected to be spam
for not explicitly including certain words. So I am tempted
to advertise a useless database engine, competitor to mySQL, with claims
that it supports trillions of queries a second and multi-petabyte
tables..
I just j
On Saturday 27 October 2001 10:10, shanmukha rao balla wrote:
> i had set proper classpath for jdbc drivers and my username ,
> password and database name,port no also correct. i am able to
> connect to mysql server using that username,password at COMMAND
> line. but while connecting to database
>Description:
Though not mentioned in the Change log, it appears that mysqlbinlog
was moved from sql/ to client/ sometime between 3.23.41 and 3.23.43.
As a result, make fails under HPUX 10.20 with
/bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -DHPUX -I/opt/dce/include
-felide-constructors -
Hi All!
> >Do any of the public web archives of the list suit your needs? Have
> >you seen them?
>
> It's fine for archived messages but too hard to find new messages, say
> within the last 7 days. Staying current with MySQL is a lot harder with the
> mailing list because you have to keep up wit
> It puts the messages in a tree and makes viewing pertinent threads
> a breeze,
My mail client puts messages in a tree and makes viewing pertinent threads a
breeze. And even with the archives:
http://marc.theaimsgroup.com/?t=10043869449&w=2&r=1
Doesn't look hard to me...
database,sql,quer
"INSERT INTO duser (username, upass, fname, lname, hphone, haddress, hcity,
hstate, hcountry, hemail, utype) VALUES
('$username','$upass'.'$fname','$lname','$hphone','$haddress','$hcity','$hstate','$hcountry','$hemail','$utype')"
this is an insert statement that works fine in the console, but n
I'am not english speak.
sorry~ ^^;;
[error]
# ./bin/safe_mysqld --user=mysql
Starting mysqld daemon with databases from /usr/local/mysql/data
011030 09:04:16 mysqld ended
#
---
>Description:
To make myself clear, I am talking about the binary update log file.
When specifing a fixed filename in my.cnf and running the flush-logs command
(via mysqladmin) MySQL does not close the file and open the new file when
run by a logrotate script. This does work correctly if no log f
indexes.
On Tue, 30 Oct 2001, Jason Parker wrote:
>
> - Original Message -
> From: Jason Parker
> To: [EMAIL PROTECTED]
> Sent: Tuesday, October 30, 2001 9:11 AM
> Subject: improve the speed of update, insert, delete and select queries
> through mySQL
>
>
> Anyone,
> Does anyone know
- Original Message -
From: Jason Parker
To: [EMAIL PROTECTED]
Sent: Tuesday, October 30, 2001 9:11 AM
Subject: improve the speed of update, insert, delete and select queries
through mySQL
Anyone,
Does anyone know ways to improve the speed of update, insert, delete and
select queries thr
On Mon, Oct 29, 2001 at 05:49:57PM -0500, C. Williams wrote:
>
> Does anyone know how to speed the performance of deletes on a large
> table? I have a large table w/ approx. 180,000,000 rows, with the
> following table structure:
[snip]
> It takes approximately 45 seconds to delete an hour's wor
Any way of getting a native error,sqlstate,error number list ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-
>Description: I'm running HPUX 10.20 on a 9000/782. I configured
according to section 2.6.6.2, HP-UX Version 10.20 Notes (see below).
make test warns that setrlimit fails, then fails the join test,
presumably because it requires more than 60 files. (Full output below)
It appears that getrlimit
In the next version of my mysqldeveloper site (which I hope to release
here pretty quick) it will support a feature to show you which messages
are new and which you've already read.
Hope this helps ;-)
BD wrote:
>
> PMFJI,
>
> >Do any of the public web archives of the list suit your needs?
PMFJI,
>Do any of the public web archives of the list suit your needs? Have
>you seen them?
It's fine for archived messages but too hard to find new messages, say
within the last 7 days. Staying current with MySQL is a lot harder with the
mailing list because you have to keep up with the mai
Or you could add path-to-unix-socket= somewhere else than /tmp
Sometimes your machine will delete things in the /tmp directory without you knowing.
I put it in /var/lib/mysql
(linux).
Ed Carp wrote:
> Riccardi Moreno ([EMAIL PROTECTED]) writes:
>
> > Hi all,
> > I've installed mysql 3.23.42 o
Hello All,
I'm fairly new to mySQL but not to SQL or databases in general.
I have recently installed mySQL on an NT box without much difficulty.
My question is about security. What are the steps to ensure our data and
client data is not accessible to the hacker public? I'm not a network
pe
Does anyone know how to speed the performance of deletes on a large
table? I have a large table w/ approx. 180,000,000 rows, with the
following table structure:
mysql> desc TABLEA;
|+--+---+--+-+--+---+|
Field | Type
Riccardi Moreno ([EMAIL PROTECTED]) writes:
> Hi all,
> I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i
> said me "can't connect to localhost /tmp/mysql.sock not found".
> How can i repair this error?
First, you can refrain from posting the same question twice.
Second,
Hi!
> "R" == R Talbot <[EMAIL PROTECTED]> writes:
R> Below is My bug report...
R> Mysql 3.23.40 is runjning after the compile but,
R> after a compile with errors 3.23.42 or .43 won't run the
R> server starts and fails so I guess we should concentrate on 3.23.40
R> gcc version egcs-2.
On Mon, Oct 29, 2001 at 01:22:55PM -0700, Matt Sellers wrote:
>
> The information in this email is great, but the volume of mysql
> emails mixed in with my other emails is forcing me to unsubscribe!
> (yes, I could filter, but that still fills up my email client.)
You think this list is busy? Tr
I have a couple java servlets and WebObjects applications that fetch
data from MySQL databases. I recently tried running them and received
the following error:
SQLException raised when connecting : java.sql.SQLException: Server
configuration denies access to data source
From a command line,
alexus wrote:
> Hello
>
> I have a very busy site (www site) w/ a lot of hits
>
> my site is very heavily integrated w/ mysql
>
> and when i do top it shows me like over 80% of cpu
>
> even though i have dual p3 850mhz w/ 1.5 gig of ram
>
> any ideas what to do about it so it'll drop down?
Have
I agree, the volume of email is too huge and it makes communication on
certain topics (like this one for example) cumbersome.
Steve
- Original Message -
From: Matt Sellers <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, October 29, 2001 3:22 PM
Subject: News
Hello
I have a very busy site (www site) w/ a lot of hits
my site is very heavily integrated w/ mysql
and when i do top it shows me like over 80% of cpu
even though i have dual p3 850mhz w/ 1.5 gig of ram
any ideas what to do about it so it'll drop down?
thank you in advance
The information in this email is great, but the volume of mysql emails
mixed in with my other emails is forcing me to unsubscribe! (yes, I could
filter, but that still fills up my email client.)
Could we have newsgroups instead? That would provide history, conversation
threads, etc. We could g
> You could also do ORDER BY RAND(), which I just discovered in the DuBois
> book when looking for the syntax of the RAND() function (which I haven't
> used before).
For a different take on retrieving random records, check out
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_21_0
/ Carsten
--
Carst
> Chris Bolt wrote:
>
> > Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
> > tables will give you "Duplicate entry" errors if you hit the maximum.
>
> I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests
> ISAM tables also returned a "Duplicate entry
> > Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
> > tables will give you "Duplicate entry" errors if you hit the maximum.
>
> I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests
> ISAM tables also returned a "Duplicate entry" error when I hit
> t
I had to replace "@HOSTNAME@" with "HOSTNAME" in the file
mysql.server on the line, pid_file=$datadir/HOSTNAME.pid. @HOSTNAME@ wasn't
a valid variable.
-Original Message-
From: Neil Aggarwal [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 10:29 AM
To: Mysql list
Subject
Heh, yeah that sounds rookie ;)
Have you ever done work in Perl? PHP is a lot like Perl in many aspects
(and nothing like it in many others). Heh.
Check out http://www.zend.com/ for some other tutorials, if you can find
'em. http://www.phpbuilder.com/ has some gooduns, too.
Mike
Todd William
Patrick Nelson wrote:
-
Having problems getting the server started. First mysql_install_db reported
that resolveip can't resolve my servers host name (of cowa) bla bla bla but
this means I only have to use ip addresses in my grant stuff. Fine but the
problem is that mysql_saf
Ive tried mailing:
mailto:mysql-unsubscribe-%4B%2E%48%61%75%67%68%74%6F%6E%3D%62%6C%75%65%79%6F
[EMAIL PROTECTED] x 8
[EMAIL PROTECTED] x 5
[EMAIL PROTECTED] x 3
the website
getting rather FUCKED OFF WITH TRYING.
-
Before pos
Hi all;
i have problem with mysql -3.23.42 installation on my freebsd 4.3-RELEASE,
when I execute a make
i get an error "make: no target to make".
Thanks and have a great day!
-
Before posting, please check:
http://www.my
Chris Bolt wrote:
> Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
> tables will give you "Duplicate entry" errors if you hit the maximum.
I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests
ISAM tables also returned a "Duplicate entry" error when
I have been using MySQL for approximately 6 months now on Solaris 2.6/2.7
and have never had a problem installing from source and compiling, but have
never been successful in installing a binary distribution.
In particular, after untarring the files using (GNUtar), after changing
permissions, etc
Hi!
> "Mike" == Mike Blazer <[EMAIL PROTECTED]> writes:
Mike> Miguel Angel SolÕrzano wrote:
>>
>> At 14:24 24/10/2001 +0400, Mike Blazer wrote:
>> Hi Mike,
>>
>> Thanks for the bug report.
>> The explanation why the insert command doesn't works on Win32,
>> is because the link file pointi
Hi!
> "Sebastian" == Sebastian Bergmann <[EMAIL PROTECTED]> writes:
Sebastian> Michael Widenius wrote:
>> The symbol 'mysql_module_entry' doesn't come from the MySQL library,
>> so this is a PHP problem.
Sebastian> Okay.
>> Note that you can use MySQL 4.0 with the old MySQL 3.23 library
Hi!
> "Deepanshu" == Deepanshu Shukla <[EMAIL PROTECTED]> writes:
Deepanshu> Hi!,
Deepanshu> I tried to install from mysql-3.23.43.tar.gz.
Deepanshu> i configured using ./configure
Deepanshu> --prefix=/usr/local/mysql
Deepanshu> --localstatedir=/usr/local/mysql/data
Deepanshu> and then m
Hello,
Just wanted to talk about the MySql Query Optimiser.
After having performance problems with some queries, I arrived to
thoses conclusions:
- The order of joins with constants and column have no effect on the
speed of the query
- MySql make all joins between tables before extracting the re
Hello:
I tried to set-up mysql 3.23.43 on my RedHat 7.1 server, following the
binary
installation instructions.
Here is what I did:
lynx
ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/mysql-3.23.43-p
c-linux-gnu-i686.tar.gz
tar zxvf mysql-3.23.43-pc-linux-gnu-i686.tar.gz
/usr/sbin/
On Mon, 29 Oct 2001 11:38:12 -0600, Eric Dean <[EMAIL PROTECTED]> wrote:
>>Hello,
>>
>>I've tried to use CREATE INDEX to create a fulltext index on an existing
>>table and received the message: "Can't create table
>>'./old/#sql-d55_ae7.frm' (errno: 140)". I tried dropping the table and
>>recre
Hello,
I've tried to use CREATE INDEX to create a fulltext index on an existing
table and received the message: "Can't create table
'./old/#sql-d55_ae7.frm' (errno: 140)". I tried dropping the table and
recreating it with the fulltext index in the new table description and got
this message: "Can
Luca Vertua
[EMAIL PROTECTED]
8volante srl soluzioni_internet
Via Cernaia 7
25034 - Orzinuovi - Bs
Tel.: 030/9444003
Fax: 02/700430453
www.8volante.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Luca Vertua" <[EMAIL PROTECTED]>
Sent: Monday, October 29, 2001 6:06 PM
Subject: Re:
Hello -
You may wish to try something a little bit more fundamental if you are new
to the Java thing.
one good way to learn how everything works in JSP is to use a free Java
Server, such as Tomcat, and build pages using Macromedia's ultradev
software. There is an extension that installs JDBC-ODBC
>> I'm not sure what the problem with this is? The first (unique) column is
>> independent of the second (random) column. If the random column has
>> duplicate values, it just means that the corrosponding first column
values
>> will be adjacent in the sorted table.
>If you're really depending o
Are you sure MySQL is listening on port 80? The default port is 3306:
jdbc:mysql://192.168.1.2:3306/
-Original Message-
From: Benj Arriola [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 10:56 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: JSP newbie n
>Description:
this is how i find the bug.
under the mysql console, i tried to drop a table, and i know that the mysql console
do the same thing like bash
some of the command ... and the command autocomplets. OK .. let me show
mysql> drop table categor;
categories categor
Try http://www.mysql.com/doc/A/c/Access_denied.html it explains further
what needs to be done.
M;)
> I have read the manual.
>
>
> I don't understand because when i type: SELECT VERSION(), CURRENT_DATE;
> it's OK, the server answer to me!!
>
> Fanck
>
> -Message d'origine-
> De : [EMAIL
COLLINEAU Franck FTRD/DMI/TAM writes:
> I have read the manual.
>
> I don't understand because when i type: SELECT VERSION(), CURRENT_DATE;
> it's OK, the server answer to me!!
> >
> > I have the error message:
> > ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
If yo
David Wolf wrote:
> Maybe I'm missing something here--I don't know
> of a way to create an index
> on TWO tables at once? Also, when I do:
My bad. You cant.
Since you are joining on the primary key, you want
to add an index like:
ALTER TABLE users ADD UNIQUE ( id, username(10));
Since you ar
I have a couple java servlets and WebObjects applications that fetch
data from MySQL databases. I recently tried running them and received
the following error:
> SQLException raised when connecting : java.sql.SQLException: Server
> configuration denies access to data source
Since the last tim
Maybe I'm missing something here--I don't know of a way to create an index
on TWO tables at once? Also, when I do:
EXPLAIN SELECT log.entity, log.action,
LEFT(users.username,10) AS username,
LEFT(boards.title,15) AS Board,
LEFT(topics.subject,22) as Subject,
log.postid, log.extraid,
LEF
- Original Message -
From: "jim barchuk" <[EMAIL PROTECTED]>
> With luck you got the book at a reputable dealer who'll allow you to
> exchange it for Paul Dubois _MySQL_ New Riders ISBN0-7357-0921-1. Please
> spend a few extra $ and save yourself many many hours of confusion and
> frustra
George Eric R Contr AFSPC/CVYZ writes:
> I'm not sure what the problem with this is? The first (unique) column is
> independent of the second (random) column. If the random column has
> duplicate values, it just means that the corrosponding first column values
> will be adjacent in the sorted
You need to setup your permisions in MySQL. Look in the MySQL reference
material on how to setup users and permisions.
M;)
> Hi!
>
> I have the mysql prompt.
> mysql>
>
> I type :
>
> mysql> CREATE DATABASE menagerie;
>
> I have the error message:
> ERROR 1044: Access denied for user: '@localho
David Wolf wrote:
>Not quite fixed.. When I run the query without limiting by time, it still
>fails to use the userid key. i.e. if I only select where
>users.username="testuser", I'd expect that users.username to return the
>users.id=2, and to search using the indexed log.userid=2
MySQL can onl
>I can see one problem with this, which is that in the case that you
>get two identical number in the second column their order will be
>strongly dependent on the values in the first column.
I'm not sure what the problem with this is? The first (unique) column is
independent of the second (rand
Hi!
I have the mysql prompt.
mysql>
I type :
mysql> CREATE DATABASE menagerie;
I have the error message:
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
??
Franck
-
Before posting, please check:
Hello,
I started developing a small application that uses
this great library (mysql) with its API (mysqlpp) and
wxWindows.
But, i couldn´t even compile the program because I
received some errors like this:
C:\SQLPP\INCLUDE\set3.hh(23) : error C2872: 'ostream'
: ambiguous symbol
C:\SQLPP\INCL
Hello Everyone,
I need to run MySQL using JSP.
I am a JSP newbie, actually a Java newbie too. I am more of a PHP/MySQL
guy.
I have successfully installed Allaire JRun 3.0 on Win98 using PWS.
JRun has an application management console and I cannot seem to run
MySQL.
I am totally unfamilia
I'd like to package MySQL, some databases, and PHP-enabled Apache on a
CD-ROM, with all
components runnable with, essentially, no installation in a Windows
environment. This would be
a read-only database accessed through a web browser by way of PHP scripts.
Is such a thing
possible?
Alternative
Hi, all,
About my earlier message about installation of mysql on Linux.
the "~/local/" directory is a local scratch space allocated by my lab.
And my problem is that no Makefile is created after the ./configure and thus I
cannot make.
Wei
-
Hi, all,
I am installing MySQL+Gemini 3.23.41 on Linux 6.2. I followed the instructions
such as "tar xvf", etc. Then I came to the :
"CFLAGS="-03" \
CXX=gcc CXXFLAGS="-03 -felide-constructors -fno-exceptions -fno-rtti" \
./configure --prefix=~/local/mysql\
--enable-assembler
[EMAIL PROTECTED] wrote:
> I am using SecureCRT to login to a remove MySQL server. I can get pass the
> initial login. However, a login screen displays on the screen asking for a
> second password. I have entered all information correctly, but the system is
> still requesting another password
When I run my startup script, I get the following message:
# /etc/rc2.d/S99mysql start
/etc/rc2.d/S99mysql: my_print_defaults: not found
# Starting mysqld daemon with databases from /usr/local/mysql/data
I've tried adding a command "print-defaults" to my.cnf, but that caused
the startup to termi
Hei
Could anybody explain me the different between a question and a
sql-request in mysql?.
F.example:
If I send a sql-request to mysql:
select * from Table where column_A=1 and column_B=2 order by column_C;
num.sql_request = 1 and num.questions = 1
Is this true? Can I send 1 sql_request that
I am using SecureCRT to login to a remove MySQL server. I can get pass the
initial login. However, a login screen displays on the screen asking for a
second password. I have entered all information correctly, but the system is
still requesting another password.
Verlin Taylor
-
Hi
Just type: mysql -u root
Regards
> -Oryginalna wiadomoæ-
> Od: COLLINEAU Franck FTRD/DMI/TAM
> [mailto:[EMAIL PROTECTED]]
> Wys³ano: 29 padziernika 2001 15:05
> Do: '[EMAIL PROTECTED]'
> Temat: MySQL privileges
>
>
> Hi!
>
> I'm working on a Linux Mandrake 8.1 station.
> I have ins
Hi!
I'm working on a Linux Mandrake 8.1 station.
I have installed MySQL. I have typed './mysql_install_db'
When i type mysql, i have the prompt mysql>
But when i type "create database phpdig" i have the error message: "ERROR
1044: Access denied for user:
'@localhost' to database 'phpdig'."
Can a
On Mon, 29 Oct 2001, Jindo Soul wrote:
> Why this error exists is beyond my knowledge though.
> I am guessing that Perl DBI escapes ' \ in bind_param call.
> And MySQL escapes the data again when using big5 charset,
> which ultimate causes an error because of double escaping.
Well, its not that
Ed Carp writes:
> >Description:
>
> make[3]: Entering directory `/usr/local/src/mysql-4.0.0-alpha/sql'
> gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local\"" -
> DDATADIR="\"/usr/local/var\"" -DSHAREDIR="\"/usr/local/share/mysql
> \""
Thanks to the help of Sasha Pachev and Robin Keech,
the problem has been resolved.
The solution came in three stages:
1) "Downgrading" glibc and glibc-devel to non-RedHat
2.2.4-5 RPMs
2) Ditto for gcc - down to v. 2.95.3
3) And an error on my own: removing some extraneous
mysql_free_result
> Hi!
>
> On Oct 28, Kevin Maynard wrote:
> > I have been building an extensive dB with MySQL for a large Insurance
> > Company and am nearing the completion stage. I have build several PHP
> > forms to show the preliminary pages to the various groups who will be
> > using this dB.
> >
> > I have
Hi Sommai!
On Mon, 29 Oct 2001, Sommai Fongnamthip wrote:
> Did you mean V4 must ran with innodb? Oh! I have bad experience with
> innodb. It ate a lot my hard disk space.
Oh no! Absolutely not required!
I think V4 defaults to --with-innodb because './configure --help |grep -i
inno' returns
Hi!
> "Mike" == Mike Blazer <[EMAIL PROTECTED]> writes:
Mike> Well, I'm sure there are some better ways too - it's a pity that it such
Mike> a useful feature fails on Win32.
>> I have now changed MySQL 4.0.1 to ignore any DATA DIRECTORY
>> directives, until we have come up with an accepta
> Hello mysql
> I have been give the database files for a mysql database that I can not
> get to
> open and display records.
> I have run myisamchk, isamchk, mysqlcheck, mysqldump and all return the
> "header does not support check/repair" or
> Now I am using mysql 3.23 on win32 to view this
David Wolf writes:
> I've been trying to play with MySQLGUI lately (running the win32 version of
> the GUI, Linux version of the server). I can connect fine. Run queries fine.
> But, when I try to do any grants on a database or edit a table, the client
> connects to the server as many times as it
Thank you for your report.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
I have the same question but i want to store binaries in the database, but not sure
how to go about it
cheers Dave
Siim Einfeldt aka Itpunk wrote:
> I know you most likely want to add the full source of teh pics to
> database, but this is nt a good idea. The best way would be to just write
> th
Hi all,
Not sure if this is the right place to ask this one but here goes!
I'm trying to export an Access 2000 database to MySQL and remain using
Access as the front end. Everything seems to be working fine, except for
this one line of code which is giving me and ODBC call failed error.
Current
Hi,
Getting non-empty results when comparing something with NULL seems very odd
to me too. Even if it is undefined, id expect to see an error message
telling me i shouldnt compare an undefined variable rather than receiving
results.
Why not ask someone to change things so that "WHERE xx=NULL" g
Hi,
When I run my application I get
java.sql.SQLException: General error: Can't lock file (errno: -1)
at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
Hi,
I have mysql - bin -log, but when i read this I can't find IP number
from client who made connection to my server. How i find IP number in
mysql - bin -log ?
thanks
-
Before posting, please check:
http://www.mysql.com
1 - 100 of 105 matches
Mail list logo
