Hello,
I have a empty db that I'm trying to load a .sql file (created via
mysqldump) into. The dump has 791611 lines and is 807 MB. Loading the
dump is consistently failing at line 1763. Line 1763 is an INSERT
statement. The line is 95610 characters long.
The error is:
ERROR 2013 (HY000) at line
> -Original Message-
> From: Larry Martell [mailto:larry.mart...@gmail.com]
> Sent: Wednesday, July 03, 2013 11:29 AM
> To: shawn green
> Cc: mysql@lists.mysql.com
> Subject: Re: 1 file
>
> On Wed, Jul 3, 2013 at 9:51 AM, shawn green
> wrote:
> > Hello Larry,
> >
> >
> > On 7/3/2013 11:
You probably want
where cast(transaction_date as date) BETWEEN '2013-04-16' AND
'2013-04-16'
That works on my test case
You could also change the where clause to be >= date and < date+1
-Original Message-
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Thursday, May 23, 2
To adjust a table name within a SQL statement, you need to create a
string with the updated values and use PREPARE/EXECUTE
See below, I am replacing your CONCAT with the complete insert statement
The example below is also assuming the value in the WHERE clause should
be adjusted to the number, inst
Hi All,
InnoDB repeatedly prints this message in the error log:
# InnoDB: Error: unlock row could not find a 4 mode lock on the record
Im not sure if the error message is critical or not, but its definitely not
nice to have in the error log.
After some exploration, I found this error is relevant
.
Thank you for answering my question. Please consider my question resolved.
Kailash.
On Sun, Oct 16, 2011 at 10:06 PM, Dan Nelson wrote:
> In the last episode (Oct 16), Kailash R said:
> > Nice input Dan. Let me run some checks. My query is as follows:
> >
> > select group_c
ut I it doesn't error out with the same problem. I suspect
server variables or what not .. not sure what.
Thanks for the feedback Dan I will post with more information.
Kailash.
On Sat, Oct 15, 2011 at 9:38 PM, Dan Nelson wrote:
> In the last episode (Oct 15), Kailash R said:
> &g
I was wondering if there is a way to increase the size of user defined
variables ? I am not able to attribute a type to them and when I assign @sql
= 'a_text _field' , 'a_text_field' gets truncated if it exceeds the size of
@sql. This is not wholesome as I am using @sql in a subsequent prepare
sta
I have been looking high and low but am having trouble finding good
info. I need to try to lock down mysql with strong passwords
password expiry yadda yadda. I've looked at securich and am not sure
I want to use it.
All I really want is to prevent users from be able to change their
pa
> Why would the auto_increment not work for you? The only case where you
> would have a problem is if the last record was deleted before mysql
> shutdown. If you are really concerned about this unique scenario,
> insert a dummy record before shutdown to guard against it and delete
> the dummy reco
> >I try to generate a unique id for each row in a Mysql-InnoDB Table.
> >Because of many deletes I can't use an auto_increment column.
> >After a Mysql restart, the next value for an auto_increment-column is
> >max(auto_increment-column)+1, and I need a really unique id.
> >
> [JS] See if the
Hi all,
I try to generate a unique id for each row in a Mysql-InnoDB Table. Because of
many deletes I can’t use an auto_increment column.
After a Mysql restart, the next value for an auto_increment-column is
max(auto_increment-column)+1, and I need a really unique id.
My first solution looks
hi to all, does anybody knows if there is any mysql training or seminar
to be held in the philippines? thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
c,
> perhaps optimizing the indexes etc on the table might help with the
> performance.
>
> Also, make sure your HD's aren't full... that will kill performance
> very quickly if the needed disk space isn't there.
>
> Erik
>
>
> On Jan 3, 2008, at 3:44 PM, Gunna
c,
> perhaps optimizing the indexes etc on the table might help with the
> performance.
>
> Also, make sure your HD's aren't full... that will kill performance
> very quickly if the needed disk space isn't there.
>
> Erik
>
>
> On Jan 3, 2008, at 3:44 PM, Gunna
USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND
2410 mysql 15 0 470m 310m 4464 S 99.9 30.8 4200:25 mysqld
How come the CPUs can have idle time even though mysqld is running at
99.9%, AND there's a processor queue (4.36)?
Cheers,
Gunnar R.
On ons, januar 2, 2008, 13:
31 0:01
/usr/sbin/httpd
apache3602 0.7 1.2 26244 13384 ?S22:31 0:01
/usr/sbin/httpd
apache3607 1.1 1.2 26268 13424 ?S22:31 0:02
/usr/sbin/httpd
apache3608 0.7 1.2 26264 13416 ? S22:31 0:01
/usr/sbin/httpd
qmaild3658 0.0 0.0 5320 944
Hello,
I am running a community site mainly based on phpBB. It has about 9.300
registered users, 650.000 posts and about 200.000 visitors/month (12 mill
"hits"). The SQL database is about 700MB.
It's all running on a couple of years old Dell box with two P4 Xeon 1.7Ghz
CPUs, 1GB of RAMBUS memory
lly. If they work change the my.cnf to make
them survive the next time mysql is restarted (for example on a reboot).
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: htt
On Mon, March 12, 2007 8:04, Neil Tompkins said:
> I've been researching the best method to store credit card numbers in a
> database which are saved encrypted. My version of mysql is 3.23 therefore
> I
> think the only function I could use is
>
> ENCODE() and DECODE().
>
> I've tried these functi
On Tue, March 6, 2007 9:40, Marcus Bointon said:
> On 6 Mar 2007, at 17:12, David T. Ashley wrote:
>
>> Best practice is that all times maintained in a database (or
>> anywhere on the
>> server) are UTC, and are only converted to local timezone and/or
>> adjusted to
>> daylight savings time as requ
On Wed, February 28, 2007 14:10, Ryan Stille said:
> I am on 4.1.20-1.
>
> Maybe your OS isn't patched?
>
> Try this: "SELECT @@global.time_zone;"
Won't help if you are on debian which is still on 4.0.
> If you get back "SYSTEM", then MySQL is looking to the OS for timezone
> data. And its only l
Please post to the list not to me personnally.
Original Message
Subject: RE: [PART 2/2] InnoDB - Different EXPLAINs for same query From:
"John Anderson" <[EMAIL PROTECTED]>
Date:Thu, January 18, 2007 10:24
To:
gt; open_files_limit=8192 # Anything higher needs corresponding ulimit entry
>
>
>
> #Buffers
>
> join_buffer_size=128M
>
> key_buffer_size=512M
>
> key_buffer=512M
>
> large_pages
>
> max_heap_table_size=1024M
>
> myisam_sort_buffer_size=256M
>
> read_buffer_size=64M
>
> read_buffer=64M
>
> query_cache_size=32M
>
> query_cache_type=1
>
> record_buffer=512
>
> sort_buffer=512M
>
> table_cache=512
>
> thread_cache=4M
>
> thread_stack=512K
>
> thread_cache_size=300
>
> thread_concurrency=16
>
> tmp_table_size=1G
>
>
> #innodb
>
> innodb-table-locks=off
>
> transaction_isolation=REPEATABLE-READ
>
> innodb_buffer_pool_size=1024M
>
> innodb_log_buffer_size=8M
>
> innodb_flush_log_at_trx_commit=0
>
> innodb_log_file_size=128M
>
> innodb_additional_mem_pool_size=32M
>
> innodb_thread_concurrency=16
>
> innodb_commit_concurrency=4
>
> innodb_flush_method=O_DIRECT
>
> innodb_open_files=8192
>
> innodb_sync_spin_loops=32
>
> innodb_thread_sleep_delay=1000
>
> innodb_autoextend_increment=1024M
>
> innodb_file_per_table=TRUE
>
>
>
> [client]
>
> socket=/tmp/mysql.sock
>
>
>
>
>
> John Anderson
>
>
>
>
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Have you looked at ubuntu distribution of linux. I think they have a
'school' variant which might be close to what you need. Also, the people
there might be able to give you more help. Good luck.
On Thu, December 7, 2006 9:39, Saqib Ali said:
> Hello All,
>
> I know this is little bit off-topic
Sorry, but I haven't gotten any emails from the list and I'm trying to
determine if there is a blockages. Sorry to disturb the list.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing Lis
to match the
new structure), drop the old table and rename the new table to the old
tables name. So the time might be realistic. It depends on the hardware
you are using and what else is going on on the system.
Hope this helps.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.
t;
Then it is really a UNION. I hope you have the date field as an index
otherwise you are looking at a table scan which is always slow.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list
it a RELATIONAL database. If the tables
don't have such a relationship you are asking for the UNION of the
separate information from table a, where it meets its WHERE conditions,
and the information from table b where it meets its WHERE conditions. The
fact that both where conditions are the
; --
> http://www.spacemarc.it
Well that's what you asked it to do, if you look closely at your query.
How are table a, b, and c related to each other?
Do you want all the information from each of the tables (which are NOT
related to each other) between the specified dates? If that is the
Would it not be best to have the field with the fewest repeats (i.e., the
closest to unique) first, or is that what you meant.
Bill
On Tue, October 17, 2006 10:12, Jerry Schwartz said:
> I didn't think of that (combinations). You are probably right. Due to my
> background, I tend not to think a lo
A couple of comments:
- Simultaneous connections can be increased, but at some point the user
than runs the mysqld process will run out of file handles it can allocate
(each table takes 2 or 3).
- If we are talking about a database server and test server being the same
box then what are you trying
Just noticed that you said partitions. I am assuming that you meat
multiple drives in a raid array.
Bill
David Lazo said:
> Thanx again.
>
> For the time being, we will keep 4 drives with Dan's suggestion. OS and
> MySQL running from there.
>
>
>
> On 8/25/06 11:03 AM, "Dan Buettner" <[EMAIL PR
ore issues, but no issue can 'belong' to
more than one customer then its 1 to many and you can put the customer ID
in the issues table.
If several customers can have the same issue (row) then you will need an
intermediate table which has two columns: customerID and issueID.
---
Wi
D] 20050518
>Environment:
System: NetBSD roswell.lazyrockinw.com 3.99.20 NetBSD 3.99.20 (piggy)
#2: Mon Jun 12 22:59:37 CDT 2006
[EMAIL PROTECTED]:/stuff/src_current/sys/arch/i386
/compile/obj/piggy i386
Some paths: /usr/pkg/bin/perl /usr/bin/make /usr/pkg/bin/gmake /usr/bin/gcc
/u
somewhere
>> > between 1000 and 2000 rows, but you just want to see the
>> last 50. These
>> > last 50 might be the most recent entries, for example. Can
>> this be done
>> > in single query?
>> >
>> > Dirk Bremer - Senior Systems
romyd misc said:
> Hi Everyone,
>
> I'm developing an application using C# .NET and mysql as database. It's a
> multithreaded application, we open a mysql database connection at the very
> beginning when the application is started and all the database requests
> use
> the same connection. But under
ing the installation. I wasn't sure what to use
> to Default Schema so I just put in test. I keep getting a connection error
> number 2003 stating I can't connect to MYSQL server. Is there something
> that someone can suggest?
>
>
>
> Thanks,
>
>
>
> Chu
as you can see I do not select a engine type, is there some
> engine type better suited and or faster for the way I am
> trying to use the keys?
>
> Thanks for your advice and help.
Close but you need to specify that the index is UNIQUE (see changes above)
---
William R. Mussatto, Seni
Please, i'm a crazy ! i dont can write in a table, please anybody can help me
try find the error
Thanks
--
---
---
Kleiton L R Soares (21-2620-0735 | 21-9639-5829)
PCS - Processos Consultoria Soluções
www.pcs.com.br / [EMAIL PROTECTED]
--
MySQL General Mailing
Good Morning
Hi, i need make a query on my database and the result save in a text file with
coma (CSV-file)
Somepeople can help-me
Thanks !
--
---
---
Kleiton L R Soares (21-2620-0735 | 21-9639-5829)
PCS - Processos Consultoria Soluções
www.pcs.com.br / [EMAIL
Hi all.
I figured this question was suitable for both the MySQL list and the
PHP-General list. Here's what I'm running into.
I just installed MySQL5 and currently have PHP 4.3.11 installed. I
am wanting to connect to the mysql database on localhost, but I
get the following results:
--
Hi all.
I am having some troubles with what should be contained within my
my.cnf file. Would a few of you be willing to show me what yours
consists of?
Thanks,
~Philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
Hi all.
Let me clarify my subject line. I *think* I actually got all the
'MySQL5 +server' files installed correctly using Darwin Ports. The
problem is that I am not able to start my server. I think that
'my.cnf' may also be incorrect. Here's what's happening...
- When I try to start the se
to disable show databases to get Lasso working properly.
Unfortunately, we also need phpMyAdmin to work properly, and it seems
to have problems if this feature is disabled.
Thanks,
-Bill
On Dec 19, 2005, at 7:34 AM, William R. Dickson wrote:
This did the trick. Many thanks. I had found tha
This did the trick. Many thanks. I had found that option, but
misinterpreted what I read; I thought it was only available in 4.x.
Thanks again!
-Bill
On Dec 14, 2005, at 6:59 PM, Michael Stassen wrote:
William R. Dickson wrote:
OK, I strongly suspect I've just done something stupid
OK, I strongly suspect I've just done something stupid here, but I'm
having trouble figuring it out. I had a disk go bad on a MySQL server
this past weekend. I did a clean system install (FreeBSD 5.4) on a
new disk, installed the MySQL 3.23 port, and restored the mysql data
directory from b
It has been discussed on this list and on the web site that the
mysqldump behavior has changed from 4.0 to 4.1, and now converts all
data from the character set of the data to the default-character-set
(which is utf8 by default).
So my question is: how does one reliably use mysqldump to back u
Alle 08:21, giovedì 13 ottobre 2005, Huub ha scritto:
> Hi,
>
> Can someone tell me if it is anyhow possible to import a dBaseIII+
> database into MySQL and if so: how?
>
On linux there is "dbf2mysql"
http://packages.debian.org/stable/misc/dbf2mysql
On windows you could import the tables in m$acc
is implies, at least to me, that one doesn't need a 2nd
> database server or to do a mysqldump (your steps 5-7). Instead, we just
> tar cv /mnt/ops/dbbackup (to use the article's example name for the
> mounted snapshot), save the tape, and dispense with the snapshot.
> Wouldn&
Gleb Paharenko said:
> Hello.
>
> In my opinion, one of the causes of the problem can be the processing of
> trailing spaces in varbinary fields. See:
> http://dev.mysql.com/doc/mysql/en/binary-varbinary.html
Thanks, you may be right since the results are too short.
>
>
I was storing some 8 bit information in a varchar binary field (encrypted
stuff) and I think its getting corrupted. I thought they were (except for
size) interchangable? I'm running debian GNU Linux and haven't moved to
sarge so I'm still on 3.23.x but will be moving shortly.
---
s:
>
> <http://dev.mysql.com/doc/mysql/en/string-functions.html>
> <http://dev.mysql.com/doc/mysql/en/string-comparison-functions.html>
As Michael suggests, better to do this in an app. It should not take you very
long to write a quick data importer in PHP that woul
d: You have an error in your SQL syntax near 'temp'
>
> how do stop mysql from trying to interperate this data and blindly store it
> ??
Another solution would be to base64 encode the data before storing it in the
database.
--
Lamont R. Peterson <[EMAIL PROTECTED]>
F
aptop clients connect to, which handles the
syncranization of the data.
I have built a few like this in the past (working on another now) and it works
great.
Basically, all you have to do is track which records have not been synced each
way and then have the client & server do it w
Hi All!
I'm using the latest mysql 4.0.x and I've successfully
set-up database replication on it over 2 machines.
I have noticed though that mysql doesn't seem to
replicate CREATE TABLE operations on the master to the
slave. Is this a limitation? Or I just missed
something. If so, can someone ple
I posted a few days ago, but didn't get any responses. I'm hopeful someone
has seen this, and can offer advice.
We recently converted some tables from MyISAM to InnoDB because the need had
arisen for transactional support.
Things have been fine until recently, when the .frm files for these
We have been using MyISAM tables with MySQL merrily for about 18 months.
Recently we upgraded to MySQL 4.1, and even more recently, we converted some
of our MyISAM tables (which needed transactional support) to InnoDB.
After some configuration issues - the worst of which was the need to use a
s
David Blomstrom said:
> I discovered by accident that I can link any website
> on my reseller account to one database. That would be
> far more convenient than working with six separate
> databases, and it would also cut down on file size
> overall, since there are certain tables that I share
> bet
[ This is my second e-mail, the first I forgot to CC me.
Please CC me, I am not subscribed ]
Are there SNMP OIDs avialble to get MySQL qps, inserts ps, etc?
Luis
--
GnuPG Key fingerprint = 113F B290 C6D2 0251 4D84 A34A 6ADD 4937 E20A 525E
pgppLI1O5jxLy.pgp
Description: PGP signat
Are there SNMP OIDs available I can use to query MySQL qps, inserts ps, etc?
Luis
--
GnuPG Key fingerprint = 113F B290 C6D2 0251 4D84 A34A 6ADD 4937 E20A 525E
pgp7JOjsc3R2E.pgp
Description: PGP signature
Eric Bergen said:
> Apache 1.3 with php (not sure about tomcat) is a pre forked daemon. Any
> connection pooling numbers will be per child. Try setting your
> connection numbers per child (for most php apps this is 1) and let us
> know what happens. I'm guessing it will create as many connections a
ald
>>>
>>>
>>>>I am trying to insert data for the first time using MySQL. In Oracle
>>>> I used the following:
>>>>
>>>># my $sql = "insert into bar( group_name, me, daily, item, unit,
>>>> qty, amount, tax, total )
>>>>
>>>># values( ?, ?, ?, ?,?,?,
>>>> ?, ?, ? ) ";
>>>> my $sth = $dbh->prepare( $sql );
>>>> die $dbh->errstr if $dbh->err;
>>>> $sth->execute( $group_name, $me, $daily, $item, $unit, $qty,
>>>> $amount,
>>>>$tax, $total ) || die "Cannot execute FIRST
>>>> Statement!!\n$DBI::errstr";
>>>>
>>>>
>>>>I keep getting "Can't call method "prepare" on an un undefined value.
>>>> All the name listed are correct by looking at MySQLAdmin1.3\4.
>>>
>>>Apart from David Logan's answer:
>>>
>>>You have to create the $dbh object first (man DBI); the "undefined
>>> value" in
>>>
>>>the error message refers to that.
>>>
>>>
>>>HTH
>>>
>>>joe
>
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Message-
From: Sheni R. Meledath [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 04, 2005 11:40 PM
To: MySQL Masters
Subject: MySQL Load on server
Hello:
We have multiple web sites hosted on a virtual web server. Many of the web
sites are using MySQL databases. Recently we are having problems
:01 71.29% 71.29% mysqld
Is there any way to track the processes on the MySQL databases? Please
suggest a solution to fix this problem. Thank You.
Regards
Sheni R Meledath
[EMAIL PROTECTED]
options with my knowledge. No luck yet. Can anybody help me out.
MySQL installation file/version - mysql4.0.20d-win
Regards
Sheni R Meledath
Assistant Manager - Web Development
*
Cyber Gear LLC
P.O. Box 53735
Dubai, United Arab Emira
index named with a keyword, which 3.23.x appears to
> allow but 4.0.x doedsn't. Edit the dump file and see.
>
> - ian
Or it could be that a table name is now a reserved word.
DIV in my case
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
myodbc on the windows box and then use
access.
The firewall's (if any) will have to be adjusted so that traffic on the
correct port is allowed from only that IP.
Just a thought.
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL Genera
Michael Stassen wrote:
>
> You would increase your chances of getting a useful answer if you would
> take
> the time to reformat your query to be easily readable, as I have done for
> you below.
>
> > SELECT Product.Product,
> >AssignedToAgent.AgentName AS AssignedTo,
> >sum(Inqu
lly qualify all column
> names in queries; if so, you should follow your shop standard ;-) More
> likely, you are probably using some sort of query generating tool in which
> case you probably don't have a choice in the matter.
>
> Rhino
>
>
>
> - Original Messag
I have an interesting problem that I cannot find any clues to in the MySQL
documentation. The following query works in 3.2.3, but does not work in
4.1.7:
SELECT `Product`.`Product`, `AssignedToAgent`.`AgentName` AS `AssignedTo`,
sum(`Inquiries`) AS `Inquiries` FROM `Inquiry` INNER JOIN `Produc
Mark Matthews said:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> William R. Mussatto wrote:
>
>>>Tried it and now I get connection timed out after three tries. I'm
>>> running the testbed using the tomcat buried in netbeans. Cut and
>>> pas
Hassan Schroeder said:
> William R. Mussatto wrote:
>
>>>Tried it and now I get connection timed out after three tries. I'm
>>> running the testbed using the tomcat buried in netbeans.
>
> Frankly, the whole concept of running a server from "within"
Warning!! Make sure the php module will handle the new password scheme in
4.1. DBD::mysql from AS will not. There are work arounds. I'm having to
fall back to 4.0 because I can't get .jsp to work with 4.1 database (no
connection).
GH said:
> What I have been asking for... is that the upgrade do
William R. Mussatto said:
> Mark Matthews said:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> William R. Mussatto wrote:
>>> Keith Ivey said:
>>>
>>>>William R. Mussatto wrote:
>>>>
>>>>
>>&g
Mark Matthews said:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> William R. Mussatto wrote:
>> Keith Ivey said:
>>
>>>William R. Mussatto wrote:
>>>
>>>
>>>>I've been googling for 1/2 hr w/o any answers. sorry if I'
lution I used was to create
the passwords using OLD_PASSWORD('plaintextPassword') function
Look at http://dev.mysql.com/doc/mysql/en/Password_hashing.html for the
details as well as work arounds. When they update DBD::mysql this should
go away.
--
William R. Mussatto, Senior Systems Engineer
P
Michael Stassen said:
>
> Rudy Lippan wrote:
>
>> On Mon, 15 Nov 2004, Patrick Galbraith wrote:
>>
>>
>>>William,
>>>
>>>I'm not sure about this, because it involves windows/active state, and
>>> those ppm packages used for active state perl are pre-compiled to
>>> run. I'll talk to the current m
un older mysql which have to support the old
interfaces. The only think I can think to do (assuming you can't ask
which version is supported) is to try the long and then the short version
of the passwords, or to allow the default behavior of the DBI-> connect
function to be altered by
Mark Matthews said:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> William R. Mussatto wrote:
>> Keith Ivey said:
>>
>>>William R. Mussatto wrote:
>>>
>>>
>>>>I've been googling for 1/2 hr w/o any answers. sorry if I'
Keith Ivey said:
> William R. Mussatto wrote:
>
>>I've been googling for 1/2 hr w/o any answers. sorry if I've missed
>> the obvious.
>>Problem. Fresh install of mysql 4.7.1, AS perl 5.8
>>DBI and DBD-Mysql via ppm.
>>Client does not support authn
#x27;dbi:mysql:cjuhsdinfo', '{username}',
'{password}') called
at stdconfig.ph line 2
Any thoughts on how far I need to fall back to get around this?
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For li
-xbuiltin=%all -xlibmil -xlibmopt -xtarget=native' CXX='CC'
CXXFLAGS='-xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all
-xlibmil -xlibmopt -xtarget=native' LDFLAGS='' ASFLAGS=''
LIBC:
-rw-r--r-- 1 root bin 1886116 Nov 4 2
Is there a way to tell mysqldump to dump all tables in
the specified database except certain specified
tables?
Like maybe: "mysqldump dbname !exclude_this_table >
data.sql"?
I have about 200 tables in my database and I only need
to back-up about 98% of them. The other 2% are HUGE
temporary searc
manual, and also read High Performance MySQL
>> from Zawodny
>> and Balling, and MySQL from Paul Dubois, but none of them seem to
> address
>> this issue.
>>
>> Can somebody point me to a URL or book that I should be reading to
> improve,
>> this, or
In your query you have converted the Date column into a string by using
DATE_FORMAT so it is a string of bytes. If you want it to still be a
date then don't format it.
John Bonnett
-Original Message-
From: Thomas Trutt [mailto:[EMAIL PROTECTED]
Sent: Thursday, 7 October 2004 2:29 AM
To:
> I'll look into this, though.
>
> Thanks,
> Michael
Actually php may be using connection pooling which will NOT close off the
connections. It can be configured either way in the apache php
configuration file. I use squirrelmail, which is a php based webmail
system with MySQL holdin
Alfredo Kengi Kojima said:
>
> MySQL Administrator 1.0.11 has been released.
>
> MySQL Administrator is a GUI management console for MySQL, with support
> for tasks such as managing users, configuring MySQL, performing backups,
> editing table definitions etc.
>
> More information at:
> h
k. From
>>>>
>>
>> what
>>
>>>>I've been reading, a restart will cause this to happen, but I'm in a
>>>> production environment, and I'm afraid that InnoDB will take its
>>>> sweet
>>>
>>>time
&g
onsive. Do
each of your perl scripts include an explicit ' $dbh->disconnect;'? That
may be needed to return things to the pool. You might also make sure that
the $dbh is 'my'ed and that its scope is less than the entire program.
For example putting it inside of set of { }
Is the 2GB filesize limit in linux still there?
Specially in Gentoo and Debian linux?
If so, how can this be addressed when your mysql's
.MYD files reach 2GB?
Is there any way MySQL can split really big .MYD
files?
Regards,
Shannon
__
Do you
ble.
>
> I've read on this list that people running MySQL w/ FreeBSD can have
> similar sounding problems. I am wondering if there is a connection.
>
> I know that the site is getting virtually no traffic, so the problem is
> not that it is being overloaded. I have tried this scen
good day all!
i'm getting really confused with how to properly allow
users to access mysql from other machines.
that is, i tried this as mysql root user:
GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.* TO
[EMAIL PROTECTED] IDENTIFIED BY 'password';
after this, i can access mysql as 'dbus
Hello,
It should select * from table where field not like '%c%';
or to be safe;
select * from table where field not like 'c%' and field not like '%c'
and field not like '%c%';
Fred.
Tiago Serafim wrote:
Hi,
Try the following:
WHERE not (field like '%c%' or field like'%C%')
Cheers,
On Wed,
Hello Jungsu,
What are the tools you're using to connect? Any client applications?
Fred.
Heo, Jungsu wrote:
>Hello.
>
>I'm using MySQL 4.1.2 on Linux(Fedora Core 2) and Window 2003 Server.
>
>When connect from Linux to Windows, or from Window to Linux connection time is very
>slow.
>( it take
hello list!
i'll be moving from a RedHat server to a Debian server very soon. despite the
different linux distributions, is it ok to transfer my entire mysql database by just
copying everything in /var/lib/mysql of the RedHat system to the Debian system? has
anyone tried this before?
the r
Do you mean SQLYog? If so, this is a MySQL GUI - Info. at:
http://www.webyog.com/sqlyog/index.php
John R. Porter
I.T. Services
University of Strathclyde
Faculty of Education
76 Southbrae Drive
Glasgow
G13 1PP
e-mail: [EMAIL PROTECTED]
Tel. 0141 950 3289
-Original Message-
From: Robert J
thing always happens. Is this a known issue
> with Apache + mysql 4.0.18?
>
> Ryan
>
Are you using mod_perl by any chance? You might check to make sure that
you are calling 'disconnect' at the end of each call. With mod_perl
connections may stay open. I see a similar proble
Y'
Do I have to set 'Grant_Priv' to 'Y' for 'demouser' in the 'user' table?
Doesn't that give the user global GRANT privileges, rather than restricting
them to the single database 'test'? Or do I have to give the user Read/Write
privs. to the gra
oes 'demouser' have to be explicitly GRANTed access to the MySQL grant
tables (user, db, host, tables_priv and columns_priv) before the user can be
GRANTed GRANT privileges to any database or table? If so, what are the
minimum privileges required?
John R. Porter
I.T. Services
Univer
1 - 100 of 785 matches
Mail list logo