rude awakening. What is an effective easy to
follow protocol for backup and recovery in mysql!
Nick from Toronto
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
What is the best way to backup your database. Which are the files that
I need to store on a usb disk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
:)
Nick.
On Wed, Aug 21, 2013 at 10:39 PM, wrote:
> >>>> 2013/08/21 18:03 -0400, Nick Khamis >>>>
> We have the following mysql timetampe field
>
> startdate | timestamp | NO | | -00-00 00:00:00
>
> When trying to insert a long value in th
--++
| Variable_name | Value |
+---++
| time_zone | +00:00 |
+---++
SELECT @@global.sql_mode;
+---+
| @@global.sql_mode |
+---+
| |
+---+
Not sure why I am getting this error.
Thanks in Advance,
Nick.
Question, is building the source exactly the same as mysql?
Meaning, if I build it with set CMAKE options building mysql, can I
use those exact same options building mariab?
eg:
cmake -DCMAKE_INSTALL_PREFIX=/usr -DINSTALL_INCLUDEDIR=include/mysql
-DINSTALL_LIBDIR=lib/mysql -DMYSQL_USER=mysql
-D
Just out of curiosity, is the hardware stationed, or traveling close
to the speed of light (i.e., 18,000 miles per second)? Sorry I could
not help it
N.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hello Everyone,
We installed mysql 5.6.11 from source without server, and was
wondering what happened to the mysql command?
/usr/local/mysql/bin/
innochecksummysql_waitpid replace resolveip
my_print_defaults perror resolve_stack_dump
Kind Regards,
Nick
n fix made available to them months ago,
should, get me a win to move away from mysql. (perhaps this is what
oracle wants anyway, since mysql earns them no money)
On 6/9/13, Claudio Nanni wrote:
> Hi Nick,
>
> It seems it is fixed already in MariaDB:
> http://bugs.mysql.com/bug.php?id=
This was reported in 5.5.31, a patch, VERY SIMPLE was submitted.
The problem goes ignored by oracle
5.5.32 releases, same error, apply the same simple patch and builds
/tmp/mysql-5.5.32/vio/viossl.c: In function 'ssl_do':
/tmp/mysql-5.5.32/vio/viossl.c:175: error: 'SSL_OP_NO_COMPRESSION'
undecla
This is what happens when a large conglomerate writes large
checks. Everyone goes on the aggressive... I'm KIDDING!@!!@#!@!!
N.
On 4/6/13, Noel Butler wrote:
> On Sat, 2013-04-06 at 16:18 +, attee...@gmail.com wrote:
>
>> You don't have to be a jackass to him/her.
>>
>
>
> He's always a
Hello Reindl, I just noticed that I misspelled your name. Sorry about that!
Cheers,
Nick.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
in_symax |
+---+
| acc |
ERROR 1146 (42S02): Table 'symax.acc' doesn't exist
I should mention that we have deleted the ib_* files in the past. Is
it ok if I post our config
for a quick review?
Thanks in Advance,
Nick.
On Tue, Nov 1, 2011 at 10:09 A
ailed to create sys files
make[2]: *** [include/mysqld_error.h] Error 1
make[1]: *** [extra/CMakeFiles/GenError.dir/all] Error 2
make: *** [all] Error 2
Thanks in Advance,
Nick.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
I should have mentioned that this is using mysql 5.5.15
Thanks Again,
Nick.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello Everyone,
I am looking to build just the mysql client, and not the entire server
from source.
Which cmake flags do I need to install just the mysql client/devel header files.
The actualy mysql server is on a different machine.
Thanks in Advance,
Nick.
--
MySQL General Mailing List
For
Thanks Shawn!
Ninus from Montreal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I will post the cmake that get's just the devel header files shortly.
Nick.
That being said, does cmake have a --help friend? I just don't want to
install the complete MySQL server, just MySQL-devel, as
mentioned earlier.
Nick
Hello Everyone,
Thank you so much for your response. I don't need the entire MySQL server
just the
development libraries. I found "MySQL-devel-5.5.16-1.linux2.
6.i386.rpm", but there is
no MySQL-devel-5.5.16-1.linux2.6.i386.tar.gz.
Thanks Again,
Nick.
Hello Everyone,
Thank you so much for your response. I don't need the entire MySQL server
just the
development libraries. I found "MySQL-devel-5.5.16-1.linux2.
6.i386.rpm", but there is
no MySQL-devel-5.5.16-1.linux2.6.i386.tar.gz.
Thanks Again,
Hello Everyone,
I was wondering if the MySQL devel files tar was available for download? I
was
only able to find rpm on the mysql site.
Thanks in Advance,
Nick.
9","NGU10","NGU11","NGU12","NGU13","NGU14","NGU15","NGU16","NGU17","NGU18","NGU19","NGU20","NGU21","NGU22","NGV09","NGV10","NGV11","NGV12","NGV13","NGV14",
"NGV15","NGV16","NGV17","NGV18","NGV19","NGV20","NGV21","NGV22","NGX09","NGX10","NGX11","NGX12","NGX13","NGX14","NGX15","NGX16","NGX17","NGX18","NGX19","NGX20","NGX21","NGX22","NGZ09","NGZ10",
"NGZ11","NGZ12","NGZ13","NGZ14","NGZ15","NGZ16","NGZ17","NGZ18","NGZ19","NGZ20","NGZ21","NGZ22");
Running query b gives me a result set as follows:
| 2010-01-15 | NYMEX | NGZ22 | 8.9620 | 8.9680 | 8.9620 | 8.9680
| 0 |
++++-+-+-+-++
86765 rows in set (4.46 sec)
I then because I want to generalize query b I continue by creating query c
as follows:
mysql> select * from endOfDayData where endOfDayData.market like 'NYMEX'
and endOfDayData.symbol IN (select names.symbol from names where
names.market like 'NYMEX' and names.name like 'natural gas {%');
Query c seems to have good syntax as neither the command line mysql
interface nor the gui spit it back but it literally takes forever to run;
I've waited at least twenty minutes and not got anything back. I'm running
Ubuntu 9.10 on an intel core i7 with 4GB RAM and 12GB swap... the process
monitor doesn't even flinch so I'm not thinking hardware here... why is the
sub-query running so slow?
Thanks for you help!!
Nick
hdparm -Tt /dev/sdX ?
Ian Simpson wrote:
That's pretty much what I've been doing to get that the drive is running
at 100% bandwidth.
What I'd like is something that just gives the bandwidth of the device
in terms of Mb/s: you can probably work it out using that iostat
command, seeing how mu
I want to install MYSQL from source on Windows.
Now, i have compiler success with Microsoft Visual Studio 2005 and Cmake on
Windows XP.
But nothing happened!!
I have read the "INSTALL-WIN-SOURCE" that is in source, but no use.
So, who can help me what should I do the next step to install MYSQL
Hello Jeremy
Thank you for the pointer. After make clean, re-configured, re-compiled then
tried, but /path/to/bin/mysql --help still shows /etc/my.cnf as the default file.
Jeremy Cole wrote:
Hi Nick,
This should do it:
--sysconfdir=DIR read-only single-machine data [PREFIX/etc
Is there an easy way to build MySQL client library, server and start-up script
so that /etc/my.cnf is ignored?
I need to build client and server so that it in no way interacts with the global
system install, and build programs against that client library which also don't
interact with the glob
,
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello John
There are two approaches to this.
1) Best, save date into table as a number. Select date like
WHERE date>=$date1 AND date<=$date2
2)Otherwise, if storing dates a strings:
WHERE date=$date1 OR date=$date2 OR date=$date3 OR date=$date4 OR
date=$date5.
In general, if you want to
that I get this problem even when the
temporary table doesn't exist, on a brand-new connection.
I've had this code running for a couple of weeks and just noticed the
problem, so I'm not sure if it cropped up right away or not. Haven't
had a chance to bounce the server yet.
Hello Adam
Adam Wolff wrote:
Actually runs through the table four times instead of twice, and maybe
can't even use the index for the whole query.
Assuming my results are not typical of MySQL query times, this would
explain the sqrt() relationship of returned rows to query time.
I have tried
Alexey Polyakov wrote:
On 4/23/06, Nick Hill <[EMAIL PROTECTED]> wrote:
I've noticed a couple things.
1) Right now you're emulating spatial index.
2) In future, you're going to emulate partitioning.
Why do you think that doing this stuff manually is better than using
buil
Hello
I have been looking at planning the database strategy for openstreetmap
(http://www.openstreetmap.org).
There are several data types stored in tables with longitude and
latitude columns. Select statements work by selecting
where lat>$lat1 and lat<$lat2 and lon>$lon1 and lon<$lon2
I h
Hi, experts
How can I make mysql database users password with expire date?
Does mysql can do it?
--
NiCK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ut the stored procedure debugger -- does all the
functionality in the documentation work with MySQL? Anybody used this with
MySQL, who could describe their experience with it?
I would really love a good SP debugger!
Nick
--
Nick Arnett
[EMAIL PROTECTED]
Messages: 408-904-7198
ll let me use the function.
I hit a problem using functions in stored procedures, too, and I'm wondering
if these are related.
Nick
--
Nick Arnett
[EMAIL PROTECTED]
Messages: 408-904-7198
Somebody give me some ammo for this. I flagged MySQL v5 to our CTO and
got shot down. We currently develop in MSSQL and I don't know enough
about either to make a constructive argument. I'm not even sure I
understand what he's on about with 'table functions' and 'nested
selects'. I couldn't find th
Is there a way to have foreign keys and force referential integrity? I have
a main table and a lookup table, i want to be able to require that the main
table is using values from the lookup table. I am just not sure how in
MySQL. Thanks
eet.
Thanks to everyone here for their insight. I coudln't
have achieved it without all of you!
-Nick
--- inferno <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I had to do the same thing on a project and the
> problem was that if
> you use CSV you will not be able to mak
--- Partha Dutta <[EMAIL PROTECTED]> wrote:
> Nick Jones wrote:
>
> >--- "J.R. Bullington" <[EMAIL PROTECTED]>
> wrote:
> >
> >
> >
> >>Automatically populate??
> >>
> >>Not that _I_ know of, but of course ther
oven to be less than useful so far in my endeavor.
Also, thanks to James for his suggestion on using the
ODBC query directly from Excel. This will get us
started for the time being, and give me some leeway so
I can work on doing this in PHP.
Thanks to you both!
-Nick
__
Does anyone know if it is possible to populate values
into an Excel spreadsheet from a MySQL database? Can I
do this directly in Excel or do I need to create an
external program to do the work (i.e. in VB).
Thanks
-Nick
__
Do You Yahoo!?
Tired of
Jigal van Hemert wrote:
Nick Sinclair wrote:
"[.] WHERE date_format(timestamp, '%Y-%m-%d %T')
<=DATE_SUB(CURDATE(),INTERVAL $BLACKLIST_DECAY HOUR)"
* ...It only resolves to the DAY and not an hourly resolution. I have
included a script below that I use f
Hi All,
I seem to be having a problem with the resolution using the timestamp
function. I am accessing the database "snort" on an ACID/SNORT/MySQL
installation utilizing a collection of shell scripts that are run as
cron jobs and function as a "bot" adding and removing firewall rules
(iptables
Hi All,
I seem to be having a problem with the resolution using the timestamp
function. I am accessing the database "snort" on an ACID/SNORT/MySQL
installation utilizing a collection of shell scripts that are run as
cron jobs and function as a "bot" adding and removing firewall rules
(iptables
able4.something
AND
table1.something LIKE table5.something
AND
table1.something LIKE table6.something
;
----( Nick Pasich )
On Mon, Apr 25, 2005 at 12:51:53AM +0200, Schalk Neethling wrote:
> Greetings everyone.
>
> Hope someone can give me some
were on 4.0.18).
I see some changes to datetime handling in the 4.1.x releases, but
nothing that seems immediately obvious.
I hope to fix this is by re-building MySQLdb based on the 4.1.10
libraries. Any other suggestions? I'm using MySQLdb.times to format
the datetimes before inserting.
Thanks. That was it. I'm glad it was something so simple. Just needed a
careful set of eyes. I was worried my understanding of SQL/JOINs was
screwy.
Thanks again.
Nick
PS I'll read up on the FULLTEXT matching. I don't know it well.
>> $query = "SELECT v.vbus
it's
> tough to narrow down the problem.
>
> sk
Yes, I understand, but that's not what I'm getting. I'm getting rows
returned where "apples" is not present in any of the columns in any way. I
think it's a syntax mistake in my query, but I can't see it.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
p.productname LIKE '%Apples%')
OR (p.productfamily LIKE '%Apples%')
OR (v.vcategory LIKE '%Apples%')
GROUP BY v.vbusiness
Where am I going wrong? The results aren't random, but I can't see how
they're coming up with what they're coming up with.
TIA,
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e never been able to see how we can find out which connection has the lock
on a given table. If
that's possible, I'd like to know that, too, so I could at least know how it
got locked in the first
place.
Could a misbehaving client do this in a way that would cause the lock to
persist even
tement and that would just slow you down, wouldn't it?
Indeed, which was one reason I went with the HEAP table... which is also a TEMPORARY table so that
two clients can work concurrently.
Thanks.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
looked at using LOCK IN SHARE MODE, but I don't see how to be sure
that a SELECT ... LIMIT... statement will select the same messages as UPDATE... LIMIT... unless I
lock the whole table, which seems needless.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
ches
that work for it do apply... but unless interoperability matters, it's
hard for me to imagine a good reason to bother with XML.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
x27;ll be interested!
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ry_key
and if I do the equivalent SELECT:
EXPLAIN SELECT * FROM a, b WHERE a.primary_key = b.primary_key
it shows that it's doing a table scan on table b.
Is this normal? Is it because primary keys are unique? I had imagined
that this would be a very fast operation, but it's not, it&#x
ull-text engine when a record is added or modified, and the
pointer for deletes.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dathan Pattishall wrote:
Use char
And use fixed-length types for *all* columns... one variable-length
column makes all records variable-length.
Nick
-Original Message-
From: Marc Michalowski [mailto:[EMAIL PROTECTED]
Sent: Friday, January 28, 2005 10:28 AM
To: mysql@lists.mysql.com
27;s what I was just reading!
So... is this the equivalent of using BEGIN and COMMIT, for which I have
methods in the Python MySQLdb module? Or is there an advantage to the
latter?
Thanks again,
Nick Arnett
Director of Business Intelligence Services
Liveworld Inc.
--
MySQL General Mailing List
Fo
OMMIT off and COMMIT when appropriate?
Thanks!
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
since
it will have copied them to the same table, then delete them.
I can do it the way above, but I'm thinking there might be a better way...
Thanks!
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I am trying to get MsSQL working. I can't get the server to start.
I tried typing in mysql_install_db and got the following response:
linux:/home/nick # mysql_install_db
Installing all prepared tables
040602 5:54:02 /usr/sbin/mysqld: Shutdown Complete
PLEASE REMEMBER TO SET A PAS
from the database on my 2.7GHz with 2GB of RAM it
will spike to 100% for around
1 second then go back to normal.
--Nick
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Nick A. Sugiero" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
is at all as it effects the performance of the
server / game and I'm also worried someone could use such a thing to cause a
Denial of Service attack.
Regards,
--Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
440 is only 84MB, which
should be under 512MB. I'm not running out of processes or file handles, or
sockets from sysctl -a. Does anyone have any other suggestions or things to
double check?
Nick
rd to
track down at first because the manually compiled version of MySQL didn't
give me near the details the binary version did.
Thanks!
nickg
-Original Message-
From: Jeremy Zawodny [mailto:]
Sent: Wednesday, February 11, 2004 12:55 AM
To: Nick
Cc: [EMAIL PROTECTED]
Subject: Re: F
--- Original Message -
From: "Nick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 02, 2004 1:30 AM
Subject: FreeBSD 4.9 + MySQL 4.0 + LinuxThreads
>
> I previouslly compiled my own version of MySQLd 4.0.14 on FreeBSD 4.8 with
> LinuxTh
I previouslly compiled my own version of MySQLd 4.0.14 on FreeBSD 4.8 with
LinuxThreads using Jeremy Zawodny's config/compile options
(http://jeremy.zawodny.com/blog/archives/000458.html) and have had no
problems. However, I've got 4.9 install with updated ports, etc. and I
can't seem to get 4.0.
http://www.mysql.com/doc/en/mysql_connect.html
This function is deprecated. It is preferable to use
mysql_real_connect() instead.
#include
#include
int main(void) {
MYSQL mysql;
if(mysql_init(&mysql) == NULL) {
fprintf(stderr,"Unable to initlize MySQL structure.\n");
Any idea when 4.1 will be released as a final?
nick marsh
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear ALL
I am Nick, I come from Taiwan company - EC-SERVER~~I have two WEB
SERVER to make load balance. Both of the WEB SERVER was installed mysql~~
I used the mount NFS instruction the storage spaces in linux.At the
same time,WEB's Data and mysql's data both in NFS parat
be Jeremy could compile "unofficial but recommended" binaries that
MySQL AB would support more like official binaries? :) If he's got
nothing better to do of course, he already puts in so much time to the
MySQL community as is.
Nick
-Original Message-
From: Ken Menzel [
es in queue
Main thread id 158370816, state: waiting for server activity
Number of rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----
END OF INNODB MONITOR OUTPUT
Nick
--
MySQL General Mailing List
For list archi
the same column over multiple _rows_
I am aware of the GROUP_CONCAT function, but we are currently running
MySQL 4.0.13 (this functionality is only available on a vers > 4.1)
If any one has a suggestion as how I should go about this one I would
really appreciate it.
Kind regards, Nick
--
Nic
> Hello,
>
> I have aproximately 1,000,000 rows and I would like to do some query.
> The first one is to get the number of row so I do :
>
> mysql> SELECT COUNT(*) FROM `Log`;
> +--+
> | COUNT(*) |
> +--+
> | 969129 |
> +--+
> 1 row in set (0.00 sec)
MyISAM tables keep
I know the replication method is different in MySQL 4.0 then MySQL
3.23.x, but I have a bug that causes problems. The following query will
cause MySQL's logic to not properly read any of the following my.cnf
commands on slave servers:
replicate-wild-do-table
replicate-wild-ignore-table
replicate-
data
chgrp -R mysql data
in the mysql directory. Obviously you need to have a mysql user, and
this lets that user, and only that user write to the data directory, or
even enter it for that matter (besides root of course).
HTH!
-Nick
On Wed, 2003-07-30 at 01:19, Peter Bradley wrote:
> Hi Sa
no longer a
transaction.
The culprit was some table locking that improved performance quite a bit
when the tables were MyISAM. Gotta go look for more of those lurking in the
corners, I guess.
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
> -Original Message-
> Fr
ere was a bug that it was specified as a
> NO_ARG parameter.
I noticed some of your other messages about that. It's probably time for me
to update.
Thanks very much. I really appreciate the speed with which you respond (not
just to my messages, I read the list regularly).
Nick
--
MySQL
n to find out who uses a
given application, the query would be along these lines (this uses the
column 'app_id' as the key:
SELECT used_by FROM nms_apps, user WHERE nms_apps.app_id = user.app_id AND
app_name = "Application Foo"
Hope that helps. If you grasp this, you'll
e future?
Thanks for any info...
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yep, saw that and did just as you stated :)
> Nick, As you stated, your priority field datatype is "varchar", with
> possible
> values "Hi", "Medium" and "Low", as opposed to being integers. The use of
> max
> function, as suggested by
That works great. =D
Knew it shouldn't be that difficult, thanks a bunch.
And it actually works with the Priorities being in text form to (low, med,
hi).
-Nick
> At 02:52 PM 7/24/2003, you wrote:
>>After some searching around different books/manuals/google I still can't
>&
entire table.
I really want to group by the resource, but still have all the info
available for what ever the highest priority task it is in.
-Nick
Btw, all the fields are varchars with the priorities being Hi, Medium,
Low, but I could really care less on what particular priority it is atm
other words, if a resource is in a high priority task and a low
priority task, I only want to show the high priority task.
Thanks for the help!
-Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 17, 2003 9:38 PM
> To: Nick Arnett; [EMAIL PROTECTED]
Well, Paul, just knowing you were on the job inspired me and I finally
realized the dumb thing I'd done. The list I'm
ght near the beginning of the HTML, where it has lots of (annoying, I
suppose) backslashes, quotes and other stuff that is a pain to encode
properly by hand.
Any help will be most gratefully accepted. My hair will thank you, too.
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTE
not set right. Any help would be greatly
appreciated.
Nick
Oh, and I can not find ANY log files anywhere (/var/lib or
/usr/local/mysql/data).
Here are some messages:
[EMAIL PROTECTED] mysql]# pwd
/usr/local/mysql
[EMAIL PROTECTED] mysql]# bin/safe_mysqld --console
Starting mysqld daemon with
Yep, that was it, along with what Mark said.
On Wednesday, Jul 9, 2003, at 15:10 US/Central, gerald_clark wrote:
Nick Boudreau wrote:
Trying to start mysqld for the first time after a reinstall on Mac OS
X gives me this error:
030709 12:53:26 mysqld started
030709 12:53:27 InnoDB
mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: Cannot continue operation.
030709 12:53:27 mysqld ended
Anyone know what could be causing this? I'm baffled.
Thanks,
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysq
reate the mySQL user on Mac OS X?
2. How can I delete all that stuff about root users and start anew?
3. What can I do about the socket error?
#3 may not be an issue once I fix the others.
Please consider helping a poor guy out.
Thanks,
Nick Boudreau
--
MySQL General Mailing List
For list archives
Thanks for pointing that one out. Unfortunately relplace(table.*, ...)
does not work (syntax error) so I'll stil have to go through each field
individually. This will be two statements per-field which kinda stinks,
but oh well.
Thanks again!
-Nick
On Mon, 2003-06-23 at 11:10, Mike Hillyer
hole bunch of fields
and don't really want to go down the route on all of the fields. But if
I have to I will.
Thanks for the advice!
-Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
o insert fewer
records at once or increase MAX_ALLOWED_PACKET, if I recall the correct
variable.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lumn (int has
> support for
> up to 2.1 Billion records wheras mediumint is up to 8.3 million - more
> efficient for your data type).
If he only has a few million records, why would this be more efficient?
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
ing INTs to STRINGs with
that last bit, in which case you'd want to change the column type for
pricelevel or put quotes around the numbers in the query? I hit that
problem all the time using 1 and 0 as Booleans in an ENUM column.
Nick
--
MySQL General Mailing List
For list archives: http:/
nserting quite a few at a time, you might disable indexing, do
the inserts, then allow the indexing to happen all at once. For a large
number of inserts, you might also try writing them to a file, then loading
it. That's much faster for really large numbers of inserts, and you can
also suspend indexing as I mentioned. I use the latter for building
externally generated text indexes (frequency tables and such), generating a
couple of million records at a shot. It made an enormous difference. But
I'm working in Python and can't help you with the C API, as I said.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
might first try one of the generic sample config files that came with
your new version, just to see if it'll start up properly. Then try
modifying one variable at a time, restarting after each.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You could pre-pend "EXPLAIN" and see if it generates an error.
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
> -Original Message-
> From: Jerry [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 04, 2003 5:46 AM
> To: [EMAIL PROTECTED]
> Subjec
yone confirm that wildcards, indeed,
can't be used in phrase searches. I'm doing these in Boolean mode because I
need exact counts of occurrences. This is on MySQL-4.0.12-nt.
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives
1 - 100 of 312 matches
Mail list logo
