process and renamed the file myself.
File is: C:\mysqldata\erqed.dll
Anything known about this?
please reply to [EMAIL PROTECTED]
Gary
8 (but not activated in the php.ini)
Anyone have an idea to where I should start to look?
Thanks
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Not sure if this is it, it was the only .err file that I have. Also this
seems to be the latest entry that has a date.
Thanks for your help.
Gary
090617 21:50:45 - mysqld got exception 0xc005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the
on the my.ini to see if there is something wrong (maybe a path
> pointing to a missing place or memory setting bigger than your actual RAM)
>
> Carlos
>
> On 7/11/2009 12:17 PM, Gary wrote:
>> Not sure if this is it, it was the only .err file that I have. Also this
>> s
ail.com...
>
> Take a look on the my.ini to see if there is something wrong (maybe a path
> pointing to a missing place or memory setting bigger than your actual RAM)
>
> Carlos
>
> On 7/11/2009 12:17 PM, Gary wrote:
>> Not sure if this is it, it was the only .err file
thing, but a very good lesson. I did find
a file that had all of the databases in it, I wonder if I copy all of those
if I would be able to save whatever DB's I had.
Thanks again and if anyone thinks of anything new, I would love to hear it.
Gary
""Gary"" wrote in messag
). I also tried writing the $query as an array, which got me an
error message (saying it was expecting a string and I offered an array).
Someone point me in the right direction?
Gary
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
http://www.w3.org/1999/xhtml";>
U
Seriously
You should read your answers before you post, the SA link did not provide
the answer. Had you read the page you sent, you would notice it does not
apply to mulitple tables...
Gary
"Colin Streicher" wrote in message
news:201004112310.16594.co...@obviouslymal
$result=mysqli_query($dbc, $query)
or die('Error querying database.');
mysqli_close($dbc);
?>
It seems a bit redundant for php, but it seems to work.
If by the way anyone sees a problem with this solution, I would love to read
it.
Again, thank you for your response.
Gary
"
will try to apply your solutions to the original problem.
Thanks again for your reply.
Gary
"Colin Streicher" wrote in message
news:201004122103.15609.co...@obviouslymalicious.com...
>
> Normally I would avoid getting into this sort of argument ( The 'OMG
> someone on t
.
So hopefully I will learn from my mistakes.
Thanks for your help.
Gary
"Chris W" <4rfv...@cox.net> wrote in message
news:4bc47b0b.7020...@cox.net...
>I have no idea how you got here but there is no reason to do it that way.
>This will work just fine and I do it every day in
;' . $row['description'] . '';
if (is_file($row['image_file'])) {
echo 'height="100px"/>';
}
As a bonus question, does anyone have any idea why the image would show up
in IE9, and not FF?
Thanks for your help.
Gary
im.image_id' at line 1
Anyone see where I am going wrong?
Thank you.
Gary
__ Information from ESET Smart Security, version of virus signature
database 5063 (20100426) __
The message was checked by ESET Smart Security.
http://www.eset.com
--
MySQL General Mail
Thanks for the replies. It was my understanding that whitespace is ignored,
and I did not think that not having space, in particular with "." would
result in an error message.
Gary
""Gary"" wrote in message
news:20100426233621.10789.qm...@lists.mysql.com...
I
this something to worry about? I had
(or so I assumed) plenty of protections on the files, including one of the
more popular anit-spam/injection attack systems.
Any guidance on this would be appriciated.
--
Gary
__ Information from ESET Smart Security, version of virus signature
27;type'] . '';
echo '' . $row['singles'] . '';
echo '' . $row['six'] . '';
echo '' . $row['can'] . '';
echo '' . $row['bottles'] . '';
echo '' . $row[
recall why I had it in the first place.
if (mysql_num_rows($result) == !'0') {
$row = mysql_fetch_array($result);
Again, thank you for your help.
Gary
"Johnny Withers" wrote in message
news:aanlktik3nhjqkc00iw-nv1qqpdeaj1_5xtwbf7skd...@mail.gmail.com...
> Your very
practice and fourth for articles?
I would enjoy hearing opinions on this.
--
Gary
__ Information from ESET Smart Security, version of virus signature
database 5868 (20110212) __
The message was checked by ESET Smart Security.
http://www.eset.com
--
MySQL General
meone could direct me to what to
post I would be appreciative.
--
Gary
__ Information from ESET Smart Security, version of virus signature
database 6044 (20110415) __
The message was checked by ESET Smart Security.
http://www.eset.com
--
MySQL General Mailing Lis
_db($database_assess, $assess_remote);
$Result1 = mysql_query($insertSQL, $assess_remote) or die(mysql_error());
"Michael Dykman" wrote in message
news:BANLkTi=+fpW=-qbmb6tcfffhr1gb32w...@mail.gmail.com...
I presume you are inserting to both tables always at the same time
inside a
this field.
if ($_POST['address'] != '' ) {
die("Changed field");
}
""Again, I see no reason you could not call last_insert_id() after the
first insert and use that value explicitly in the second.
""
I'm not sure I undertand this, c
I'm sorry, I am unfamliar with an asc file, so I have not opened them.
GAry
"Reindl Harald" wrote in message
news:4da87554.8030...@thelounge.net...
__ Information from ESET Smart Security, version of virus signature
database 6044 (20110415) __
The mess
.
I also took the advice to moved the honey pot code out of the middle of that
code and moved it up.
Again, thank you.
Gary
"Reindl Harald" wrote in message
news:4da87902.9030...@thelounge.net...
__ Information from ESET Smart Security, version of virus signature
dat
David T. Ashley wrote:
On 6/27/07, Eddy D. Sanchez <[EMAIL PROTECTED]> wrote:
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of systems, can you suggest
SELECT column FROM table WHERE column LIKE "CAT\_%";
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the thing to remember is that if you only want strings that start with
CAT you'd never want to query with %CAT% because this could match
DOG_CATHY.
% is a wildcard that matches any number of characters including none.
if you want to match a single character you use _
if you actually need to s
The following query should work if I understand what you're attempting
correctly. Use at your own risk though ;)
DELETE FROM Item USING Item, ItemTag WHERE ItemTag.ItemID =
Item.ProductID AND ItemTag.TagID = '168';
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
autotest (
-> id INT UNSIGNED NOT NULL AUTO_INCREMENT,
-> name VARCHAR(10) NOT NULL,
-> PRIMARY KEY (id))
-> AUTO_INCREMENT = 1001;
mysql> INSERT INTO autotest (name) VALUES ('Gary'), ('Andrew'), ('Paul');
Query OK, 3 rows affected (0.00 sec)
Look at your my.cnf for a configuration directive called
'innodb_data_file_path'. This is where you configure the files for the
innodb table space. The last one is probably an auto-grow. My guess is that
every time it complains, it's just added 8MB to the file. If you remove the
auto-grow (and I ca
I would drop the primary key off of your cust_id and add a new field like
customer_id and relink using the old fk.
I'd probably do this by creating a new table and doing an INSERT INTO SELECT
FROM to populate the autoincrement and rename the table.. From there, add
the fk's to your other tables a
Yeah, pretty much, but I would keep cust_id around and start over with a
true autoincrement from 1.
On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
and this would be, in other words, the solution 2, right?
> If you really want to change the customer ID, then you can always copy
the
>
Yes you can. Be sure not to delete the one the database is currently writing
to.
Are you replicating your database? Are you using them for point in time
restores?
If you're replicating, make sure your replicas have all caught up on the
files you're deleting.
On 6/3/06, Jacob, Raymond A Jr <[EMA
I believe the command is PURGE LOGS or something like that.
On 6/3/06, Jacob, Raymond A Jr <[EMAIL PROTECTED]> wrote:
-Original Message-
From: Gary Richardson [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 03, 2006 14:10
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subje
You'd have to use another table. I don't believe mysql views will keep your
'moving average' values.
If you're using 5.1, you can automate the select/insert with an event --
it's a cron like tool built into mysql.
If you have a datetime field in either of the tables that represents the
'action'
Make sure your disks are all redundant -- get two of each and mirror
them. You'll thank yourself when a drive dies.
If the database server has any uptime requirements, I recommend going
hotswap for everything -- you'll thank yourself again when you can
swap the drive out during core business hours
We've been using CentOS more and more. I recently built a small prototype
datawarehouse with CentOS (but I used MySQL 5 RPM's instead of the stock).
I've had no problems that I didn't have with RHEL on CentOS. I also have a
few similar RHEL systems, so when a problem occurs on a CentOS box, I
r
I need to drop a database named ÃáãÃáà using the mysql client. I'm
getting "you have an error in your sql syntax" for the command
DROP database ÃáãÃáÃ;
I'm sure this is a character set issue. How can I drop this database?
Regards,
Gary H.
--
MySQL General M
My guess is that the RAID has nothing to do with it -- it seems very unlikely.
In any case, if you want top performance out of your raid, you may
want to change things up. You'd get better performance if you didn't
use RAID5. Use RAID1 or RAID10 for your data drives. RAID5 is slower
than these oth
It depends on what heavy traffic is and what your machine is.. If it's
an E10K, then you can probably put them both on one machine for most
traffic loads :)
Your database will typically perform better if you have your DB on a
separate machine.
Without knowing more about the code running the site,
I've also experienced this. The 5.0.16 RPMs for RHEL3 worked fine on a
RHEL3 box.
As for the RHEL4, I even tried recompiling the source RPM's and still
got the dependency error! I ended up using the generic RPM's as those
installed fine.
For me, it's a moot point anyway as 5.0.16 isn't stable eno
gt; >
> > Marcus
> > --
> > Marcus Bointon
> > Synchromedia Limited: Putting you in the picture
> > [EMAIL PROTECTED] | http://www.synchromedia.co.uk
> >
>
> I blame it on Gary for hijacking your original (unrelated) thread. Sorry
> for the cros
Are you doing single insert statements, multiple insert statements or
LOAD DATA INFILE statements?
On 12/4/05, Chenzhou Cui <[EMAIL PROTECTED]> wrote:
> Dear MySQL fans,
>
> I have a 260 GB huge file with 1045175762 rows. Two weeks ago, I wrote a
> Java program to read the huge plain text file in
Also, if the file looks anything like a CSV file, I recommend using
LOAD DATA INFILE
http://dev.mysql.com/doc/refman/4.1/en/load-data.html
You'll probably load that data in half to a quarter of the time.
On 11/30/05, Daniel Kasak <[EMAIL PROTECTED]> wrote:
> Chenzhou Cui wrote:
>
> > I didn't us
It doesn't seem like a mission critical app, but I would seriously
consider using redundant RAID (ie, not 0, but 1 or 5). Nothing ruins
your day quite like losing a non-redundant drive, even if you have
good backups.
Also, what sort of workload are you looking at? How responsive does it
need to be
I don't have any experience with dual core yet (my first dual dual
core box is scheduled to arrive this week!!). I don't think I'd opt
for a dual core in place of 2 single cores. I'm hoping (expecting?) to
see an advantage in 2 DC over 2 SC.
As far as SCSI over SATA goes, I exclusively use SATA. I
We moved directly from 4.0.20 to 5.0.16. Worked like a charm. I had a
script that went through and optimized all tables with keys on
text/varchar and char fields.
We're also slowly ALTERing innodb tables to get them into the new
compact format.
On 12/28/05, Gleb Paharenko <[EMAIL PROTECTED]> wro
upgrading between version. On possible probablem you could be facing
in change in how whitespace is handled in indexes.
On 12/30/05, Christian Meisinger <[EMAIL PROTECTED]> wrote:
> Gary Richardson wrote:
> > We moved directly from 4.0.20 to 5.0.16. Worked like a charm. I had a
>
get the string
(truncated):
"aHR0cC8xLjAgMjAwIG9rDQpzZXJ2ZXI6IDB3LzAuNmQNCmRhdGU6IHRc3"
My wild guess is that this is a unicode string. Is there any way for me to
work with this raw data and display the text in it's native character set?
Thanks,
Gary
--
MySQL
CREATE TABLE blah LIKE old_table
On 1/11/06, George Law <[EMAIL PROTECTED]> wrote:
> Hi All,
>
>
>
> Just another follow up on my emails.
>
>
>
> What this came down to was sheer number of records and indices in my
> tables causing it to take several minutes to insert 10-20K records via
> "load da
I would typically do this in code, but you could also create a stored
procedure that does something like:
- create a temporary table
- populate it with all possible values with a count field set to 0
- run an REPLACE INTO temp_table
- dump the contents of the temp table
You may also want to just
e (no other configuration info has changed)
My question is, why when I "GRANT all on *.* to root@'localhost' identified
by 'xxx'" do I get a 16 byte hash and not a 41 byte hash? Since my
theory is the lack of a grant with a 41 byte hash I'd like to test
What are the problems you've been experiencing? Did you convert all tables?
How big is the database?
On 2/9/06, Shaun Adams <[EMAIL PROTECTED]> wrote:
>
> I have a customer who has been in production for a few weeks now having
> converted from MyISM to INNODB. We have been experiencing a few prob
If you use the 5.1 tree, you should be able to use the new EVENT stuff
to accomplish this:
http://dev.mysql.com/doc/refman/5.1/en/events.html
CREATE EVENT check_table ON SCHEDULE AT '2006-03-10 19:00:00' EVERY
WEEK DO your_check_table_procedure_here();
Or something like that..
On 3/10/06, René
iles that ship
with the tarball appear to apply to the more typical installation of a
single huge database rather than thousands of individual dbs. Can
anyone offer any suggestions?
Thanks,
Gary Huntress
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
GHz system.
The tuning articles I've read, and the sample my-*.cnf files that
ship with the tarball appear to apply to the more typical
installation of a single huge database rather than thousands of
individual dbs. Can anyone offer any suggestions?
Thanks,
Gary Huntress
Gary,
I really don't think this is an apache issue. I get the same poor
connection speeds using the mysql client.
Gary
[EMAIL PROTECTED] wrote:
I'm just wondering if it would be possible to use several
apache servers on different ports and using virtual servers,
that would each
Velentin,
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
Note the section for the droping of foreign keys used the contraint name, not
the key name. Try this and see if it solves the first problem (of removing the
constraint). Then you should be able to drop the c
I'm working on a small project of re-implementing all of the sql for a web
site. The task is pretty trivial but overall there are some minor things that
I'm trying to code through.
We've moved much of the logic over to stored procs and call them with
parameterized queries. This works well sin
ireless.com
>
>
>
> > -Original Message-
> > From: Gary Smith [mailto:g...@primeexalia.com]
> > Sent: Friday, March 27, 2009 12:59 PM
> > To: mysql@lists.mysql.com
> > Subject: [MySQL] Search based where claused and stored proc
> >
> > I&#x
I have system that is generating a larger than normal number of connection
errors. We know why the errors are occuring and are working to resolve them
(connectivity and load issue on the client). The question is, how can I tweak
mysql to tolerate a higher level than normal of bad connections b
From: mos [mo...@fastmail.fm]
Sent: Tuesday, April 07, 2009 9:18 AM
To: mysql@lists.mysql.com
Subject: Re: flush-host problem
At 10:39 AM 4/7/2009, Gary Smith wrote:
>I have system that is generating a larger than normal number of connection
>errors. We know why the e
ns of rows?
Give you more information and we can probably give you a better answer. Maybe
a table structure and numbers behind it would be nice.
Gary
From: Lin Chun [franks1...@gmail.com]
Sent: Wednesday, April 29, 2009 7:49 AM
To: mysql@lists.mysql.c
Oracle owns the mess now. I assume the next release will be 5.11, followed by
5.11i, and then finally dropping of the 5 to be in line with how they manager
their os, leave it to just be 11i. To ensure it is smooth they will change the
license and add $5k in suport costs.
_
eceiving the error through PHP.
Of course, I could be wrong, in which case I know people will probably jump me
for it. If this is the case, please do as I would like to be wrong here as it
would make my compiling life easier every time I update MySql on all of my
boxe
From: joerg.bru...@sun.com [joerg.bru...@sun.com]
Sent: Thursday, May 07, 2009 2:40 AM
To: Gary Smith
Cc: mysql@lists.mysql.com
Subject: Re: Problems After MySql 5.1.34
Hi Gary, all,
Gary Smith wrote:
> Johnny,
>
> Welcome to the hell that is php + apache + mysql. If you upgrade your MySql
You are right. I misspoke regarding mysql -> php -> apache hell. It happens
anytime an interface changes.
From: Mark [ad...@asarian-host.net]
Sent: Thursday, May 07, 2009 5:57 AM
To: mysql@lists.mysql.com
Subject: RE: Problems After MySql 5.1.34
can accept large inserts of this size?
Thanks,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Michael,
Thanks. Thats what I was looking for, I just couldn't remember what it was.
Gary
From: Michael Dykman [mdyk...@gmail.com]
Sent: Wednesday, May 20, 2009 9:17 AM
To: Gary Smith
Cc: mysql@lists.mysql.com
Subject: Re: Large insert question
O
Off the top of my head, try this.
SELECT
MONTHNAME(s.created) AS month,
sum(if(ifnull(s.id,0) > 0, 1, 0)) AS num_logins,
sim(if(ifnull(d.id, 0)> 0, 1, 0)) AS num_downloads
FROM sessions AS s LEFT JOIN downloads AS d
ON d.session_id = s.id GROUP BY month
tables
On 07/08/2009 03:33 PM, Gary Smith wrote:
> Off the top of my head, try this.
>
> SELECT
> MONTHNAME(s.created) AS month,
> sum(if(ifnull(s.id,0)> 0, 1, 0)) AS num_logins,
> sim(if(ifnull(d.id, 0)> 0, 1, 0)) AS num_downloads
> FROM sessions AS s LEFT JOIN downl
using the client and changes their password using SET
PASSWORD= PASSWORD('their new password'), it breaks the single signon.
Thanks,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
state was real time, which is now known to be false.
Any ideas/assistance would be greatly appreciated.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
top using IDBConnection and go with MySqlConnection there is a Ping()
that doesn't exactly that. I guess I've been spending too much time on the MS
and Oracle providers...
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Here is steps take to get to the problem. Version is 5.1.35
To be on the safe side, I did this prior to executing the scripts. I deleted
the mysql directory and the mysql-log directory, recreated them, chowned them,
ran mysql_install_db, chowned them again. So, I know at least I'm working wit
specified, even though the tables are qualified.
Can anyone confirm this?
Gary
From: Gary Smith [g...@primeexalia.com]
Sent: Friday, July 10, 2009 5:12 PM
To: mysql@lists.mysql.com
Subject: Crazy replication problem
Here is steps take to get to the probl
> -Original Message-
> From: Gary Smith
> Sent: Friday, July 10, 2009 5:26 PM
> To: Gary Smith; mysql@lists.mysql.com
> Subject: RE: Crazy replication problem
>
> One quick follow up note:
>
> In the top of the big script, I'm doing:
>
> CREATE
After getting table replication to work by including the USE database on the
creation scripts, I have run into a rather large problem. We have 5 databases
on the server which get replicated to another server. We call them databases,
A, B, C, D, and E. we have two other databases F and G which
> -Original Message-
> From: sjm...@pobox.com [mailto:sjm...@pobox.com]
> Sent: Saturday, July 11, 2009 1:02 AM
> To: mysql@lists.mysql.com
> Subject: Re: Replication, Stored Proceedures and Databases
>
> g...@primeexalia.com (Gary Smith) writes:
>
> ...
&
> -Original Message-
> From: Claudio Nanni [mailto:claudio.na...@gmail.com]
> Sent: Saturday, July 11, 2009 2:44 AM
> To: Simon J Mudd
> Cc: mysql@lists.mysql.com
> Subject: R: Re: Replication, Stored Proceedures and Databases
>
> You dont have changes coming from db G since it is ignore
atabase did it come from and what version of the database is it
going to?
Anyway, if the original server is still up, I'd just copy from one store to the
other. It might be slow to do a 4 day export, but if you are two days into
this the savings of USB copy has already been lost.
Ga
.
I think as others have mentioned, the startup recovery flags might be your best
bet.
From: Daevid Vincent [dae...@daevid.com]
Sent: Tuesday, July 14, 2009 12:23 PM
To: mysql@lists.mysql.com
Cc: Gary Smith
Subject: RE: Copy 70GB ibdata, etc. and serv
this were a hot backup, I could see
this problem happening. If it were a could backup, it should work.
From: Johnny Withers [joh...@pixelated.net]
Sent: Tuesday, July 14, 2009 1:40 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com; Gary Smith
Subject: Re: Copy
I have a new slave I setup against a new master server. The master server has
4 log files in it, the most current being updated on the 16th. The slave
server on the other hand has several files, many which seem to be blank. This
slave is set to slave the master and act as a master for downstr
I'll have to look into that. We have a single cronjob that just does a
mysqldump daily but not during the time of the log file generation, but that's
all I can think of off the top of my head.
Gary
From: tly...@sitehelp.org [tly...@sitehe
> -Original Message-
> From: Gavin Towey [mailto:gto...@ffn.com]
> Sent: Friday, July 17, 2009 2:02 PM
> To: Gary Smith; Todd Lyons
> Cc: mysql@lists.mysql.com
> Subject: RE: Slave log files going nuts...
>
> The binlogs are closed and reopened every time you do
s SQL injection. Pop that into Google and
you'll get a shedload of stuff.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
,table as t2,table as t3 where
t1.column1='blah' and t2.column2='blah' and t3.column3='blah'
does the same thing as
select * from table where column1='blah' and column2='blah' and
column3='blah'
Does that do what you're af
column_name,data_type from columns where data_type='YOUR DATA
TYPE HERE';
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
(id) would be wrong for however long it takes for
auto_increment to get to that figure, which could potentially be a long
time.
Cheers,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
* need.
Aah... I'd mis-remembered on this. Is there an SQL mode or somesuch
which changes this behaviour, or is my mind dribbling out of my ears?
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub
oing on
behind the scenes?
I recently attended Sun's MySQL DBA course
(http://www.mysql.com/training/schedule.php?class=5200) which I can
heartily recommend. The course covers the kind of things you're after,
including indexing, how the engines work (ie pros and cons), backups, etc.
find all of the distinct hospital codes by doing
select distinct code from hospital.
Apologies if this isn't possible.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ltset, but as a
single column. Essentially, hospital1code, hospital2code and
hospital3code need to be merged to a single column, deduped, and then
returned.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?
d create a new one as it was when it
was exported. Is this what you're after?
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ts, so it'll do what you're wanting to do.
Do you have any primary keys/auto increment columns that are going to
overlap or anything like that?
Cheers,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
sier way to do this? I've got into some bad
habits over the years, but I'm not aware of another way to do what
Patrice is trying to do.
Cheers,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
machiel.richards wrote:
How can we do this when running in a cron script?
mysql -e "select * from into outfile '/path/to/output/file'
fields terminated by '|'" ?
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Krishna Chandra Prajapati wrote:
Hi guys,
Is the information is true.
http://planet.mysql.com/
http://tokutek.com/2010/04/tokutek-acquires-oracle/
Might want to check the date.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
GRANT OPTION;
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 'PRIVILAGES ON *.* TO 'g...@supercrunch' IDENTIFIED
BY 'qatip' WITH GRANT OPTION' at line 1
Leavi
Hi Anand,
Just try 'load data local infile',it maybe work.
Eric
2010/12/20 Anand :
> Hi guys,
>
> i am facing a serious issue with my replication , i tried so many things but
> no luck.
>
> my replication is running with mysql 5.0.51a in master and 5.0.90 in slave.
>
> we run LOAD DATA INFILE in
1 - 100 of 399 matches
Mail list logo
