Estimate mysqldump size

lared in the header, tar does not like that (if the size of the dump is smaller than the actual size, it can be padded with spaces). So, the estimate must be larger than the actual dump, how to acheive that? Thanks in advance, Olivier -- -- MySQL General Mailing List For list archives:

Re: Estimate mysqldump size

Ronan McGlue writes: > Hi Olivier, > > On 28/11/2018 8:00 pm, Olivier wrote: >> Hello, >> >> Is there a way that gives an estimate of the size of a mysqldump such a >> way that it would always be larger than the real size? >> >> So far, I have fou

Re: Estimate mysqldump size

Ronan McGlue writes: > Hi Olivier, > > On 28/11/2018 8:00 pm, Olivier wrote: >> Hello, >> >> Is there a way that gives an estimate of the size of a mysqldump such a >> way that it would always be larger than the real size? >> >> So far, I have fou

FW: Misc Question

instructions. User gets a mysqld ended and an error log in ./data/ saying can't create files... shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql I post your bug report on our [EMAIL PROTECTED] Regards, Olivier -- MySQL Training

newbie question about InnoDB

is wrong ?? Note the same script works fine without type=InnoDB. Any idea ?? Olivier - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

mySQL under cygwin : mysql_install_db does not create host.frm

... Mr Haase, could you help ? :-) thanks, Olivier. - Olivier Delrieu [EMAIL PROTECTED] Phone : +33 1 44 89 77 59 : +33 1 44 89 77 50 (secretariat) Mobile : +33 6 64 63 00 15

RE: mySQL under cygwin : mysql_install_db does not create host.frm

include only reference to 'root' user in autorisation table. may be that is the problem ? olivier -Message d'origine- De : TP R Murthy [mailto:[EMAIL PROTECTED]] Envoye : ven. 3 mai 2002 12:28 A : Olivier Delrieu Cc : [EMAIL PROTECTED] Objet : Re: mySQL under cygwin : mysql_install_db does

config fails

[localhost:/usr/local/mysql-3.23.51] root# ./configure --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/run/mysql_socket --with-mysqld-user=mysql --with-comment --with-debug checking build system type... powerpc-apple-darwin5.5 checking host system type...

