Besides using Phpmyadmin to edit the data. I actually prefer to use
something like webmin to manage my data.
Do a search on Webmin on the internet.
- Original Message -
From: "Aqua" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 25, 2002 12:42 PM
Subject: How to access
Hi,
My mysql error file (hostname.err) had grown to 11G on Red Hat 7.0, kernel
2.4.3, file system type ext2. As I understand it, file size in Terrabytes
can be supported under this kernel version, however, mysql semi-crashed at
this point, meaning I could not connect to it remotely (I could connec
Yes, MERGE Tables is useful for getting around the file size limit problem.
However, Linux 7.2(Kernel 2.4.x), MySql 3.23.47 supports file sizes greater
than 4GB. Mysql 3.23 by defaul will create tables that can grow only upto 4G
but these can be altered using ALTER TABLE. You willl need to alter
A
Yes it does.
http://www.mysql.com/doc/R/e/Replication_Implementation.html
- Original Message -
From: "Alice" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 6:52 PM
Subject: Is mySQL support replication ??
> Hi, all,
>
> May i know is mySQL support replication ???
At 18:36 -0700 6/24/02, Emma Grant wrote:
>Hi All,
>
>First of all I want to thank you all for all the help that
>you have given me throughout the last week.
>
>I have learnt a great deal, and through your help and the
>resources on the interenet I have successfully been able to cr
At 9:42 +0700 6/25/02, Aqua wrote:
>Hi guys! Does anyone know how to access mysqladmin from Internet Explorer so
>I can view and edit my data.
>Please help, thanks.
That's a strange request, given that mysqladmin neither displays table
data nor allows it to be edited.
What do you mean?
>
>Aqua
If you installed correctly and it's running then you likely forgot to
add the '/' at the end of the phpmyadmin part i.e.
youriphere/phpmyadmin/ not yourip or localhost/phpmyadmin.
justin
-Original Message-
From: Aqua [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 7:42 PM
To: [
Hi guys! Does anyone know how to access mysqladmin from Internet Explorer so
I can view and edit my data.
Please help, thanks.
Aqua
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
Hi, all:
I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When "LOAD
DATA INFILE" to a table whose file size is 4G, it fails and mysql_error(...)
reports "Lost connection to MySQL server during query". How can I clearly
know the failed reason is just hit the 4G file size limit?
If
Hi, all,
May i know is mySQL support replication
regards,
alice
/---\
Confidential and/ or privileged information may be contained in this
e-mail and any attachments transmitted with it ('Message'). If you a
Hi All,
First of all I want to thank you all for all the help that you have given me
throughout the last week.
I have learnt a great deal, and through your help and the resources on the
interenet I have successfully been able to create and connect to a database through
Taylor ...
Check out ...
http://hotwired.lycos.com/webmonkey/databases/tutorials/tutorial4.html
... or ...
http://vtwebwizard.com/tutorials/mysql/
- Original Message -
From: "Taylor Lewick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 1:16 PM
Subject: mysql
Mark:
Do you have my.ini (or my.cfg) set to ignore case in table names?
set-variable = lower_case_table_names=1
Gerald Jensen
- Original Message -
From: "Mark Weiler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 5:56 PM
Subject: Case Sensitivity for CHECK
Check this out:
http://www.mysql.com/doc/m/y/mysqldump.html
According to the above page, -T option creates a table_name.txt file for
each given table, with its CREATE TABLE syntax and the data for its content
in the file
Gurhan
- Original Message -
From: "Rachael LaPorte Taylor (SS
After much testing, I have managed to overcome the limits on file descriptors and such
on linux; and have a mysql daemon that is fairly lean and able to support several
thousand simultaneous connections.
I still, though, would like to see what kind of improvment gcc-3.0.4 makes as opposed
to 2
Mac OS X
mysql 3.23.47
I have a database with a table named: tname.
After several inserts, I run
CHECK TABLE tname;
No errors are reported.
I then run
CHECK TABLE TNAME;
And errors are reported!
Which is it? Errors or no errors?
Thanks
Mark
-
* Cindy
> OK, I determined that at least part of the problem was that I ran out
> of space in /var/tmp, so I reset TMPDIR to a directory that's 40G in
> size an am trying again. But I'd still be very interested in any
> comments on the below select statement given the size of everything
> involve
At 04:06 PM 6/24/2002, you wrote:
>I want to copy the structure of a table to a brand new table, but I
>don't want to use phpmyadmin or some other program. I'm looking for the
>command line code.
>
>Anyone have a link to where I can find it? Or, anyone wanna send me
>the code?
>
>Thanks!!
>
>mys
I used the mysql builds myself. Funny thing is that I use your tool
'mytop', which is very cool by the way, to watch things and it pauses
for about 5-8 seconds when refreshing with .51 and is almost instant
with .47
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
> -Original Message
OK, I determined that at least part of the problem was that I ran out
of space in /var/tmp, so I reset TMPDIR to a directory that's 40G in
size an am trying again. But I'd still be very interested in any
comments on the below select statement given the size of everything
involved (eg, an 1800M f
Other than all previous comments, you can also do ,
SHOW CREATE TABLE tablename;
and then copy+paste it with a different tablename.
Gurhan
- Original Message -
From: "Phil Schwarzmann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 5:06 PM
Subject: copying the st
* [EMAIL PROTECTED]
[...]
> The referred to keys are the same type and are indexed (they are
[...]
> CREATE TABLE genres (
> genre_idSMALLINT NOT NULL PRIMARY KEY,
[...]
> genre_idSMALLINT,
...does not look the same to me... ;)
--
Roger
sql
>From pg 149 of the New Riders Press book
"MySQL" by Paul DuBois (ISBN 0-7357-0921-1):
CREATE TABLE new_tbl_name SELECT * FROM tbl_name WHERE 1=0
--
Mark P. Hennessy [EMAIL PROTECTED]
On Mon, 24 Jun 2002, Phil Schwarzmann wrote:
> Date: Mon, 24 Jun
Hello.
On Mon 2002-06-24 at 17:06:19 -0400, [EMAIL PROTECTED] wrote:
> I want to copy the structure of a table to a brand new table, but I
> don't want to use phpmyadmin or some other program. I'm looking for the
> command line code.
>
> Anyone have a link to where I can find it? Or, anyone w
mysqldump -d database table > existingTable.sql
Then edit existingTable.sql, change the name of the table, save it as
newTable.sql
mysql database < newTable.sql
You could do :
mysqldump -d database table | sed | mysql
database
but I'm not an expert on regex. :)
=C+
-Original Message--
Victoria Reznichenko wrote:
>
> Brandon,
> Saturday, June 22, 2002, 9:00:49 PM, you wrote:
>
> BM> Is there any particular reason that anyone knows of that would prevent
> BM> mysql 3.23.51 for windows from working upon the execution of the SHOW
> BM> STATUS FROM tablename query?
>
> BM> In L
I want to copy the structure of a table to a brand new table, but I
don't want to use phpmyadmin or some other program. I'm looking for the
command line code.
Anyone have a link to where I can find it? Or, anyone wanna send me
the code?
Thanks!!
mysql
-
If I remember correctly from the manual, you can dump
your data generating the SQL statements (this is what
you are doing) and your file will have a bunch of
INSERTS. Your problem is that those inserts will have
something like SET YourBinaryField =
'a-bunch-of-characters'. The problem is that some
Some database providers implementation always return
-1 no matter the amount of records is returned. That
happens to ADO too for certain cursors. The best way
to go to count records is Count(*), prepare a query
like Select count(MyField) from MyTable Where ... and
then get the value.
I hope it he
Hi!
I just ran the standard
perl run-all-tests --small-test --small-tables --create-options=type=innodb
on 3.23.49a and an in-house prerelease of 3.23.51, on Linux 2.4.16. The
times were essentially the same.
3.23.50 and .51 are almost identical in source code. But as we remember,
3.23.51 was
The one at www.php.net
-Original Message-
From: Taylor Lewick [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 1:50 PM
To: [EMAIL PROTECTED]
Subject: Re: mysql php question
gotcha, thanks, which manual is that?
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Bert,
- Original Message -
From: "Bert VdB" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, June 24, 2002 11:09 AM
Subject: RE: Re-do logging feature with InnoDB: is it possible ?
> Hello everybody,
>
> I have a small question regarding to the Mysql-InnoDB-tables :
On Mon, Jun 24, 2002 at 12:43:47PM -0700, Jeremy Zawodny wrote:
> > I will second this.
> >
> > I attempted an upgrade from 3.23.50 to 3.23.51 and hit immediate
> > performance problems. I tried for about 20 minutes to see what was
> > causing it but to no avail. I reverted to 3.23.50.
> >
> > A
On Mon, Jun 24, 2002 at 03:11:53PM -0400, Michael Bacarella wrote:
> I will second this.
>
> I attempted an upgrade from 3.23.50 to 3.23.51 and hit immediate
> performance problems. I tried for about 20 minutes to see what was
> causing it but to no avail. I reverted to 3.23.50.
>
> At first I t
D. H. Craig, CSM
__
This is the first public release for "my_gui".
my_gui.py is a simple Grafic User Interface for MySql.
It can be used as a Python module to create your own MySQL interface.
Sorry, no documentation yet
download it at http://www.prosa.it/projects/projects
I will second this.
I attempted an upgrade from 3.23.50 to 3.23.51 and hit immediate
performance problems. I tried for about 20 minutes to see what was
causing it but to no avail. I reverted to 3.23.50.
At first I thought it was my fault so I decided not to report it
until I did some further res
This is the first public release for "my_gui".
my_gui.py is a simple Grafic User Interface for MySql.
It can be used as a Python module to create your own MySQL interface.
Sorry, no documentation yet
download it at http://www.prosa.it/projects/projects
MAS
I tried the skip-name-resolve and it had no effect. So there goes my
hypothesis.
Here are the results from test:
Benchmark DBD suite: 2.14
Date of test:2002-06-24 11:19:19
Running tests on:Linux 2.4.16-0.13smp i686
Arguments:
Comments:
Limits from:
Server version: MySQL 3.23.51
Hi folks,
Currently I'm using mysqldump with the --opt option to backup
databases. I recently discovered the -T option to output to delimited
files. Aside from only being able to run mysqldump on the same machine
as the mysql daemon, are there any other disadvantages or advantages
of using the -T
I tried 'skip-name-resolve' but it had no impact. :( So it may have
nothing to do with name resolution.
Here are the results in file RUN-mysql-Linux_2.4.16_0.13smp_i686:
I'm going to run the tests on .47 next to see if there is any
difference.
Sincerely,
Steven Roussey
http://Network54.com/?p
gotcha, thanks, which manual is that?
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
"Help Wanted. Seeking Telepath..."
"You Know where to apply."
>>> [EMAIL PROTECTED] 06/24/02 01:39PM >>>
in the php manual in the section of functions about mysql, it has a few
examples.
Not really a simplistic one, but simple to set-up and use:
http://phpnuke.org
Very nice dynamic php/mysql based web site you can download and install.
Larry Irwin
CCA Medical
- Original Message -
From: "Taylor Lewick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002
Does anyone have some simple sample code using php to access a mySQL database?
Could you post it or send someit to me please?
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
"Help Wanted. Seeking Telepath..."
"You Know where to apply."
[snip]
So if the end result is to have the records selected appended to the
Customer_Equipment table, I have to make a temporary table based on the
characteristics of the Customer_Equipment table... then insert from that
temporary table. Correct?
[/snip]
BINGO! Goofy rules can be frustrating
Greetings Jay:
RE: mySQL query help please
I love rules that don't make sense ;-)
So if the end result is to have the records selected appended to the
Customer_Equipment table, I have to make a temporary table based on the
characteristics of the Customer_Equipment table... then insert from t
>Description:
In CREATE TABLE, column-spec REFERENCES does nothing, as described
in the documentation.
If FOREIGN KEY (x) REFERENCES othertable(y) is added to the table, as
described in the documentation:
http://www.mysql.com/doc/S/E/SEC446.html
I always get an error like this:
ERROR 1005 at l
[snip]
INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID,
Configuration, Equipment_Type, Group_ID, Location, Rack_Location,
Network_Status_Name, Creator_ID, Primary_IP_Address FROM
Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) =
Customer.User_ID;
The select statement wor
Greetings:
RE: mySQL query help please
INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID,
Configuration, Equipment_Type, Group_ID, Location, Rack_Location,
Network_Status_Name, Creator_ID, Primary_IP_Address FROM
Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) =
Cust
Hi,
I came across this problem:
where the manual describes Fulltext Fine-tuning it says:
* Minimal length of word to be indexed is defined by MySQL variable
`ft_min_word_length'. *Note SHOW VARIABLES::. Change it to the
value you prefer, and rebuild your `FULLTEXT' indexes.
This
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and
> tried 51. No dice. It does not handle load, CPU and the load average go
> through the roof. I'm using Red Hat Linux 7.2 and the official mysql
> binaries. It appears to be slo
Dear Monty,
At the beginning, I missed doing the step of setting default
character-set.
After I have done what you said about setting default character set,
the correct chinese characters are stored in mysql database.
Thank you very much!
Best regards,
Henry.
>From: Michael Wideniu
you don't. Check the manual. Nested queries are not yet supported. (4.1?)
=C=
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 20, 2002 1:53 AM
To: [EMAIL PROTECTED]
Subject: Netsde Query
Hello everybody!
I am using mysql-4.0.1-alpha on windo
Hi there!
I'm using MySQL with Delphi 5.
After running a query i get a recordcount of -1. But when I check the result there are
records.
Can anybody help me?
Thanks,
peter
__
FreeMail in der Premiumversion! Mit mehr
Hello everybody!
I am using mysql-4.0.1-alpha on windows 2000 professional
How to exceute nested query in MySql
select aeVcharEventId from alarmescalation where aeDtimeTimeStamp = (select
max(aeDtimeTimeStamp) from alarmescalation)
This query gives an error
you have an in your Sql syntax near
Hi,
There are a new MySQL Database Manager.
Try this site: http://geocities.yahoo.com.br/burbello/
doesn't need to install, just download and execute.
Regards
Alexander
___
Copa 2002
Yahoo! - Patrocinador oficial da Cop
Your string contains special characters, and must be properly escaped
before storing.
Use the appropriate string escaping function in your language ( if it
exists ) or
write a routine to escape them for you before storing them.
The manual lists the special characters.
henry lee wrote:
> Dear
Hi guys,
I want to migrate data from SQL Server 2000 to Mysql.I have two
problems. First is easy one,
First problem is to migrate big fields which had type varchar(7900) or
so I tried using Text datatype of mysql, is that the right one or I
should have used BLOB. That field doesnt contain any i
Jeremy Zawodny writes:
> On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote:
>
> As another data point for you, I've got 3.23.51 running on our master
> quite well. The difference is that I built it from source (to get a
> critical InnoDB patch). I don't recall which compiler the My
I know version 4.0.1 does.
I use Delphi 6 to write my UDF's for it.
mike
-Original Message-
From: Inandjo Taurel [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 23, 2002 9:20 PM
To: [EMAIL PROTECTED]
Subject: UDF on win2k??
hi,
i checked the manual, but i want a confirmation here: Mys
I am comparing songnames from two tables to find a match.
My query looks like this:
$querymvideo = "select movietable.id, movietable.songname
from movietable where TRIM(movietable.songname) LIKE
'__$foo' ";
The above query works fine except when a songname has the
single quote symbol: "'" or may
Hi!
> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote:
>> Hi all,
>>
>> I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and
>> tried 51. No dice. It does not handle load, CPU and the load avera
You need libtermcap. (libtermcap-2.0.8-28.i386.rpm)
You are running a Redhat 7.2 box, use binary distribution instead of source
package if you're not familiar with building programs.
Regards,
Sébastien
>
>
> please tell what mean the follow:
> [root@guanqun zsj]# cd /usr/local/src
> [root@guanq
I think the problem is that the mysql package is still tarred. You need to
tar -xvf mysqlx.tar
This will extract the archive into a new folder, and from within that
folder you should run the commands as listed in your original mail
(./configure .)
So in short, the commands you are tr
Florin,
You may put something like
# wait until mysql is ready
counter=0
while ! mysqladmin \
-h localhost -u user -pPassword ping >/dev/null 2>&1
do
counter=$((counter+1))
if [ $(($counter)) -gt $((200)) ]
then
echo "mysqld start
Hi Frank,
Thanks, but it is fine if the year is same. If years are different then
result may comes in -ve value.
D K Dubey
-Original Message-
From: Frank Gates [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 5:09 PM
To: D.K.Dubey
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject:
* Simon Green
> After running this simple question I get this error. I have looked at the
> my.cnf file and all looks fine and the system has 1.256 G of memory.
> Can some one please tell me where I have gone wrong.
>
> select in_names.Username
> from in_names, in_names2
> where in_names.Userna
Thanks for this...
So I think I need some joins!
Simon
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: 24 June 2002 12:19
To: Mysql (E-mail)
Cc: Simon Green
Subject: Re: Out of memory on simple question.
* Simon Green
> After running this simple question I ge
Use the month(date) function.
select month(firstDate) - month(secondDate) from someTable where ...;
Hope this helps.
Frank
"D.K.Dubey" wrote:
> Hi, Can anybody tell me how i can calculate the months between two dates in
> mysql.
> thanks in advance
> Regards
> D K Dubey
>
> --
Hi!
> "Georg" == Georg Richter <[EMAIL PROTECTED]> writes:
Georg> On Friday, 21. June 2002 15:43, Stefano Incontri wrote:
Georg> Hi,
>>
>> I found the following problem, which I consider a bug, but maybe I'm
>> missing something to make it work correctly.
Georg> This is not a bug. Why do
Hi,
checking for working aclocal... missing
checking for working autoconf... missing
checking for working automake... missing
checking for working autoheader... missing
checking for working makeinfo... missing
You need to install automake and autoconf before trying to compile MySQL.
(texinfo is
Just for those people who have the same problem:
-Original Message-
From: Mark Williams (MWP) [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 11:13
To: Bert VdB
Subject: Re: Binary data mysqldump and restore.
That did it thanks!
MWP
> Hi,
>
> Have you tried making a dump with
please tell what mean the follow:
[root@guanqun zsj]# cd /usr/local/src
[root@guanqun src]# cd mysql-3.23.44.tar/
[root@guanqun mysql-3.23.44.tar]# ./configure --prefix=/usr/local/mysql
bash: ./configure: No such file or directory
[root@guanqun mysql-3.23.44.tar]# ls
mysql-3.23.44 mysql-3
you can download your binary for installation
if there is supported hardware and OS made binary for you
http://www.mysql.com/downloads/mysql-3.23.html
- Original Message -
±H¥óªÌ: "ÕÅÉƽð" <[EMAIL PROTECTED]>
¦¬¥óªÌ: <[EMAIL PROTECTED]>
¶Ç°e¤é´Á: 2002¦~6¤ë24¤é PM 04:06
¥D¦®: I know
>
I'm trying to start mysql -I have installed the db.
t> Now I'm getting the following:
t> [localhost:~] lloyd% sudo safe_mysqld --user=root &
t> [1] 630
t> [localhost:~] lloyd% Starting mysqld daemon with databases from
t> /usr/local/mysql/data
t> 020623 20:25:20 mysqld ended
mysqld didn't star
Ruben,
Sunday, June 23, 2002, 10:51:59 AM, you wrote:
RIS> Of course it's running. I can only get in as the root user
RIS> of the system
Check where your mysql.sock is located and check permissions on the socket file.
RIS> On 2002.06.23 03:51 Brandon McCombs wrote:
>>
>>
>> Ruben I Safir wro
Brandon,
Saturday, June 22, 2002, 9:00:49 PM, you wrote:
BM> Is there any particular reason that anyone knows of that would prevent
BM> mysql 3.23.51 for windows from working upon the execution of the SHOW
BM> STATUS FROM tablename query?
BM> In Linux it works fine, in windows it crashes mysqld
toby,
Monday, June 24, 2002, 10:06:57 AM, you wrote:
t> i cant create tables, the tables which had NO foreign keys or they didmt
t> refer to another table were created fine
t> but the ones WITH foreign key ... refferring to fieldz in other table(s)
t> cant be created
t> mysql>create table lang
Hytham,
Saturday, June 22, 2002, 12:37:21 AM, you wrote:
>> > i have a column of type blob, that i wish to store images in it, but
>> how
>> > can i right the sql statement to insert the image?
>> > i mean :
>> > insert into tblImages set imageField = ??? where id=999
It's not a correct stat
plz give me the oringal software about mysql.when i make it will not successful.i have
sent the wrong message twice to u.
__
===
ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn)
ÐÂÀË·ÖÀàÐÅÏ¢£º¶þÊÖÊг¡
thnx van ... its workin now
it was no bug ... no mysql problem no explorer problem
my mistake
i changed the fontdisplay in my t.htm file from unicode to user defined
n its workin fine now
thnx
n im terrabbly sorry all of u
a bit better now ...
toby ...
Hi, all:
I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When "LOAD
DATA INFILE" to a table whose file size is 4G, it fails and mysql_error(...)
reports "Lost connection to MySQL server during query". How can I clearly
know the failed reason is just hit the 4G file size limit?
If
On Friday, 21. June 2002 15:43, Stefano Incontri wrote:
Hi,
>
> I found the following problem, which I consider a bug, but maybe I'm
> missing something to make it work correctly.
This is not a bug. Why do you use a reserved word (LOAD) for an index name?!
Rename it and everything should be ok.
Hi
After running this simple question I get this error. I have looked at the
my.cnf file and all looks fine and the system has 1.256 G of memory.
Can some one please tell me where I have gone wrong.
select in_names.Username
from in_names, in_names2
where in_names.Username != in_names2.Username
What about using the skip-name-resolve option rather than skip-grant-tables?
I'm using the 3.23.51 binaries, also, and would appreciate knowing if this
makes a difference. Debian potato 2.95.2 is a known good compiler, too,
isn't it Jeremy? I may have to recompile my own anyway to change
ft_min_wo
Hi all...
!! First, can you CC to [EMAIL PROTECTED], as im not on the mailing list.
I have a few tables which are storing a few MB of binary data (like jpegs).
I can dump the db fine using mysqldump, but on doing a "mysql ... < dumpfile" i get
many errors, as it seems mysql isnt accepting the b
I try it over !the question is that i couldn't configure and make the "mysql",so i
can't install and run it .i don't know why .i try it as book!please give me the
oringal software!
__
===
ÐÂÀËÃ
Hi,
Which is the best solution ? I use MySQL (exclusively with large InnoDB
tables - 150 to 200 tables, 3 or 4 of them with 200 000 lines per day,
approx. 40 to 80 Go of datas). I must switch my system to UNIX. So, what is
the best solution, HP-UX or Solaris ?
Thank's
--
### CHANGES ###
--- version 16.3 ---
- thresholds messages are now displayed in the trace module window and
tables by default
- in preferences, added thresholds trace page so that the user can
choose whether thresholds messages are displayed in the trace
module window and tables
- in displa
Toby:
Beyond off-topic, but try Netscape...
If that isn't the cause; check that the web server has been patched for the
chunk-encoding vulnerability that existed on Apache before 1.3.26, which was
released last week.
Otherwise: try and give some more useful details.
Van
--
Hello everybody,
I have a small question regarding to the Mysql-InnoDB-tables :
"Is it possible to use an Oracle-like 're-do logging' feature with InnoDB" ?
This means more or less taking regular consistent backups of your database,
and then in case of corruption, you restore the latest consis
Dear professional people,
When I write a program to store the (Big5) Chinese characters ¯S³\¸gÀç
into mysql database through the mysql ODBC driver,
the original chinese characters change into another characters ¯S³¸gÀç
in mysql database.
On the other hand, I have tried the program to store
That'll only work if the months are in the same year. Here's a more
general one:
SELECT PERIOD_DIFF( EXTRACT( YEAR_MONTH FROM date1 ),
EXTRACT( YEAR_MONTH FROM date2 ) );
Dean Harding.
-Original Message-
From: Dogaru Dragos [mailto:[EMAIL PROTECTED]]
Sent: Monday,
Really?
MONTH(date)
Returns the month for date, in the range 1 to 12:
mysql> SELECT MONTH('1998-02-03');
-> 2
There're other functions that will also be useful tools for you to achieve what
I can only guess is your goal. I can think of 10 ways off-hand to solve your
Hi,
I have 2 version installed on my win2k machinge (.49 , .50 and .51)
As long as you install in different directories , take care of config files
and
don't try to start 2 server simultaniously, I don't see why this should give
problems.
(At least, I haven't got any problems ;) )
CB.
-Orig
guyz
all is down now
i cant even get my explorer to display the unicode it was displaying till
yesterday
now its giving me ALL BOXES for the unicode im trying to store
till yesterday it gave me boxes only for a few characters but the rest were
FINE ! ! ! !
has this somethin to do with my
select month(current_date)-month(fild_name) from database where
your_critteria
This should show you the months between the current date and the date
contained in the fild_name
- Original Message -
From: "D.K.Dubey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "[EMAIL PROTECTED]" <[EMA
Hi Van,
I read that before sending u the query. In that no where is mention to
subtract the dates and finding the no months between dates.
D K Dubey
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Van
Sent: Monday, June 24, 2002 11:43 AM
To: D.K.Dubey
C
97 matches
Mail list logo
