Hi Daniel,
Yes, query_cache_type is 1 by default if you don't set it. :-) It's not
used by default, however, because query_cache_size is 0. You need to set
query_cache_size to 16M, 32M, etc.
Hope that helps.
Matt
- Original Message -
From: "Daniel Kasak"
Sent: Thursday, September 25,
Does anybody have any idea why this program won't compile, it seems to
be straightforward, but it I can't get it to compile on Redhat-7.3.
It starts screaming about mysql.h immediately, I use this link to
compile with, on my machine at the house, it compiles just fine and runs
just fine, but I can
Roman,
- Original Message -
From: "Roman Neuhauser" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, September 24, 2003 11:46 PM
Subject: Re: innodb: storage requirements
> # [EMAIL PROTECTED] / 2003-09-24 17:41:29 +0300:
> > the row co
When i exported the data, i found an option on the lower part of the sql
code.
> ) TYPE=MyISAM AUTO_INCREMENT=0 ;
I tried to make a table again, and when i entered it resets to whatever
options i last type it on the "AUTO_INCREMENT=0" value.
I still didnt see how to reset it manually, when its l
Hi all.
I've set an option in the my.cnf file ( for a 4.0.14 server ):
[mysqld]
query_cache_type = 1
and restarted the server.
The query cache is supposed to be available. "SHOW VARIABLES LIKE
'have_query_cache'" returns 'YES' as described in the documentation. But
all the qcache_* status in
hi
Could you please tell me what is the command to install the mysql 4.1
alpha with the default character sets arabic (cp1256) on windows .
thanks alot
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, 24 Sep 2003, Misaochankun wrote:
> Error(using 2.5G RAM out of 4G total):
>
> 030924 15:39:55 mysqld started
> Warning: Ignoring user change to 'mysql' because the user was set to
> 'mysql' earlier on the command line
> InnoDB: Fatal error: cannot allocate 2684370944 bytes of
> InnoDB: me
Robert,
ADO seems to prefer blobs to be at the end of the select. Try the following
to see if it works:
Select Picture, Questions, Answers FROM FAQ ORDER by OrderID
Dennis
-Original Message-
From: Helpdesk3 ( Mid North Coast Internet )
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, Septe
Hi,
I installed mysql-4.0.15 in Windows 2000 Advanced server. Mysql-max-nt is
working fine, except some problems.
Sometimes when I try to use access web pages through php pages, mysql says
"Connection to server lost" or
"Can't connect to mysql server" or sometimes query error. Query is tested
a
Hi,
Check the behaviour of auto_increment in the change logs - it changed
from using the highest available number to carrying on from where it
left off some time ago, but I believe there is a was to reset it
manually.
Hope this helps.
Quentin Bennett
Senior Analyst
Infinity Solutions Ltd
PO Box
I have a id_entry field that is doing auto increment on that field.
Now, when i try to delete the numbers it still continues to count
from where it left.
ex: i have entrys
1|one
2|two
once i deleted 1|one on the field or even 2|two
it still counts to 3|three and so on
And is it also possible t
*** Is everyone else getting ~50% virus e-mails on the list?? :-( ***
Hi Kevin,
Don't know what's causing the hang-up on those queries, as they seem
like they should be fast as you said (unless it's some mod_perl/DBI
interaction -- no idea). :-/ Just responding to 2 other things...
- Origin
Hi,
Compaq Tru64 UNIX V5.1 (Rev. 732)
so possibly not the same issue!
Thanks
Quentin Bennett
Senior Analyst
Infinity Solutions Ltd
PO Box 3323, Auckland
Ph: 09 921 8146
Fx: 09 309 4142
www.infinitytransport.net
> -Original Message-
> From: Terence [mailto:[EMAIL PROTECTED]
> Sent: T
We had the same problem when running on linux with the 2.4.18 kernel.
Upgraded to the 2.4.20 and no problems since.
Don't know if that's your problem, since you didnt mention kernel versions.
Cheers
Terence
- Original Message -
From: "Quentin Bennett" <[EMAIL PROTECTED]>
To: <[EMAIL PRO
Will this help anyone?
Set objRS = CreateObject("ADODB.RecordSet")
=>objRS.Open "SELECT Questions, Answers, Picture FROM FAQ ORDER BY
OrderID", Provider=MySQLProv;Data Source=DSN=database, 2
objRS.Close
Set objRS = Nothing
The Questions and Answers columns are the text/blobs. Picture is
On Wed, Sep 24, 2003 at 03:45:22PM -0700, Misaochankun wrote:
> OS: RedHat Enterprise ES 2.1
>
> I talked with RedHat about any OS limitations, and they had me change
> the max shared to a suitable number, and still I am stuck at 512MB of
> RAM.
It's clearly an OS bug of some kind. I've used well
Thanks Kevin!
I see what you're saying. That would mean I would have a common 'mysql'
database though (for the db, user, func tables, etc). I thinks that's
acceptable in my case. (I assume I don't need to update these tables if
I want to add a 'link' to a new database somewhere, and that 'USE' wou
OS: RedHat Enterprise ES 2.1
Current working InnoDB settings:
innodb_data_home_dir = /home/mysql
innodb_data_file_path = ibdata1:2M:autoextend
innodb_log_group_home_dir = /home/mysql
innodb_log_arch_dir = /home/mysql
innodb_log_files_in_group=2
# You can set .._buffer_pool_size up to 50 - 80
Hi Marlon,
Under linux mysql will 'see' any databases you've got links in the
folder you've configured it to look. So in my /var/lib/mysql I have a
symlink to /db/Allpoetry, and it knows to look there for the data files.
So each database can have its own directory. You could probably even
symli
Hello,
I run a mod_perl/mysql website, and have been noticing increasingly
often lately that queries will get stuck for a very long time in the
sending data phase:
3652allpoetry localhost allpoetry Query 291
Sending dataSELECT
amt,bid,bids.lid,bids.mid,owner,name,title
Its not, i ment to say mysql user.
A cron will work, but it wont be up-to-date.. hmm, need to research it a bit
more.
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 3:11 AM
Subject: Re: Dat
I'm trying to have MySQL connect to different filesystems (mostly in
read-only mode). I've tried setting the read-only attribute of my files
under my database directory under "c:\mysql\data" and MySQL seems to be
able to SELECT it with no problem (I then tried doing an INSERT and it
came up with an
On Wed, Sep 24, 2003 at 03:03:20PM -0700, Misaochankun wrote:
> MySQL tells me at startup that it can not allocate more than 512MB of
> RAM.
> It will fail to start the server if I specify any further.
On what OS?
Can we see the exact error?
Have you checked things like ulimit?
Jeremy
--
Jerem
Hi,
Advice on the cause of the following table corruption would be much
appreciated.
Some background:
This customer has been running MySQL for 3 or more years, and, for back
up purposes, shuts MySQL down each night, takes a snapshot of the tables
for backup, and restarts.
We have sufferred a ta
MySQL tells me at startup that it can not allocate more than 512MB of
RAM.
It will fail to start the server if I specify any further.
As far as separate instances, we have not looked into doing that for the
masters, but we may use that for the data warehouse copy. The idea of
multiple MySQL maste
Use Linux to Linux makes life easier, because Microsoft doesn't seem to
like Linux (although some ms code is in it (dhcp)).
Windows 98 out the box configures TCP usage for a 56K modem from what
I've read. Use the program linked below to switch from modem settings to
LAN settings.
Mimic the Window
Thanks for your helps. If I have a Linux on server and windows xp on client,
do I still have slow connection? I think I will have because Linux is using
TCP/IP for connection to windows clien. is that right?
- Original Message -
From: "Dan J. Rychlik" <[EMAIL PROTECTED]>
To: "Dathan Vanc
On Mon, Sep 22, 2003 at 06:09:22PM -0700, Misao wrote:
> What follows is a short story, all true and quite stressful. No database
> servers were harmed in the making of this server, but a couple were
> threatened with loose rack mount rails.
>
> We are trying to move over to InnoDB, but we have
Hmm, as I feared, this problem is so major that no one wants to touch
it. Not that I blame anyone.
-Original Message-
From: Misao [mailto:[EMAIL PROTECTED]
Sent: Monday, September 22, 2003 6:09 PM
To: [EMAIL PROTECTED]
Subject: InnoDB, Replication, and Data warehouse: Oil, Water, and litt
Hooray for Linux! True the networking code in Linux has proven to have less
overhead the windows.
- Original Message -
From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]>
To: "'Mojtaba Faridzad'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, September 24, 2003 3:40 PM
Subject:
# [EMAIL PROTECTED] / 2003-09-24 17:41:29 +0300:
> the row count in SHOW TABLE STATUS is only an estimate based on 8
> dives into the index tree.
ok.
> You had a typical symptom of a fragmented table: space usage much bigger
> than you would expect.
that doesn't answer my questions :) n
Use Linux! This is the solution.
If you have to use windows will need to tweak your TCP settings
Here is a tool that can help you.
http://www.dslreports.com/front/drtcp.html
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
Unix or Linux..
>>> "Mojtaba Faridzad" <[EMAIL PROTECTED]> 09/24/03
03:10PM >>>
Hi,
I wrote some queries to check the speed. If the client and server both
are
windows NT, retrieving large number of records is very slow but when
the
client is windows 98 and server is NT, it works almost 20 times
f
Hi,
I wrote some queries to check the speed. If the client and server both are
windows NT, retrieving large number of records is very slow but when the
client is windows 98 and server is NT, it works almost 20 times faster.
Probably the problem is caused by TCP/IP which is much slower over the lan
Hi!
Resending this, because this did not show up at
http://lists.mysql.com/list.php?list=mysql#b
Heikki
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 23, 2003 10:04 PM
Subject: Re: Innodb & disk geometry
> Sean,
>
> Inno
...after finding a log in the directory that I was trying to use for my new
DataDir, I've discovered my problem (and, surprise, it makes sense).
The MySQL database table must also be in place in the directory, I suppose in
order to keep track of the other databases and tables, etc.
Cheer.
--
Gustavo,
you have to raise the log sequence number with the insert trick I explained
in my earlier message. Creating new log files does not help.
I have now added checks to a future version of InnoDB. They monitor the lsn
at the startup, shutdown, and every 2 seconds during mysqld operation. They
Changing the ownership fixed everything. I did not realize there were
multiple notions of 'root'.
Thank-you,
Avram
On Wednesday, September 24, 2003, at 12:10 PM, Victor Pendleton wrote:
The user `root` in MySQL is not the same as the Unix `root` user. The
user,
mysql, or whatever you have se
On Wed, 24 Sep 2003 14:23:04 -0500
"Dan J. Rychlik" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a question about INSERTing data into 2 different tables with one statement.
> Can you do this?
>
> INSERT INTO table1 (name,address,phone) VALUES ( ' USER ', ' USERADDY ','
> USERPHONE') AND tab
Hello,
I have a question about INSERTing data into 2 different tables with one statement.
Can you do this?
INSERT INTO table1 (name,address,phone) VALUES ( ' USER ', ' USERADDY ',' USERPHONE')
AND table2 (name) VALUES( ' USER ');
-Dan
Title: Mensagem
Hi,
everybody,
I'm using MySQLcc
version 0.9.2-beta... I want to recover more than 1000 rows in a select
statement... What is the command to alter this setting
???
Thanks,
===José Oscar de Souza
EduardoCoordenador de Pro
Hello, I am indexing a decent sized table( ~400M rows, 20 gig), and am looking
for a way to monitor the progress of the indexing. I imported the data with
keying turned off (alter table disable keys), then did the enable keys
command after I imported the data with load data infile.
I of course
The user `root` in MySQL is not the same as the Unix `root` user. The user,
mysql, or whatever you have selected needs to own the directory and files in
the todo directory.
chown -R mysql todo
chgrp -R mysql todo
...
Error 13 means that the user that started the MySQL server does not have
permissio
>From my experience the php mailing lists & newsgroups are quite actively
monitored and a lot of excellent advice is given there.
What I'd do is check error status after mysql calls (whether while dev'g
code or permanently to make your app stronger).
Check out mysql_error and mysql_errno. Also ch
On Wed, Sep 24, 2003 at 06:15:19PM +0100, [EMAIL PROTECTED] wrote:
>
> Hi,
>
> I'm working in MySQL with innodb tables, in Linux (Red Hat 9).
> I'm creating indexes in a table with 16 million rows (it's a fact table), and it
> takes a lot of time (2/3/4 hours), because my system is always swappi
I have tried logging in as root ( mysql -p -u root todo )
and also as myself and both methods yield the same results, shown below:
mysql> SHOW TABLES FROM todo;
ERROR 12: Can't read dir of './todo/' (Errcode: 13)
mysql>
It continues to be curious...
-A
On Wednesday, September 24, 2003, at 08:22 A
Don't forget that if you "commit" then last_insert_id will return 0
- Original Message -
From: "William R. Mussatto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 24, 2003 6:56 PM
Subject: Re: last_insert_id()
: R.Dobson said:
: > Hi,
: >
: > Is it possible to o
At 19:33 +0200 9/24/03, Philippe MAIRE wrote:
Hi
I would like to execute a select on a table for which i don't know the
column names.
IE I would like a command like
select column(1) from table where ...
Sure, if I ask, it is because I cannot use the desc command.
You can use SELECT but you cannot u
R.Dobson said:
> Hi,
>
> Is it possible to obtain the last_insert_id() for a particular column in
> a particular table?
> eg, say i wanted to obtain the last insert id of a column called id in
> table reference, something along the lines of:
>
> last_insert_id(reference.id)
>
> The reason I ask is
I think by issuing a SELECT * FROM tblTableName will execute your query
without knowing the column names.
But you can also issue a SHOW FIELDS FROM tblTableName to get a list of the
table columns.
Hope this helps,
Thanks
Emery
- Original Message -
From: "Philippe MAIRE" <[EMAIL PROTECTED]
Hello,
I've read that the STD function in MySQL returns the biased standard
deviation. Is there a way to get the non-biased SD using MySQL?
Thanks for your help,
Brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
Hi everybody,
We maintain both MySQL databases and Paradox databases and would like to
build some automated data exchanger.
Were in the process of replacing our Paradox with MySql; however it
will take some time to rewrite all related software, approx 700
programs.
Is there anybody in the gr
On Wed, 24 Sep 2003 18:44:06 +0100 (BST)
John Cole <[EMAIL PROTECTED]> wrote:
> "Fatal error: Call to undefined function:
> mysql_connect() in /var/... on line 2"
This error means, that you PHP was built without MySQL support.
You need to add MySQL support or to ask your admin to do it.
> PHP ver
hello,
i am learning PHP and MySQL recently, i use PHP to
connect to MySQL server,
however, an error occur:
"Fatal error: Call to undefined function:
mysql_connect() in /var/... on line 2"
Following is the PHP program:
1 ";
7 $result2 = mysql_list_tables($db_data[0]);
8 $num_rows2 = mysq
Hi
I would like to execute a select on a table for which i don't know the
column names.
IE I would like a command like
select column(1) from table where ...
Sure, if I ask, it is because I cannot use the desc command.
I have another solution which causes again a problem :
if I could execute a fun
Hi,
I'm working in MySQL with innodb tables, in Linux (Red Hat 9).
I'm creating indexes in a table with 16 million rows (it's a fact table), and it
takes a lot of time (2/3/4 hours), because my system is always swapping in/out
(i think).
At the start of the creating, it's fast (because my buff
On Wed, Sep 24, 2003 at 03:18:07PM +1000, [EMAIL PROTECTED] wrote:
> Yeah but when they make a nwe table, it will be owned by root.root wont it?
First, don't run MySQL as root.
Second, yes. It will be owned by whoever creates it. But a periodic cron
job to chorwn them appropriately would be a r
On Wed, Sep 24, 2003 at 09:54:12AM -0400, John May wrote:
> Will this show usage per-database, or only for the server overall?
Overall.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 10 days, proc
In a message dated 9/24/03 12:34:34 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> Have you tried using the blackslash? `\` instead of the forward slash `/`?
Same results. The manual states that even on Windows that the '/' should be
used as the '\' is MySQL's escape char. Optionally, y
> * MATCH ... AGAINST() in natural language mode now treats words that are
> present in more than 2,000,000 rows as stopwords.
Arg! Is this really true only for natural mode? It seems to be doing it for
boolean mode too.
Did this change having anything to do with index creation? So I could
downg
Hi,
Is it possible to obtain the last_insert_id() for a particular column in
a particular table?
eg, say i wanted to obtain the last insert id of a column called id in
table reference, something along the lines of:
last_insert_id(reference.id)
The reason I ask is because I want to initially in
Have you enabled the update on cascade features for the innodb tables?
-Original Message-
From: ginger cheng [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 10:26 AM
To: Victor Pendleton
Subject: RE: pseudo-trigger to update multiple tables?
Yes, I am using InnoDB tables.
Have you tried using the blackslash? `\` instead of the forward slash `/`?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 10:34 AM
To: [EMAIL PROTECTED]
Subject: DataDir question
I am using a portable drive with a few tables on it
Bruce Feist wrote:
David Garamond <[EMAIL PROTECTED]> wrote:
CREATE TABLE `payments` (
`date` date NOT NULL,
`payee` varchar(255),
`amount` double
)
The 'payments' table records the amount of money that should be paid
to each person every month. But the actual cheque is only given when
Haydies wrote:
That was an amazingly vage question.
Yup, sorry for that. Accidentally sent :)
--
dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Victoria Reznichenko wrote:
David Garamond <[EMAIL PROTECTED]> wrote:
Can I do this with in pure SQL (instead of having to create logic in
programming language)?
What do you mean "Custom/conditional grouping"? Please, be more detailed.
Sorry, please refer to my other post. The first email was ac
>Description:
mysqlhotcopy (but possible any other software) can cause delayed
handlers to terminate with "Delayed insert thread couldn't get requested
lock for "
I havent worked out the exact conditions under wich mysqlhotcopy
fails, but it seems that if mysqlhotcopy tries to get a lock
I am using a portable drive with a few tables on it that I copied from a
MySQL server. My intent is to be able to transport the portable drive home (with
the large DB) and plug it into my Windows server to continue working.
To do this, I need to change the datadir to the portable drive (in my c
Are you using innodb table types? Is this the type of updating you are in
need of?
-Original Message-
From: ginger cheng [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 10:04 AM
To: [EMAIL PROTECTED]
Subject: pseudo-trigger to update multiple tables?
Hello,
I am just
Does the user who you start the MySQL Server up with own the directory and
the files? If the files are there you can try issuing a `show tables from
todo`. If the tables appear try running `check table tasks` and let us know
what the output is.
-Original Message-
From: Avram Aelony [mailto
Hello,
I am just wondering how I can make a trigger to update multiple tables
efficiently. (mysql db). RIght now I am thinking of making copys of the tables
involved and update the copies to see the result. But it could be time consuming if
the tables are huge. Any one has good ideas abou
Roman,
the row count in SHOW TABLE STATUS is only an estimate based on 8 dives into
the index tree.
You had a typical symptom of a fragmented table: space usage much bigger
than you would expect.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row le
paradox for dos or paradox for windows?
If you can write object pal then you can easily write an export to text
I love Paradox, use to be an PAL developer when I was little. and an
Object PAL contractor later, ah, the good old days :-)
- Original Message -
From: <[EMAIL PROTECTED]>
On Wed, 24 Sep 2003 18:19:30 +0400
<[EMAIL PROTECTED]> wrote:
> Is there a painless way to import Paradox data and database structure to MySQL?
try to follow this advice:
http://dbforums.com/arch/51/2003/5/766832
---
WBR,
Antony Dovgal aka tony2001
[EMAIL PROTECTED]
--
MySQL General Mailin
Okay, I had to log in as root to do so. The data seems to be still
extant in tasks.MYD .
The other 2 files, tasks.MYI and tasks.frm, are binary.
-Avram
[aa:local/mysql/data] aelony# ls -l todo
total 40
-rw-rw 1 mysql wheel 1220 Sep 23 18:11 tasks.MYD
-rw-rw 1 mysql wheel 2048 Sep 2
Is there a painless way to import Paradox data and database structure to MySQL?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can you post the contents from the todo directory?
-Original Message-
From: Avram Aelony [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 9:14 AM
To: Victor Pendleton
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL newbie: table gone after reboot
I am unfamiliar with frm, myd, and
I am unfamiliar with frm, myd, and myi files, yet perhaps is
insightful?
-Avram
[aa:/usr/local/mysql] % ls -l data
total 41032
-rw-rw 1 mysql wheel 6362 Sep 23 22:55 aa.local..err
-rw-rw 1 mysql wheel 25088 Sep 8 00:43
ib_arch_log_00
-rw-rw 1 mysql wheel
whoops, yes, thanks, missed that
Victor Pendleton wrote:
One thing that stands out is the data types are different sizes.
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
-Original Message-
From: R.Dobson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 8:42
Are the frm, myd and myi files located in the data directory? What is the
data directory?
-Original Message-
From: Avram Aelony [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 8:43 AM
To: [EMAIL PROTECTED]
Subject: MySQL newbie: table gone after reboot
I am new to MySQL an
One thing that stands out is the data types are different sizes.
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
-Original Message-
From: R.Dobson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 8:42 AM
To: [EMAIL PROTECTED]
Subject: innodb foreign key
Hi,
Will this show usage per-database, or only for the server overall?
- John
Might try mytop (search google for it) .. jeremy z wrote it.. it works
well for realtime monitoring..
On Tue, 23 Sep 2003, John May wrote:
Is there any way to monitor which databases are being used the most
heavily on
Hi,
I have two innodb tables produced as show below
CREATE TABLE `monogenic` (
`id` smallint(5) unsigned NOT NULL default '0',
`exp_design` varchar(50) default NULL,
`disease` varchar(50) default NULL,
`omim` varchar(20) default NULL,
`phenotype_ID` smallint(5) unsigned NOT NULL default '0',
I am new to MySQL and have encountered a problem that probably happens
to everyone, yet I have searched for a solution online and elsewhere
without success. I created a database and table. Then I populated the
table. Everything worked perfectly. Then I shutdown MySQL and rebooted
my computer.
On Wed, 24 Sep 2003 09:14:33 EDT
[EMAIL PROTECTED] wrote:
> Has anyone ever had to move a database from one machine to another? I tried
> to just copy all the files from /var/lib/mysql/db1 to another machine into
> /var/lib/mysql/db2. Although I can see the tables using SHOW TABLES, I get an
Has anyone ever had to move a database from one machine to another? I tried
to just copy all the files from /var/lib/mysql/db1 to another machine into
/var/lib/mysql/db2. Although I can see the tables using SHOW TABLES, I get an
error 13 trying to access or repair them.
Is it possible to move
* fbeltran
> According to documentation, in MySQL version 4.0, it is possible to use
> sub-selects, but i haven't found the correct syntax...
Like others have said, it's from version 4.1:
http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html >
> Does any one know how to do this?
> I need somet
David Garamond <[EMAIL PROTECTED]> wrote:
CREATE TABLE `payments` (
`date` date NOT NULL,
`payee` varchar(255),
`amount` double
)
The 'payments' table records the amount of money that should be paid to
each person every month. But the actual cheque is only given when the
total accumulat
"Nelson Velasco" <[EMAIL PROTECTED]> wrote:
>
> Hi, I am very new to MySQL.
>
> Does anyone know if InnoDB works with the tool MySQL Control Center??
Yes.
>
> If works, what I have to do? If does not work, how I create the InnoDB tables in
> MySQL?
You can execute CREATE TABLE table_name (..
That was an amazingly vage question. But first thoughts would be yes and no.
You can do grouping, but you can't really do it conditionaly with out code.
SQL dosn't support much in the way of logic. So, basicly you do the
"conditional" part in code, then the grouping with SQL. If you want the data
g
David Garamond <[EMAIL PROTECTED]> wrote:
> Can I do this with in pure SQL (instead of having to create logic in
> programming language)?
>
What do you mean "Custom/conditional grouping"? Please, be more detailed.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Th
# [EMAIL PROTECTED] / 2003-09-23 21:56:55 +0300:
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > A simple question regarding storage allocated / reported by MySQL/InnoDB.
> > If BIGINT takes 8 bytes, and a table has exactly four BIGINT columns,
> > why is the reported avg. row length 148 bytes?
>
[EMAIL PROTECTED] wrote:
> According to documentation, in MySQL version 4.0, it is possible to use
> sub-selects, but i haven't found the correct syntax... Does any one know
> how to do this?
> I need someting like this:
>
> Select a, (select sum(b) from T2 where T2.a=T1.a) as b from T1
In MySQL
# [EMAIL PROTECTED] / 2003-09-24 02:32:10 -0600:
> According to documentation, in MySQL version 4.0, it is possible to use
> sub-selects
According to what documentation?
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message.see http://www.eyrie.org./~eagl
"Knepley, Jim" <[EMAIL PROTECTED]> wrote:
>
> The docs explicitly say that wildcards are allowed when specifying
> database names in GRANT commands, but don't say anything about wildcards
> being allowed in table names.
> For example, in one large database I have table names that are grouped
> by
"Optik Bacik Scheibbs" <[EMAIL PROTECTED]> wrote:
>
> So this is my first time here...
>
> I am using myODBC 3.51 Server 4.0.14
>
> So I created a table with one columm called "GebDat" - format Date
>
> I connect to this DB using VB6 (SP5) with ADO.
> OK - So when I add a new data it works fine
Roman,
the table is probably very fragmented. The command
ALTER TABLE pmsystem2.editor_competence_product TYPE=InnoDB;
will defragment it.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup t
Hi,
What is the table definition? Have you got a primary index?
I work with date fields without problems in this way:
Update table set Date_Field = '2003-08-01' Where Date_Field = '2003-01-19'
Lourdes.
Optik Bacik Scheibbs escribió:
Hey!
So this is my first time here...
I am using myODBC 3.
According to documentation, in MySQL version 4.0, it is possible to use
sub-selects, but i haven't found the correct syntax... Does any one know
how to do this?
I need someting like this:
Select a, (select sum(b) from T2 where T2.a=T1.a) as b from T1
Hey!
So this is my first time here...
I am using myODBC 3.51 Server 4.0.14
So I created a table with one columm called "GebDat" - format Date
I connect to this DB using VB6 (SP5) with ADO.
OK - So when I add a new data it works fine. But when I will update any one data I
always get an error!
1 - 100 of 103 matches
Mail list logo