, an empty mysql directory is created.
Cameron
On Thu, Feb 12, 2015 at 2:35 PM, Bob Eby wrote:
> Hi Cameron,
>
> I've seen a similar error running on windows 7.
>
> When you look in your datadir= specified in my.ini what is there exactly
> (hopefully not empty)? Do y
tempted rebooting before and after installation of
mysql-community-server to no effect.
Previous versions of 5.6.x appear unaffected.
Cameron Mann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
find a
hosting site. I need a hosting site that allows me to:
1. Use PHP/MYSQL
2. Send 1000 + emails a day <-- the mail function has been my greatest
limitation with godaddy
Thanks in advance, Cameron
So it turns out that the RPM install didn't work nor did the binary version
but by rebuilding the source with a
configure --prefix=/usr/local/mysql --- Well, that worked in the end. I
still don't know why but there it is. :)
Just thought I'd post my experience.
Cheers
-Original Message--
Thanks Rory,
I did go through (as per the manual)and set the permissions
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> scripts/mysql_ins
;>
> >> try
> >>
> >> mysql> CREATE TABLE oldreport_2002_12_08 as select * from oldreports;
> >> to create populated copy
> >>
> >> or
> >>
> >> mysql> CREATE TABLE oldreport_2002_12_08 as select * from oldreports
&
ulated copy
>
> or
>
> mysql> CREATE TABLE oldreport_2002_12_08 as select * from oldreports where
> 1=2;
> to create an empty copy
>
> I hope this helps
>
> Simon Windsor
> Eml: [EMAIL PROTECTED]
> Tel: 01454 617689
> Mob: 07960 321599
>
> -Origin
Thanks for the quick reply!
As root, I tried:
mysql> use research1data;
mysql> show tables;
+-+
| Tables_in_research1data |
+-+
| oldreports |
+-+
1 row in set (0.00 sec)
mysql> CREATE TABLE oldreport_2002_12_08
I have spent some time in the past with mysql but am far from an
experienced database head. A while back I received a some mysql data
for a research project. The files are:
$ cd /usr/local/mysql/research1data
$ ls -lh
-rw-rw 1 mysql mysql 21G Jun 20 2003 oldreport_2002_12_08.MYD
-rw-rw
ithout issue for a good 3
months. Recently the load has increased, but only from .3 to .5 queries
a second.
Anyone have any ideas on where I should start looking?
Thanks,
Chris
--
Chris Cameron
UpNIX Internet Administrator
ardvark.upnix.net
bitbucket.upnix.net
--
http://www.upnix.com
n EXPLAIN on this query as it also hangs. Also, I've
been fiddling with indexes, so they may be a little out of whack.. But I
do think the right things are indexed.
Any help would be appreciated.
Thanks,
Chris
--
Chris Cameron
UpNIX Internet Administrator
ardvark.upnix.net
onnection with
MySQL as well.
Here are my system specs:
mysqld Ver 3.23.54 for pc-linux-gnu on i686
I've tried with kernel 2.5.59 as well, I'm currently using: 2.4.21-pre3
I have dual pentium III 800 mhz cpu's (133 fsb)
1 GB of pc133 ram
If more info is needed, I will glady provide
instead of trying to cheat :)
Anyway, thanks for your help guys,
CM
PS Rick, I don't have much experience with AWK, always been one of those
things I need to look into.
-Original Message-
From: Bradley Brown [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2002 00:27
To: Cameron Murdoch
Cc: [
D 4-STABLE. MySQL was compiled
from the FreeBSD port.
Thanks for your help,
Cameron
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To re
Uma
I asked MySQL the same question earlier this week and got the following
answer :
>Cameron,
>Actually Stored procedures and triggers will be in version 5.0, which
is >planned for release by end of year. Current development is
underway. A >stable version of 5.0 will likely be i
Just a quick question regarding how (if at all) MySQL's binary update log
consumes resrouces as it records modifications to various tables in the
database.
Are there any potential performance issues or limitations to be
expected (other than excessive consumption of diskspace) if this log is
not f
OBLIGATORY TOPIC REFERENCE TO BYPASS FILTER: mysql
Just a quick question regarding how (if at all) the binary update log
consumes resrouces.
Are there any potential performance issues or limitations to be
expected (other than excessive consumption of diskspace) if this log is
not flushed/rotated
I'm sure this is disscused somewhere, but I'm not sure how I'd look for
it.
Is it possible to supply a thesaurus-like file for mysql so when you
go "%oil%" it finds petrol gas and/or lubricant?
Does anyone know of a database that will do this?
Thanks,
Chris
---
Perhaps it's his platform of choice.
On Sun, 2 Sep 2001, Sinisa Milivojevic wrote:
> What you are trying to do can be done on NT / W2K only.
>
> --
> Regards,
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__
Is there a place that outlines the advantages/disadvantages of both
MyISAM and InnoDB?
Thanks,
Chris
-Original Message-
From: Tonu Samuel [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 04, 2001 2:34 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Thinking of switching from My
I sent this before, but it never made it..
Does anyone here have any advice on controlling the size of user
databases?
I've heard talk of symlinks before, anyone had any luck with that?
Thanks,
Chris
-
Before posting, please
I'm sure if done right, MySQL could do whatever you want satisfactorily.
Same with MS SQL (ignoring cost).
However, something few people seem to know, but I've realized from
experience is that when you offer people services based off free
software, you get a different kind of customer. And not th
Have you checked that you've got a musql server running. (ps ax|grep mysqld)
On Fri, 13 Jul 2001 05:51, you wrote:
> Thanks for your replies
> but my problem is still there
> this is the php code iam using for connecting to Database:
>
> $ss_conn = mysql_connect($db_host,$db_usr,$db_pwd);
>
> a
Shouldn't it be ./configure --prefix=/usr/local/mysql
On Mon, 16 Jul 2001 12:44, you wrote:
> I am trying to compile mysql by it is failing in the ./configure step. I am
> running solaris 2.5.1 , gcc 2.95, binutils 2.11.2. It fails with the
> following error
>
> ./configure -prefix=/usr/local/mys
A client has asked us to make him an application that requires us keeping
Credit Card Numbers. I'm a bit concerned as it immediately remined me of
egghead.com (having all their CC #'s stolen).
One of the ideas was to have the users password encrypted as an md5 hash,
and then to encrypt the users
I'm currently using a 166 UNIX machine for a dedicated MySQL database,
and I'm interested in knowing what kind of speed I should be expecting
from it. I ask because right now it's at a point of being unusable even
for development on some of the larger queries.
I compiled MySQL 3.23.37 myself with
Hi,
Seems I've never had any luck with MySQL and OpenBSD, and I'm hoping I can
finally get some help now that I've finally got around to recompiling it
again.
I'm running OpenBSD 2.7 and am compiling MySQL 3.23.38. I'm using the
configure options;
"CXXFLAGS="-O6 -march=i586" CFLAGS="-O6 -march=i
>Description:
The following line inputs the current UNIX time into a field -
date_start - with the date_stop filed defaulting to '0':
insert into contract_work (sess_id,email,date_start)
values('bde32bfde3ac89c7d510df573bb6bb88','Joe Bloggs',unix_timestamp())
The result is as follows:
I should start reading this list more..
I've had a similar problem, and good luck finding many people who'll help
you with OBSD problems on this list (or any problems for that matter).
Anywho, it's ports specific I think. I installed MySQL from source
compiling with -O6 and the proper arch (like
concurrently and if any one is not able to, then none commits.
regards
Martin Cameron
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Whenever my MySQL server (3.23.33) is under heavy load it restarts itself.
Stopping whatever was connected to it at the time.
In my .err log I've just got;
010307 00:12:32 mysqld started
/usr/local/libexec/mysqld: ready for connections
Killed
010307 00:16:56 mysqld restarted
/usr/local/libexec/
word I throw at it, it says I don't
have access AHHH!
>Fix:
>Submitter-Id:
>Originator:Cameron Gull
>Organization:
SeraNova, Inc.
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: Can't set the MySQL
After noticing all my PHP scripts using MySQL had stopped working, I
noticed that any attempt to look through databases mith mysql brought
up;
Can't read dir of '.' (Errcode: 9)
Can't read dir of './mysql' (Errcode: 9)
Database changed
I can no longer get any information from MySQL, and I'm hopin
D/mit-pthreads: not found.
make[2]: Entering directory `/u105/cameron/temp2/mysql-3.23.32/mit-pthreads'
GNUmakefile:55: /pthreads/GNUmakefile.inc: A file or directory in the path name
does not exist.
--
I also n
34 matches
Mail list logo
