>
>> Am 13.09.2016 um 12:13 schrieb Johan De Meersman:
>> - Original Message -
>>> From: "Ryan Coleman"
>>> Subject: Re: MySQL Platform Migration
>>>
>>> Because they want to be belittled by european jackasses online.
>&g
Dear sir,
You do not realize that there aren’t always sys admins on these lists. Your
proven track record of asshole first, kid gloves later drives people away.
Your fight to change mailing lists is one which only you seem to share.
Goodnight.
> On Sep 12, 2016, at 7:27 AM, Reindl Harald wro
Because they want to be belittled by european jackasses online.
On Sep 10, 2016, at 11:56 PM, Reindl Harald wrote:
>
>
> Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal:
>> Is the mysql datafile compatible with different operation system ? I have
>> not done this in the past.
>
> why shouldn'
8.10.2015 um 22:52 schrieb bluethu...@gmail.com:
>> e
>>
>> Sent from my iPhone
>>
>>> On Oct 18, 2015, at 4:12 PM, Daevid Vincent wrote:
>>>
>>> d
>>>
>>>> -Original Message-
>>>> From: ryan.esca...@gmail.co
c
On Fri, Oct 16, 2015 at 3:01 PM, Ryan Coleman wrote:
> b
>
> > On Oct 15, 2015, at 10:07 PM, Dennis Ruiz wrote:
> >
> > a
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe
b
> On Oct 15, 2015, at 10:07 PM, Dennis Ruiz wrote:
>
> a
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
No but there should be. If there's not my task is useless.
Secondly yes. Unique name on it too.
--
Ryan Coleman
Publisher, d3photography.com
ryan.cole...@cwis.biz
m. 651.373.5015
o. 612.568.2749
> On Aug 4, 2015, at 17:33, Wm Mussatto wrote:
>
>> On Tue, August 4, 2015 11
records from /images/ and thusly could be 3000+ from /files/.
How on earth do I do this?
—
Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
opinion, additional steps shouldn't be taken to make MySQL more
secure, instead additional steps should be taken to make it insecure
if that is what is needed in certain environments.
Thank you for the reply.
Ryan
On Tue, Dec 27, 2011 at 4:08 PM, Shawn Green (MySQL)
wrote:
> Hello Ryan
Hi,
Does anyone know why what's done in 'mysql_secure_installation' [0]
isnot part of the default mysql installation?
[0] http://dev.mysql.com/doc/refman/5.0/en/mysql-secure-installation.html
Thank you,Ryan Dewhurst
P.S. I also asked this question on the
forums:http://forums.mys
s not like
to share an app server) and added memcache. So I think we're ripe for another
try.
Thanks again,
Ryan
On Oct 18, 2011, at 5:39 PM, Lydia Rowe wrote:
> You have answered your own question, good sir. Or so I have come to believe.
> Is your primary concern $? Is your organiz
Architecture question I'm having trouble finding an answer to:
I run four WordPress websites. I have mysql setup in a write master/read
replica slave configuration on Amazon. There is one master that all the
WordPress instances write to. I'm trying to figure out how to setup the read
replicas.
` = d ?
Thanks,
Ryan
Hello,
I am setting MySQL (5.0) replication over WAN for backup purpose (with
SSL enabled).
I have read the document:
http://dev.mysql.com/doc/refman/5.0/en/replication.html, and wonder if
any special tunning needed for using replication over WAN.
Are there any configuration parameter(s) need s
According to this document:
http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
It said MySQL support UTF-8 using one to three bytes per character.
But I have created a test table:
-- create table test ( c char(5) ) default charset =utf8;
>From the table status, the data length is alway
Assume MySQL int range (unsigned) is from 0 to 4294967295
There are total 10 digits.
Why a lot of tutorial in the web tell you to declare,
e.g.
CREATE TABLE t1 (f INT(11) UNSIGNED);
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
Hi,
On Tue, Jun 8, 2010 at 12:44 AM, Warren Young wrote:
> The Unicode consortium has stated that Unicode will
> never require more than 21 bits per character[*], and 24 bits is the next
> even multiple of 8 up from that.
Maybe off topic, but just curious...If 3 bytes is enough for all
Unicode
http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
Since MySQL only support BMP, so in fact 16 bit is needed actually?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hey.
Back to few years ago, InnoDB require table level locking when
inserting auto-increment PK to the table, and Heikki said there will
be a fix.
Is this problem still exist now?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
On Sun, Dec 13, 2009 at 11:48 AM, Michael Dykman wrote:
> I hope the only reason this thread is so quiet is because we are all
> busy notifying our friends. There are a hell of a lot more users
> invested in MySQL than those who read this list. Spread the word!
>
Let's stand up today to face t
Hello,
Is it common heard from people that if you have large table (assume
MyISAM in my case), you need large memory in order to have the
key/index in memory for performance, otherwise, table scan on disk is
slow.
But how to estimate how much memory I need?
Consider a simple case, a MyISAM table
h all the non-ascii characters removed, for example.
-Ryan
Darryle Steplight wrote:
Hi Ryan,
MySql does have regular expressions. See Link
http://dev.mysql.com/doc/refman/5.0/en/regexp.html
On Thu, Sep 11, 2008 at 9:52 AM, Ryan Stille <[EMAIL PROTECTED]> wrote:
From looking at the M
e regex in the where clause.
Thanks,
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Sep 4, 2008, at 1:48 PM, Ranjeet Walunj wrote:
Hi ryan.
As pointed by Johnny, it is difficult to give optimization advise
without exactly knowing the performance of your machine.
I'm assuming you are using the machine as Database Server and not
running application (Web/other) o
Variable_name: sort_buffer_size
Value: 67108856
12 rows in set (0.00 sec)
I'll bump innodb_buffer_pool_size to 2G and see how that goes. Thanks
for the tips, if there's additional innodb tuning parameters folks
tend to hit first I'd be glad to try them as well.
--
Ryan S
t follows my sig below...
My devs are adding indexes where the slow query log is pointing them,
but any suggestions on how better to tune things up would be much
appreciated. I'm not sure what else to tune here but we're getting
bursts of 1200+ queries per second regularly and s
Ryan Stille wrote:
Thanks for the help, I rewrote it as a subselect and it deleted all
10K records in two seconds.
DELETE subTable FROM subTable LEFT OUTER JOIN parentTable ON
subTable.parentID = parentTable.ID WHERE parentTable.ID IS NULL
-Ryan
Whoops, I meant that I rewrote it as a JOIN
Thanks for the help, I rewrote it as a subselect and it deleted all 10K
records in two seconds.
DELETE subTable FROM subTable LEFT OUTER JOIN parentTable ON
subTable.parentID = parentTable.ID WHERE parentTable.ID IS NULL
-Ryan
--
MySQL General Mailing List
For list archives: http
gone.
Thinking about it now... its probably the IN clause, isn't it? I've
heard those are slow. Hopefully someone will have a better idea.
Thanks,
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm trying to delete some orphaned records from a table that has about
150K records. Here is my delete:
|CREATE TEMPORARY TABLE deleteids AS (
SELECT subTable.ID from subTable
LEFT OUTER JOIN parentTable ON subTable.ID = parentTable.ID
WHERE parentTable.ID IS NULL
);
DELETE FROM subTable WH
heir own socket
files, or ...
I would settle for a single shared database in which users could create
databases and drop their own databases but not other users'. They'll have
to live with namespace collisions.
Is that possible to do with mysql's permissions?
Thanks.
--Ryan
On
onnect to their own servers instead, and not
have to remember a port number. Like:
mysql -h mysql.username.domain.com -u username -p
and then they'd be pointed at their appropriate instance.
Anybody know how I can do that?
Thanks.
--Ryan
--
MySQL General Mailing List
For
)?Eod>
#master-connect-retry = 60
#replicate-do-db= mydns
#
--
Regards,
Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Y `index_tags_on_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `projects_tags` (
`project_id` int(11) default NULL,
`tag_id` int(11) default NULL,
KEY `tag_id` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
I'm using MySQL 5.0.37. Thanks in advance.
scription, description_clean, options) VALUES\n";
print "($i, 888, 'title $i', 'clean title $i', 'description $i', " .
"'clean description $i', 999);\n"
}
so:
perl newfile.pl > test_records.sql
mysql -p mydatabase < test_records.sql
l-dump-Friday.zip
mysql-dump-Saturday.zip
etc.
Modify to suit your needs.
-Ryan
Brian Dunning wrote:
I have a huge MySQL table, 2.1 million records, 200MB. Once a week I
need to dump it in CSV format and zip the file.
This is not on my server, and it's in production, so I don't want t
Perl would be my language of choice to do something like this.
-Ryan
Thufir wrote:
what would be the quickest, easiest way to import, for example, the rss feed
<http://rss.gmane.org/gmane.comp.db.mysql.general> into mysql?
what would be some different approaches, pls? I'm more in
Is MySQL on each one set to the same time zone?
SELECT@@global.time_zone;
-Ryan
Néstor wrote:
That was interesting. I have 2 rhel 3 servers and they both have been
update to handle the DST. They both yield different results when I
ran the
command:
SERVER=RALPH
d your OS, you need to do that.
-Ryan
Jerry Schwartz wrote:
What version of MySQL are you using? I'm running 4.1.21, and that check
doesn't work even after I've updated (I think) the time zone tables.
I should probably eyeball the output of mysql_tzinfo_to_sql.
Regards,
Jerry
Whats wrong with using the --single-transaction switch for backing up
InnoDB tables? What does the Hot Backup product do that this doesn't?
Thanks,
-Ryan
Juan Eduardo Moreno wrote:
Ananda,
For Innodb the best is Innodb Hot Backup ( www.innodb.com (US$) )
For MyISAM you can use a s
too concerned about them.
-Ryan
Mike Blezien wrote:
Out of curiousity, what should be done if they results are different.
We checked on one of boxes and got two different results:
SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'),
-&g
Ryan Stille wrote:
Paul DuBois wrote:
At 4:40 PM -0600 2/20/07, Ryan Stille wrote:
Is there an easy way to test to see if MySQL already has the proper
tables loaded?
-Ryan
Yes, reload them. :-) After that, they're current! ...
After digging around on the net for a while I fou
Ryan Stille wrote:
Paul DuBois wrote:
At 4:40 PM -0600 2/20/07, Ryan Stille wrote:
Is there an easy way to test to see if MySQL already has the proper
tables loaded?
-Ryan
Yes, reload them. :-) After that, they're current! ...
My timezone tables appear to be empty. At leas
Paul DuBois wrote:
At 4:40 PM -0600 2/20/07, Ryan Stille wrote:
Is there an easy way to test to see if MySQL already has the proper
tables loaded?
-Ryan
Yes, reload them. :-) After that, they're current! ...
My timezone tables appear to be empty. At least the time_zone_nam
Is there an easy way to test to see if MySQL already has the proper
tables loaded?
-Ryan
Paul DuBois wrote:
At 4:17 PM -0600 2/20/07, Paul DuBois wrote:
At 4:36 PM -0500 2/20/07, Sun, Jennifer wrote:
Any answers for the question below ?
Is there a DST patch for MySql 4.0.20? Thanks
er. When
would every column in your table have the same value? (john smith in
your example).
You can programmatically get a list of columns in a table, then when you
are using Perl or PHP or whatever to build your query string, you can
loop through the columns to list them.
-Ryan
--
MySQ
.
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
docs about this the other day.
It said temp tables are always created in memory, but can be moved to
disk if they get too large, or will be created on disk initially if the
table contains a certain type of field (maybe text or binary, can't
remember).
-Ryan
--
MySQL General Mailin
omething for setting
the next auto increment id. Hope this helps.
-Ryan
Daevid Vincent wrote:
http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html
We have recently switched several database tables from MYISM to INNODB, only
to find out this colossal design flaw in InnoDB tab
Maybe I should just be looking at using a HEAP table?
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
running on MSSQL, and we are wondering if we could find any
speed improvements by moving to MySQL, possibly running on a ram disk.
Any input appreciated.
Thanks,
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
slave(s) is/are
doing. The master only writes stuff to the binary log and leaves it at
that.
Anyway, that's my understanding.
Cheers,
Ryan
--
Ryan Tracey
Citizen: The World
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
e time,
I think you even said most of your traffic would be browsing and reading
the listings. So I don't think it would be a problem to build up all
the data in a session and then write it all at once at the end.
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Rithish,
Thank you all for your suggestion, I would definitely give it a shot.
Regards,
Ryan.
On 3/13/06, Rithish Saralaya <[EMAIL PROTECTED]> wrote:
>
> Hello Ryan. I am more of a developer than a MySQL administrator. Hence, I
> would always favour applications logging quer
Hi Dan,
Noted with thanks.
As such, is there a workaround to log problematic sql queries ran against
the mysqld server ? Do I need to write separate script to do this ?
Regards,
Ryan.
On 3/10/06, Dan Nelson <[EMAIL PROTECTED]> wrote:
>
> In the last episode (Mar 08), ryan lwf
does not work on my server
with mysqld-4.0.25 binary version.
Any inputs are appreciated.
Thanks,
Ryan.
Are my emails not coming through? Or is this question way too 'newbie'
and no one wants to touch it?
-Ryan
Ryan Stille wrote:
> I'm still hoping someone can else can share their input on this.
>
> What do other people usually do as far as the collation setting?
>
I'm still hoping someone can else can share their input on this.
What do other people usually do as far as the collation setting?
Thanks,
-Ryan
Ryan Stille wrote:
> When we migrated to MySQL from MS SQL, I left everything set
> to the default as far as collations - latin1_swedish_ci.
> What else can I do to observe myslqd?
mytop may be of some use: http://jeremy.zawodny.com/mysql/mytop/
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
some ColdFusion functions. I am wondering if my
database charset has anything to do with it.
What do other people usually do as far as the collation setting?
We are in the US, but do have a few sites that make use of German and
Spanish characters.
Thanks,
-Ryan
--
MySQL General Mailing List
from the local machine,
depending on what address you use to connect to. (local IP, local host,
actual hostname, etc).
-Ryan
Scott Haneda wrote:
> ERROR 2002: Can't connect to local MySQL server through
> socket '/tmp/mysql.sock'
>
> I accidentally deleted the above
Yes, look at the PURGE LOGS command.
Rithish Saralaya wrote:
> Hello.
>
> Can I delete off the binary log files manually? I do not want
> to 'RESET MASTER', as it will clear all the binary logs, and
> that's not what I want to do. The database is backed up every
> midnight, and I wouldn't want to
specific names (ads.id as adid).
Thanks,
-Ryan
Rhino wrote:
> I don't understand what you want. If you have the original
> query, it should be apparent from it where each 'id' column
> originated. If you're not sure how to read the query, post it
> and we can he
Put "SET SQL_LOG_BIN=0" at the top of your dump file. That will turn
off logging just for your session.
-Ryan
> -Original Message-
> From: sheeri kritzer [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 02, 2006 11:56 AM
> To: Rithish Saralaya
> Cc: M
turned, so they show up as ads.id, track.id, etc?
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>>> did u start mysql with --skip-name-resolve ???
>>> Kishore Jalleda
Kim Christensen wrote:
> On 2/16/06, Ryan Stille <[EMAIL PROTECTED]> wrote:
>> Nope.
>
> Well, have you tried it? Did it solve your problem?
Sorry, I misunderstood. I t
Nope.
_
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 4:32 PM
To: Ryan Stille
Cc: mysql@lists.mysql.com
Subject: Re: User is rejected because of IP, but hostname is
allowed
did u start
nc.com'. The machine I'm trying to connect from is named
dbdev.willcomminc.com. I did a reverse lookup from the database server
and the IP 192.168.2.56 does indeed lookup to dbdev.willcomminc.com.
Why is MySQL ignoring the hostname and using the IP?
I did google for this first but d
You can also install MyODBC and then hook an Excel spreadsheet into your
database. Editing the spreadsheet will update data in your database.
This isn't a good solution if you are going to be creating new tables
often. But for manipulating data in a known set of tables it's gre
then add that to the field value.
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Furthermore, would it make more sense to have the data dump locally,
> and then use a script to move the contents of the dump to a machine
> on the network, perhaps even to a machine located on an alternate
> network accessed via a second ethernet card?
This would be the simplest approach. That
l/libz.a(compress.o)(.text+0x0): In function `compress2':
: multiple definition of `compress2'
/usr/lib/mysql/libz.a(compress.o)(.text+0x0): first defined here
...
Did something change in the 4.1.16-1 RPM's in regards to zlib? As I
mentioned above, 4.1.16-0 worked fine.
Thanks,
Ryan
--
I am using MySQL 5.0.15 on windows and cannot run this query:
SELECT a.*,b.name, c.fullname,d.fullname
FROM access_authorization a, building b
LEFT JOIN users c ON a.createdby=c.id
LEFT JOIN users d ON a.modifiedby=d.id
WHERE a.sortcode=b.sortcode AND
a.sortcode like '1,2,1,6%' LIMIT 0, 25
I re
I fixed the whole problem by typing this one line:
`ln -s libz.so.1.1.3 /usr/lib/libz.so`
Linux is such a pain sometimes.
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
there's no obvious break between my comments and my pasted error
messages. I hate Outlook with a passion but am forced to use it.
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re command:
./configure --without-server \
--prefix=/usr/local/mysql \
--exec-prefix=/usr/local/mysql \
--with-named-curses-libs=/usr/lib/libncurses.so.4 \
--enable-thread-safe-client \
--with-extra-character-sets=complex
Any ideas on what's wrong?
is it possible to get the the given (unix)timestamp in milliseconds
since the epoch?
tia!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is possible to get UNIX timestamp with microseconds
when i try the following it just give 10 digits
mysql>SELECT unix_timestamp('20051114095641'+ INTERVAL 0 HOUR) as ts;
output :
1131933401 <--- 10 digits
any tips?
tia!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
?
i suggest you post the email header here, so anyone can help you further.
hth
--
Ryan Escarez
CEBB F1E4 1E39 EC48 F05D 6B72 9C11 DD88 5E39 E471
$ gpg --keyserver pgp.mit.edu --recv-keys 0x5E39E471
main(k){float i,j,r,x,y=-16;while(puts(""),y++<15)
for(x=0;x++<84;putchar(" .:-;!
lude/sql.h file on that system. I don't know
how it got there. By looking inside the file it appears to be related
to MyODBC 3.5.11.
Just for kicks I copied this file to the second system, but got the same
error when trying to run ./configure.
Any ideas?
-Ryan
--
MySQL General M
-and-
select IF((SHOW TABLES LIKE 'cfgbiz'),notifyto,'') FROM cfgbiz;
But it looks like the SHOW TABLES statement just doesn't return like a
regular SELECT statement does, because the above works if I use it like
this:
select IF(1,notifyto,'') FROM cfgbiz;
-Ryan
-
in that list. But I
was hoping for a more elegant way to do it, within the single query.
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
S NOT NULL
SELECT notifyto FROM cfgbiz
ELSE
SELECT '' as notifyto
Is there something similar in MySQL? I am running version 4.1.x.
Thanks,
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a field will contain.
> How can TEXT(16) hold more data than VARCHAR(16) ?
I'm not sure how the (16) is used on a TEXT field. MS SQL has TEXT
fields and VARCHAR fields. A VARCHAR(16) in MSSQL would be the same as
a VARCHAR(16) in MySQL. But in my MSSQL database I have data with
t
Josh Chamas wrote:
> Ryan Stille wrote:
>> Has anyone ever used this MSSQL-to-MySQL converter? It's pretty
>> reasonable at $40, and the demo output I got looked pretty good. But
>> I wanted to see if there is anything I should be weary about.
>> http://www.conve
and I've tried setting
autocommit = 0 at the beginning also.
I will ask on a CF list, because they may have run into this issue. But
really I think it's a MySQL question.
Thanks,
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
your MySQL server version for the right syntax to use near 'INSERT
INTO rps_names (nameid, name) VALUES (NULL, "Ryan Smithland") SELECT LA'
at line 2
With MSSQL the trick was the NO COUNT. That told the database server
not to return a count of the rows affected. Is there som
error:
ODBC Error Code = IM003 (Specified driver could not be loaded)
Thanks for any help.
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Has anyone ever used this MSSQL-to-MySQL converter? It's pretty
reasonable at $40, and the demo output I got looked pretty good. But I
wanted to see if there is anything I should be weary about.
http://www.convert-in.com/mss2sql.htm
Thanks,
-Ryan
--
MySQL General Mailing List
For
sing "--skip-extended-insert".
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
about it!
Thanks for any input,
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ord in the database. The
mysqldump is still running. How is this record getting inserted into
the database? I thought it was locked while the dump was happening? I
thought it would get queued up and inserted when the mysqldump is
finished. The record was NOT in the dump, this part made sense.
T
ne completely?
>
>Thanks in advance!
>
>
>
If you could bring both database servers down, you could tar up the data
directory and untar it on the other server.
--
Ryan Cavicchioni
GPG ID: C271BCA8
GPG Public Key: http://confabulator.net/gpg/ryan.asc
GPG Fingerprint: 83E4 2495 619
ause "pic1" for "from_cno" should be "r.jpg" but its
somehow "cacheing" the above.
Please advise.
Thanks,
Ryan A
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.0 - Release Date: 4
($result_client, MYSQL_NUM);
...then start printing our information from Table2
Best regards,
Ryan
Is 'find' what you're looking for?
find ${path} -type f -iname '*.doc' -print
find ${path} -type f -iname '*.doc' -exec /some/import/script {} \;
Thanks,
Ryan Yagatich
,______,
/ Ryan Yagatich
Can I post a query to this list and ask for help optimizing it?
--
Ryan McCullough
mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Ryan McCullough
mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
> --
> Eric Bergen
> [EMAIL PROTECTED]
>
> --
> MySQL General Mailing List
> For list archive
ows in set (0.00 sec)
mysql> SELECT * FROM category WHERE parent_path LIKE CONCAT((SELECT
parent_path FROM category WHERE id=2), ",2");
Empty set (0.00 sec)
mysql> SELECT VERSION();
+-+
| VERSION() |
+-+
| 4.1.5-gamma |
+-+
1 row in set (0.00
1 - 100 of 389 matches
Mail list logo
