any additional information I can provide you with whatever
you need.
Thank you for your time and efforts.
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This problem is indeed not related to OS / Hardware Problems.
Take a look at this thread:
http://lists.mysql.com/mysql/197542
Read the part about show databases as root vs standard user
+ observed file system activity.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
5/6/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
Perhaps it's time to file a bug report, then?
-Sheeri
On 5/3/06, Alex <[EMAIL PROTECTED]> wrote:
> This problem is indeed not related to OS / Hardware Problems.
>
> Take a look at this thread:
>
> http://l
_messageblks' (errno: 150)
Appreciate any help,
Alex
Here's the script, launch it on a db without dbmail_messageblks nor
messageblks table:
### this part is from the dbmail 1.1 dump with mysql Ver 12.18 Distrib
4.0.12, for pc-linux (i686)
## first I disable foreign key chek
Alex wrote:
I'm running mysql 5.0.22 on SLES9, using the mysql.com appropriate rpm.
I've tried other versions of mysql 5, including 5.0.6, 5.0.17, 5.0.18
and 5.0.21. The result is always the same. This leads me to believe,
that there are new requirements for mysql 5 and that&#x
Gabriel PREDA wrote:
Hope this helps !
Thanks a bunch, that was it. Problem solved.
I'll tell about it on the dbmail list as well.
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lots of bin log files that you can do a cleanup on. Bin logs occupy a
great deal of space.
Thanx
Alex,
MySQL DBA
Yahoo!
On Tue, 03 Jan 2006 08:28:24 +0530, Carl Brewer <[EMAIL PROTECTED]>
wrote:
Hello,
I'm stuck with a rapidly decreasing amount of available disk
Hi,
Please provide details like what tables are you using, the entire my.cnf
and the information from the mysqld.err when the crashes occurred.
--Alex
On Wed, 04 Jan 2006 06:11:24 +0530, Jonathan Chong <[EMAIL PROTECTED]>
wrote:
Hi everyone
I run a relatively popular foru
before user comments.
Hope this helps.
Thanx
Alex
On Wed, 04 Jan 2006 15:25:39 +0530, Jonathan Chong <[EMAIL PROTECTED]>
wrote:
Hi Alex
Thanks for this, and sorry for the late reply.
That was the entire my.cnf file in my last email. This is from SHOW
VARIABLES in
the table type whether it is myisam or innodb. create table statements are
preferred when you have slow query issues.
--Alex
On Wed, 04 Jan 2006 15:57:06 +0530, Jonathan Chong <[EMAIL PROTECTED]>
wrote:
Sorry
I also forgot to ask - when you say the tables, did you want the
se are kernel
messages) when the crash occurred. Without the error info from the
mysql_error.log we cant do much.
Thanx
Alex
On Wed, 04 Jan 2006 19:00:16 +0530, Jonathan Chong <[EMAIL PROTECTED]>
wrote:
Hi Alex
There are over a hundred tables for the site, and those that are
rel
Hi Sujay,
Can you please post details like the my.cnf configs, how is the
load on system like cpu, memory, disk usage etc.
Thanx in advance
--Alex
On Mon, 09 Jan 2006 15:16:39 +0530, Sujay Koduri <[EMAIL PROTECTED]> wrote:
I am giving the system configuration which we are us
)
+ max_connections*2MB
In an ideal case the above equation should evaluate to a value lesser than
the physical memory available.
Thanx
Alex
On Mon, 09 Jan 2006 22:12:53 +0530, sheeri kritzer <[EMAIL PROTECTED]>
wrote:
We're running MySQL version 4.1.12 on Fedora Core 3 64-bit.
i type
bzr branch lp:mysql-server
and now 986582KB downloaded
What size of repo i must download with this command ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi
I created DB in MySql with name x
I finish fill data to this DB
Next day somebody run any script
And this script removed my DB and created new DB with the same name
How can I get my data back in MySql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
r not.
If not, are there any alternatives anyone can suggest?
Thanks
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sql query building topics on this through
google, so I'm trying my luck here.
thanks
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi list,
In general, is there any guarantee that the .frm and innodb files
(including logs) will be exactly the same cross-platform? More
specifically, would the database data files created on Windows work when
placed on an OSX installation of the same version?
Assume whatever version of mysq
I have some queries that return around 75,000 rows, and I've been trying
to figure out how to speed them up a little. In the course of looking for
the bottleneck, I discovered that simply getting a large result was
considerably slower on OS X.
I tested on a number of machines, with MySQL versions
InnoDB is exactly the same - 513951016 bytes. Which
restrictions are the cause of this - InnoDB's or FreeBSD's?
Thanks in advance
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
by 50%? Or is it myisam
buffer that mysql is trying to extend?
Regards
---
Alex
On Tue, 14 Oct 2003, alex wrote:
> Hi people,
>
> I have mysql 4.0.7-gamma/linuxthreads running under FreeBSD 4.6.2 (server
> has 4G phisical memory), and occasionally mysql traps with the message:
>
by 50%? Or is it myisam
buffer that mysql is trying to extend?
Regards
---
Alex
On Tue, 14 Oct 2003, alex wrote:
> Hi people,
>
> I have mysql 4.0.7-gamma/linuxthreads running under FreeBSD 4.6.2 (server
> has 4G phisical memory), and occasionally mysql traps with the message:
>
by 50%? Or is it myisam
buffer that mysql is trying to extend?
Regards
---
Alex
On Tue, 14 Oct 2003, alex wrote:
> Hi people,
>
> I have mysql 4.0.7-gamma/linuxthreads running under FreeBSD 4.6.2 (server
> has 4G phisical memory), and occasionally mysql traps with the message:
>
by 50%? Or is it myisam
buffer that mysql is trying to extend?
Regards
---
Alex
On Tue, 14 Oct 2003, alex wrote:
> Hi people,
>
> I have mysql 4.0.7-gamma/linuxthreads running under FreeBSD 4.6.2 (server
> has 4G phisical memory), and occasionally mysql traps with the message:
>
by 50%? Or is it myisam
buffer that mysql is trying to extend?
Regards
---
Alex
On Tue, 14 Oct 2003, alex wrote:
> Hi people,
>
> I have mysql 4.0.7-gamma/linuxthreads running under FreeBSD 4.6.2 (server
> has 4G phisical memory), and occasionally mysql traps with the message:
>
by 50%? Or is it myisam
buffer that mysql is trying to extend?
Regards
---
Alex
On Tue, 14 Oct 2003, alex wrote:
> Hi people,
>
> I have mysql 4.0.7-gamma/linuxthreads running under FreeBSD 4.6.2 (server
> has 4G phisical memory), and occasionally mysql traps with the message:
>
I'm very sorry for the duplicated posts, my mail softtware behaved wrong
:(
---
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
al script I get the
whole system but as the main and single console is blocked cannot login
to machine - only by remote.
That's a problem.
Linux RedHat 9.0 with standard kernel 2.4.18
Single Processor with Hyperthreading - hence using smp-kernel.
P4-3200
2048 MB RAM
Alex
--
MySQL General M
key_buffer_size | 3221225472
top says mysql is only using about 1.8G. Key_reads *is* increasing, even
though Key_blocks_used is not.
Anyone have any idea what could be causing this behavior? Running 4.0.18
on Mac OS X Server 10.3.3.
Thanks,
Alex
--
MySQL General Mailing List
Fo
output volume
The problem is that if I use a local client on FreeBSD-computer I get
the result immediately.
But if I try to do the same via tcp-connection it takes few minutes.
After I used EXPAIN query it turned out that when I use tcp-connection
USING FILE SORTING occurs.
How to cure that?
Alex
i have to use a statement like:
SELECT CODICE FROM TABSIC WHERE COM=1 AND SEN=1 AND PRI=1
AND CODICE<>ALL(SELECT CODICE_TABSIC FROM ARCHIVIO_SICU_MIN WHERE
(CODICE_ARCHIVIO=342))
but mysql doesn't support inner select.
What statement should i use instead of this one ?
Tha
i have to use a statement like:
SELECT CODICE FROM TABSIC WHERE COM=1 AND SEN=1 AND PRI=1
AND CODICE<>ALL(SELECT CODICE_TABSIC FROM ARCHIVIO_SICU_MIN WHERE
(CODICE_ARCHIVIO=342))
but mysql doesn't support inner select.
What statement should i use instead of this one ?
Tha
Mensaje citado por: Peter Skipworth <[EMAIL PROTECTED]>:
> fulltext is now a reserved word - either change the name of the field,
> or use quotes when refering to it.
>
> [EMAIL PROTECTED] wrote:
>
> > Hi! I just upgraded from 3.22.26a to 3.23.33. We've got a
> database
> > that has a tabl
>Description:
Hi,
I have 28 linux boxes configured identically, 27 as slaves, one as
master. On all 27 slaves, everything works fine, but only on one I have strange
errors in the logs:
011002 17:49:49 Slave: received 0 length packet from server, apparent master
shutdown: (0)
011002 1
Hello,
Are there any obvious reasons why
mysql -h localhost
works and
mysql -h 127.0.0.1
does not.
It says : ERROR 2003: Can't connect to MySQL server on '127.0.0.1'
(110)
/etc/hosts contain :
127.0.0.1 localhost
as a first line.
--
Best regards,
Alex
Dear Sirs,
My MySQL is not configured properly...
I can connect using localhost with -h flag , but when I'm using IP
instead of hostname it doesn't connects at all...
What'd I do?
Thank you.
-
Before posting, please check:
Yours,
Alex Duras.
RESUME
Alex Duras
7A Grygorenko St., apt.83
02068 Kyiv, Ukraine
phone: +380 44 572 4082
email: [EMAIL PROTECTED]
Objective
Yours,
Alex Duras.
RESUME
Alex Duras
7A Grygorenko St., apt.83
02068 Kyiv, Ukraine
phone: +380 44 572 4082
email: [EMAIL PROTECTED]
Objective
envoyer à qui
vous voulez par simple Email. Cest ça Internet !
Bref, une vrai ressource pour séclater entre potes et bien se marrer.
Aurez-vous le courage de cliquer ici ?
http://www.sexportail.com/
100% des gagnants ont essayé...
Alex.
Un ami qui vous veut vraiment du bien
oto")->Value=btmp;
...
pRecordset->Fields->GetItem(L"src_ip")->Value=btmp;
}
The fields "id" and "proto" are numeric, the field "src_ip" is char. And I
get the above error while updating the "src_ip" field. Do you have any
ideas?
ed in privilege tables - I checked.
But when trying:
mysql_real_connect(db,"localhost",MY_USER,MY_USER_PASSWD,"my_database",0,"",0);
I get and error message "Access denied to user MY_USER@localhost (Use
password=YES)"
What's going bad?
Alex
--
Hi ppl!
I've a strange problem - I'm creating HEAP-type table and filling it
with the result of select query from a relatively big table
(containing ~2187000 records).
The resulting error message is the following "Got error code 127 from
table handler"
And that's all :0)
I'm just wondering what
Sinisa Milivojevic wrote:
>
> Hi!
>
> I made an error in my previous message. All three instances should be
> like this:
>
> connX = mysql_init(NULL);
> if (!mysql_real_connect(connX, ip2, user2, pass2, db2, 0, NULL, 0))
> error .
>
By the way it seems to me that in 3.23.XX series mys
directory /usr/var/mysql/xyz
Hope this helps.
Thanx
Alex
On 4/18/06, hicham <[EMAIL PROTECTED]> wrote:
>
> On 4/18/06, Dominik Klein <[EMAIL PROTECTED]> wrote:
> > hicham schrieb:
> > > Hello
> > > I'm new bie user of mysql, I need to create a dat
olumn user_id .
mysql> SELECT logs.*, users.username
> -> FROM logs JOIN users ON users.id = logs.id
> -> WHERE user_id = (SELECT id FROM users ORDER BY username);
> ERROR 1242 (21000): Subquery returns more than 1 row
again replace = by in.
Hope this helps.
Thanx
Alex
the state
"sending data". With the current setup data seems to go up and down the
network stack for sending data to a client on the same host. Can this be
short circuited somehow for better performance.
Thanx
Alex
of this is that a binary package was previously
available (3.51.9 or 10 I think), that had all of these things in it,
but I don't seem to be able to find it anymore on the servers.
Any help most gratefully taken.
Alex
--
Thurgood Alex <[EMAIL PROTECTED]>
Cabinet Michel Richebourg
--
I'd like their amount of
gold to go up by 1 (or say a variable say $goldupdateamount).
I'd like to know which would be the best way of doing this, and if there is
a command in mysql which would achieve this.
Regards,
Alex.
--
MySQL General Mailing List
For list archives: http:/
count(*) is slow in innodb due to Multi Versioning. Which table type are you
using ?
Thanx
Alex
On 6/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi everybody,
MySQL 5.0.21 running on RedHat EL4, 2GHz CPU, 2,5GB RAM, RAID5/128MB
RAM. At one point I had to issue the following quer
How do backup at the client side?
I don't have an account, nor a shell on the server
side. When I give the path, it thinks it is the path
on the server. How do I tell mysql that it is a path
on the client side?
thanks,
ble2 via a drop down list that executes a select SQL statement on the
list of values present in field2. That way, the user can choose the
value they want. I'm using a button activated macro to try and generate
a new reference, but I'm failing with the necessarySQL command.
Any hel
mysql standard versions, and on another occasion when
I deleted the idb files because I didn't know what they were and why
they were so big compared to the data I actually had in my tables.
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lized that you could insert
non-contiguous values into an auto_increment column and maintain the
increment integrity.
Thanks a lots for your reply,
Alex
--
Thurgood Alex <[EMAIL PROTECTED]>
Cabinet Michel Richebourg
--
MySQL General Mailing List
For list archives: http://lists.my
Regards,
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ties
WHERE Assignment_ID=$row['Assignment_ID']
ORDER BY Date DESC LIMIT 10) AS tblTemp
ORDER BY Date ASC
This works perfectly on 4.1. How can I rewrite this to get the same
effect without using a subquery and so allow it to work on 4.0?
Any help gratefully recieved!
Alex
--
MySQ
[EMAIL PROTECTED] wrote:
Alex Gemmell <[EMAIL PROTECTED]> wrote on 11/30/2005 10:06:09 AM:
Hi,
Unfortunately I need to use a query on an old MySQL (4.0.xx) and the one
I currently have uses a subquery. So it works on my 4.1 but not with
this 4.0. I have read in the MySQL manual
Dan Nelson wrote:
In the last episode (Nov 30), Alex Gemmell said:
I tried splitting up the queries to see if it helped but it didn't
work either:
[PHP]
$query1 = "CREATE TEMPORARY TABLE tmpSubquery
SELECT * FROM tblactivities
WHERE Assignment_ID='"
rouvas wrote:
On Wednesday 30 November 2005 18:11, Alex Gemmell wrote:
[EMAIL PROTECTED] wrote:
Alex Gemmell <[EMAIL PROTECTED]> wrote on 11/30/2005 10:06:09 AM:
Hi,
Unfortunately I need to use a query on an old MySQL (4.0.xx) and the one
I currently have uses a subquery. So it
Michael Stassen wrote:
Alex Gemmell wrote:
Thanks Shawn but I couldn't seem to get this to work.
I made the point of checking the MySQL User that PHP connects with. I
gave it CREATE and DROP privilages on the database schema in question.
It previously only had SELECT privilages.
Alex Gemmell wrote:
> Thanks Micheal - yeah, I managed to figure out the CREATE_TMP_TABLE
privilage problem myself.
I should have used those "die on errors" too - will do next time!
To recap here's the working final solution (after MySQL User has
CREATE_TMP_TABLES a
-+
| Variable_name | Value |
+++
| Bytes_received | 1718034415 |
| Bytes_sent | 2783965287 |
+++
2 rows in set (0.00 sec)
This will give you an incrementing value that you can plot on a graph
using MRTG (www.mrtg.org) or similar.
-- Alex
--
MySQL General
etween NOT NULL and default
values; I would be very grateful if someone could confirm what the issue is
and suggest a way of solving it (the dump is 500mb, so any manual fix is not
a lot of use!)
With many thanks,
Alex Davies
ql4 builds from source, which include
the documented server-specific file listed after /etc/my.cnf
How can I get mysql5 to use a server-specfic options file? Am I
missing a configure option or defines for mysql5?
Thanks,
Alex
--
--
MySQL General Mailing List
For list archives: http://lists
On Mon, 13 Mar 2006 16:52:03 + (GMT)
[EMAIL PROTECTED] wrote:
>
> Hi Alex. It seems that mysqld and all the client
> programs insist on reading /etc/my.cnf first.
>
> To overide this behaviour for a particular instance of
> mysqld you need to pass the --defaults-
s defined in the
global file. None of the options from the server-specific my.cnf are
returned. This is not the way 4.1, and probably earlier, works.
Thanks,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
For embedded server do I need to configure
--with-embedded-privilege-control?
It looks like stored procedure is looking for mysql.proc table.
Thanks.
Anyone knows how to figure out the mysql basedir string using Autoconf and
then pass it to Automake for an embedded application?
Thanks in advance,
-Alex
In mysql embedded server 6.09 built from source for Linux 2.6.27.11
kernel.
First create a connection (mysql_real_connect) then close the connection in
a different thread.
This causes a SIGSEGV crash in THD:store_globals ( ). My mysql embedded
library is thread-safe.
Thanks in advance,
-Alex
Hi,
What is the size of MYSQL_TYPE_LONG in a 64bit machine? I am trying to save
pointers. If this type is 4 bytes on a 32bit machine and 8 bytes on a 64bit
machine will make it much easier.
Thanks,
-Alex
is the error code?
Thanks,
-Alex
On Tue, Apr 7, 2009 at 11:17 AM, Martijn Tonies wrote:
> Alex,
>
> Please respond to the list instead of my personal address.
sorry I thought i was.
>
>
>
> Nevertheless, if MYSQL_TYPE_LONG is the datatype for a table field,
> it would always -have- to be the same size,
an application
C/C++ function from mysql stored procedures?
Thanks in andvance!
Alex
Hello Martin,
This sounds great! I am not sure if plugins are supported for the
embedded mysql applications. Meaning that my application is linked with the
libmysqld not libmysql. Do you know the answer?
Thanks,
Alex
On Mon, May 18, 2009 at 10:17 AM, Martin Gainty wrote:
> yes if
Hello,
Would anyone know how to load data infile into a temporary table?
Thank you,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
u can load data infile into table without specifying the schema
of this table but it does not look like you can do load data infile
into a temporary table.
Thank you,
Alex
2009/5/19 Janek Bogucki :
> Hi,
>
> mysql> create temporary table t(i int);
>
> mysql> \! echo 1 > /t
e_name=NULL
ELSEIF STRCMP(NEW.Variable_name, 'ASN') != 0 THEN
set NEW.Value=CONVERT(CONVERT(NEW.Value, UNSIGNED), CHAR);
ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN
set NEW.Value=INET_NTOA(INET_ATON(NEW.Value));
ENDIF
END
Thanks in advance!
Alex
Hi Folks,
I am getting syntax error with the mysql signal. I have a trigger
that needs a signal for raising an error condition if a row with
specific value is removed.
CREATE TRIGGER my_trig BEFORE DELETE ON my_tbl
FOR EACH ROW BEGIN
DECLARE mysig CONDITION FOR SQLSTATE '45000';
> DECLARE divide_by_zero CONDITION FOR SQLSTATE '22012';
> IF divisor = 0 THEN
> SIGNAL divide_by_zero;
> END IF;
> END
>
> Methinks someone forgot to include this feature in the release!
>
>
> -Original Message-
> From: Alex Katebi [mailto:alex.
Anyone knows where I can download the 6.0.11 gziped source from?
Hi,
I noticed that the 6.11 branch is not available for download anymore. Did
they rename it to 5.4?
Thanks,
-Alex
you might be interested in this:
http://simplegeo.ksikes.net
https://github.com/alexksikes/simplegeo
On Mon, Feb 7, 2011 at 7:29 AM, Sander de Bruijne wrote:
>
> http://www.geonames.org/
>
> http://download.geonames.org/export/dump/?C=S;O=D
>
>
> On 02/02/2011 11:30 AM, viraj wrote:
>>
>> dear l
second
query to the get the record id, but how would I easily reposition the
browse listing back in date order on the record found in the second query?
Thanks,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
int n_fields = mysql_num_fields(result);
MYSQL_FIELD *fields = mysql_fetch_fields(result);
int i;
for (i = 0; i < n_fields; i++) {
printf("%s: %d\n", fields[i].name, fields[i].type);
}
mysql_free_result(result);
mysql_close(conn);
}
Unfortunately the decision to run 32-bit libs on 64-bit systems is outside
of my control. Given that it *should* work I'm more interested in
diagnosing whether this is a bug of some sort in libmysqlclient or a bug in
my code/build procedure.
Alex
On Sat, Jun 4, 2011 at 10:06 AM, walter
ize already, but I don't think it affects the current query.
What can I generally do to actually make this perform?
Thanks,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On 2011/07/19 09:52 PM, andrewmchor...@cox.net wrote:
Hello
I am about to create a database in mysql. I would like to be able to import
some dbase3 (.dbf) files into the tables I will be defining. What is the
easiest way to import the table. Is there software that can be downloaded that
will
the field to be cleared if the server loses the connection to
the client. How would I do this, or is there an alternative?
Thanks,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
If you have a table with columns A & B, and might do a where on A or B,
or an order by A, B, would single column indexes on A and B suffice or
would performance on the order by query be improved by an index on A,B?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
On 2011/10/11 02:22 PM, Rik Wasmus wrote:
Just to clarify having key indexes of (a,b) or (b,a) have no difference ?
They DO.
See it as lookup table which starts with 'a' in the first case, and 'b' in the
second one. Looking for anything that matches 'b' for an index (a,b) requires
a full scan
On 2011/10/11 02:30 PM, Alex Schaft wrote:
On 2011/10/11 02:22 PM, Rik Wasmus wrote:
Just to clarify having key indexes of (a,b) or (b,a) have no
difference ?
They DO.
See it as lookup table which starts with 'a' in the first case, and
'b' in the
second one. Looki
,
but the lines are as much as 16k long in the text file times about 110
of those for one huge insert statement.
What can I pass to mysqldump to get more sane statement lengths?
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
On 2011/10/20 10:53 AM, Alex Schaft wrote:
What can I pass to mysqldump to get more sane statement lengths?
+1 for extended-inserts...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On 2011/10/20 11:54 AM, Johan De Meersman wrote:
- Original Message -
From: "Alex Schaft"
I'm monitoring a mysqldump via stdout, catching the create table
commands prior to flushing them to my own text file. Then on the
restore side, I'm trying to feed these to mysq
On 2011/10/20 03:43 PM, Johan De Meersman wrote:
- Original Message -
From: "Alex Schaft"
I realize that, I'm just trying to stop the phone calls saying "I
started a restore, and my pc just froze"
I might just read all the single insert lines, and get a wh
On 2011/10/21 10:26 AM, Johan De Meersman wrote:
- Original Message -
From: "Alex Schaft"
Got my app reading in a dump created with extended-inserts off, and
lumping all of the insert statements together. Works like a charm
Just for laughs, would you mind posting the on-di
to do
the most processing, with the second one being faster, or would both
have to do the same amount of work?
Thanks,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On 2012/02/09 01:40 PM, Johan De Meersman wrote:
- Original Message -
From: "Alex Schaft"
If I were to do a select count(*) from x where y prior to doing
select * from x where y to get a number of records, how would this impact
performance on the server itself? Would the firs
ch of these,
or should I do a batch INSERT with ON DUPLICATE KEY UPDATE?
Going to try both ways now, but was wondering what would be the best
"internally" my instincts tell me the latter.
Thanks,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On 2/14/2012 10:30 AM, cars...@bitbybit.dk wrote:
On 14.02.2012 10:20, Alex Schaft wrote:
Hi,
I need to update a table along the lines of the following
update table set LastUpdate=now(), UpdateSource='Abc' Where Key1 = 'Def'
and Key2 = 'ghi'
I need to possib
I suppose an easier way is to have a getrow function, Something like
while ($row = getrow($RS) {
.
.
.
}
function getrow($RS)
{
if ($current_server_is_mysql)
{
return mysql_fetch_assoc($RS);
}
els
1 - 100 of 421 matches
Mail list logo
