I am having an issue with mysql 5.1.52 and using mysqlbinlog. Essentially I
am running the command piped into mysql and all is working well until I am
getting to a huge BINLOG command and I get:
121002 16:09:03 [ERROR] /usr/libexec/mysqld: Out of memory (Needed
3759556332 bytes)
Small versions pr
On Wednesday 19 April 2006 11:10, Lucas Vendramin wrote:
> Hi all.
> I am creating a trigger that update the some table witch call it.
> Ex:
> create table t1 (
> id int, name varchar(50), c int default 0, father int,
> primary key(id),
> index (father),
> foreign key (father) references t1(id)
On Friday 04 November 2005 07:30 am, AESYS S.p.A. [Enzo Arlati] wrote:
> Hi, I'm trying to migrate from MySQL 4.1.11 to MySQL 5.0 and I get a
> problem with the new release.
> I have this table...
>
> provasql
> CREATE TABLE `provasql`
>
> `idrow` bigint(20) unsigned NOT NULL default '0',
> `descr
On Friday 04 November 2005 08:06 am, Chris Wells wrote:
> /usr/lib/chkrootkit/chkproc -v -v
>
> PID 1230(/proc/1230): not in readdir output
> PID 1230: not in ps output
> CWD 1230: /var/lib/mysql
> EXE 1230: /usr/sbin/mysqld
> ... (report the same for 1231 - 1238)
> You have 9 process hidde
On Thursday 27 October 2005 03:51 pm, [EMAIL PROTECTED] wrote:
> hy! I've been trying to find this piece of information in the manual, but
> seem to have some trouble. so I'm asking it out loud: I'd like to know
> whether mysql 4.0.25 supports utf-8 as an internal encoding. Because a
> server I lik
On Wednesday 26 October 2005 04:24 pm, LMS wrote:
> Hi,
> I have this structure:
> ---
> CREATE TABLE tabla (
>id int(10) unsigned NOT NULL auto_increment,
>nombre varchar(100) NOT NULL default '',
because your defaulting it to ''.. so null = ''
On Friday 21 October 2005 07:04 pm, Stever wrote:
> Is there any reason why there isn't a source rpm for mysql 4.1.15? I
> need to compile my own version since (annoyingly), there doesn't seem to
> be a binary rpm version that works with glibc 2.2.5.
>
> Anyone out there created a source rpm for my
On Wednesday 19 October 2005 04:34 pm, Mihail Manolov wrote:
> It's the way our code is written, and I just changed the table type and
> began getting this error. We have lots of data to insert into this
> table, therefore the optimal option is to use DELAYED and insert them in
> blocks.
>
> Not s
On Wednesday 19 October 2005 01:15 pm, Olaf Faaland wrote:
> The queries in question are:
>
> This query uses the index:
> mysql> explain
> -> select itran_log_date, itran_log_actionid from itran_log where
> -> itran_log_actionid = "170807";
>
> This query performs a table scan:
> mysql> ex
On Thursday 06 October 2005 10:57 am, Ryan Stille wrote:
> I am converting some code from MSSQL to MySQL. In one place I need to
> have a conditional query depending on if a table exists or not. There
> are different versions of this application and the table only exists in
> some of them. Here
On Wednesday 05 October 2005 04:05 am, Rob Hall wrote:
> Having a few problems using cursors in 5.0.13 and I don't know wether it's
> an 'operator error' :)
>
> Should this work?
when loading a procedure, do show warnings after it.. It tells you what
problems its running into..
So what error ar
On Monday 29 August 2005 04:55 pm, Alexey Polyakov wrote:
> I'd try setting
> innodb_buffer_pool_size=8G
> in my.cnf
Then it will run out of memory. You only get 2gig for bufferpools no matter
how much more you have.
--
===
Jab
On Monday 01 August 2005 12:43 pm, Jason Pyeron wrote:
> On Mon, 1 Aug 2005, Enrique Sanchez Vela wrote:
> > Most likely you would need to specify the database
> > server hostname with the -h option.
>
> yes I am aware of this. When you use the native windows mysql.exe it will
> default to localhos
On Thursday 30 June 2005 06:47 am, Patrik Wallstrom wrote:
> mysql> use testdb;
> mysql> drop trigger foo;
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near '' at line 1
> mysql> drop trigg
On Friday 17 June 2005 02:38 pm, Brady Brown wrote:
> Have any of you MySQL/FreeBSD cats successfully set
> innodb_buffer_pool_size > 2G without runing into any of the memory
> allocation problems found on Linux platforms?
It has nothing to do with linux.. its an x86 thing.. So no..
However, so
On Tuesday 14 June 2005 11:57 pm, Michael Gale wrote:
> Even if I change the value to 2G it still will not load ? Because the
> value was 500M before do I not have to remove the ib* files and have
> them recreated ?
2g is still to large.. its 2gig for all buffer pools, not just that one..
On Thursday 09 June 2005 01:26 pm, George L. Sexton wrote:
> Another limitation in MySQL is that you can only have one timestamp column
> with a default of CURRENT_TIMESTAMP.
>
How many friggin times do I have to say that this is not an issue with 4.1 and
above? Which, BTW, is production mysql..
On Thursday 09 June 2005 11:47 am, George Sexton wrote:
> I'm working in that direction. I first posted to the regular mysql list,
> and then I posted again to the internals list. I guess the next step is to
> talk to the MySQL people.
We answered you I thought.. Whats the issue you dont know?
J
On Thursday 09 June 2005 09:39 am, Jeremiah Gowdy wrote:
> I am proposing that when a query is received by MySQL, a timestamp could be
> taken immediately, and that timestamp could travel with the query until it
> is actually processed. For delayed inserts, the query would still sit in
> the inse
On Wednesday 08 June 2005 10:57 pm, George Sexton wrote:
> 1)Why can't I declare a datetime field with DEFAULT NOW()
4.1 has options to default timestamps on update/inserts or both..
Jeff
pgp2pHd6mM2jF.pgp
Description: PGP signature
On Wednesday 08 June 2005 11:49 am, you wrote:
> Easy there boss, I was just responding to the thread and meant no
> offense. I saw the whole thing as funny.
Oh.. email sucks that way..
My apologies as well..
Jeff
pgpvHgJLsGjaw.pgp
Description: PGP signature
On Wednesday 08 June 2005 11:16 am, you wrote:
> [snip]
> Thats funny.. looks like it will be added to 5.1.. Dunno why they think
> fixing
> it is adding a feature..
> [/snip]
>
> The best open-source database on the market today? Free
> Constant improvements to database? Free
>
> Ability to compla
On Wednesday 08 June 2005 10:56 am, you wrote:
> In the last episode (Jun 08), Jeff Smelser said:
> > On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
> > > Subqueries in 4.1 are totally broken. They don't use indexes.
> > > They're evil. We're
On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
> Subqueries in 4.1 are totally broken. They don't use indexes. They're
> evil. We're told we have subqueries but there's no way anyone on earth
> could use them. To make matters worse a lot of developers are TRICKED
> into using them and as
On Friday 03 June 2005 03:36 pm, Joey wrote:
> SET PASSWORD FOR 'user'@'localhost' =
> OLD_PASSWORD('passowordo');
Why not recompile php to work with 4.1?
--old-password
Jeff
pgpEctk2PnMK1.pgp
Description: PGP signature
On Wednesday 01 June 2005 10:40 am, Josh Trutwin wrote:
> Just curious - was there a 5.0.5-beta release? The last beta I had
> was 5.0.4 unless I missed a release announcement...
You need to read that email.. it says it was never released.
Jeff
pgpk9pJzWINTK.pgp
Description: PGP signature
On Monday 23 May 2005 02:01 pm, Dayakar wrote:
> I want a solution to implement the views in mysql 4.12 version. It is
> urgent. Earlier our database was oracle and our search of database is done
> using views. I want to implement the same in mysql 4.12 version.
You need version 5.0.4..
http://de
On Friday 08 April 2005 10:38 am, Chris Scheller wrote:
> i have replication going between 2 boxes. the master crashed a few days
> ago, and this morning i noticed that the slaves slave thread errored
> out. the binary log and offset had changed on the master and the slave
> couldn't sync up. i got
On Thursday 24 March 2005 10:27 am, Marc Dumontier wrote:
> I had a slave machine (ralph) as backup to a master machine (barney). I
> then made ralph the production server, and turned off barney. I now want
> to make barney a backup to ralph (so ralph would be the master).
http://dev.mysql.com/do
On Tuesday 22 February 2005 09:08 am, Johan Jonkers wrote:
> I was wondering if there is a way to specify how verbose the logfile
> should be in my.cnf. I've tried searching the manual and google, but
> have not yet found anything (besides the -v commandline option but thats
> not it). Any helpd a
On Friday 18 February 2005 11:28 am, Nestor Florez wrote:
> TO back up the databases in Mysql, isn't there a way where you can just
> copy somefiles to another directory and in essence you have a backup? I
> thought I read this somewhere
mysqlhotcopy does this for myisam tables, there is a hot c
On Thursday 17 February 2005 12:29 pm, Ian Meyer wrote:
> > You have a server thats on DHCP? Well, your problem is dhcp I am sure..
> > But good luck with that horror flick.
>
> Our servers IPs are static, as is the DNS in /etc/resolv.conf
Then you need to make sure its compiled to the right glib
On Thursday 17 February 2005 11:46 am, Ian Meyer wrote:
> I wish we could do that, however, it's not an option as we use DHCP.. so
> the IP's change, yet the hostname does not. Besides, that's just a cheap
> way to avoid fixing the problem when it should work to begin with. Our
> access tables are
On Thursday 17 February 2005 09:41 am, Ian Meyer wrote:
> When trying to connect, it fails with the message:
> 'MySQL Error Number 1045
> Access denied for user 'user'@'192.168.2.103' (using password: YES'
The 192.168.2.103 is your tip that its not using a host. grant
[EMAIL PROTECTED] and thing
On Monday 14 February 2005 03:52 am, Ben Clewett wrote:
> I am having a lot of problems deleting a large amount of data. Say 20GB
> from a 40GB table. I seem to get failure quite a lot (due NOT to mysql,
> but bad hardware), then MySQL roles back the transaction, which takes as
> many hours and s
On Tuesday 08 February 2005 03:32 pm, Emmett Bishop wrote:
> is it possible to force a field to be NOT NULL but not
> have any default value (I.E the insert statement must
> explicitly provide data for the field in question)?
of course: col1 int not null
Jeff
pgpKRoQG6Ktfo.pgp
Description: PGP
On Friday 04 February 2005 03:31 pm, John Trammell wrote:
> In my version of MySQL (4.1.9), your sample code generates an error:
>
> mysql> select decode(encode("foo"));
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for
On Friday 04 February 2005 11:00 am, shaun thornburgh wrote:
> Apparently not!
>
> mysql> SELECT DECODE ( CSV_DATA_ENC_FORENAME, "test_password" ) FROM
> DATA_TABLE_PID_1_DESC_137;
Is it so hard to read directions?
select decode(csv_data_enc_forename) from DATA_TABLE_PID_1_DESC_137;
This assumes
On Friday 04 February 2005 09:51 am, shaun thornburgh wrote:
> I have a table where users upload various data items via a web site. Some
> fields in the table are named DATA_ENC... to denote that the data should be
> encrypted uusing the encode function. This all works fine, however when I
> come
On Thursday 23 December 2004 02:01 pm, Bryan Heitman wrote:
> Hi Sergio,
>
> All of your suggestions deal with key optimization, I do not believe I have
> a key issue here. Remember that select count(*), an index-only query
> returns in .06 seconds which is very quick. The real question, is why d
On Wednesday 22 December 2004 12:02 pm, Philip Barlow wrote:
> I am working on a query that was built for Oracle databases but I need
> to make it compatible with MySQL. Basically I need to convert or cast an
> INT as a CHAR. The Oracle query just uses TO_CHAR() to achieve this but
> I am stumped
On Wednesday 22 December 2004 09:28 pm, Ney André de Mello Zunino wrote:
> I have just obtained that conclusive evidence. The MySQL installer is
> indeed messing up the type of the /Path/ value on the registry, changing
> it from REG_EXPAND_SZ to REG_SZ. The problem will only take place when
> you
On Thursday 09 December 2004 01:06 pm, Patrick Marquetecken wrote:
> and for ansewring Jeff Smelser i have installed mysql 4.x on linux and then
> dit from the commandline create database and then run the create table
> commands from snort.
No idea.. you can do a show create table db
On Thursday 09 December 2004 09:49 am, Patrick Marquetecken wrote:
> I have 3 snort sensors logging to a central mySQL database after two weeks
> the size of the database is about 3.3GB and the machine is getting slow, as
> i'm not used to be working with mySQL is my question how far can i go
> be
On Tuesday 07 December 2004 02:51 pm, you wrote:
> mysql> explain select * from queryLog where date_format(queryTime,
> '%Y-%m-%d') =
> '2004-11-16';
> mysql> explain select * from queryLog where queryTime =
> date_format('2004-11-16'
> , '%Y-%m-%d');
> +--+--+---+---
On Tuesday 07 December 2004 02:03 pm, Victor Pendleton wrote:
> A function on the left hand side will nullify the use of an index.
Sides dont matter, a function on an index, no matter what side, will kill an
index.
Jeff
pgpsVFJcgS9kp.pgp
Description: PGP signature
On Tuesday 07 December 2004 01:56 pm, Ronan Lucio wrote:
> Actually, I´ve never had such problem.
> I´m just afraid of it because I´ve read some issues about corruption
> in MySQL tables and the own MySQL Manual says that exist a command
> just to repair MyISAM tables (myisamchk -
> http://dev.mys
On Tuesday 07 December 2004 01:22 pm, Ronan Lucio wrote:
> Both, because I have tables that have few inserts and too few
> updates/deletes,
> like states, cities and so on, but I plan transform every table in InnoDB
> to avoid corruption issues.
Nothing here has slowed down. A few innodb stuff I
On Tuesday 07 December 2004 12:58 pm, Ronan Lucio wrote:
> The following thread appeared in the FreeBSD list:
>
> Once I plan to run FreeBSD-5.3 + MySQL-4.1.7 in my server, it can
> affect me.
I may have missed it, but myisam, or innodb?
Jeff
pgpSqggIBC6My.pgp
Description: PGP signature
On Tuesday 07 December 2004 06:41 am, Ronan Lucio wrote:
> Hi,
>
> Has anyone any benchmark between 4.0 and 4.1?
>
> MySQL website says that version 4.0 has some performance
> improvements but I´ve heard that MySQL-4.0 is 20% faster
> than MySQL-4.1.
As far as what? Thats a very general statement.
On Tuesday 30 November 2004 04:44 pm, Greg Macek wrote:
> OK, sounds like what I should do is the following:
>
> * Upgrade current mysql install (3.23.49) to latest stable 4.0 series
> (4.0.22 according to the website)
> * Test out all applications and make sure everything is working as
> expected
On Tuesday 30 November 2004 01:36 pm, Steve Grosz wrote:
> I had installed MySql on Win2003, and when I check the 'server
> information' page, it shows a IP of 127.0.0.1. The IP of the server has
> a 192.x.x.x address.
Change the line below in my.cnf to what you need.. Its binding to 127 ip.
# k
On Monday 29 November 2004 11:35 pm, Greg Macek wrote:
> I was thinking about this as well, but was hoping to minimize the amount
> of work I would have to do. However, if this makes the most sense for
> upgrading, perhaps this is what I'll do.
Actually, I think you will be minimizing going the 4.
On Monday 29 November 2004 09:01 am, Greg Macek wrote:
> I am actually in the process of planning a similar upgrade for our
> database server. None of our databases are that big, but was wondering
> about what "gotcha's" I should be on the lookout for. I planned on
> walking through the upgrade pa
On Wednesday 24 November 2004 07:32 am, Hristo Chernev wrote:
> How to upgrade from 3.23.58 to 4.1.7? Which is the easiest way with minimal
> risk and downtime?
Yeah right.. ;)
> Background: Heavy loaded mysql server, only one database but it is huge -
> 5GB.The database is replicated to another
On Wednesday 24 November 2004 04:02 am, Heikki Tuuri wrote:
> > Only two ways to make copies of innodb.. mysqlhotcopy (its not free)
>
> mysqlhotcopy is free, but it works only for MyISAM.
>
> See:
> http://dev.mysql.com/doc/mysql/en/Backing_up.html
Sorry, I meant the hot backup tool for innodb.
On Tuesday 23 November 2004 02:12 pm, Titus wrote:
> I have converted some tables from MyISAM to INNO
> using an ALTER TABLE statement. It seems to work
> fine. However, when I copy that database to another
> directory for purposes of backup, a subsequent 'use'
> statement on the backup directory
On Monday 22 November 2004 04:15 pm, Santino wrote:
I can confirm it anyway: I think we have a bug.. Unless someone else see
something, might want to take this to bugs.mysql.com
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 578 to server version: 4.1.7-log
On Sunday 21 November 2004 08:38 am, Dayakar wrote:
> Can any one help me in creating view using mysql4.1. If we cannot then any
> other alternative. It would be great if anyone give me an example for that.
Thats a 5.0 feature.. Your not gonna get to far with 4.1..
Jeff
--
=
On Tuesday 16 November 2004 02:15 pm, William R. Mussatto wrote:
> I had a similar problem with DBI/DBD. The solution I used was to create
> the passwords using OLD_PASSWORD('plaintextPassword') function
> Look at http://dev.mysql.com/doc/mysql/en/Password_hashing.html for the
> details as well a
On Monday 15 November 2004 03:25 pm, Jeff Smelser wrote:
> insert delayed is a myth.. Least in the 4.1 version. 4.1.18 it was taken
> out.
Course thats 4.0.18.
pgpBoy3BGuPlh.pgp
Description: PGP signature
On Monday 15 November 2004 11:30 am, [EMAIL PROTECTED] wrote:
> I am running mysql version 4.1.7 on SuSE professional 9.1.
I run 4.0.22
> I have a MyISAM table which I use for syslog messages. This table gets
> about 40-70 inserts a second with peaks of over 400 inserts a second. I am
> using IN
On Sunday 14 November 2004 05:05 pm, kalin mintchev wrote:
> can somebody please explain what is wrong with this command:
> select t1.data from table1 as t1 where t1.zip=(select * from table2 as t2
> where t2.chain like "%carmike%");
If your no usiing 4.1, subselects are not even allowed..
If so
On Sunday 14 November 2004 11:34 am, Robb Kerr wrote:
> I'm posting to test a new newsgroup client. Please post several replies.
Does it work with mysql?
Just curious.
Jeff
--
===
Jabber: tradergt@(smelser.org|jabber.org)
Quot
On Tuesday 09 November 2004 03:23 pm, ian douglas wrote:
> GRANT SUPER,REPLICATION CLIENT to 'syscheck'@'mywebserver.domain.org'
> IDENTIFIED BY 'mypasswd' ;
I have no idea how this script is gonna help, but your having permission
problems. The last message you wrote was permission problems as w
On Tuesday 09 November 2004 11:49 am, ian douglas wrote:
> My bad, I wasn't running "START SLAVE" to get them going. Seems odd that
> this has to be done manually.
I never do.. once its started, it should be fine.. Your just getting errors
making it stop.
> Also, overnight, my slaves reported
On Thursday 04 November 2004 02:28 pm, Scott Hamm wrote:
> create table account (
> ID int auto_increment,
> Date date,
> Check_Number int(5),
> Bank_Match int enum(0,1),
> Category varchar(20) no null,
> Credit decimal(7,2),
> Debit decimal(7,2),
> Balance decimal(7,2),
> primary key (ID)
> );
It
On Wednesday 03 November 2004 02:43 pm, Mark Hennessy wrote:
> I have three mail servers, on each is a MySQL DBMS. I want to set up a
> replication ring between the three MySQL DBMS on these machines so they
> will constantly share the same data in near real-time. But, the chance
> exists that a
On Wednesday 03 November 2004 09:59 am, Yves Goergen wrote:
> Ehm - what please is the difference between MySQLCC and MySQL
> Administrator? And what is Query Browser again? It's confusing to have
> three products that all do the same.
No, they are not all the same..
MySQLCC is depricated..
MyS
On Thursday 14 October 2004 04:00 pm, Mike Johnson wrote:
> It does matter, though. You can't use DATE_FORMAT() to translate
> '10/14/2004' into '2004-10-14.'
No, your right, that would be wrong.
> It looks like what the poster wants is STR_TO_DATE() (a la
> STR_TO_DATE('10/14/2004', '%m/%d/%Y'),
On Thursday 14 October 2004 03:46 pm, [EMAIL PROTECTED] wrote:
> For values headed into a SQL statement, use whatever functions are
> available to you in the language (PHP, PERL, Python, Java, VB Script,...)
> you are using to accept the user's input in order to make the commands you
> send MySQL c
On Thursday 14 October 2004 03:35 pm, Stuart Felenstein wrote:
> No :),. cause it seems that those formats are for
> outbound, db ->.
> I was looking for the other direction.
Huh? It really doesnt matter does it? They work either way..
I use those functions all the time for inbound..
Jeff
pgps
On Thursday 14 October 2004 03:12 pm, Stuart Felenstein wrote:
> Thanks , I know the page and have the links
> bookmarked!
So you got the answer from it right?
Jeff
pgpSsmcBOJscM.pgp
Description: PGP signature
On Thursday 14 October 2004 02:45 pm, Stuart Felenstein wrote:
> Apparently, mysql does not like the format
> "MM/DD/"
> Then again I tried it around , still no dice.
> It's intended to go into a Date" column.
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
All, you every need
On Wednesday 13 October 2004 10:33 am, Ulrich Seppi wrote:
> Hello people,
> does anybody know if Foreign keys increase the performance of select
> querys? example.
> DB1 has only INNODB tables.
> DB2 has the same structure as DB1 with all possible foreign keys.
Huh? You might want to read what a
On Monday 11 October 2004 11:57 am, Massimo Petrini wrote:
> I my network I have 1 master and 4 slaves. I need to squeeze the innodb on
> my master; which is the correct way to execute the squeeze action (now the
> innodb files is around 1gb, while in a new db is around 300 mB)
> thanks
There isnt
On Wednesday 06 October 2004 02:10 pm, Scott Hamm wrote:
> Like I said before it "seems" to group by "threads". Therefore, it is
> close enough.
Right! thats why Microsoft thrives. Because as long as it appears to work, its
all good.. :)
Jeff
pgpAXe4d5h6QD.pgp
Description: PGP signature
On Tuesday 05 October 2004 02:39 pm, Scott Hamm wrote:
> If you sort it by conversation topic, then it will seem to group by
> "threads".
> I'm running Outlook 2000.
Seem.. Thats the key word.. Its not true threading support..
These are not there for looks..
References:
<[EMAIL PROTECTED]>
I
On Tuesday 05 October 2004 02:23 pm, David Brodbeck wrote:
>
> Well, that's nice...
Hmm
> I just don't see what difference it makes. As far as I can see, the
> outcome is identical either way...
Cause your doesnt support threads.. Outlook was the only one I knew off that
did not.
Jeff
pgp1r
On Tuesday 05 October 2004 01:56 pm, David Brodbeck wrote:
> Saves having to retype the list address, or look it up. I don't see what
> difference it makes...
Click on the email, on mine, it brings up a nice to empty message with the
email address..
Jeff
pgp50O9uZVT4t.pgp
Description: PGP si
On Tuesday 05 October 2004 01:55 pm, you wrote:
> We're not perfectionist like you. :)
Actually its proper email etticate.. look it up if you don't believe me..
Jeff
pgpjB48FEXyL0.pgp
Description: PGP signature
On Tuesday 05 October 2004 01:14 pm, Ed Lazor wrote:
> Does anything need to be done to my data while upgrading the server from
> 3.23 to 4.0.21?
Whats the deal and this list? No one can ever just hit new message, they
always hit reply and put a new subject in..
Geez.. This list is horrible with
On Monday 04 October 2004 01:18 am, Batara Kesuma wrote:
> I have a cron running this every night.
> DELETE message_inbox FROM message_inbox LEFT JOIN message ON message.id
> = message_inbox.message_id WHERE message.id IS NULL
>
> Message table also has about the same amount of rows.
>
> I notice t
On Tuesday 28 September 2004 01:02 pm, Ed Lazor wrote:
> I usually create an index for each criteria being checked against in the
> SQL statements.
>
> For example, for this query
>
> Select * from products where ProductID = 'aeg8557'
>
> I'd create an index on ProductID. The same thing applies if
On Thursday 23 September 2004 04:44 am, Patrick Connolly wrote:
> Last week, I asked this list had others had problems contacting MySQL
> AB. I promptly received a short note from
>
> [EMAIL PROTECTED]
>
> It suggested I could respond to that address which I tried to do, but
> I get this:
>
>--
On Sunday 05 September 2004 11:44 am, Leandro Melo wrote:
> Hi,
> how can i make a back of the data in my database?
check out mysqldump
--
===
Jabber: tradergt@(smelser.org|jabber.org)
Quote: "Nothing fails like prayer." -- Ann
On Saturday 14 August 2004 01:06 am, [EMAIL PROTECTED] wrote:
> mysql> mysqldump b
> -> c:/hdump/dump.sql
Do it from the command line, not mysql command prompt.
--
===
Jabber: tradergt@(smelser.org|jabber.org)
Quote: "We don'
On Wednesday 04 August 2004 06:44 am, Odhiambo Washington wrote:
> Is there hope for me in this situation??? I have googled and googled but
> all that I see doesn't seem to help me to recover the data in the table.
>
> This makes me very desparate.
>
> I'd be very thankful for any pointers that wo
On Tuesday 03 August 2004 01:11 pm, Jon Drukman wrote:
> We were having terrible problems with a master/slave setup. The master
> does a huge amount of writes, and the slave simply started lagging
> behind, despite both machines being identical hardware-wise. This made
> the application basically
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 05 July 2004 06:07 pm, Gary Mack wrote:
> Hi there,
>
> I am having trouble converting a timestamp from mySQL to the US Format
> mm/dd/. Can someone please help. I am also having trouble converting
> -mm-dd into a normal mm/dd/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 30 June 2004 01:09 pm, Jeff Smelser wrote:
> On Wednesday 30 June 2004 12:46 pm, J S wrote:
> > Thanks for your reply.
> > By replication do you mean do I have tables with duplicate rows? If
> > that's the cas
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 30 June 2004 12:46 pm, J S wrote:
> Thanks for your reply.
> By replication do you mean do I have tables with duplicate rows? If that's
> the case then I do have one table with duplicate rows.
No.. Replication, meaning, you have the same
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 30 June 2004 12:10 pm, J S wrote:
> Hi,
>
> I would like to switch off the logging that creates the large files below
> (in the mysql data directory)
> Could someone tell me how to do this please?
take out log-bin from my.cnf. But you bet
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 24 June 2004 12:15 pm, Jim Shea wrote:
> I'm setting up a cron job to run myisamcheck with the options
> "-Aacmorv". As I have to put in a username and password, for security I
> want to create a special account that has the minimum require
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 11:48 pm, Tom Williams wrote:
> Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux
> system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to).
> The compile runs smoothly, but make test fails. Here i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 03:00 pm, Kairam, Raj wrote:
> After unzipping and untarring the DBD-mysql-2.9003.tar.gz ( obtained from
> CPAN ), in the DBD-mysql-2.9003 directory I tried the following
> mkdir /tmp/mysql-static
> cp /usr/lib/mysql/*.a /tmp/my
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 12:52 pm, Michael McTernan wrote:
> Dear Mark,
>
> The best way to fix this is by correctly setting your from address in your
> mailer to [EMAIL PROTECTED]
Your email software seems to be wrong. All these people can't be doing
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 11:05 am, Mike Miller wrote:
> Unless you have a specific need for it, you could save yourself a lot of
> trouble by putting select tables or databases or even clients on each
> server. This also means you don't incur the added
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 15 June 2004 01:29 pm, Eric Gunnett wrote:
> You can do a reset master, and it will start the log over at 001 and
> remove the old log files that are there.
Thanks,
I also had to restart the slaves (change master to command) to start
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am trying to prune some bin-logs and noticed:
mysql> show master logs;
++
| Log_name |
++
| db-bin.001 |
| db-bin.002 |
| db-bin.003 |
| db-bin.004 |
| db-bin.005 |
| db-bin.006 |
| db-bin.007 |
| db-bin.008 |
| db-bin.009
1 - 100 of 122 matches
Mail list logo