[Fwd: MySql++ compilation error on Aix with gcc3.2.1 (default argument given]

. Thanks, Olivier -- * * * Olivier HARDOUIN [TRANSICIEL - TECHNOLOGIES] * * * * sgl: 8is - Bur: M077 - Tel: 05 62 14 34 87 * * * ---end of your message

RE: Misc Question [University of Alberta, Canada]

. Best Regards, Olivier Beutels, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Olivier Beutels / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Account Manager /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland

Mysql_install_db

To whom it may concern: When running, the /scripts/mysql_install_db, it starts off with preparing the tables, and then it says it is Installing the tables. That is all it does, it says the process is running and everything. Does it take a real long time for it to install the tables? If so how

Problem installing binary on AIX 4.3.1.0

for that ? Building from the source distribution on an AIX machine is not that straightforward, so I would prefer to use the binary distribution. Any advice appreciated, Olivier. MySQL support: none Synopsis: Problem installing binary on AIX 4.3.1.0 Severity: critical Priority: medium Category

JOIN optimization

query for each battery I have Well, I know that's a bit long, but it would greatly help to orientate me on how to continue... Thanks in advance for any help or hint, Olivier

RE: JOIN optimization

Bob, I feel more confident now. Olivier - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

RE: GROUPING

; I didn't try it, but that's what I would try. Un saludo, Olivier - Original Message - From: Rodrigo Gonzalez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 4:56 PM Subject: GROUPING Hi, I have to do a query but i don't know how to do this... I have this table

query w multiple tables and expressions

Hello everyone I hope this is the right list for my question if not please let me know. First I've got to say that I'm not an experienced query-builder so maybe the answer to my problem is very easy. But I have no idea how I could solve this problem and all my research (Internet and Forums) did

AW: query w multiple tables and expressions

Thank you very much. Works perfectly now. -Ursprüngliche Nachricht- Von: Harald Fuchs [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 15. Juli 2004 13:58 An: [EMAIL PROTECTED] Betreff: Re: query w multiple tables and expressions This gives all hotels having at least one of the required

Enum or Int

Hello all I have a table with a field which needs to hold a yes/no or 1/0 value. Which field type is best for this ? Should i create a ENUM field with yes or no values or is it better to create an Int field for this ? What would you recommend ? Best regards Olivier Salzgeber -- MySQL General

AW: cannot add mysql user on debian sarge

I think he's trying to create the user mysql on the system. If so try if you can add any other user on your system. If this fails, it's a problem of your system. Try asking the question on a debian list. Maybe they can help you better. Regards O.Salzgeber -Ursprüngliche Nachricht- Von:

AW: recommended books for web app.

It's not one from your list but I can recommend you this one: http://www.oreilly.com/catalog/webdbapps2/index.html Gives you a nice overview about PHP/MySQL and a nice case study which explains how to create a Online Winestore. Regards Olivier -Ursprüngliche Nachricht- Von: Peter Brawley

query problem after transfer from 4.0.x to 3.23.x

out what is wrong. Can anyone put me in the right direction ? Regards Olivier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: OT Gmail

. The first two who send me a message win :-) Regards, Olivier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Reg Backup

asking. Regards, Olivier Kaloudoff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Cannot GRANT REPLICATION SLAVE

I had the same stuff going on for 4.0.7g on windows. Olivier Hi, I have this weird things happens. kaspia:/var/lib/mysql# mysql --version mysql Ver 12.22 Distrib 4.0.21, for pc-linux-gnu (i386) mysql show grants for \root\@\localhost

Mysqldump and read lock

is Win2K. Regards, Olivier

Re: server performance

of mysql: --log-slow-queries[=file_name] then watch file_name with tail -f file_name, and you should see the bad queries come up. next, do an EXPLAIN on each query, to see if it's using indexes or not, and put indexes where you can. Olivier http://dev.mysql.com/doc/mysql/en/slow-query

ERROR 1189 (08S01): Net error reading from master

1189 (08S01): Net error reading from master Any ideas ? is this a bug in 4.1.8 ? Regards, Olivier Kaloudoff CKR Solutions Open Source Mandelieu, France http://www.ckr-solutions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: ERROR 1189 (08S01): Net error reading from master

at all.. Olivier On Tue, 8 Feb 2005, Olivier Kaloudoff wrote: Hi, I have some problems here with two mysql servers, version 4.1.8; on the master server, binary logs are activated, free disk space is not null; [EMAIL PROTECTED]:~# ls -l /repl/mysql/data/master.* -rw-rw 1 mysql mysql

Re: ERROR 1189 (08S01): Net error reading from master

the command, as the Query Cache is completely wiped out to 0 Queries when load data from master is issued So there does not seem like a network problem to me :) another idea ? Olivier Kaloudoff ha scritto: Hi, As no one answered to the question below, I'm wondering wether it's a FAQ ... or a bug

Re: Permission Denied for INSTALL-BINARY

to install the package. (with more INSTALL-BINARY, for example, quit with q). so read this and follow the instructions ;-) Olivier PS: note that if you have a RedHat based system, like SuSE, Fedora, Mandrake, that use the RPM (Redhat Package Manager), you should download the RPM package instead

Qcache and read data from master

during this operation. I would like to know if this behaviour is expected, and would be interrested if someone can explain me why this is necessary ? Olivier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Shell execution of mysql query

the same query as listed below. the following egrep (or grep -e) should do the trick: mysql -D $dbName --vertical -u $DBUSER -p$DBPASS $queryFile $opFile egrep -qv Empty set (0.00 sec) $opFile rc=$? Olivier Kaloudoff CKR Solutions Open Source Mandelieu, France http://www.ckr-solutions.com -- MySQL

problem with table design

about this the whole morning but couldn't get a solution. I hope somebody on this list can point me in the right direction. Regards, Olivier Salzgeber -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fwd: problem with table design

