hello,
I'm kindof a newbie with MySQL, and recently did something fairly stupid : I
installed a new system (I'm running on MacOSX, was 10.1.5.1, now after
upgrading it is 10.2.1) and I did not properly do it I'm afraid : I backed
up my /usr/local/var directory which contained all my mysql
Maybe you didn't specify the correct data-dir in my.cnf?
Thomas
sql,query
On Sun, 6 Oct 2002 09:23:51 +0200 jeroen [EMAIL PROTECTED] wrote:
hello,
I'm kindof a newbie with MySQL, and recently did something fairly stupid : I
installed a new system (I'm running on MacOSX, was 10.1.5.1,
Another in my hopefully-sparse-enough tedia2sql announcements.
tedia2sql now supports MySQL and one-to-one relationships thanks to the
international nature of the internet (Thanks, Martin).
What is tedia2sql? You create your database diagram (ERD) in Dia using the
UML shapes. Then you run
1. MySQL storeed data in where you put Mysql
server/data/. Format data file.myi, file.myd, file.frm
2. yes
rgds,
d34dflowers
--- Chris Couture [EMAIL PROTECTED] wrote:
1 - Where does mySQL normally store it's data base
files?
* From what I have seen, it depends on how you
install
Description:
if I access the mysqld locally, all is well, but if I access it
from outside (i.e. not over the 127.0.0.1 interface), the daemon
hangs and restarts.
Could this be the result of a run of RedHat up2date which placed a new gclib?
How-To-Repeat:
[root@liz root]# mysql -h liz -u myself
Okay, I'm very sorry for bothering you all with this. If I had not panicked,
I probably would have found it myself.
- Original Message -
From: jeroen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, October 06, 2002 9:23 AM
Subject: need urgent help recovering after renistall
Okay, I'm very sorry for bothering you all with this. If I had not panicked,
I probably would have found it myself.
The solution was right under my nose :
http://www.mysql.com/doc/en/perror.html
even tough perror doesn't work on my macosx machine, the above webpage
states nicely that errno 13
Hi Friends,
I am having a local MySQL database tables in Linux and the data is
updated in the table using PHP scripts working through apache web server.
local MySQL database is connected using the following php scripts.
mysql_connect(localhost,root,vinodb)
or die (cannot connect to mysqld);
Hi all,
I am having MySQL database on web. (eg., at www.lmcr.net). What is the PHP
script which I can connect the MySQL table from my Local machine. Can
anybody help me.
Regards,
Vinod.
-
Before posting, please check:
Hello,
Since it seems that your new box is limited by the CPU, the conclusion
seems that your old 1GHz biprocessor had more horsepower than the new
single 1.7GHz processor.
Have you replaced a dual PentiumIII by a single PentiumIV ?
Some benchmarks show that a 1.7GHz PIV performs only
Hello James.
What first occurs to me... did you install the two systems independently, or
did you simply copy/paste the compiled apache/mysql/php files/directories?
.. Stupid question, but you never know. At first this performance breach
seems to me like incompability between the different
Maybe P4 1,7 mhz performs marginally better than a P3/1000Mhz, but ...
My webserver have a P3/450Mhz with 384 MB Ram and a 10 Gb IDE drive :P I
cant seem to get above 1.0 load average on the machine on normal use (I have
average 10-30 people online simultaneously 24 hours a day). The machine
Since it seems that your new box is limited by the CPU, the conclusion
seems that your old 1GHz biprocessor had more horsepower than the new
single 1.7GHz processor.
Have you replaced a dual PentiumIII by a single PentiumIV ?
Some benchmarks show that a 1.7GHz PIV performs only marginally better
I am writing a serverside application in Java which needs to query/search
200 000 rows and update affected records once every 2 minutes.
As performance/speed is of importance here - and this Table only contains
5-10 Columns of Integer numbers, I figured that using a HEAP type of table
would be
Hi James,
What kind of disks are in the old system and the new system (scsi or ide,
any raid, what rpm do they have etc..?) I ask this because high cpu levels
can be a symptom of a diskbound server...
Try running the following:
iostat -x 5 5
vmstat 5 5
Let me know I'll try to help.
After giving up MySQL installation with the RPMs I am now wanting to freshly install
MySQL 3.23 (the latest) on my SUSE 7.3 Linux machine. I am a sort of newbie to Linux
also. On p.98 of the Widenius MySQL reference manual I am suppose to do this;
Add the full path;
http://www.php.net/manual/en/ref.mysql.php
- Original Message -
From: Vinod Bhaskar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, October 06, 2002 3:56 AM
Subject: How to connect web database from Local machine
Hi all,
I am having MySQL database on web. (eg., at
-Original Message-
From: Robert H.R. Restad [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 06, 2002 9:04 AM
To: James Riordon; [EMAIL PROTECTED]
Subject: RES: Re: Server comparison running Mysql
Another thing... I noticed once when I moved a website from one server to
another,
I found the following statement in my mysql.server script, and I changed it
back to default... (the howto at tldp.org had me put this in, and I had
forgotten about it)
$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --bind-address=
127.0.0.1
$bindir/safe_mysqld
He is replacing *2* P3/1GHz by *1* P4/1.7GHz, I just wanted to point
out that it doesn't look so much like an upgrade.
And, you know, not all webservers need the same amount of power.
The main webserver I manage is actually a cluster of 6 load-balanced
Apache/mod_perl front-ends with a dedicated
What is the best strategy to make mysqld listen from another port than 3306
?
In fact we have 2 servers that handle mysql. The first is listening at port
3306 but we need that the second one listen from another port in order to
run in our local network IP Port Mapping
What is the simple way to
Hi, I need some help with Mysql on OSX 10.2.1
I get this error
phpBB : Critical Error
Could not connect to the database
I created a database with nothing inside phpbb
I set all the users with passwords and used
default user: root and local host and I get that error
I have not created any
Hello all,
On Saturday Sun, 6 Oct 2002 11:27:29 +0200,
Stan P. van de Burgt wrote:
Description:
if I access the mysqld locally, all is well, but if I access it
from outside (i.e. not over the 127.0.0.1 interface), the daemon
hangs and restarts.
Could this be the result of a run of RedHat
corereader contains safeguards to prevent updates,
but its design helps quick development of queries
such as yours. you can do a multiple join with
multiple selects just by pointing and clicking to
try out various ideas.
it's free at http://corereader.com/
it installs at the novice skill
So, a fix to this MySQL bug anyone??
- Stan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
Hi,
I am working on an application that will need to store users CC
numbers so that they can be charge once a month and to verify
identity. My question is: I am in process of getting an SSL, but my
experience with SSL is none existent. Can someone give me an overview
of protecting the
At 11:21 AM 10/06/2002, David Gerler wrote:
Hi,
Can someone give me an overview
of protecting the numbers with mysql and SSL? Will the SSL protect the
numbers when they are stored on the site? Or just when they are
transmitted? Should I use something like PGP to encrypt the numbers
before
On Sunday 06 October 2002 22:04, Stan P. van de Burgt wrote:
So, a fix to this MySQL bug anyone??
I don't think this is a mysql bug.
For me it seems like a bug in a RedHat patch to glibc.
Btw mysql binary packages are not affected.
(IIRC they are staticaly linked against mysql team homemade
On Sunday 06 October 2002 23:05, Sergey S. Kostyliov wrote:
On Sunday 06 October 2002 22:04, Stan P. van de Burgt wrote:
So, a fix to this MySQL bug anyone??
I don't think this is a mysql bug.
cut
I'm personaly solve this problem by just glibc downgrade
E. g. RedHat-7.3.
wget
I would agree, storing credit card numbers on a database such that they can
be used by an automated system (without manual intervention) is a serious
risk. Unless you are operating an EXTREMELY secure server with good
firewalls and the bare minimum of shell access I would have second thoughts.
I
My query is:
SELECT id, title_analytic, date, keyword_article, author_article, keyword,
name
FROM Article, Years, Keyword_Info, Keywords, Author_Info, Authors
WHERE Article.id = Keyword_Info.keyword_article
AND Article.id = Author_Info.author_article
AND Article.date_of_pub = Years.yearsid
AND
Mysql - how many tables will it handle?
I currently have no access to docs, so forgive me as I'm sure it is
documented.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello,
I just added a user called our_guest to our mysql database, and the user
should be able to log on through a jsp page
I *can* log our_guest into MySQL from a command line.
But the user cannot log on via the www. The SQLException thrown is
java.sql.SQLException: No IP restriction
Hello,
I'm having problems compiling the C++ mysql api on linux, here's the
output:
automake
automake: Makefile.am: required file `./INSTALL' not found
automake: Makefile.am: required file `./NEWS' not found
automake: Makefile.am: required file `./COPYING' not found
automake: Makefile.am:
Hi,
I need a where clause in following situation:
Say I want to query two tables: A and B. In table A there is field Afn,
while in table B there ere 3 fields: Bfn1, Bfn2 and Bfn3. I want to
compose a query, in which the where clause can do this:
if A.Afn=1, then check Bfn1,
if A.Afn=2, then
Hi
I am running php/mysql on 2x PIII 1 GHz / 512MB RAM / SCSI and can run
queries on datasets of 220,000
SELECT * FROM `Tablename` WHERE `Prod_code` LIKE 'A43611109%' in less time
than I can count (0.1 sec at a guess)
The insert/update bit is the bit which will dictate the speed - how many
I am running php/mysql on 2x PIII 1 GHz / 512MB RAM / SCSI and can run
queries on datasets of 220,000
SELECT * FROM `Tablename` WHERE `Prod_code` LIKE 'A43611109%' in less time
than I can count (0.1 sec at a guess)
The insert/update bit is the bit which will dictate the speed - how many
Hi
Just did a quick test using phpMyAdmin
INSERT INTO `db`.`speedtest` SELECT * FROM `db`.`table1`
These are just standard MyISAM tables
The query creates about 120,000 rows and 5 indexes on CHAR fields in 45
seconds so you should be fine if MySql does the work. If you have a lot of
Java
Hi,
I'm trying to insert some data into a MySQL table and I'm just not getting
it to work. It's not a problem with the connection with the database because
I get to SELECT and show the data, but when I try to INSERT or UPDATE any
record, nothing happens...The weird thing is that it doesn't
I'm a newbie, so thanks for any help.
Running RedHat Linux 7.3 - Apache - MySQL scripting
with PHP on an Intel box...
Question 1:
I want to print a specified field or fields, in
specified records to the line printer several times a
day...
Can anyone get me started on the PHP script to do
Hi folks!
I have just installed mysql version 3.23.49! It's all ok!
I have setted error message to be shown in portuguese language! But i
cannot write (using mysql client) any query that uses special portuguese
character, any advice?
Of course, my charset is already setted to latin1.
hi list,
Does anyone has experient in analyzing MySQL traffic? Is there any
method/tool to know how frequent a particular table is accessed / which
table is heavily used / which is the table that causing speed bottle neck
and et cetera.
Thanks.
Chee Peng
Is it possible to do a show tables similar to a select statement
where ...
similar to: select field where anotherfield like ABC% gives matches
for all field which begins with ABC
I'd like to say
show tables like ABC%
ie. to get a list of all tables whose name begins with ABC.
Thanks in
After I used the comment mysqld,I used the mysqladmin ping comment,then the
following infomations appeard(c:\mysql):
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port
This requires a similar function to Oracles decode. I do not know if MySQL
provides such a function.
Regards
Peter Goggin
- Original Message -
From: Alex Shi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 07, 2002 6:47 AM
Subject: where clause question
Hi,
I need a
Hello everyone.
I'm working on migrating Oracle to MySQL 4.0.3
MySQL works on Redhat 7.3 and Pentium 550Mhz with 256 Mb RAM.
Our application need Transactions, so I decided to use InnoDB.
But, InnoDB is slower than I expected.
-
mysql
Hello, I have a few SQL books, but they only have simple SQL queries in
them.
I signed up with the list a few days ago and I have seen select
statements that do amazing things. I went to the book store and they
don't have any books with these types of select statements in them.
Please let me
On Monday 07 October 2002 11:09, John Jacques wrote:
Hello, I have a few SQL books, but they only have simple SQL queries in
them.
I signed up with the list a few days ago and I have seen select
statements that do amazing things. I went to the book store and they
don't have any books with
The amount of updates will vary from time to time. Sometimes I imagine there
will be 200-300 records to update, but for the most time maybe 10-50
records.
The mathematical system I will create is in a way recursive... You check
Record #1 - how many records in the database has similar values.
45 seconds to create 120 000 MyISAM table char rows?
Thats a pretty nifty speed. PHP have a considerable overhead compared to new
versions of Java. (I use both languages... I prefer PHP for webpage
generation, but Java for serverside applications)
I am hesitant to dig into C++ just to solve
I am hesitant to dig into C++ just to solve this problem, so I am as far as
possible trying to solve the performance issues within Java and MySQL. I
will probably rewrite the code countless of times just to see if I can do
it, and last resort would be C++.
Why dig into C++? MySQL has a
Thats a pretty nifty speed. PHP have a considerable overhead compared to new
versions of Java. (I use both languages... I prefer PHP for webpage
generation, but Java for serverside applications)
And both have a significantly larger overhead than C. Have you tried Escapade? It's
a simple,
Hi Friends,
OS : Linux Redhat 6.2
Kernel version : 2.2.14-5.0
MySql version : 11.13 Distrib 3.23.36, for pc-linux-gnu (i686)
When I type mysql in the command prompt it is giving the error ERROR
2002: Can't connect to local MySql server through socket
'/var/lib/mysql/mysql.sock' (111)
There is
What is the best strategy to make mysqld listen from another port than 3306
?
In fact we have 2 servers that handle mysql. The first is listening at port
3306 but we need that the second one listen from another port in order to
run in our local network IP Port Mapping
What is the simple way to
On Mon, 7 Oct 2002, Stéphane Pinel wrote:
What is the best strategy to make mysqld listen from another port than 3306
?
In fact we have 2 servers that handle mysql. The first is listening at port
3306 but we need that the second one listen from another port in order to
run in our local
Le 7/10/02 7:33, « Iikka Meriläinen » [EMAIL PROTECTED] a
écrit :
On Mon, 7 Oct 2002, Stéphane Pinel wrote:
What is the best strategy to make mysqld listen from another port than 3306
?
In fact we have 2 servers that handle mysql. The first is listening at port
3306 but we need that the
56 matches
Mail list logo