2009/10/23 Jeff j...@platinumsynergy.com:
I currently have a query like so:
SELECT p.fldId, p.fldFName, p.fldLName, p.fldEmail, p.fldPhone, p.resellerId,
d.timezoneId, d.bestTime, d.lastDate, d.lastTime, d.lastConnected FROM
tblProspects as p LEFT JOIN tblProspectsDetails as d ON
I currently have a query like so:
SELECT p.fldId, p.fldFName, p.fldLName, p.fldEmail, p.fldPhone, p.resellerId,
d.timezoneId, d.bestTime, d.lastDate, d.lastTime, d.lastConnected FROM
tblProspects as p LEFT JOIN tblProspectsDetails as d ON d.prospectId = p.fldId
WHERE p.uId = 46437 ORDER BY
Dear all,
Benetl, a free ETL tool for files using MySQL, is out in version 3.2.
This new version is now supporting Java SE 6 and using memory arguments
for JVM.
You can freely download it at : www.benetl.net
You can learn more about ETL tools at:
http://en.wikipedia.org/wiki/Extract
Dear all,
Benetl, a free ETL tool for files using postgreSQL and MySQL, is out in
version 3.2.
You can freely download it at : www.benetl.net
This new version is now supporting Java SE 6 and using memory arguments
for JVM.
You can learn more about ETL tools at:
http://en.wikipedia.org
Listing? Why does it matter? Well it makes your indexes disasterously
bloated:
KEY `index_addresses_on_parent_city_id_and_addressable_type`
(`parent_city_id`,`addressable_type`),
If you noticed in the explain plan, that index is 733 bytes *per row*.
Especially using utf8 means each character
, that index is 733 bytes *per row*.
Especially using utf8 means each character takes 3 bytes in the index.
That's terrible. That type field should be a foreign key tinyint or at the
very least be a much much shorter varchar field (such as 8 or 10)
You have lots of those varchar(255) fields, which
Dear all,
Benetl, a free ETL tool for files using postgreSQL (and now MySQL), is
out in version 3.1.
A small correction has been done to Benetl 3.1.
This is now available online.
You can freely download it at : www.benetl.net
This new version brings the support of long as date.
Benetl
than 2ms), but
selecting the latest listing within a city is REALLY slow (10-20 seconds)
despite being almost a subset of the event query.
I have been working on this for about a day, and have tried all sorts of
tweaks to the indexes but to no avail. I always seem to end up with 'using
temporary
Dear all,
Benetl, a free ETL tool for files now using MySQL is out in version 3.1.
You can freely download it at : www.benetl.net
You can learn more about ETL tools at:
http://en.wikipedia.org/wiki/Extract,_transform,_load
Thanks for your interest.
Regards,
--
Benoît Carpentier
Hi,
Part of our road map is to use an open source database besides commercial
databases (oracle and sql server), we need to select an open source database
to build the necessary skills for administration and operation.
Then we would put guidelines on which applications should use open source
strongly encourage having a good
look at Postgresql. In my opinion, it is better suited for a commercial
database environment than mysql.
If you are curious, join the Postgresql general mailing list and watch the
traffic for a couple days, see what others are using it for.
Colin
--
MySQL
Dear all,
Benetl, a free ETL tool for files now using MySQL is out in version 3.0.
You can freely download it at : www.benetl.net
You can learn more about ETL tools at:
http://en.wikipedia.org/wiki/Extract,_transform,_load
Thanks for your interest.
Regards,
--
Benoît Carpentier
pagination and the rownum.
I know in mysql there is support for sql using the LIMIT clause, but the
LIMIT seems to take 2 arguments, the first one being the start rownum and
the second being the number of rows to output. I need the second to be the
to rownum. I have done a lot of googling, but apart
there is support for sql using the LIMIT clause, but the
LIMIT seems to take 2 arguments, the first one being the start rownum and
the second being the number of rows to output. I need the second to be the
to rownum. I have done a lot of googling, but apart from just putting a
rownum for the sql output
in mysql there is support for sql using the LIMIT clause, but the
LIMIT seems to take 2 arguments, the first one being the start rownum and
the second being the number of rows to output. I need the second to be the
to rownum. I have done a lot of googling, but apart from just putting a
rownum
Hi,
I am using a technique described here at:
http://forums.mysql.com/read.php?20,227102,227102#msg-227102
To make results Random before applying the GROUP BY method.
The query to my table structure is this:
SELECT r.physicians_id,
(SELECT r1.id FROM physicians_images r1 WHERE
(r.physicians_id
?
Are we talking half a second, ten-seconds, 20 minutes?
It depends. Long-running queries will block FLUSH TABLES WITH READ
LOCK, if you're using it, which will in turn block other queries. So
FLUSH TABLES WITH READ LOCK itself can take a long time. If you're
using only InnoDB tables you don't
We have a 20 gig db (that includes the MYIs and MYDs and FRMs).
We are wondering how long LVM snapshots take.. in that how long might
the DB be read-locked? Do we have to read-lock it and flush tables?
Are we talking half a second, ten-seconds, 20 minutes?
Currently, when we copy the raw files
Hi Tim,
We use LVM snapshots all the time. They are essentially
instantaneous with our 90GB innodb database files.
A command to generate the snapshot could be:
sudo /usr/sbin/lvcreate --snapshot --name mysqlsqlbackup --size 15G /
dev/system/data01
Please let me know if you have any
What we do to start is the following:
) open 2 windows to the server running the mysql instance
) in one window,
) run the mysql cli and issue command 'flush tables with read lock'
) stop the slave, if this is a running slave
) run either show master status or show slave status,
Little, Timothy wrote:
We have a 20 gig db (that includes the MYIs and MYDs and FRMs).
We are wondering how long LVM snapshots take.. in that how long might
the DB be read-locked? Do we have to read-lock it and flush tables?
Take a look at mylvmbackup which takes care of flushing tables,
is it using /tmp? How much free space
do I need on /tmp? Can/should I make the server use a different location
instead of /tmp?
Thanks,
Mike Spreitzer
On Thu, Jun 11, 2009 at 8:51 AM, Mike Spreitzer mspre...@us.ibm.com
wrote:
I find my MySQL Community Edition 5.1.34 server running out of space on
/tmp (which is indeed small). Why is it using /tmp? How much free space
do I need on /tmp? Can/should I make the server use a different
This might help:
http://dev.mysql.com/doc/refman/5.1/en/temporary-files.html
On Jun 11, 2009, at 12:51 AM, Mike Spreitzer wrote:
I find my MySQL Community Edition 5.1.34 server running out of space
on
/tmp (which is indeed small). Why is it using /tmp? How much free
space
do I need
(*) from my_connect
It takes 1 minute to return while doing the same query by explicitly
using directly the select states above without the VIEW return after 1
second.
Can it be that the VIEW doesn't work with the tables indexes or
something like that?
Regards, Yariv
--
MySQL General
to return while doing the same query by explicitly using
directly the select states above without the VIEW return after 1 second.
Can it be that the VIEW doesn't work with the tables indexes or something
like that?
Mysql's view optimization is very rudimentary. If it can trivially
substitute
I find my MySQL Community Edition 5.1.34 server running out of space on
/tmp (which is indeed small). Why is it using /tmp? How much free space
do I need on /tmp? Can/should I make the server use a different location
instead of /tmp?
Thanks,
Mike Spreitzer
We are using mysqld_multi to start three instances, the command /usr/
bin/mysqld_multi --config-file=/etc/my.cnf start 1-3 works just fine.
But when I tried to put that in rc.local only 3306 would start. Ok
fine.
So I created 3 scripts that I put in /etc/init.d called mysqld1, 2,
and 3
Yeah, please show us the source code of yours.
On Wed, Apr 15, 2009 at 4:10 PM, Venu Gopal neo.v...@gmail.com wrote:
Hi guys,
I am using stored procedures and stored functions for the first time.
And currently stuck at a this point where. I am unable to retrieve
results returned by stored
Hi guys,
I am using stored procedures and stored functions for the first time.
And currently stuck at a this point where. I am unable to retrieve
results returned by stored function using MySql C API.
Kindly let me know how to do so. In case you need details I'll share
the source code.
Cheers
AFAIK, repeated LIKEs.
On Tue, Mar 24, 2009 at 6:24 AM, Yariv Omer yar...@jungo.com wrote:
Hi
when I am using a query for several field's values I am using the following
query:
Select field from table where in ('11', '22')
I need to do a LIKE search (not exact match but like match)
How
Hi
when I am using a query for several field's values I am using the
following query:
Select field from table where in ('11', '22')
I need to do a LIKE search (not exact match but like match)
How can I do it
Thanks, Yariv
--
MySQL General Mailing List
For list archives: http
`campaign_date` (`campaign_date`),
KEY `campaign_name` (`campaign_name`)
) ENGINE=MyISAM AUTO_INCREMENT=1415388 DEFAULT CHARSET=utf8
`temp_del_ids` has 81 records; `cust_campaigns` has 1052796. Here's my
puzzlement. I checked out two queries, and I don't understand why one of
them is using an index only on my
as you say you need recursion to build the tree from the table.
if you are interested just in all the employees that are not manager with
their manager info.
select * from emp e1 inner join emp e2 on e1.uidman=e2.uid;
cheers
Claudio
2009/3/10 Ali, Saqib docbook@gmail.com
Hello,
I
Hello,
I have following simplistic DB representing a hierarchy:
++--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| uid| int(10) | NO | PRI | 0 | |
|
How can I do some recursion to get the UIDs of all the employees
reporting up to a manager, regardless of how deep the tree is. I can
do this usindg LDAP and/or PHP, but not sure how to do it as a mysql
query.
Examples discussion at
On Tue, Mar 3, 2009 at 6:51 PM, Perrin Harkins per...@elem.com wrote:
My guess would be that your table is too small to bother using an
index on. There's some information in the MySQL docs about when it
chooses to use an index. For small tables, using one makes the query
slower.
I think
I'm using MySQL 5.0.67-0ubuntu6.
I'm stepping through MySQL - 4th Edition. There's a simple table called
member that we've just added an index to, for the expiration column,
which is a date column.
The current example in the book is:
mysql EXPLAIN SELECT * FROM MEMBER
- WHERE expiration
My guess would be that your table is too small to bother using an
index on. There's some information in the MySQL docs about when it
chooses to use an index. For small tables, using one makes the query
slower.
- Perrin
On Tue, Mar 3, 2009 at 7:58 PM, David Karr davidmichaelk...@gmail.com wrote
hi,
It seems that mysql will call write interfaces(eg. bulk_update_row
ha_update_row ...) of HANDLER before writing a binlog.
Does this mean the time when binlog is written actually vary from
engine to engine?
Thank you.
--
MySQL General Mailing List
For list archives:
Hi list,
I'm wondering what the cost (if any) is by using eg. mediumtext
over text, or largetext over mediumtext. Is there a non-negligible
reason to not just just largetext?
And how about varchars, what's the cost of using varchar(1000)
rather than varchar(20)?
My intuition tells
,
I'm wondering what the cost (if any) is by using eg. mediumtext
over text, or largetext over mediumtext. Is there a non-negligible
reason to not just just largetext?
And how about varchars, what's the cost of using varchar(1000)
rather than varchar(20)?
My intuition tells me that I should
Backing up MySQL using file system snapshots
http://forge.mysql.com/wiki/Backing_up_MySQL_using_file_system_snapshots
This Thursday (February 26th, 14:00 UTC), Lenz Grimmer will give a MySQL
University session on Backing up MySQL using file system snapshots. Lenz
is a member of the MySQL
Hi,
I am using MySQL 5.0.51a. I've got a problem with a stored function. It
reads as follows:
CREATE FUNCTION `_contractRoot`(temp INT) RETURNS int(11)
READS SQL DATA
BEGIN
DECLARE _parent_id INT;
REPEAT
SET _parent_id = temp
On Mon, Feb 9, 2009 at 6:10 PM, Lucio Chiappetti lu...@lambrate.inaf.itwrote:
I used to make Unix soft links of mysql tables back on mysql 3.23.
[...]
But I wonder if there is anything intrinsically wrong in the usage of
soft-links, or whether this might be an indication instead of
Using DTrace with MySQL
http://forge.mysql.com/wiki/Using_DTrace_with_MySQL
This Thursday (February 12th, 14:00 UTC), MC Brown will give a MySQL
University session on Using DTrace with MySQL. MC has been involved not
just with documenting DTrace but also with DTrace development; see his
recent
Hi
I am able to create an updatable view using a subquery in MySQL 5.1.29
mysql CREATE VIEW v_aa AS
- SELECT *
- FROM flight AS f
- WHERE f.RouteID IN
- (SELECT r.RouteID
- FROM route AS r
- WHERE r.To=
- (SELECT a.AirportID
- FROM
Hi!
On Mon, Feb 9, 2009 at 7:17 AM, blue.trapez...@gmail.com wrote:
Hi
I am able to create an updatable view using a subquery in MySQL 5.1.29
mysql CREATE VIEW v_aa AS
- SELECT *
- FROM flight AS f
- WHERE f.RouteID IN
- (SELECT r.RouteID
- FROM route AS r
On Mon, Feb 9, 2009 at 1:17 PM, blue.trapez...@gmail.com wrote:
mysql CREATE VIEW v_aa AS
- SELECT *
- FROM flight AS f
- WHERE f.RouteID IN
- (SELECT r.RouteID
- FROM route AS r
- WHERE r.To=
- (SELECT a.AirportID
- FROM airport AS a
so that a soft-link clone of the table comes into existence.
Then I have cases where I do queries on x left join xdup (or on
some other table left join x left join xdup). I never perform any
update, insert or delete on xdup.
I know I could do a query on the same table using
Your subquery is not in the select list, it is in the where. A
subquery in the select list would be:
CREATE VIEW v_aa AS
SELECT
*
, (SELECT MAX(x) FROM y) AS z
FROM flight
This is not updatable because there is no sensible way to propagate
changes to the y base table.
Great catch
My objective is to have all Windows XP workstation (300+) report their
activities using mysql client that exports in CSV format to our Active
Directory's MySQL server. Is it possible to install just the MySQL client over
GPO, is this possible?
Thanks,
Scott Hamm
Technology Coordinator
MOT
I have a query that runs very slow and using Using temporary; Using
filesort. Is there a way to avoid them using current table structure?
Goal with the query is to find ads (ad_id) that have tags (tag_id) connected
to them, order by antal is used to get the most relevant first. ( the one
One optimization I see quickly is changing the left join to an inner join.
You always look for records that exist in tag_ad_map (by checking for
tm.is_active) so the left join is not necessary. That should at least speed
this query up considerably.
Walter
Need MySQL advice?
OlinData.com is the
hi all,
We have a c application who work perfecty with mysql 5.0. We decide to
upgrade and use mysql 5.1.
Since that, nothing work, in owr log, we have always the follonig
error Using unsupported buffer type: 254 (parameter: 2) when we
call the mysql_stmt_bind_result function
what we do
at the SQL level (using the PREPARE statement)
and those processed using the binary client-server protocol (using the
mysql_stmt_prepare() C API function).
Kind regards,
Walter Heck
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
computer. (so my computer never seen
mysql)
after taht, I downloaded the 5.1 mysql installer
http://dev.mysql.com/downloads/mysql/5.1.html#win32
install it configure the server and then try my test and ... Using
unsupported buffer type: 254 (parameter: 2)
I made other test (with number
Not really, the query took 4-5 seconds. The query runs through 13910 rows
according to explain, that isnt alot is it?
SELECT COUNT(*) antal,ad.ad_id FROM ad
INNER JOIN tag_ad_map tm ON tm.ad_id=ad.ad_id
WHERE
tm.tag_id IN (99, 10807, 20728, 21, 135)
AND ad.is_removed = 0 AND ad.is_active=1
--
From: Walter Heck li...@olindata.com
Date: Wed, Jan 14, 2009 at 1:08 PM
Subject: Re: Upgrage MYSQL 5.0 to 5.1 :: Using unsupported buffer type
To: elekis ele...@gmail.com
As I said before: carefully read
http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-5-0.html :0
Kind regards
Did you re-compile/re-link your C app with the new MySQL header files?...
Sounds like you didn't.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
oki, I found, it's the dll in system32 who was not suppress.
thanks for all
a++
On Wed, Jan 14, 2009 at 4:27 PM, c...@l-i-e.com wrote:
Did you re-compile/re-link your C app with the new MySQL header files?...
Sounds like you didn't.
--
MySQL General Mailing List
For list
restart of the server.
The MySQL config file is very standardized and would not be hard to deal
with.
I also first thought of using the config file, but I have time
constraints, that's the reason I asked about any command line option.
Please don't take this the wrong way, I hate to discourage
Hi everybody,
I am working on a small GUI tool for managing MySQL server.
I would like to include one functionality to change the port number of
the server and restart the server just after the change took place. Is
there any command line tool which I can use to change the port number?
e.g.
lists-mysql wrote:
in a *nix environment, restarting the mysql server is done with a
system-level command and requires *system* root privileges, not
something that the average db-admin is likely to have. also,
changing the port a service is listening on has potentially serious
implications as
know what language you're using, but
there's lots of libs available for perl and python to do this easily.
I hopt this helps.
-Micah
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
the client and the server, using the same
certificate authority certificate, is there one set of public-private
keys where the server's private key is the client's public key and the
server's public key is the client's private key ? Or are there actually
two distinct sets of public-private keys, one each
Due to illness, the MySQL University session Using DTrace with MySQL
has been moved to February 12th, 2009. Sorry for the short notice (blame
it on the flu which came on short notice, too
between the client and the server, using the same
certificate authority certificate, is there one set of public-private
keys where the server's private key is the client's public key and the
server's public key is the client's private key ? Or are there actually
two distinct sets of public-private
This Thursday (December 18th), Martin MC Brown will talk about using
DTrace with MySQL.
The session will start at 14:00 UTC / 8am CST (Central) / 9am EST
(Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow).
Note that we'll be using a new session address / Dimdim URL:
http
I have a server that I've been using as a MySQL Slave for a while now. I
want to change it over to a regular server now. I could simply stop the
slave (STOP SLAVE), however, I'm concerned that if I re-boot the server,
then it'll re-start the slave. What else do I need to do to stop using
Hi Jesse,
Just add 'skip-slave-start' to your configuration file, restart there you
go.
Best regards,
Amit Sharma
On Tue, Nov 25, 2008 at 7:12 PM, Jesse [EMAIL PROTECTED] wrote:
I have a server that I've been using as a MySQL Slave for a while now. I
want to change it over to a regular
stop slave;
reset slave;
restart mysql server
On Tue, Nov 25, 2008 at 7:12 PM, Jesse [EMAIL PROTECTED] wrote:
I have a server that I've been using as a MySQL Slave for a while now. I
want to change it over to a regular server now. I could simply stop the
slave (STOP SLAVE), however, I'm
stop slave;
reset slave;
Krishna Chandra Prajapati wrote:
stop slave;
reset slave;
restart mysql server
On Tue, Nov 25, 2008 at 7:12 PM, Jesse [EMAIL PROTECTED] wrote:
I have a server that I've been using as a MySQL Slave for a while now. I
want to change it over to a regular server now
: Wednesday, November 26, 2008 12:58 AM
To: Krishna Chandra Prajapati
Cc: Jesse; mysql@lists.mysql.com
Subject: Re: Stopping using a server as a slave
stop slave;
reset slave;
Krishna Chandra Prajapati wrote:
stop slave;
reset slave;
restart mysql server
On Tue, Nov 25, 2008 at 7:12 PM, Jesse
Tompkins Neil wrote:
Hi
We are looking to upgrade our version of mySQL to the latest version of
mySQL 5. One of the main features we are going to think about using is
replication for our website data. Basically we have 2 websites located in
the UK and US which share similar information, and we
Date: Mon, 17 Nov 2008 10:16:16 +
From: Tompkins Neil [EMAIL PROTECTED]
Subject: Using Replication in mySQL version 5
We are looking to upgrade our version of mySQL to the latest version of
mySQL 5. One of the main features we are going to think about using is
replication for our website
-S 5.1 replication configs running okay for a while
-Original Message-
From: Tompkins Neil [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2008 2:16 AM
To: [MySQL]
Subject: Using Replication in mySQL version 5
Hi
We are looking to upgrade our version of mySQL to the latest
are going to think about using is
replication for our website data. Basically we have 2 websites located in
the UK and US which share similar information, and we are going to be using
replication as a way of keeping the data up to date and in sync.
Based on your experiences, is there anything we
open to hear your suggestions for other topics.
We'll be using the Dimdim conferencing system for this session. Dimdim
has integrated voice streaming and chat. To attend, you need a browser
with a recent Flash plugin. You may register a Dimdim account but you
don't have to. The virtual meeting room
Hi
We are looking to upgrade our version of mySQL to the latest version of
mySQL 5. One of the main features we are going to think about using is
replication for our website data. Basically we have 2 websites located in
the UK and US which share similar information, and we are going to be using
The next *MySQL University* session will take place this Thursday, 23rd
October. David Van Couvering will show how to use NetBeans with MySQL.
Note that this session will start at 9:00 Pacific Time (18:00 CET, 17:00
BST).
For this session, we'll use a new presentation system that we hope will
I am using WinXP.I am wanted to shutdown MySQL service from the command line
and ran the command mysqladmin -p root shutdown next the root password was
asked for,I entered the correct password, when I entered the password the
below displayed error was the result
mysqladmin: connect to server
Varuna Seneviratna írta:
I am using WinXP.I am wanted to shutdown MySQL service from the command line
and ran the command mysqladmin -p root shutdown next the root password was
asked for,I entered the correct password, when I entered the password the
below displayed error was the result
Hi Varuna,
I think you're missing the -u option (User for login if not current user.)
Try: mysqladmin -u root -p shutdown
(-p without a value indicates to prompt for a password from the terminal.)
Andy
Varuna Seneviratna wrote:
I am using WinXP.I am wanted to shutdown MySQL service from
is denied for [EMAIL PROTECTED], rather than [EMAIL PROTECTED]
Thanks
On Sat, 2008-10-04 at 13:56 +0530, Varuna Seneviratna wrote:
I am using WinXP.I am wanted to shutdown MySQL service from the command line
and ran the command mysqladmin -p root shutdown next the root password was
asked for,I
using WinXP.I am wanted to shutdown MySQL service from the command
line
and ran the command mysqladmin -p root shutdown next the root password
was
asked for,I entered the correct password, when I entered the password the
below displayed error was the result
mysqladmin: connect to server
I have the blocked connection problem between three of my servers, all
behind two firewalls and on one switch.
Occaisionally the mysql servers start blocking the hosts.
What's the downside to running a Flush hosts once per minute on these
mysql servers?
The only hosts that are connecting are
Hank schrieb:
I have the blocked connection problem between three of my servers, all
behind two firewalls and on one switch.
Occaisionally the mysql servers start blocking the hosts.
What's the downside to running a Flush hosts once per minute on these
mysql servers?
better solution:
PROTECTED]
Sent: Tuesday, September 09, 2008 8:49 AM
To: mysql@lists.mysql.com
Subject: Re: Using Flush Hosts in cron
Hank schrieb:
I have the blocked connection problem between three of my servers, all
behind two firewalls and on one switch.
Occaisionally the mysql servers start blocking the hosts
Hank schrieb:
On Tue, Sep 9, 2008 at 11:48 AM, Werner D. [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Hank schrieb:
I have the blocked connection problem between three of my servers, all
behind two firewalls and on one switch.
Occaisionally the mysql servers
Hi,
I've been trying to import a 10G dump file using mysqlimport
and it is eventually failing because it runs out of tmpdir
space -- I get Errcode: 28.
I was surprised that it was using a temp file at all. I've
looked in the documentation and other sources but have not been
able to find
Mysql use tmpdir,
when ever there is any index creation.
regards
anandkl
On 8/21/08, jthorpe [EMAIL PROTECTED] wrote:
Hi,
I've been trying to import a 10G dump file using mysqlimport
and it is eventually failing because it runs out of tmpdir
space -- I get Errcode: 28.
I was surprised
to import a 10G dump file using mysqlimport
and it is eventually failing because it runs out of tmpdir
space -- I get Errcode: 28.
I was surprised that it was using a temp file at all. I've
looked in the documentation and other sources but have not been
able to find anything about this file
Hello,
Couple of questions - experienced MSSQL developer but new to mySQL.
I have 2 servers on a local network. I did a dump from one to its
local drive, and I want to restore it to the 2nd server.
1. is it possible to do this with 3rd party tools such as SQLyog or
EMS Sql Manager? When I try
to the server.
If you have a dump file on the server as in your case, there are a
couple of options:
1. Copy the dump file to the 2nd server and on the 2nd server restore it
using mysql --username=root --password /path/to/dump_file.sql
or
2. Connect to the 2nd server from your first box
Hi All,
I have been using mysql 5.1.26-rc on Linux and configured to log queries
that do not use index through
log-queries-not-using-indexes
I would like to ask two questions, please:
1)
I have noticed that in some cases some queries get logged because a scan of
the index on a field is executed
: MySQLForum MySQLForum [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2008 6:35 AM
To: mysql@lists.mysql.com
Subject: log-queries-not-using-indexes and Using index in the Extra
col of Explain
Hi All,
I have been using mysql 5.1.26-rc on Linux and configured to log queries
that do not use index
PROTECTED]
Sent: Tuesday, July 29, 2008 6:35 AM
To: mysql@lists.mysql.com
Subject: log-queries-not-using-indexes and Using index in the Extra
col of Explain
Hi All,
I have been using mysql 5.1.26-rc on Linux and configured to log queries
that do not use index through
log-queries-not-using-indexes
Hi All,
how to Get file modified time and date of file by using builtin function or
procedure in sql?
Thanks,
Siva
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
which file are u talking about.
regards
anandkl
On 7/24/08, Sivasakthi [EMAIL PROTECTED] wrote:
Hi All,
how to Get file modified time and date of file by using builtin function or
procedure in sql?
Thanks,
Siva
--
MySQL General Mailing List
For list archives: http
301 - 400 of 3107 matches
Mail list logo