://lists.mysql.com/[EMAIL PROTECTED] Thanks for your reply. I see this could be a possible solution. But isn't it possible to solve this problem somehow without having to create an additional job_group table? Regards, Olivier -- MySQL General Mailing List For list archives: http://lists.mysql.com

MySQL error to syslog

--defaults-extra-file=/database/mysql/my.cnf --basedir=/usr/local --datadir=/database/mysql --plugin-dir=/usr/local/lib/mysql/plugin --user=mysql --pid-file=/database/mysql/database.cs.ait.ac.th.pid --socket=/tmp/mysql.sock --port=3306 Any help will be greatly appreciated. TIA, Olivier -- -- MySQL

Re: Help with REGEXP

Paul, You could look for a tool called The Regex Coach. While it is mainly for Windows, it runs very well in vine. I fijd it highly useful to debug regexps. Best regards, Olivier -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Select one valuebut not the other

and a different data_value. What is the command to select all the records where an item_number has the data 1 but not the data 2? Thanks in advance, Olivier -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Select one valuebut not the other

SELECT * FROM table WHERE item_number=1; Sorry if my question was not clear: what I am looking for is: SELECT * FROM table WHERE data_value=1 AND there is not any reccord with the same item_number and data_value=2 Olivier On Wed, April 29, 2015 06:30, Olivier Nicole wrote: Hi, I am sure

Re: AW: Select one valuebut not the other

Axel, Simply translated: select * from table t1 where t1.data_value=1 AND not exists(select * from table t2 where t2.data_value=2 and t2.item_number = t1.item_number) Yes, but with t1 and t2 the same table. best regards, Olivier Axel Diehl

Re: Select one valuebut not the other

Thank you, SELECT * FROM test WHERE item_number in (SELECT item_number FROM test where data_value=1) AND item_number not in (SELECT item_number FROM test where data_value = 2); That did it. Olivier On Wed, April 29, 2015 07:20, Olivier Nicole wrote: SELECT * FROM table WHERE item_number

Re: Select one valuebut not the other

and resource_type_id=2 order by item_id; Maybe not the fastest nor the nicest, but as I need to run it only once, it is enought. Thank you, Olivier Consider e.g. the following table (it has two columns, no seq column, and nothing else ... actually it is a table of seq pointers in two other tables

Fwd: Enabled memcached Plugin on mysql

-- Forwarded message -- From: Olivier Morel <olivierm...@gmail.com> Date: 2016-03-09 13:35 GMT+01:00 Subject: Enabled memcached Plugin on mysql To: mysql@lists.mysql.com i've installed mysql5.6 on debian 8 , i've also enabled daemon_memcached. After enabled memcached i r

Re: does anyone else have problems sending mails to this list ?

o are not diligent enough to remove the spammers from their networks, legitimate customers get penalized. Best regards, Olivier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

limits to volume handled by MySQL

i know scratch the project .. seriously ?) Cheers Bernard Clist Bernard-Olivier Clist Administrateur du site Internet de l'OGE Site Web : http://www.geometre-expert.fr/ Mél : [EMAIL PROTECTED] - Before posting, please check

Newbie question: importing cvs settings

. -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Newbie question: importing cvs settings

+44 (0)7812 451238 Email j...@butterflysystems.co.uk -Original Message- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: 26 September 2009 17:08 To: mysql Subject: Newbie question: importing cvs settings Greetings: I have a project for which need to import cvs files into db

Re: Newbie question: importing cvs settings

Back again... I have 192 records to import, and tried my extra line at the end hoping for a work around, but nope, it failed at line 17 again. Invalid field count in CSV input on line 17. Anyone have an idea why this might be happening? Patrice Olivier-Wilson wrote: Yep, typo ...:-( I

Re: Newbie question: importing cvs settings

. (above represents an empty portfolio_ID, a filled in sort_ID, title, empty bodycopy, image, empty before) Thank you. -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Newbie question: importing cvs settings - followup

.) posted by . February 14, 2007 ) -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

csv import issues - good solution found

