Hey Scott,
Try:
GRANT ALL ON DATA.* TO user1@"%" IDENTIFIED BY "password"
/or simply/
GRANT ALL ON DATA.* TO user1 IDENTIFIED BY "password"
Not specifying a domain defaults to %.
HTH
Ben
-Original Message-
From: Scott Meesseman [mailto:[EMAIL PROTECTED]]
Sent: 09 April 2001 01:27
To:
I am experienced a problem of using MYSQL GUI on windowME to connect mysql server,
which was v3.22 and installed on open linux .
I couldn't make any connection with it and don't know why.
I checked my password and Ip address, they both are correct and working properly.
please be kind to giving
Hi
On Monday 09 April 2001 05:34, Jack A. Tinsley Jr. wrote:
First, things, first - I am a newbie to MySQL but I have it up and running
quite well. The only thing I haven't been able to figure out is why I'm
losing "\" (back slashes) in my stored data. I have a application I'm
considering
Without being picky, and just to let Jack know, the line:
"\\\server\\folder"
should be:
"server\\folder"
Each double slash pair (\\) is replaced in the database with one slash (\).
I recommend you take a look at the AddSlashes() and ereg_replace() functions
if you're using PHP
just some thoughts, this is a nice way of creating one "tree"-table of unlimited
levels, top-level-items has for example parent_id -1, and if you want to get the items
(the childs of a parent) just say
select * from items where parent_id = x
create table items (
item_id int unsigned not
(that was already sent to [EMAIL PROTECTED])
Description:
Programs, compiled with mysql++ on that machine, abort with a
segfault at an attempt to connect to the mysql server, while
programs using Mysql C API (for instance, mysql's own
benchmark suite) and the same programs executed on a local
HI Friends ...
I wish u help me in this problem ... I have installed the mysql(recommended
version) For NT(my platform) and the odbc, and finally I installed the
mm.mysql.jdbc-1.2c.zip and made all the required configurations . Mysql
driver works properly and I build a database using the SQL
Hi,
After Upgrade to 3.23.36 from source tarball on debian 2.2r2 potato with
kernel 2.4.1 not mysqlshow neither mysqldump show results. Only the version
will be prompted. Access via mysql-client is working. All databases are
myisam-dbs.
Access via phpmyadmin doesn't work because of the
Hi!,
My application uses an archive 'libmysqlclient.a' and another
object module 'dblib.o' which internally make calls to functions
supported by 'libmysqlclient.a'. So i decided to use a single archive
file containing both of them i.e. 'libmysqlclient.a' and 'dblib.o'. At
link time, i get
Is it somebody out there who has made a migration from an Oracle server to an MySQL
server??
(Or do I have to talk to those NASA guys again?? =)))
The scenario is as simply:
A SUN machine with an Oracle 8.1.7 server with a database with content that I want to
transfer to
a MySQL database. No
Lance Benson writes:
In my version of WinMySQLadmin (v 3.23.33 running on Windows98, said on the
MySQL site to have been modified 3/1/1), in the Databases tab, in the Table
Columns frame, the Fields do not display properly. The first one is ok,
but then the name of the second
I've made a stupid error. While logged in as root I was deleting
records from the user table. Someone was talking to me while I was
entering a command and I didn't realize what I entered until it was too
late. I entered:
delete from user where user='root';
I immediately used an insert
At 11:06 09-04-2001 +, you 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:
database,sql,query
If you just reply to this message, and include the
I've made a stupid error. While logged in as root I was deleting
records from the user table. Someone was talking to me while I was
entering a command and I didn't realize what I entered until it was too
late. I entered:
delete from user where user='root';
I immediately used an insert
stop mysql service, restore the backup from the mysql.user table (or: copy
from a other mysql with known users, or: copy from the installation files),
restart mysql.
- Original Message -
From: "Bob Dushok" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 09, 2001 1:09 PM
Thanks very much for your help on this, it is appreciated. I downloaded and
ran the appropriate makefiles as the readme files said, however when I get
to running install Bundle::DBD::mysql then I get an error telling me that it
does not have an associated bundle so it cant continue...I know this
HI!
This is due to a bug in connection.cc.
Rebuild MySQL++ with this source and you will have no more problems
like this.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*|
[EMAIL PROTECTED] writes:
Description:
When transfering a database application to use an Alpha Linux server
rather than intel Linux previously working regular expressions fail to work.
It appears to be due to a length limit. This effects both binary downloads
and home compiled
database,sql,query
Hi All,
Is there a nice way to take a search string eg
"America spying China" and search a text or
blob field for occurances of all of the words
in the text in any order (ie not just a literal
string match, but the equivalent of
AND X LIKE "%America%" AND X LIKE
I bet you downloaded the source code version and not the binary version.
check your download.
Daniel Katcher
202-619-7643 ( voice )
202-619-7655 ( fax )
[EMAIL PROTECTED]
"Amit" [EMAIL PROTECTED] 04/07/01 12:40PM
Dear Sir,
This a mail from a new established software company. We are
I am experienced a problem of using MYSQL GUI on windowME to connect =
mysql server, which was v3.22 and installed on open linux .
I couldn't make any connection with it and don't know why. =20
I checked my password and Ip address, they both are correct and working =
properly.
please be kind to
Hi there,
the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes,
the master is running. the user name and password are correct. actually i
dont think it gets to the state of actually verifying the user name and
password. even if i do just a mysql -h 192.168.1.2 it gives me
Hi
I am MySQL as database in my project. Can i get Type IV driver for
JDBC to connect with database. If so, can u send me the information. If
not, when can i get drivers information for JDBC.
thanks in advance
bye
venkatesh
Hello,
i would like to know if it is possible to have mysql running on a unix server
(HP-UX 11) and a C++ client application running on windows.
Thanx for your help,
Aurlien
-
Ce message a ete envoye grace a Endymion MailMan.
depuis l'adresse :
http://www.mysql.com/doc/I/n/Internal_locking.html
Hope this helps.
-- Rodney
Zach Hollandsworth wrote:
Is there an explanation somewhere about the rules mysql uses when lock
tables?
-
Before posting, please check:
Marco Baldacchini wrote:
MySql support transactions?
The OLE-DB provider support transactions?
Call the method Begintrans on a connection object (ADO) return an error!!!
And you read the manual, right?
Transaction support depends on the version of MySQL you are running, and
the table type
Well, if this is zdnets's MySQL tutor, I would suggest you find another
one, or get
the book "MySQL" by Paul DuBois ( New Riders ).
This command will not work, even if you are in the MySQL monitor.
You can start right now by reading the manual that comes with the MySQL
package.
Once you have
Could please let me know whether Mysql database can be used with QNX
realtime 4.25? If so which version? What are the terms for commercial
licensing? Can I get a trial version. I appreciate your help
Thanks
Lekha Das
-
To eliminate DNS problems, put each machine in the others /etc/hosts
file.
MCA Department PESIT wrote:
Hi there,
the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes,
the master is running. the user name and password are correct. actually i
dont think it gets to the
THe manual recommends restarting the server with --skip-grants.
Fix your user table, and flush privileges to reload the grant tables.
Bob Dushok wrote:
I've made a stupid error. While logged in as root I was deleting
records from the user table. Someone was talking to me while I was
Hi!
"Peter" == Peter Zaitsev [EMAIL PROTECTED] writes:
cut
Peter It's a pity what mysql misses something like PROFILE call for the
Peter query so I could check how much time is spent for different phases of
Peter query execution.
MW Any suggestions for the output for this?
Peter Well Yes.
hi i downloaded Linux (Intel libc6 systems) [pc-linux-gnu-i686] i have
uncompressed it and untarred it onto a PC. but i cannot find the necessary
make and make install files to compile and run sql ! why is that ?
machine i am running on is P166, 64mb ram using red hat linux 7.
thanks i hope
That is a binary tarball.
If you want to compile it, download the source.
[EMAIL PROTECTED] wrote:
hi i downloaded Linux (Intel libc6 systems) [pc-linux-gnu-i686] i have
uncompressed it and untarred it onto a PC. but i cannot find the necessary
make and make install files to compile and run
On Mon, Apr 09, 2001 at 03:48:43PM +0200, Niklas Rudemo wrote:
I'm trying to select into outfile to a file that already exist.
This has been discussed before, I know, but the solution suggested
results in an SQL-error, as shown below. So what's the real solution?
Select your rows into a
Description:
oliver After several sig 11 I compliled a --with-debug version and enabled
oliver debugging and logging. Mysqld crashed shortly after starting without
oliver trace (!) and then immediatly crashed again after restart.
oliver
Hello, is it possible to prevent users from seing other databases than
the one there are using ?
I thought it was possible using priveleges and "Select_priv", but It
doesn't work...
I am using 3.23.33
Thanks in advance for your help...
-
Fabien SALVI Centre de Ressources
Try putting a line in your my.cnf that contains:
safe-show-database
This will only allow the user to see databases that they have permissions
for
You can optionally use skip-show-database, which will not allow the
command at all.
John Barton
Unix Systems Administrator
Primary Networks, Inc.
I sent that reply about this 1 WEEK Back.
Look up safe_show_databases and skip_show_databases in
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
regards,
thalis
On Mon, 9 Apr 2001, Fabien Salvi wrote:
Hello, is it possible to prevent users from seing other databases than
the one there
the page must be :
http://www.avukatpro.com/mysql.html
but i really don't know this is included as my signature and
this page contains mysql and visual basic samples.
not included about silent install yet.
Regards.
Yusuf INCEKARA
- Original Message -
From: John Steele [EMAIL
#--That is a binary tarball.
#--If you want to compile it, download the source.
What you mean with tarball? Its supposed just to uncompress it and it
should work?
Hi everybody,
I am new to MySQL.
I have Linux server through my hosting company.
I want to install MySQL on server.
I need your help in this regard how I can install the same on my remote server?
Thanks in advannce.
Anoop
_
Chat with your
"Thalis A. Kalfigopoulos" wrote:
I sent that reply about this 1 WEEK Back.
Look up safe_show_databases and skip_show_databases in
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
regards,
thalis
On Mon, 9 Apr 2001, Fabien Salvi wrote:
Hello, is it possible to prevent users from
On Sunday 08 April 2001 12:59, Kamil Yildirim wrote:
--- Sasha Pachev [EMAIL PROTECTED] wrote:
On Saturday 07 April 2001 17:59, Kamil Yildirim
wrote:
Hi
I have a problem with SQL UPDATE statement within
a
Java programm which establish a connection to a
Mysql
Server over
it seems to be working after i type safe_mysqld --log
but i get this message when i try to run mysql , i try creating a database
using mysqladmin but the same socket thing comes into it !
my error message
mysql admin connection to localhost failed
error can't connect to local mysql server
I am new to MySQL.
I have Linux server through my hosting company.
I want to install MySQL on server.
I need your help in this regard how I can install the same on my remote
server?
Read:
- this lists archive before sending questions
- www.devshed.com
- many many other websites.. you can find
I would think it is because you don't have all of the development tools in place.
also the path to mysql must be ok.
On Sat, 07 Apr 2001 17:56:41 +0200, B. van Ouwerkerk wrote:
At 17:25 7-4-01 +0200, com2 wrote:
hi everybody we get this err mex when we run:
./configure
On Sun, Apr 08, 2001 at 12:22:32PM -0500, Rodrigo Zerlotti wrote:
Description:
INSTALL-BIN file has errors:
shell chown -R mysql /usr/local/mysql/var
it should be
chown -R mysql /usr/local/mysql/data
instead "var"
Thanks, Rodrigo. I have fixed it now.
Tim
--
__
Okay, I'm about to rip my hair out trying to figure this out, and I
thought before I start looking for a gun, maybe I should ask..
I need someone to explain the 'mysql' database to me. I've tried
reading about it, tried different settings, but I'm lost. So far I've
just been adding
Description:
Attempting to delete all records in a table containing NULL values in a
UNIQUE KEY field does not work as expected. Only a single record is deleted,
presumably because the server thinks that the table will only have one record
with a NULL value in it (as it is in a UNIQUE field).
Check with your hosting company. My guess is that they handle the initial MySQL
setup for you. Very few companies will allow you to install the software on
their servers.
-- Rodney
Anoop k gupta wrote:
Hi everybody,
I am new to MySQL.
I have Linux server through my hosting company.
I
Look at the following pages in the manual:
http://www.mysql.com/doc/M/i/Missing_Transactions.html
http://www.mysql.com/doc/T/a/Table_types.html
-- Rodney
Gerald Clark wrote:
Marco Baldacchini wrote:
MySql support transactions?
The OLE-DB provider support transactions?
Call the method
I haven't read Mysql's authorization mechanism from Paul's book, but from the Oreilly
book and it was pretty comprehensive and intuitive. I suggest you borrow that book
from your local library or buy it.
To try to write here about how it works would be a waste of time for both of us. It is
Ashley,
Are you using the GRANT statement?
That is the easiest way to get it right.
Read up on the GRANT SQL statement. Look at the examples...
Using regular inserts into the mysql database, can cause improper input into
the tables, which can (from personal experience) cause mysqld to not run.
"Thalis A. Kalfigopoulos" wrote:
I haven't read Mysql's authorization mechanism from Paul's book, but from the
Oreilly book and it was pretty comprehensive and intuitive. I suggest you borrow that
book from your local library or buy it.
Ya, it's already on its way...(the book that is).
I posted a couple problems regarding the use of the FULLTEXT indexing and a
search query problem, but never got any responses. So maybe some one may shed
some lite on setting up a table with the FULLTEXT index.
I've read thru the MySQL docs on this and it's not real clear. When setting up a
On 9 Apr 2001 [EMAIL PROTECTED] wrote:
Description:
Attempting to delete all records in a table containing NULL values in a
UNIQUE KEY field does not work as expected. Only a single record is deleted,
presumably because the server thinks that the table will only have one record
with a
I'd like to use MySql with Java (under Linux) bu I can't be able to do that:
how can I do?
Thank you in advance, Mario.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
There's some good documentation (a lot of it in the form of 'warnings') on
security aspects of the "mysql" database.
http://mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#Privilege_system
But, here's some quick notes:
Anyone who has 'modify' permissions to the
Hi,
I work on the big web site of the gouvernative statistical agency of
Italy (www.istat.it).
Recently, I have built a db to collect data from the web (it's like a
census simulation...) with mySQL.
Making my querys,I had a little difficult, not so big for me, but that
can interest you.
On a
On Mon, 9 Apr 2001, Thalis A. Kalfigopoulos wrote:
This is perfectly normal from Mysql's part. What you call a uniq_id in
the table where you don't declare it as a unique key is merely another
int field and a table scan will be performed to actually find ALL the
occurences of the value you
[EMAIL PROTECTED] writes:
Description:
Attempting to delete all records in a table containing NULL values in a
UNIQUE KEY field does not work as expected. Only a single record is deleted,
presumably because the server thinks that the table will only have one record
with a NULL value
Hi,
I goot this error when I type "make" apache after installating
(mysql-3.23.36-pc-linux-gnu-i686.tar.gz) configurating it with php
4.0.4pr1 on RedHat 7.0, the problme as seen bellow seems to be related
to libmysqlclient.a(my_compress.o) but I don't know what to do. I'm
following exactly the
database,sql,query
load table from master
does not work for me. I get the error message
ERROR 1189: Net error reading from master
what can cause this?
both the master and the slave are version
3.23.33-log
--
[EMAIL PROTECTED] (Jim Ziegler)
We're looking for a DBA (MySQL). We've been without a DBA to date and have gotten to
the point where we need one.
Please respond to [EMAIL PROTECTED] for more details.
Thanks.
EQ-
I have a db I made with mysql/php/apache. I was copying my script files to a floppy
disc. I figured I'd also back up the data itself so I wouldn't have to re-enter it
all. I went into C:\mysql\data\testTrack and, being an inquisitive fellow, I decided
to have a look in the 3 files there - an
On Mon, Apr 09, 2001 at 02:01:55PM -0400, Jim Ziegler wrote:
database,sql,query
load table from master
does not work for me. I get the error message
ERROR 1189: Net error reading from master
what can cause this?
both the master and the slave are version
3.23.33-log
"Ashley M. Kirchner" wrote:
Okay, I'm about to rip my hair out trying to figure this out, and I
thought before I start looking for a gun, maybe I should ask..
I need someone to explain the 'mysql' database to me. I've tried
reading about it, tried different settings, but I'm
On Mon, 9 Apr 2001, Matt Loschert wrote:
Sorry for jumping in ...
another NULL Mysql will not complain about it cause Null!=Null whereas
it would complain if you had inserted a '1' and tried to insert
another '1'.
Clear as mud?
Your explanation makes sense, but it seems a bit
We will be moving our MySql databases from a Winnt server to a linux server. Can I
just copy the data files from one machine to the other? If not then how should I do
it?
Mat Murdock
Your mouse has moved. Windows must be restarted for the change to take
effect. Reboot
Description:
mysql uses 99% cpu and becomes extremely unresponsive under high load
How-To-Repeat:
send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click
around.
Fix:
restart mysql. this usally helps, at least for a few minutes. sometimes it climbs
back to
is it recommended to install mysql by rpm or tar?
dave
-
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
It depends on what version of MySQL you are running. MyISAM tables will
move across platforms fine, but ISAM tables will not. You could always
choose the failsafe and use mysqldump to dump the contents of your
database into a file, and then use that to reload the contents on the new
machine.
Hello.
On Mon, Apr 09, 2001 at 01:05:01PM -0400, [EMAIL PROTECTED] wrote:
On 9 Apr 2001 [EMAIL PROTECTED] wrote:
Description:
Attempting to delete all records in a table containing NULL values in a
UNIQUE KEY field does not work as expected. Only a single record is deleted,
On Mon, 9 Apr 2001 [EMAIL PROTECTED] wrote:
I have the same problem under FreeBSD-4.2 STABLE
sometimes it work fin 1week, but sometimes 1 day.
Description:
mysql uses 99% cpu and becomes extremely unresponsive under high load
How-To-Repeat:
send about 300 simultaneous visitors to
DateDB_amount CR_amount
2001-04-09 NULL300.00
2001-04-09 NULL750.00
2001-04-09 NULL300.00
Anyone know how can I do a query that will update the third record
without updating the first?
Have you tried this under a 'stable' version of freebsd?
In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault.
now, I understand RC's are generally stable; but I would still make sure
that this bug doesn't show up in a stable os.
regards,
-- Andrew
- Original
ISM file. I opened them with notepad. Now my scripts will not
execute. The ISD file says that it was modified today. All 3 icons have
changed to the notepad icon, although this is not necessarily the most
unbearable part of the whole thing. Are they lost forever? Can they be
made to
On 4/9/01 10:12 AM, "Burke Patrick" [EMAIL PROTECTED] wrote:
Hi Lindsay,
maybe you can help me?
I am trying to give a user SELECT access to just one table in my database.
If I don't give him SELECT privileges in the mysql.user table or mysql.db
table, he cannot even login to the
delete from db where date="2001-04-09" and CR_amount=300.00
insert into from db (date, DB_amount, CR_amount) values ("2001-04-09", NULL,
300.00);
insert into from db (date, DB_amount, CR_amount) values ("2001-04-09", NULL,
350.00);
would change the 3rd to 350.00 credit.
Unfortunately, there is
Your table has no primary key.
You have a badly malformed database.
How can you tell one transaction from another?
You have debit and credit amounts with no timestamp or account
identifier.
Add an autoincrement id field as a primary key. Then you can update
based on that key.
Richard Reina
database,sql,query
What causes:
010409 15:47:42 Slave: Failed reading log event, reconnecting to retry, log 'FIRST'
position 4
010409 15:47:42 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4
010409 15:47:42 Error reading
You can update the "first" row by adding LIMIT 1 to your update query.
If the rows are identical, "first" vs. "third" doesn't matter. If it
does matter,
you should probably add a unique, tiebreaking field (sequence or
DateTime, if
you can assure there will never be 2 identical records inserted
is it recommended to install mysql by rpm or tar?
dave
-
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
SELECT
url,newwebsites.description,newwebsites.title,newwebsites.catid,category.fullname,MATCH
newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category LEFT
JOIN userrestrictions ON userrestrictions.name REGEXP
'[[::]]username|GLOBALAUTHADMIN[[::]]' AND
.deb :)
Jeff Levy
Software Design
Meta-Craft Creations
On Mon, 9 Apr 2001, David Loszewski wrote:
is it recommended to install mysql by rpm or tar?
dave
-
Before posting, please check:
http://www.mysql.com/manual.php
hi.
according to this:
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html
the binary is recommended for linux.
if you know what you're doing, or want support for wacky options, compile
your own.
instructions for both options are on the above page as well.
hth.
-ravi.
Hello,
I have a box running Win2k and MySQL 3.23.36, I had made a backup of all my
databases/tables to CD-ROM last week. When I tried to access them again
from the CD-ROM, I noticed that all file names had been altered to be
displayed in uppercase and now they will not function in the php
Hi!
On Apr 09, MikemickaloBlezien wrote:
I posted a couple problems regarding the use of the FULLTEXT indexing and a
search query problem, but never got any responses. So maybe some one may shed
some lite on setting up a table with the FULLTEXT index.
I've read thru the MySQL docs on this
Hi,
I am doing a select from to tables which are join'ed, I cannot determine
automatically which table a column belongs to:-
I have tried both these selects:-
SELECT * FROM staff, staffsubjectTitles WHERE staff.id = 11 AND
staffsubjectTitles.staff_id = 11
SELECT staff.*,
Unfortunately I am using 3.22.32. Does this mean I am out of luck with
this query.
Peter Schwenk wrote:
If you are using version 3.23.x of MySQL, there is a LIMIT clause that you can use
to just update up to a certain number of records, so you could add 'LIMIT 1' to the
UPDATE command to
Hi!
I have tested a bit today.
Various logfiles are at :
http://www.dassic.dk/~jfn/mysql/
I found that after compiling with full debugging, I got the error that one
of the my.cnf parameters was too little and should be increased on the
server.
The default is 1 MB. I tried to increase it to 16
Since MATCH is evaluated AFTER the where, you need to use HAVING
SELECT
url,newwebsites.description,newwebsites.title,newwebsites.catid,category.ful
lname,MATCH
newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category
LEFT
JOIN userrestrictions ON userrestrictions.name REGEXP
I have experienced the same problems on a dual processor machine running
4.2-STABLE and mysql 3.23.36 from the ports tree.
regards,
Lars Andersson
At 16:03 2001-04-09 -0400, Andrew Schmidt wrote:
Have you tried this under a 'stable' version of freebsd?
In FreeBSD 4.2 beta, mysql would crash
Hello,
I have jsut installed mysql,DBI etc on my linux 7.0 box. I got this error
first thing trying to change the root password. I do NOT have a file
libmysqlclient.so.9 but i DO have a file libmysqlclient.so.10. how did this
get out of sync and how can I repair this install?
Thanks,
Gim
Uh, before you take his head off, consider that most people using MySQL are
not in a position to build MySQL themselves (or trust whatever comes out of
"./configure --whatever_options; make").
And the default binary distribution does not include BDB or InnoBase for any
platform (that's coming
Hi,
You can't use aliases in a where, but you can in a HAVING clause.
Regards
Quentin
-Original Message-
From: Brad Barnett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 10 April 2001 8:44 a.m.
To: [EMAIL PROTECTED]
Subject: Strange queries
SELECT
Unfortunately, you're using MySQL on a Microsoft product, and you've probably
run into one of those issues where Redmond decided what's best for you (changing
the 'case' of the filenames).
BUT, in both the Microsoft and UNIX realm of products, 'packaging' files (on
UNIX using 'tar' and 'gzip',
On Mon, 9 Apr 2001 23:16:21 +0200, Sergei Golubchik [EMAIL PROTECTED] wrote:
Then how come I keep getting these results when setting a test table. Am I
missing something here??
Create the table:
DROP TABLE IF EXISTS bus_search;
CREATE TABLE bus_search (
bus_id int(8),
title varchar(200),
Fortunately, these were only test databases so there won't be much
loss. My question is in the future, is there a recommended way of backing
up the databases that will not cause any errors?
I'm using mysqldump to create backups.. but that's on linux, I'm not sure
about windooz version.
Similar problems on FreeBSD 4.2-RELEASE.
Dedicated Mysql server is pinning the CPU, under a load of 500+ queries
per second. Memory is not exausted, and Disk usage is 0.
Just the CPU is pinned.
[EMAIL PROTECTED] wrote:
Description:
mysql uses 99% cpu and becomes extremely
1 - 100 of 126 matches
Mail list logo
