matt_lists wrote:
I've seen this quite a few times, but never been able to reproduce it
properly.
I'm assuming you're running on Windows, correct?
I'd search your dump-file for "DATA DIRECTORY" the problem on Windows
is that
it uses \ instead of / in the path names there, which makes it use it
a
That depends on what version of MySQL you are using. MySQL 4.1+ has
support for subselects, so you could do what you have there.
I'm assuming that you're running < 4.1, otherwise you would have tried
that code and found it to work...
You may have to get the result of (select id from countries w
This may be of use to you:
http://dev.mysql.com/doc/mysql/en/table-size.html
It appears that there is no limit in MySQL itself, but maybe in the
unlying operating system.
Frank Denis (Jedi/Sector One) wrote:
On Fri, Jan 28, 2005 at 04:00:24PM +, Mat wrote:
What Operating System are you
What Operating System are you running this on? Also, is there anything in the
errorlog?
Is there a limit on the size of .MYI files?
I have a database that worked flawlessly until today. I can't
restart it,
it immediately freezes.
I noticed that the .MYI file of a table has reached e
Hello, we're about to start using MySQL as our main database server for
our web-based applications, so I started looking at the commercial
licencing.
My question is this: Are we allowed to upgrade from 4.0 to 4.1 or 5.0
free of charge? Or do we have to purchase another licence when moving
betwe
electroteque wrote:
Also I am trying to push for 4.1 to be installed on the servers i
build web apps on. When will be a possible date to say that gamma
which is practically production quality, to actually say production
quality ? heheh. Our systems guy will only trust it if it says that,
god on
Add Two Time stamps. Only one will get update.
Mat
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 1:31 PM
To: MySQL List
Cc: Henning Heil
Subject: Re: updating records without changing timestamp fields
On 27 Oct 2003 at 21:21, Henning
Right now I am running my SQL 3.2.53 and getting it installed (via
FinkCommander & Fink) involved picking it out of a list and pressing a
button.
Hope this helps,
Mat
-
Before posting, please check:
http://www.mysq
Try this function
nl2br()
Mat
- Original Message -
From: "Rance Hall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 01, 2002 7:51 AM
Subject: Using MySQL text column with PHP4
> I need some help formatting a MySQL longtext column for presen
ON
FORUMCAT1.ID = FORUMMSG1.POSTNUMBER)ON USERS' at line 1.
Thanks,
Mat
- Original Message -
From: "Nathan" <[EMAIL PROTECTED]>
To: "Mat Murdock" <[EMAIL PROTECTED]>
Sent: Friday, February 22, 2002 12:03 PM
Subject: Re: How to rewrite this statement.
STATUS)<>2) AND ((FORUMMSG1.MESSAGE) Like "*java*"))
ORDER BY FORUMCAT1.LASTPOST DESC;
Thanks ahead of time!
Mat
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
it Memo'
when 'F' then 'Finance Chg'
when 'O' then
case ar_open_items.is_deposit
when 'Y' then 'Deposit'
when 'N' then 'On-Account'
else 'D-Logic Error'
end
else 'Data Error'
end as DOC_TYPE,
...
Thanks,
Mat
Hehehehe.
- Original Message -
From: "Geoff Blake" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 11:37 AM
Subject: Re: possible bug in sum() function
> On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
>
> >
> > the query was:
> >
> > select
Is there a particular reason why you want the images in a mysql database.
It would be faster if you put that path to the images in a table then the
actual images.
Mat
- Original Message -
From: "Kevin Pratt" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROT
We will be moving our MySql databases from a Winnt server to a linux server. Can I
just copy the data files from one machine to the other? If not then how should I do
it?
Mat Murdock
Your mouse has moved. Windows must be restarted for the change to take
effect. Reboot
your help,
Mat
Your mouse has moved. Windows must be restarted for the change to take
effect. Reboot now? [ OK ]
Did you look at doing something with replication?
Mat
Your mouse has moved. Windows must be restarted for the change to take
effect. Reboot now? [ OK ]
- Original Message -
From: "Aigars Grins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sen
You can read a binlog with mysqldump?
Mat
Your mouse has moved. Windows must be restarted for the change to take
effect. Reboot now? [ OK ]
- Original Message -
From: "Scott Baker" <[EMAIL PROTECTED]>
To: "Mat Murdock" <[EMAIL PROTECTED
I've looked through the manual and about 9000 posts from multiple mailing lists..
Is there a way to have mysqlbinlog take a log file and dump just the sql statements to
a file? Am I using the wrong program to do that? Any help would be most appreciated.
Mat
is there a way I can search all 3 of these, returning the results under the field
headers author,title,description sorting them by author.
If you need any more info, please ask...
thanks
Mat
booksellersolutions.com
Read what the SF Examiner says about booksellersolutions.com:
http
I tried RedHat, but had the same problem getting apache and php and mysql to
talk to each other. I decided to try Mandrake 7.2 and it did all the work
for me.
Murdmath
- Original Message -
From: "Luis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTE
21 matches
Mail list logo