(not the table) -- viola! :-) Just thought I'd share in case anyone else might need it... -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Inserting csv

Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

insertng csv - solved

to import and it stopped at line 17 (again). BUT progress! So, went back to the converter and entered into SQL on phpmyadmn interface... viola! success. Thank you both so much for your help. -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives

inserting csv - solved, but more to the puzzle

a thought. If anyone has any insight, most appreciated. -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: inserting csv - solved, but more to the puzzle

CRLF (chr(13)chr(10)). andy Patrice Olivier-Wilson wrote: In case anyone might find this of the least interest, probably not, but I always hope to add to discussion just as part of the thank you for help. Further work with same issues found that a file received from a PC based client, if opened

Importing table contents

that there is already a table named tips in databaseB. Yep, know that... I want to bring in the contents...not make a new table. Any help, most appreciated Thanks as always -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Importing table contents

Gary Smith wrote: Patrice Olivier-Wilson wrote: I have 2 databases, different domains. Both have a table named 'tips'... both have different contents in the table. Using phpMyAdmin for GUI. I want to export databaseA tips as sql (done) then import content into databaseB tips. But when I run

Re: Importing table contents

Gary Smith wrote: Patrice Olivier-Wilson wrote: I have data I need to keep in both db just trying to merge. There's two ways around this: First is to not export the structure (uncheck structure). The second is to export with if not exists. This should (IIRC) do a create table

Re: Importing table contents

Gary Smith wrote: Patrice Olivier-Wilson wrote: Gave it a try got this: MySQL said: #1062 - Duplicate entry '1' for key 1 Yeah, that's what I was saying about in my previous mail. It looks like you've got a primary key on one of your columns, and you're attempting to insert data

newbie question database tables

, but then I couldn't expand later. Reverse is true if I add user_ID to the Topics. So, need an idea how to solve this so it doesn't matter how many new users I keep adding, I can still see who is using the topics. As I said, a newbie question. Thanks much. -- Patrice Olivier-Wilson http://biz

Re: newbie question database tables

On 9/10/10 12:31 PM, Jerry Schwartz wrote: Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com Thank you! -- Patrice Olivier-Wilson http://biz-comm.com

Re: newbie question database tables

Thanks all... I got this to work! Much appreciated.. And thanks for patience with a newbie! -- Patrice Olivier-Wilson http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Not to show until a certain date

an announcements_postdate in the table. Just not sure what the WHERE should be to not show until that date. Thanks much, -- Patrice Olivier-Wilson http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub

Re: Not to show until a certain date

On 9/28/10 10:52 AM, Patrice Olivier-Wilson wrote: Hi... beginner here. Working on a php page and using this $query_announcements = SELECT * FROM announcements WHERE announcements.announcements_expiredate CURDATE() ORDER BY announcements_expiredate ASC ; Client now wants the announcement

Re: Not to show until a certain date

On 9/28/10 8:33 PM, Chris W wrote: SELECT * FROM announcements WHERE announcements_expiredate CURDATE() AND announcements_postdate = CURDATE() ORDER BY announcements_expiredate ASC Thank you! -- Patrice Olivier-Wilson http://biz-comm.com -- MySQL General Mailing List For list archives

List archive?

I have a question that this list solved a year ago, and I can't remember what the solution was. Does this list have an archive? (Sorry if it is on one of the links to the list, but I don't have any on hand at the moment.) -- Patrice Olivier-Wilson http://biz-comm.com -- MySQL General Mailing

Re: List archive?

On 12/14/10 12:51 PM, Patrice Olivier-Wilson wrote: I have a question that this list solved a year ago, and I can't remember what the solution was. Does this list have an archive? (Sorry if it is on one of the links to the list, but I don't have any on hand at the moment.) see

MySQL Error#: 2002

appreciated. Regards, Patrice Olivier-Wilson 828-628-0500 http://Biz-comm.com b...@biz-comm.com Everything will be alright in the end, so if it is not alright, it is not yet the end. - Quote from movie: The Best Exotic Marigold Hotel -- MySQL General Mailing List For list archives: http