Stuck with a huge ibdata1 file

2004-09-26 Thread Wouter van Vliet
Howdy Folks, Got a bit of a hassle. After some broken tries (got impatient) to change the type of large table's column I found that, when I finally got the patience, my disk went full and cancelled the operation again. Since MySQL copies the table before such operation, my ibdata1 file (using Inno

Changing datatype of a large table's column

2004-09-16 Thread Wouter van Vliet
Howdy, I'm running a website (dah) and chose to store images in the database. What I didn't take into consideration however, was that some images would be larger than the amount of data a BLOB can store. Just didn't notice it while testing. (Stupid me). Currently, the site is stuck with some half

Problems with very special characters

2004-05-08 Thread Wouter van Vliet
I'm stuck here with my hands in my hair, and would very much appriciate any clue to a solution, Wouter van Vliet (ps. I tried to post this message some days before too, but failed back then. If it comes in twice, I apologize)

Problems with very special characters

2004-05-08 Thread Wouter van Vliet
Hello everybody, I'm back! (been a subscriber here before, a while ago .. was quite an active one at that time .. ;)) .. and I'm back for a reason, having a very wicked problem. The setup is one RedHat linux 9 machine (called "s007"), previously in use as both our web and database server. As traf

RE: Export in XML

2003-12-08 Thread Wouter van Vliet
On maandag 8 december 2003 14:08 Jay Blanchard told the butterflies: > [snip] > > Well Todd, it is a little more complex than this. How much do you > > know about XML? > > In fact, exporting is quite simple. Just give > > > mysqldump --xml --password=[password] \ > [-u usernam

RE: Query to emulate what mysqldump does

2003-12-04 Thread Wouter van Vliet
On woensdag 3 december 2003 22:56 Andrew Braithwaite told the butterflies: > You could try to use the "select into {OUTFILE | DUMPFILE} > from tablename where blah=blah..." > > I think you may be able to do "select into local outfile from > blah" > > Which will put the file on the same serv

RE: INSERT INTO tbl (SELECT) UNION (SELECT) ORDER BY field-does not work. Why?

2003-12-02 Thread Wouter van Vliet
George Georgeus wrote: > Hi! > I do not know how to use INSERT and UNION together. > For example: > INSERT INTO tmp_table_name (a) > (SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY a LIMIT > 10) UNION (SELECT a FROM table_name WHERE a=11 AND B=2 ORDER > BY a LIMIT 10) ORDER BY a; It does not

RE: Non-conditional LEFT JOIN

2003-12-02 Thread Wouter van Vliet
On dinsdag 2 december 2003 14:44 news told the butterflies: > In article <[EMAIL PROTECTED]>, > "Director General: NEFACOMP" <[EMAIL PROTECTED]> writes: > > > [1 ] Hi group, > > > I want to do a LEFT JOIN that takes no condition. > > > For example I have the following tables: > > > table_1

RE: Non-conditional LEFT JOIN

2003-12-02 Thread Wouter van Vliet
On dinsdag 2 december 2003 14:06 Director General: NEFACOMP told the butterflies: > Hi group, > > I want to do a LEFT JOIN that takes no condition. > > For example I have the following tables: > > table_1table_2 > ---

RE: Export in XML

2003-12-02 Thread Wouter van Vliet
On maandag 1 december 2003 15:40 Jay Blanchard told the butterflies: > [snip] > Is there a way to export/import MySQL tables in XML format? [/snip] > > Well Todd, it is a little more complex than this. How much do > you know about XML? In fact, exporting is quite simple. Just give > mysq

RE: Reducing and counting duplicate rows

2003-12-02 Thread Wouter van Vliet
On dinsdag 2 december 2003 4:07 Skippy told the butterflies: > I must admit I'm pretty stumped here. I'm using MySQL 4.0.12. > > I have several tables with info, and one which servers as a > link between them (has id's that refer the id's in all the others). > > The info tables hold people(table

RE: Select Records From the Database

2003-12-02 Thread Wouter van Vliet
On dinsdag 2 december 2003 9:41 Nitin told the butterflies: > is this declared in php or javascript?? > depends on the syntax. > > - Original Message - > From: "Caroline Jen" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, December 02, 2003 9:38 AM > Subject: Select Reco

RE: error 1045 happened randomly

2003-12-01 Thread Wouter van Vliet
Francis Mak wrote: > - I am 100% sure that all scripts are using include > ("db.php"); so all pages are using the same login and > password and hostname > > - since I am using password, so it shows "Using Password YES" as well. > > - The error indeed occured on the same page. e.g. when you > are

RE: error 1045 happened randomly

2003-12-01 Thread Wouter van Vliet
Duncan Hill wrote: > On Monday 01 December 2003 11:46, Francis Mak wrote: > >> it works successfully, however, sometimes it just give me "Error >> 1045: Access Denied for user '[EMAIL PROTECTED]'" >> it happens RANDOMLY. >> >> Could anybody please let me know how to fix this??? > > R

RE: error 1045 happened randomly

2003-12-01 Thread Wouter van Vliet
Francis Mak wrote: > Hi, > > sorry if this has been answered previously, however I > tried to google, I found a few people having this issue, but no > solutions provided. > > I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary, > not rpm and not compiled by myself) + REDHAT 9 > >

Locking one table blocks others

2003-11-30 Thread Wouter van Vliet
Fella's, First of all I'd like to welcome myself to this list. Have been here before, but now that I need your help again I decided to return. For the following question I've of course read the Manual, googled some .. Even checked the archives. Found no answer that satisfied me. For a website I'm

SELECT into :varname

2002-08-30 Thread Wouter van Vliet
Heey Folks, I've been wondering about something for quite a while now.. I know that it's possible in some DBMS's to select a value in some variable, and then in some other query use it again. Is this also possiblein MySQL and if so, how? Thanks, Wouter -

[select into] RE: SQL - Update problem

2002-08-28 Thread Wouter van Vliet
Hmm .. isn't there any workaround for this .. Maybe something like: select count(*) into :somerVar FROM table; update sekce set pocet = :someVar WHERE ... blabla; I've seen things like this in other databas servers but haven't been able to find out if it's supported by MySQL, and

RE: Tee Shirt

2002-07-19 Thread Wouter van Vliet
Yeah .. I want it too :) .. please tell us ! -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug t

