Hi.
We plan to make a project that designed for collection and analysis of
statistic information. We should use some servers that should place
approximately 100 databases on. The databases have identical structure but
have designed for various carouses. We do not solve which database is the
best
Ok I need help
So i have table with primary key ID,
it's fills with something like 1,2,4,5
So and i have another table in which i would like to put data from first
table from row ID
how to do this
|| ||
| test1 | | test2 |
|| ||
| ID
Just tried a 3.23.32 slave (on Linux, all rpms from www.mysql.com) against a
3.23.30 server:
010123 09:38:05 mysqld started
/usr/sbin/mysqld: ready for connections
010123 9:38:05 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'jfontain-bin.008
' at position
I was wondering if anyone can explain why this SQL command doesn't work
UPDATE users SET visits=visits+1, WHERE user_id='$user' AND
password='$password'
the $user and $password are variables that are inserted by PHP, what I'm
specifically looking at is the visits=visits+1 which is simple enough
Hi,
Have anyone heard about/used a good design tool
for mapping an Extended Entity-Relational diagram
into relations for mySQL? I have tried the DeZign
tool from Heraut and Togethersofts program for ER
modeling, but none of them support inheritance.
Can you rely on a tool like DeZign, for
Hi
Why can't I do like this?
insert into tbnamn (fornamn, efternamn) values('g1','g2','g3','g4');
where fornamn and efternamn is the only fields in the table tbnamn
/Gustav Wiberg
-
Before posting, please check:
The number of fields must be the same as the number of values... otherwise:
Syntax Error.
- Original Message -
From: "Gustav Wiberg" [EMAIL PROTECTED]
To: "MYSQL List" [EMAIL PROTECTED]
Sent: Tuesday, January 23, 2001 11:19 AM
Subject: INSERT - very newbie question probably...
Hi
On Tue, Jan 23, 2001 at 11:19:20AM +0100, Gustav Wiberg wrote:
Hi
Why can't I do like this?
insert into tbnamn (fornamn, efternamn) values('g1','g2','g3','g4');
where fornamn and efternamn is the only fields in the table tbnamn
Try:
insert into tbnamn (fornamn, efternamn) values
I'm having problems with the mysql service running under Win2K.
The directory where mysql was installed became corrupt due to a power
failure. Having fixed the problem, some of the files were corrupt, so
Windows wouldn't reinstall mysql properly. I decided to install mysql again
over the top
Hi
I'm making a db design tool for the web, and would like some feedback.
Please try it out at http://dbd.aktieprat.nu/ (this domain will probably
change
later on).
TIA
/ah
-
Before posting, please check:
I believe Tomi Junnila meant you should try without the comma..
UPDATE users SET visits=visits+1WHERE ...
(no comma before WHERE)
G'luck,
Peter
--
I am jealous of the first word in this sentence.
On Tue, Jan 23, 2001 at 06:27:22PM +0800, Jamie wrote:
I've been trying a variety of things
Description:
Using database created in 3.22 with a field named 'when'
causes errors. For example,
SELECT when FROM atable;
will fail on syntax error. This works:
SELECT a.when FROM atable a;
However, since it's not (apparently)
hi there,
I've been trying to compile mysql 3.23.3x on one of those
Cobalt RAQ2 microservers, problem is that I don't seem to be able
to do this successfully.
There is a note in the setup about qube2 which is obviously also
true for raq2 as it's physically the same and the same from an os-point
* Santeri Paavolainen [EMAIL PROTECTED] wrote on 23.01.01 13:05:
Fix:
SELECTs can be worked around with table aliases, others not.
Oops, I forgot to include the cure. The first way to do this I encountered
is to simply mysqldump the whole table into a text file, then search and
replace
Hello Sinsa,
I just changed the kernel to a non-smp-kernel, to prevent the problem
you described. I checked: the kernel sees only 1 processor.
Within an hour, mysql did it again ! The server load suddenly goes from
0.3 to over 30. The swap growed from about 6 Mb to over 110 Mb. I was
just in
Hi,
I try to use 2 COUNT's and a SUM in query from 2 tables, but am not able
to get the results I want.
The 2 tables are batches and testresults, and have the following fields
and relation:
batches: testresults:
- batch_nr ---+ - id
- date | - status
-
Hi,
I would like to sort, when displaying, an "European Date" with mysql.
Anyone can give me some hints ?
The date format looks so like :
01.02.2001
03.12.2000
22.11.2000
and is stored in a simple field text
(first FEB 2001)
Thanks
GPo
You may find it easier to store the date as a timestamp and convert it on
the fly, depending on what you're using to get the info from the database.
In PHP, you'd need something like
$date = mktime(0,0,0,$month,$day,$year);
where $month, $day and $year hold the date you're dealing
Forgot to mention... you can check it for validity easily using this method
as well:
if (checkdate($frmStartMonth,$frmStartDay,$frmStartYear)) {
echo "You can enter dates correctly. Well done!";
} else {
echo "Please visit
Hi!
"Benjamin" == Benjamin Pflugmann [EMAIL PROTECTED] writes:
Benjamin Hi.
Benjamin On Mon, Jan 22, 2001 at 11:37:23PM +0200, [EMAIL PROTECTED] wrote:
"Huang-Ming" == Huang-Ming [EMAIL PROTECTED] writes:
Huang-Ming hi Tim,
Huang-Ming thanks for the prompt response which is hard to be
I would like to know whether the latest version of MySQL supports OO
databse design and the Enhanced Entity Relationship Model in particular
Specialization and Generalization.
Any information would be useful.
Thanks :)
Lee Daniel Martin
Hello,
I've got a mysql database(3.23) on a very slow disk, the database is only
50mb in size but the harddisk seems to be the real bottleneck here.
The linux box where mysql is running on has 640 megabytes of ram. the
database would fit into the ram with no problems.
Is there an option to
How about a RAM disk? I don't know of any for Linux but they must exist.
Load the whole shebang into the RAM disk and then run it as normal from
there instead of your HDD. You may want a cron job that periodically dumps
the whole lot onto the HDD for backup purposes.
HTH
Jon
-Original
Every several hours mysqld crashes and it seems to be correlated with
heavy load. For example I can repeat the crashes with mysqldump.
MySQL is 3.23.31 started with the following options:
-O key_buffer=20M \
-O table_cache=512 \
-O sort_buffer=8M \
-O
I just created a test table with the 3 fields and used:
where visits=visits+1
without the trailing comma and everything worked fine.
Cal
http://www.calevans.com
-Original Message-
From: Jamie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 3:52 AM
To: [EMAIL PROTECTED]
Yes, read up on HEAP tables in the manual. You have read the manual? Here is a quick
rundown. Create HEAP table and read all data into table on startup. When you do an
update, do it on HEAP table and to the database on disk. Both should then be in sync.
This assumes you don't do many updates.
I'm currently creating a program where I'm accessing a database using
mysql++. I can't get the "DateTime" type to work, though.
My program works if I use the "Date" type instead, but it's not good
enough!
I can write to the database, but when I try to read out a
"DateTime" my program hangs.
Lee Martin wrote:
I would like to know whether the latest version of MySQL supports OO
databse design and the Enhanced Entity Relationship Model in particular
Specialization and Generalization.
As much as any (generalised) RDBMS. (i.e no).
The (excellent) Manual (online) outline what it
Marten Svensson writes:
I'm currently creating a program where I'm accessing a database using
mysql++. I can't get the "DateTime" type to work, though.
My program works if I use the "Date" type instead, but it's not good
enough!
I can write to the database, but when I try to read out
I compilied 3.23.31 and I keep getting this error:
Cannot open "../libmysql/.libs/libmysqlclient.so"
This happens with every client binary, and I can't seem to figure out
where this is coming from during compile time.
--
Robert Hough ([EMAIL PROTECTED])
Hi,
Does anyone know of a good whitepaper comparing mysql with some of the other
major databases such as oracle, db2, etc. We are using mysql for most of
our internal work and are trying to push it for some of our project work
with clients and would like to have a nice white paper that outlines
Try compiling with the static switch set. Check the manual for exact
syntax.
Pat...
- Original Message -
From: "Robert Hough" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 23, 2001 8:10 AM
Subject: Problems Installing 3.23.31
I compilied 3.23.31 and I keep getting
Is the error 1067-something?
In that case there could be something wrong with the my.cnf file. can you
see the extension .cnf in the windows explorer? If you do, remove it, the
filename then is actually my.cnf.cnf.
The problem I had was when I wanted to update from 3.22 to 3.23, but it
could be
ERROR 1030: Got error 127 from table handler
I get this error when I try to execute SQL statements using any of my
tables I'm terrified that I've lost all my data If you know how I can fix
this up please email me [EMAIL PROTECTED] asap
Thanks, Lido
Just tried a 3.23.32 slave (on Linux, all rpms from www.mysql.com) against a
3.23.30 server:
010123 09:38:05 mysqld started
/usr/sbin/mysqld: ready for connections
010123 9:38:05 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'jfontain-bin.008
' at position
Hi,
If this is not the appropriate list for this question, please accept my
apolgies and kindly direct me to the correct list.
I have attempted to install MySQL under CLOS 1.2 (Corel Linux), using the
instructions found in Howard Schultens' "MySQL for dummies - part 1". I have
worked through
Filippo There must be a problem, then.
Filippo It happens to me, often, that I cannot obtain a proc or ext with
mysqladmin
Filippo as root.
Filippo All accesses are through an unpriv username, I have
max_connections=1000 and
Filippo a
Filippo ps ax | grep mysqld | wc -l gives me a value
Typically, processes which die with either a signal 10 or 11 are due to
hardware
problems, such as bad memory or an overheating CPU.
You might consider trying a memory tester or simply do a 'make world' in
/usr/src
(to heavily tax the CPU and memory).
-Tilghman
--
"There cannot be a crisis
Just installed 3.23.29-gamma and played around with fulltext indexes and
some other stuff. Ran into a weird problem that I hope you can shed some
light on.
Basically, a query's where clause has two parts joined by 'and':
select count(*) from ARTICLES where Publication_ID = 9 and Status
Dear Ladys and Gentleman,
i do install packages MySQL-client-3.23.32-1.i386.rpm,
MySQL-3.23.32-1.i386.rpm and MySQL-devel-3.23.32-1.i386.rpm with yast on
Linux 6.3 - OS.
When i started mysql with "save_mysqld i receved follow messages:
mysql started
Can't start server: Bind on unix socket:
Description:
Rollback still does not work with MySQL 3.23.32 and BDB 3.2.3h.
This same problem has been encountered with earlier versions of
MySQL as well. However, all hosts on which this has been noticed
have been running Red Hat Linux 7.0, which could be the
Hello !
We recently upgraded our Master (Live server) to mysql version 3.23.28 -
gamma. And the same version upgrade for our Slave server.
We tried replicating our main database, which has nearly 35 tables.
We did everything as per the MySQL documentation to Replicate the database
and have a
* Andrei Zmievski [EMAIL PROTECTED] wrote on 23.01.01 16:54:
mysql show keys from ARTICLES;
... [Andrei's mail trimmed down quite a bit]:
| ARTICLES | 1 | Publication_ID|1 | Publication_ID| A
|NULL | NULL | NULL | |
...
| ARTICLES |
Christian Przybilla wrote:
Dear Ladys and Gentleman,
i do install packages MySQL-client-3.23.32-1.i386.rpm,
MySQL-3.23.32-1.i386.rpm and MySQL-devel-3.23.32-1.i386.rpm with yast on
Linux 6.3 - OS.
When i started mysql with "save_mysqld i receved follow messages:
mysql started
Can't
On Thu, Dec 21, 2000 at 09:22:40PM +0200, Sinisa Milivojevic wrote:
Lutz Jaenicke writes:
On Thu, Dec 21, 2000 at 07:30:23PM +0200, Sinisa Milivojevic wrote:
1. It doesn't help (no surprise, as this would have meant that HP's compiler
and gcc having the same problem which is not
Andrei Zmievski wrote:
On Tue, 23 Jan 2001, Gerald L. Clark wrote:
Why isn't it using index on the last query?
Because there isn't an index that contains both fields.
So it can't use separate indexes?
I guess the obvious solution would be to create an index on both of
those
Are there any facilities or gurus who could write a .pkg file to help us Linux newbies
upgrade MySQL on a RaQ4 box? The most recent version from Cobalt is 3.22.32 and we
would like to go to 3.23.30 but do not feel confident to write a .pkg for this
machine. We are prepared to pay for the file
Hi
I am new to this list so please accept my apologies if this has been
discussed before!
One of my clients has asked me to find out a rough idea as to what
proportion of database enabled websites use the MySQL database.
Any ideas?
Thanks
Andy
http://www.freelancers.net
I'm currently running Apache 1.3.12, MySQL 3.22.32-1, and PHP 4.0.3 together
on RedHat 7.0 and everything works fine, although every time I boot up I
have to manually start the Web Server with command
/usr/local/apache/bin/apachectl start.
Does anyone know how to configure Apache so that it will
On Tuesday 23 January 2001 07:28, Jean-Luc Fontaine wrote:
On Tuesday 23 January 2001 15:13, you wrote:
Just tried a 3.23.32 slave (on Linux, all rpms from www.mysql.com) against
a
3.23.30 server:
010123 09:38:05 mysqld started
/usr/sbin/mysqld: ready for connections
010123 9:38:05
Hello,
I am trying to port a program from Postgress to Mysql. This program
works perfectly in Postgress. I am having some errors though with
mysql. I get a use of uninitialized value after I execute the following
command:
$command = $query-param('command');
and then try to just access
I am running binary version
mysql-3.22.32-sun-solaris2.5.1-sparc on Solaris 2.6 box.
I do ssh onto the MySql server and issue
../support-files/mysql.server start. Everything is working okay.
I can query data bases etc.
The problem is I cannot log out of my ssh session unless
I do
Okay, here's one for the guru's out there :)
I have a list of entries with unique id numbers X, and a set of sort methods
(S1 ... Sy).
Now, if I want to get an entry at position P (0...z) in the list of
entries ordered by method S1 then I'd
make the following query:
SELECT X FROM table WHERE
"AS" == Andy Stowell [EMAIL PROTECTED] writes:
AS One of my clients has asked me to find out a rough idea as to what
AS proportion of database enabled websites use the MySQL database.
Exactly 67.2341231123123%
Now really, how on earth do you expect to come up with such a
statistic? How can
On Tue, Jan 23, 2001 at 05:39:47PM +0100, Sander Pilon wrote:
Okay, here's one for the guru's out there :)
I have a list of entries with unique id numbers X, and a set of sort methods
(S1 ... Sy).
Now, if I want to get an entry at position P (0...z) in the list of
entries ordered by
Yes, I've tried many as well and like MySQL Front the best.
lee
-Original Message-
From: Jose Ostos [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 12:20 PM
To: MySql List
Subject: Re: MySQL-Front
Of the diferent tools I have tried, I have found this one to be very
On Sat, 20 Jan 2001, Laurie Savage wrote:
I am writing a database to store student academic records at my local
high school. I wish to generate attractively published reports home to
parents.
Does anybody know of a method or product that will produce elegantly
formatted reports from
I thought I should send this to the regular mysql list as there
are many mysql users who run DB on unix but must use windows
for a workstation and remote administration.
This is an excellent front-end.. It has the best UI of any of the
other windows front-ends I've seen, it is very fast, this
Hi:
I wonder if anybody has experience using MySQL (or anoth db for
that matter) in FastCGI environment. I open connection to database and
want to make sure it is closed gracefully when application dies
(for whatever reason, for example, killed by server because there is
little demand and
Can anyone give me more information on directly using MyISAM directly in
applications? I'd heard that it was possible, but haven't ever seen any
information relating to the subject appear on this list. (I know there's a
libmyisam, but I don't know what to do with it beyond that..)
Is the API
I have recently installed mysql and ran the mysql_install_db script, with no problems.
I then proceeded to set the root password,
which worked fine as well. Now, when I type in "show databases;" I end up 8 rows of
nothing; I have 8 databases running, but no
text shows up in the console box,
I am new to MySQL so don't laugh!
I have a table 2 fields that relate to another table (that stores the
description)
i.e
history
id
status1
status2
statusText
id
details
How can I join the history.status1 and history.status2 fields to the
statusText table? in order that I can display
id
Don't use RPM.
The RPMs for the Cobalt RaQ3 suck.
I have 8 different Cobalt RaQ3's and here's the way I've used to install:
I've installed it this way successfully each time.
Sounds like a bit of a pain, but puts you in much better control of MySQL.
INSTALLATION INSTRUCTIONS
#1 -
Hi all,
The compiler is reporting a syntax error in mySQL statement near the
WHERE clause. Help. Perl code is as such:
$sqlCmd = $dbh-prepare (q{
UPDATE Sailings
SET SailPort = ?,
SailDate = ?,
Deleted = ?,
WHERE Vessel = ?
Kill the final comma, i.e.
...
SET SailPort = ?,
SailDate = ?,
Deleted = ?
WHERE ...
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
-Original Message-
From: Don [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 13:24
To:
On Mon, 22 Jan 2001, Boyd Lynn Gerber wrote:
What is this symbol __llasgdivu that is referenced in libmysqlclient.so.10
used or does it come from? Does any one else have this problem?
I have traced this to a libc problem. The symbol is found in libc.so.1
I am not sure why it is not being
Any ideas on this error? I'd love to use fulltext, but the last server that
compiled for me was 3.23.14 :(
c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/var/home/ap
psweb/newmysql\"" -DDATADIR="\"/var/home/appsweb/newmysql/
var\""
Am I the only person experiencing these stalled slave machines as described
in my pervious post to the list?
Any help would be greatly appreciated.
Thanks,
Jon
Here is my Prevoius Post:
Hello all,
Hi, I am trying using mysql on Sun Solaris2.7 now, it is working
well. But we are going to move to Solaris2.8 in the future. I am wondering
if mysql supports Solaris2.8 or not. If so, where can I find downloading
file.
Best regards,
:-)
Jing Chen
thanks for the reply. i found a followup on this problem from sasha
("Follow up on aborted connections bug in 3.23.31"), but wading through
the archive searching for the original thread hasn't ended up being
successful yet. anyone know offhand in which thread this was originally
discussed?
Hi,
The syntax is:
set-variable= max_connections=256
Regards
Quentin
-Original Message-
From: Lars Andersson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 24 January 2001 09:47
To: [EMAIL PROTECTED]
Subject: changing mysqld variables?
Ive got a problem. If I try to change
I tested replication recently and found it extremely lacking. Even the
most minor of errors causes the daemon to stop replicating, effectively
rendering the ability useless to me, as I use mysql for authentication.
Is there some configuration command to make it *ignore* errors and continue
to
At 7:34 PM + 1/23/01, suchin kannan wrote:
hi!
i am suchindran kannan. i have started on a project with my prof on
mysql and PHP.
im new to the mysql world. i have relation in which i would have to
include a multi valued attribute, can i do that in mysql.
hope i can find an answer to
Hi,
Has anyone used the fulltext indexes in 3.23 and can share their
experiences? I've only done limited testing, but was quite disapointed
with performance.
We have an import of DMoz data into a table with Title, URL and
Description fields as a fulltext index. There are 2.5 million rows that
At 11:44 AM -0500 1/23/01, Vivek Khera wrote:
"AS" == Andy Stowell [EMAIL PROTECTED] writes:
AS One of my clients has asked me to find out a rough idea as to what
AS proportion of database enabled websites use the MySQL database.
Along with the statistics below, you might try
I have spent quite some time trying to tune up fulltext indexing
(coincidentally I am also working with the DMOZ data in my database).
I too noticed how slow it goes when you order by relevancy... but there is
no reason to order by the relevancy because it returns the results in
descending order
I'm trying to get a project going which is basically converting a
price catalog into a database, however, going over the printed catalog,
basically this is what it looks like:
service_category_1
description (text)
service_1
description (text)
Thanks to everyone on this list in advance.
Now, being that I don't know exactly how MySQL is implemented, I'm
unsure of how to handle the following situation. I have a database foo,
with:
Table bar (every user would have a row... could be 100,000 rows):
id, name, password (keyed on id and
Hello all I am very new to this so please have patience with this
question.
I have recently installed mysql on debian potato and after installing I
was able to get a mysql prompt by typing mysql at the normal; user prompt
(not root) I thought that this was good. However I now get
ERROR 1045:
Normally when you log in you would type:
-mysql -u username -p [Enter]
It would then prompt you for a password if you have one.
(By the way, substitute "username" with your username.)
It shouldn't matter what prompt you're in, root, etc.
John Halladay
-Original Message-
From:
OK, let's say I have two tables. The first is a table
full of people -- their names, address, phone numbers.
The second table is an inventory, which among other things,
has a pointer to the first table for who currently has possession
of the item.
so I select from the two tables to print out
I cannot download the PDF format of the manual from the website.
Any help ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi :
I am new user ,can you tell me where can get c++ api demo
Please e-mail go me if you have.
Thank you!
Pak: No problem from here. I downloaded from
http://www.mysql.com/documentation/mysql/alternate.html
-Martin
Martin Haase
HSIM Group
[EMAIL PROTECTED]
-Original Message-
From: Pak Tse [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 5:10 PM
To: [EMAIL PROTECTED]
Hello,
I recently moved my system to a new location where it now has all new
network connection settings. When I went ot start MySQL up for the first time
after the change I got this error:
# ./safe_mysqld
1416
# Starting mysqld daemon with databases from /usr/local/mysql/var
Killed
mysqld
try;
select rticle, dealer, price from shop where price = '19.95';
notice the "'" around the value? :)
Hope that does it for you.
Atle
On Tue, 23 Jan 2001, John Wallace wrote:
mysql SELECT article, dealer, price
- FROM shop
- WHERE price=19.95;
Empty set (0.00 sec)
On Tue, Jan 23, 2001 at 01:26:59PM +0200, Tomi Junnila wrote:
* Santeri Paavolainen [EMAIL PROTECTED] wrote on 23.01.01 13:05:
Fix:
SELECTs can be worked around with table aliases, others not.
Oops, I forgot to include the cure. The first way to do this I encountered
is to simply
Hi,
It won't be to do with the network, it'll be to do with which libraries are
available where.
You need to track down libstdc++.so, and make sure that the mysqld can see
it when it loads, either by linking it to a 'normal' location (/usr/lib?) or
setting LD_LIBRARY_PATH in the environment.
Hi,
I try to use 2 COUNT's and a SUM in query from 2 tables, but am not able
to get the results I want.
The 2 tables are batches and testresults, and have the following fields
and relation:
batches: testresults:
- batch_nr ---+ - id
- date | - status
-
Hi:
I use 3.22 and KDevelop 1.0 beta 4.
Please send to me if you have C++ api demo.
Thank you!
I am getting this error trying to compile mysql 3.23.28:
checking for pdftex... no
checking return type of sprintf... configure: error: can not run test
program while cross compiling
The documentation says the compiler is not installed correctly. I tried the
gcc2.8.1 and 2.9.5 packages from
allright, so i am a beginner with some very basic questions...
I installed and set up mysql, but everything i read, talks about using ms-dos or
something to use it. It looks the interface i have for mysql has all those options, or
no??? Is whatever I will want to do not possible within that
One of our users is getting the message "another user has changed this
database..etc save changes to clipboard or drop changes... etc",
when he tries to update certain fields in the table. The table has a
timestamp and a primary key. In fact, this user can change certain
fileds without
Hi,
I have a range of decimal numbers (Prices) in a table column that I'd
like to
run a query against. I'd like to run a query with a value that returns
the closest
price to that value if it can't find a match. Is there some function
that I can use
in my query that will allow me to do this?
Hi Mac,
This is actually quite easy (although you've not supplied your Operating
System (OS)) win95,win98,winnt,win2000 is presumed:
1. Install MySQL
2. Go to the mysql\bin directory command line (DOS Box)
3. If you want to install on NT or 2000 do A) else do B)
A) mysqld-nt --install ENTER
Hi all
I have a large table (20 million records) that I want to load into RAM to
improve selects. I understand (from previous posts) that I must create a
HEAP table. Please correct me if I'm wrong on this. My question is - how
much RAM do I need if the MYI and MYD files are as follows :-
214M
Oh, thank you so much. That does help, but now I'm stuck again for some
reason...
I am at the 'mysql' prompt, and type in:
C:\mysql\bin;
...to get to the bin directory...and i got an error in syntaxwhy?
i also tried typing:
mysqladmin -uroot -password **;
and got another error..
any
Hi Mac,
You should not be typing DOS commands within the mysql.exe utility, do the
following exactly:
Get yourself here:
C:\
Type: cd mysql\bin ENTER
Result: c:\mysql\bin
Type: mysqld-nt --install ENTER
Result: c:\mysql\bin
Type: net start mysqlENTER
Result: MySQL Service has started
98 matches
Mail list logo