Is there a way to tell MySQL to automatically spread its tables over a
number of disks without going through the trouble of symbolic linking the
chunks to the different disks?
Thanks,
Jamie Krasnoo
[EMAIL PROTECTED]
-
Before
Dawn H wrote:
-Original Message-
From: Les Roberts [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 17, 2001 9:06 PM
Cc: Dawn H
Subject: Fwd: FW: FW: HELP! functions don't work...
first I apologize for the bad function name... I had changed it to several
and left it at dayname()
Solaris8 on a Ultra5 Box, mysql++ 1.7.9: the example and also my own
appliacations core dumps if they can not connect to mysql, in other words
the try block does not work! I have tried gcc 2.95 (recommended in the
manual) and 2.95.3!
Does any has experience with this, or am I allone in the dark
Fatal error: Call to undefined function: dayname() in
/home/ccrb/ccrb-www/index.html on line 8
This indicates that I'm missing most all of the functions. Is there a
standard include that I need, or is my php installation not complete?
Here is the line of code in question:
?php
thank you.
that's sort of what i thought.
now for the silly question:
i know how to do it with 'monitor' (CLI), but where/how do you
import using phpMyAdmin, please? (this i'd love to know :) i looked
through the manual but didn't see anything for import db.
Click a database on the left
Hi there,
I'm using select queries like
SELECT * FROM table_name WHERE col_name LIKE '%some_word%'
to find rows that have col_name match to some_word. But I would also like
to find the number of word matches for each row so that I can order these
rows according to their relevances and
Today on a slave I got (this actually has occured several times in the past
months):
Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log
'xxx-bin.040' at position 47694
010511 10:37:19 Error reading packet from server: log event entry exceeded
max_allowed_packet
Sir,
We are using mysql-3.23.38 and are using Red Hat Linux
7.0. The linux kernel version is 2.2.16-22.We are
using
an IBM-PC with 128 Mb RAM,intel PIII processor.
We are presently using kannel SMS gateway-1.0.3 and
are
using Mysql as database.
We are using a C API to connect to the
he development team I am currently with is considering using MySql. However, as part
of the we require the actual benchmarks that were used as well as the results. Is it
possible to have a set of the SQL queries in the form
CREATE TABLE t ( n NOT NULL VARCHAR(100));
INSERT INTO t VALUES
David Ayliffe writes:
I wrote this program in VC++ using the MYSQL++ API for VC. I have a
generic function (below) which I call numerous times each time with a
different query string. It works fine the first time around. But the
second time I call this function it causes the program to
Stepan Havel writes:
Solaris8 on a Ultra5 Box, mysql++ 1.7.9: the example and also my own
appliacations core dumps if they can not connect to mysql, in other words
the try block does not work! I have tried gcc 2.95 (recommended in the
manual) and 2.95.3!
Does any has experience with this,
Roger Norton writes:
he development team I am currently with is considering using MySql. However, as
part of the we require the actual benchmarks that were used as well as the results.
Is it possible to have a set of the SQL queries in the form
CREATE TABLE t ( n NOT NULL VARCHAR(100));
Isn't this something that RAID O does for you on a larger scale anyway?
I would expect that most would have some sort of raid on their mutliple drive
system.
On Monday 18 June 2001 01:52 am, you wrote:
On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote:
Is there a way to tell
Dear :
Sir
There are a message error display ...
Can't connect to database : Can't connect t local MySQL server through
socket '/var/lib/mysql/mysql.sock' (111)
How and where that I can trouble shooting it ?
Best Rgards
I've been experiencing some strange behaviour
in which mysqld will get into an odd state.
When doing certain long-running operations
(see below) on large tables (5-10 million rows;
20-30 columns per row -- mix of varchar and int)
with unique indeces mysqld will occasioanlly get
into a confused
Hi Samuel
I would do this in sql. I thinks this would be much more convenient to administrate.
It would be great if you would see these informations also in with the command eg:
show database storage
and you can see as return, where the files are located.
Thanks
Philip
On Mon, 18 Jun
mysqldump regenerates a bad sql statement from a bad initial create table.
When you create this table for example (ok it's not a really nice definition):
CREATE TABLE TESTBADDUMP (
e_test enum('0','1') NOT NULL default 0
);
desc TESTBADDUMP;
[EMAIL PROTECTED] writes:
mysqldump regenerates a bad sql statement from a bad initial create table.
When you create this table for example (ok it's not a really nice definition):
CREATE TABLE TESTBADDUMP (
e_test enum('0','1') NOT NULL default 0
);
desc
Hi,
mysqldump regenerates a bad sql statement from a bad initial create table.
When you create this table for example (ok it's not a really nice definition):
CREATE TABLE TESTBADDUMP (
e_test enum('0','1') NOT NULL default 0
);
desc TESTBADDUMP;
Try quoting (' ') the 0 in your create:
CREATE TABLE TESTBADDUMP (
e_test enum('0','1') NOT NULL default '0' );
-^
You should then get the result you want.
Have a great day...
John
On Monday 18 June 2001 08:54, [EMAIL PROTECTED] wrote:
mysqldump
how to setup passwords for mysql
On Mon, 18 June 2001, [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
Le Mon, Jun 18, 2001 at 04:04:52PM +0300, Sinisa Milivojevic a écrit:
[EMAIL PROTECTED] writes:
mysqldump regenerates a bad sql statement from a bad initial create table.
When you create this table for example (ok it's not a really nice definition):
CREATE TABLE TESTBADDUMP (
but mysqldump generates an invalid statement.
mysql CREATE TABLE TESTBADDUMP (
- e_test enum('0','1') NOT NULL default ''
- );
ERROR 1067: Invalid default value for 'e_test'
mysql
I think that's what the orignator is trying to show. That mysqldump is
generating an
Hi,
I'm new in this list and new to MySQL also. What I want to know is how
to limit the size of a database.
Thanks.
--
Ali Kemal YURTSEVEN
Is Net A.S.
Iletisim Uzmani
-
Before posting, please
Hi,
Could someone please e-mail me a copy of the example cnf files, as they
did not come with my distribution. Thanks.
For a Sun E450 with a single 300Mhz processor and 256Mb of RAM which
.cnf file would you suggest I used? The machine is being used for a MRP
server as well as a ODBC mysql
Start with the troubleshooting section of the manual.
Is the server running?
Where did it put the socket file?
What program gave you that error?
What system are you running?
What version of MySQL is this?
Where did you get it?
How did you install it?
So many questions. So few answers.
CSHAkira
Guillaume Fougnies writes:
ok so it's a failure from mysqldump.
I know this declaration is not really correct but mysqldump must regenerate a
correct sql statement (good when pipe in mysql client i mean at least ;) ).
It's not the case.
Regards,
--
Guillaume FOUGNIES
Research
Sinisa,
A good way to prove that mysqldump is doing what it should, might be to do a
describe TESTBADDUMP;
I think this will prove that mysqldump is just dumping what is in the table
def, which is all you can expect.
Have a great day...
John
On Monday 18 June 2001 09:46, Sinisa Milivojevic
Hi,
I am facing the following problem in pattern matching:
I want to check the pattern matching using LIKE on a
field that is declared as Binary and also contains
back slashes.
eg:
ID INT,
NAME VARCHAR(128) BINARY
I am using C-API of mysql to escape the characters
like '\' for this field.
The
Hi,
Fairly new at this so i need all the help i could get. I created a admin
page where admin can add/mod/del/view from this page. But now I need to give
access to other admins but from diffrent companies where I need to grant
diffrent username and passwords to the original admin page. Each
On Mon, Jun 18, 2001 at 04:15:37PM +0100, VVM Ravikumar Sarma Chengalvala wrote:
Hi,
Did mysql pattern search support a backslash character?
Yes.
Since it is a special character, make sure it is properly escaped.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk:
It depends on what you mean by pattern search? You probably have to escape
the \ character. If you put a \ in front of a character it means this
next character is what I say it is not it's MySQL representation. This
would allow you to put a ; or ) in your query. Simply put \\ to mean
a
It is not working even after escaping it.I am working
on WINNT4.0 and mysql 3.23
--Regards,
Ravi
--- Scott Baker [EMAIL PROTECTED] wrote: It
depends on what you mean by pattern search? You
probably have to escape
the \ character. If you put a \ in front of a
character it means this
next
I am trying to evaluate mySql.
I am told that if I am on Solaris, I must obtain gnu tar because
of a bug in Solaris tar.
I have downloaded the mySql distribution as well as
2 different versions of gnu tar that available at the site.
gtar-solaris-4.1.4-sparc.gz and gtar-sparc.gz
The reason I
Alex,
did you change any my.cnf parameters? Version .39 should
actually be a littel bit faster than .38.
What does Unix 'top' say? What are the CPU usage %?
The biggest change performance-wise in .39 is that
you can now specify the parameter
innodb_unix_file_flush_method
in my.cnf.
You
Title: Blank
I currently have several different systems
accessing a mysql server 3.23.34 somewhere in there is a process that forgets
about connections that it has open.
So after a few days I get a "too many
connections open error". Is there a way that I can set connections to time
out
Hi,
Can someone get back to me at the earliest regarding
mysql's support for backslash characters in pattern
search.I am not able to search based on the string
which contains a backslash character even after
escaping..
Regards,
Ravi
Do
On Mon, Jun 18, 2001 at 04:32:54PM +0100, VVM Ravikumar Sarma Chengalvala wrote:
Even after escaping mysql just seems to be ignoring it.
Odd. I'm seeing something other than what I first expected. Watch
this...
---snip---
mysql CREATE TABLE slash_test ( foo VARCHAR(30) );
Query OK, 0 rows
Hello
I run mysql on a multi proccesoor server and when I run queries from different
servers,
I see it uses under 100% cpu, even thought it sometimes take 50% from each cpu. how
can I get it to use 100% for each query?
Thanks
Tomer Grassyani.
Internet Driver.
try some more then..
try // or / or .. .
Hi,
I donot even get that with an additional backslash
also.In my case it just ignores the backslash and goes
ahead with the search .
Regards,
Ravi
--- Jeremy Zawodny [EMAIL PROTECTED] wrote: On
Mon, Jun 18, 2001 at 04:32:54PM +0100,
i have recently installed the red hat 7.1 in my computer,
althought i
have not installed the mysql durring the os installations,
naw i
installed the mysql database but its giving me a socket
error like this:
/etc/rc.d/init.d/mysqld status
mysql dead but subsys locked
mysql
ERROR 2002: Can't
ola
como faço p/ mudar a data padrao do mysql??
ele esta como
-dd-mm
eu gostaria de mudar p/ dd-mm-
falow
valeu
Greg wrote:
Le jeudi 14 juin 2001, à 08:14, Daniel a écrit :
I believe that i've seen this on the list before.
Read the php docs before compiling, don't use the builtin mysql support,
specify --with-mysql=/path/to/mysqllibs
Yes, I've compiled with this option. Is it possible that it
No need to worry.On NT each table can have
upto4GB.Database there is predefined limit.It can go
even upro 20GB or more also.
--- Ali Kemal YURTSEVEN [EMAIL PROTECTED]
wrote: Hi,
I'm new in this list and new to MySQL also. What I
want to know is how
to limit the size of a
I recently set about upgrading our MySQL install on a Compaq Tru64 4.0f
Alpha box from 3.22.25 to 3.23.38.
As in the past, I used the Compaq cc as CC and gcc (2.95.3) as CXX with
appropriate flags set. I do not have the GNU binutils installed, so it
is the Compaq ld that is used. I am,
hi all, i have a small problem
im using mysql_query to access my mysql database.
now then, i have 2 queries, 1 just after the other.
the first one goes ok, the second one never does.
doesnt matter if i switch the queries, the one that is last never works.
if i write the query in an xterm
(assuming you're using PHP...)
The best idea would probably be to create a column in your users table which
indicates which company each user belongs to. Then, using select
company_name from users where username EQ .$username;
If you're not using PHP, the idea is still the same. Use a MySQL
I have downloaded the mySql distribution as well as
2 different versions of gnu tar that available at the site.
gtar-solaris-4.1.4-sparc.gz and gtar-sparc.gz
The reason I downloaded 2 different versions of the gnu tar
is that I can't get anyone of these to deflate using gzip.
I has
Ricardo,
Heh... Watch out, RH 7.x is notorious itself for being the
src of a problem.
Cheers
-v.
--EOF
Ricardo Striquer Soares wrote:
i have recently installed the red hat 7.1 in my computer,
althought i
have not installed the mysql durring the os installations,
naw i
Hello all,
I have mysql 3.23.39 installed on the new Mac OSX Server. The problem I
am having is that when I start it from the command line using safe_mysql -u
mysql, it says:
Starting mysqld daemin with databases from /usr/local/mysql/var
It never reports anything else. The database starts,
Hi, I am having a small formatting problem maybe someone can help with.
I have a query that does a left outer join, which generates a table with a
few NULL values in some columns. All okay so far. But what I need to do is
sort on this column, and I need to put NULL values at the end. Normally
That's what it's supposed to do. End the command with a so it will
spawn into the background.
Scott
At 11:05 AM 6/18/2001 -0700, Dale Schell wrote:
Hello all,
I have mysql 3.23.39 installed on the new Mac OSX Server. The problem I
am having is that when I start it from the command line
Ricardo Striquer Soares [EMAIL PROTECTED] writes:
i have recently installed the red hat 7.1 in my computer,
althought i have not installed the mysql durring the os
installations, naw i installed the mysql database
but its giving me a socket error like this:
From our RPMs, or did you
You could try using the IFNULL() function on that column before you do the join.
http://www.mysql.com/doc/C/o/Control_flow_functions.html
--jfarr
- Original Message -
From: Bryan Coon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 18, 2001 11:12 AM
Subject: left outer join
Here is the full error I am getting when running the query included:
Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239
1054 : Unknown column 'CMET3558539239' in 'where clause'
Here's the problem, I know that Customer_No exists. I can see it in the
database. This code
Kenneth Johansen ([EMAIL PROTECTED]) writes:
hi all, i have a small problem
im using mysql_query to access my mysql database.
now then, i have 2 queries, 1 just after the other.
the first one goes ok, the second one never does.
doesnt matter if i switch the queries, the one that is
Hello all,
I am running the new Mac OSX Server. In the mysql docs, it says to put
the mysql.server file in the correct place for your system. Does anyone know
what the right place on OSX Server is? I placed it in
/Library/Startup/MySQL, as the other databases I am experimenting with have
I have a design problem I was hoping some of you could help me out with. I am writing
a shopping
cart system (as if there wasn't enough already) and I have one problem that has me
stumped.
A person can order more than one item of course. So let's say they order a kite and
some string.
Both
On Mon, Jun 18, 2001 at 02:44:00PM -0400, Shrout, Ryan wrote:
Here is the full error I am getting when running the query included:
Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239
1054 : Unknown column 'CMET3558539239' in 'where clause'
Here's the problem, I know
Put quotes around the Customer_No:
SELECT * FROM customers WHERE Customer_No = 'CMET3558539239'
- TIM
Here is the full error I am getting when running the query included:
Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239
1054 : Unknown column 'CMET3558539239' in
Try
SELECT * FROM customers WHERE Customer_No = 'CMET3558539239'
Jorge Oliveira
[EMAIL PROTECTED]
© webfroggie.com - Recursos Online!
web: http://www.webfroggie.com
wap: http://www.webfroggie.com
-Mensagem original-
De: Shrout, Ryan
Thanks for the suggestions, but this is actually a variable that is passed
via a URL. For example:
http://localhost/cus-lookup.php?id=CMET3558539239
Then in the code it looks like this:
$customer_select=SELECT * FROM customers WHERE Customer_No = $id;
How can I 'put quotes around' a
Hello,
Your field(column) is a CHAR and therefore the parameter to it should be in
single
quotes:
Change your query to:
SELECT * FROM customers WHERE Customer_No = 'CMET3558539239'
*
* Visit http://www.computerstaff.net -
This looks like an order-lineitem situation, which I would imagine would
look like this:
ORDERS
ORDER_ID
CUSTOMER_ID
ORDER_DATE
LINEITEM
ORDER_ID
PRODUCT_ID
LINEITEM_QUANTITY
At 02:00 PM 6/18/2001 -0500, you wrote:
I have a design problem I was hoping some of you could help me out
with. I
Hi,
I am new to MySQL. I downloaded MySQL for Windows version 3.23.38. When
I installed in MyISAM mode, mysqld was running fine. Then I uncommented
the configure parameters for innoDB in my.cnf. Mysqld initialized the
database the folowing messages printed on screen. Can anyone help ?
Thanks,
Hi there,
Where can I get the MySQL protocol?
Thanks!
Yue
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
You are using PHP. Well PHP is not ASP :-) clever and you can enclose your
variable in single quotes as in:
$customer_select=SELECT * FROM customers WHERE Customer_No = '$id';
Hope this helps.
*
* Visit
Like this:
$customer_select=SELECT * FROM customers WHERE Customer_No = '$id';
Jorge Oliveira
[EMAIL PROTECTED]
---
© webfroggie.com - Recursos Online!
web: http://www.webfroggie.com
wap: http://www.webfroggie.com
-Mensagem original-
De:
Hello All,
Sorry if this is the wrong place to post this request.
I represent ADEMKA and in September we are launching a publication which
has both a LIFESTYLE and a TECHNICAL angle to it for Computer Professionals.
We are looking for articles relating to MySQL and are paying between
£50(GBP)
Ok, in your PHP code, do this:
$customer_select=SELECT * FROM customers WHERE Customer_No = '$id';
This will add quotes around the variable...
-TIM
On Mon, 18 Jun 2001, Shrout, Ryan wrote:
Thanks for the suggestions, but this is actually a variable that is passed
via a URL. For example:
On Mon, Jun 18, 2001 at 03:56:32AM -0700, Jamie Krasnoo wrote:
[mysqld]
datadir=/data1;/data2;/data3
- or -
datadir=/data1:/data2:/data3
As it stands now, both will produce an error and MySQL will not start.
Other ways could be like: RAID_DIRS=/data1:/data2:/data3
Well, I'll throw
Hi All!
While this is not a huge problem, it is a recurring one so I thought I would
see if someone else has a nice generic way of handling this situation. I
often set up database tables with a PHP4 interface to handle insertions.
It is always set up on a CGI basis, wherein a form blasts
Ola Ricardo,
Não sei ao certo se o formato padrao do MySQL voce consegue mudar.
Entretanto voce pode resolver o problema utilizando o DATE_FORMAT no select.
Veja o exemplo abaixo:
SELECT DATE_FORMAT(NOW(), d/m/Y) AS DATA;
[]'s
Crercio O. Silva
-Original Message-
From: Ricardo Ferrari
The problem is the text file resides on a server that holds the website
pages. I am new to UNIX. How do I setup the LOAD DATA INFILE command to
specify the text file if it is loaded on another server?
This is what I have:
LOAD DATA INFILE 'data.txt' INTO TABLE data FIELDS ENCLOSED BY ''
hi.
the easiest way is to have
an order table:
(orderID, customer, address, etc., etc.)
a item table:
(itemID, description, price, etc.etc.)
and an orderItems table:
(orderID, itemID)
this way you can
select i.description, i.price
from order o,
item i,
orderItems oi,
where
Description:
Upgraded from 3.22.27 to 3.23.32. Built from source.
When attempting to start the daemon, it immediately terminates. Log file shows Can't
find file: 'host.ISM' (errno: 2). I checked the old data directory (from where I
copied the database files) and there never has been a
Really the question is will the following work:
LOAD DATA INFILE 'home/domain name/www/subdirectory/data.txt' INTO TABLE
data FIELDS ENCLOSED BY '' TERMINATED BY ',' LINES TERMINATED BY ';';
-Original Message-
From: Hamilton, Jay
Sent: Monday, June 18, 2001 4:56 PM
To: '[EMAIL
Hi Jeff,
If you visit my homepage at:
www.geocities.com/hisiomara
click Tutorials and select the first item Team5.com an ecommerce sample
you will be able to see the ERD diagram that attends your ecommerce demand.
Actually will will be able to see much more.
The design is there,and I will
I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to
sync development with production systems).
I copied the /data directory to the new home. When I try to start mySQL, it
halts and the log file has the entry Can't find file: 'host.ISM' (errno:
2). I checked the old
Hi,
I'm connecting to a MySQL server through the MM JDBC driver on under Red Hat
6.2 using the below code. I keep getting an error message returned that says
: Server configuration denies access to data .
I'm connecting as the root user and I am definitely passing the correct
password etc. in
You can. However, in these situations (in other languages) I've written code
generators that generate either the entire HTML/PHP page for me or at the
very least, the data object that I am talking to, complete with
SELECT/INSERT/UPDATE and DELETE statements.
That having been said, not trying to
Hi.
On Mon, Jun 18, 2001 at 08:16:45AM +1000, [EMAIL PROTECTED] wrote:
What is the current way to move back and forwards and to any position in a
recordset without losing performance
There is no way. For effiency, the record set is hold in memory as
linked list. Searching a position in
Hi.
On Mon, Jun 18, 2001 at 02:32:13AM +0100, [EMAIL PROTECTED] wrote:
I need some help with a query to sum data for each id and write it into a
new table.
I have a source data table for each calendar month containing i.d.'s (not
unique) and a value and I need to sum all the values for
How can I know the version of mysql running on Linux (RedHat 6.2)
thanks,
Augusto
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
I tried to put the data (.frm, .ISD and .ISM files) of my Linux into
windows 98 put I can't use the data. When I open phpadmin2, he show how
many registrys I have, but When I try to use/list the table is empty. Can
I solve this problem? I need to use mysqldump to put the data into windows
98?
Steven Now I have a question: Does this also apply to automatic
repair inside
Steven mysqld? I'd finally use the feature if its true...
If you just run CHECK TABLE, it will repair the open count (it should
always have done that).
myisamchk --fast --force is equal to:
run CHECK TABLE on
On Mon, 18 Jun 2001 20:19:20 -0300 (EST), Augusto Cesar Castoldi
[EMAIL PROTECTED] wrote:
SELECT VERSION();
te: Mon, 18 Jun 2001 20:19:20 -0300 (EST)
How can I know the version of mysql running on Linux (RedHat 6.2)
thanks,
Augusto
Mike(mickalo)Blezien
On Mon, Jun 18, 2001 at 08:19:20PM -0300, Augusto Cesar Castoldi wrote:
How can I know the version of mysql running on Linux (RedHat 6.2)
mysqladmin version
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408)
How can I transfer the data from a MySQL 3.22.32 running on RedHat
6.2 Linux to a MySQL 2.23.37 running on Windows 98?
thanks,
Augusto
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I'm receiving the following error:
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (111) in
/home/httpd/html/phpadmin2/lib.inc.php on line 119
what could be?
thanks,
Augusto
If you're trying to check a 'remote' system, you can 'telnet' to port 3306
(IF you have remote 'telnet' access to the MySQL service, and IF it's
listening on the default port 3306) which will display some garbage containing
the version number
telnet yubby.dubby.com 3306
In case you're not aware of it yet, Linux (and other UNIX operating systems)
are not 'binary file compatible' with Microsoft products (including Windows
98).
You should always 'dump' your database contents (using mysqldump) before
'moving' the data to build another database (unless you're
Hi,
Is there a place where I can find a manual (not tutorial) of SQL
Reference/Sintax, something like the PHP Manual...
It could be about SQL in general, MySQL and/or Oracle.
Thanks,
Jorge Oliveira
[EMAIL PROTECTED]
© webfroggie.com -
At 01:08 AM 6/19/2001 +0100, © webfroggie.com wrote:
Hi,
Is there a place where I can find a manual (not tutorial) of SQL
Reference/Sintax, something like the PHP Manual...
It could be about SQL in general, MySQL and/or Oracle.
Thanks,
Jorge Oliveira
[EMAIL PROTECTED]
The MySQL manual is
I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to
sync development with production systems).
I copied the /data directory to the new home. When I try to start mySQL, it
halts and the log file has the entry Can't find file: 'host.ISM' (errno:
2). I checked the old
It's looking for the host table (physical files) within the 'mysql' data area
(not your own data area).
Did you run mysql_install_db after installing the new version ? (or copy the
mysql subdirectory from the old version)
Guy Smith wrote:
I just upgraded from 3.23.27 to 3.23.32 (can't go
Access denied for user: '@localhost' to database 'netsloth'Could not
drop database netsloth
(i asume drop means to drop 'in' in this case?)
is what i get back when i try to install the db 'netsloth.dump' from
J Greenspan's book and CD.
please tell this newcomer what he has to do to fix this
i guess that is confusing to me because it says query.
i'm really stuck though -see my recent 'please help' post to the mysql list.
thanks.
At 2:48 AM -0600 6/18/01, Chris Bolt wrote:
thank you.
that's sort of what i thought.
now for the silly question:
i know how to do it with
Tried both. 1st copied the data tree (wherein there is a host.frm,
host.MYD, and host.MYI files).
When that didn't work, I did the mysql_install_db, but that had no effect.
I suspect that there is a ./configure option I missed that declares the
default data file format to use, and that they
Description:
Starting MySQL daemon
Loading Standard Test Databases
Starting Tests
TEST USER SYSTEM ELAPSEDRESULT
alias 0.12 0.06
1 - 100 of 114 matches
Mail list logo