RE: Autoincrement in MultiColumn primary key?

2002-07-13 Thread Wouter van Vliet
Hmm, this all sounds indeed like a terrific feature .. if it would work ! So, I decided to try it and just see what'll happen. I did the following things: * first I created a table: mysql> create table autoIncrement ( -> id int(11) NOT NULL AUTO_INCREMENT, -> thingie varchar(20) NOT NU

RE: Some easy questins .. [i hope]

2002-07-11 Thread Wouter van Vliet
This opens so many possibilities ... manage MySQL tables in MS Access using MyODBC. Guess this works for remote MySQL servers too?. Almost don't dare to ask, but is this also possible from PostgreSQL? I'm in two situations with alike problems, one using MySQL and the other one PostgreSQL .. I'll s

Some easy questins .. [i hope]

2002-07-11 Thread Wouter van Vliet
Heey There Folks, Maybe you can help me with the following questions: * I was wondering, is there some application for Windows that gives a frontend to MySQL similar to MS Access? Or maybe connect from access to MySQL ? (guess not, right?) * The mysql index and data files, can they be exchanged

RE: Mass Delete

2002-07-11 Thread Wouter van Vliet
So, you've got a text file with addresses to be deleted? Hmm, that's not too hard to manage. I suppose that on each line, there is one email address and only that address? With PHP, i'd do something like: "; mysql_connect("host", "user", "pass"); mysql_select_db("database"); $textfile = file('dir

RE: Access a M$ Access 2000 db with MySql-front - could not open database error

2002-07-09 Thread Wouter van Vliet
I'm not very sure of myself ... but maybe you'd try to use quotes around the file path? -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent

InnoDB or BdB

2002-07-03 Thread Wouter van Vliet
Heey There Folks, Well, I hope that this message gets through finallly. First I got it back from the deamon because I had send it in html format, then because of I was suspected from spamming this list. Only for not having used the words query or sql once ... well, I have now so it should come th

RE: SQL - Fulltext search

2002-07-01 Thread Wouter van Vliet
e than 24 hours stating the reason of disagreement. -Oorspronkelijk bericht- Van: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]] Verzonden: maandag 1 juli 2002 09:13 Aan: [EMAIL PROTECTED] CC: [EMAIL PROTECTED]; [EMAIL PROTECTED] Onderwerp: Re: SQL - Fulltext search Pada Mon, 1 Jul 2002 09:01:13 +0200 &qu

RE: SQL - Fulltext search

2002-06-30 Thread Wouter van Vliet
I would use WHERE skill LIKE "%powerpoint%" OR skill LIKE "%PHP%" but that is because I don't know the better way, which must be there, I feel it .. anybody? -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met

RE: update syntax

2002-06-23 Thread Wouter van Vliet
You can achieve a similar thing with the WHERE column IN (SELECT column FROM table WHERE ..) subselect. In the current version of MySQL, this is not yet supported, but I've heard fearies tell that it will be in version 4.1, or else some other version to be released in the somewhere near future.

RE: timestamp problem ..

2002-06-14 Thread Wouter van Vliet
whow, this list is so very powerfull .. just give me your address and I'll send you the beer .. what kind of it would you like? -Oorspronkelijk bericht- Van: Luc Foisy [mailto:[EMAIL PROTECTED]] Verzonden: June 14, 2002 16:04 Aan: Wouter van Vliet; MYSQL-List (E-mail) Onderwer

timestamp problem ..

2002-06-14 Thread Wouter van Vliet
Heey Folks, I'm having a slight problem with the timestamp column format. When I alter a table and, add a column of type timestamp all records get the current timestamp, that's ok. When i insert a new row, all records get the current timestamp. That too is ok. But now, when I update one row of th

RE: MySqlDump

2002-06-12 Thread Wouter van Vliet
Looks like a MERGE table problem to me .. you can't insert data into this table type because there's actually no data in it ;). You need to insert data into one of the merged tables. in version 4.x though, you can set something for the insert thing, so that it will insert automatically in one of

RE: Replication zwischen MYSQL und MS Access 97(2000)

2002-06-12 Thread Wouter van Vliet
Now for the folks who don't speak germen, I'll translate his msg: Hallo, Is there any possibitity to synchronise my Access datbase with a MySQL database? If possible automatic or by user action. While actualising between 2 access copies, there is a Conflict Manager who helps with the actualisatio

RE: InnoDB foreign key constraints

2002-06-10 Thread Wouter van Vliet
What I think, is that your syntax for creating the primary key is slightly incorrect. I'm not sure if this is also true vor MySQL but I got teached at school that a foreign key can only point to the primary key of a table. Perhaps you can try to do the following: Create Table: CREATE TABLE `conn`