Subject: BDB Table / JDBC Problems
> OS: Windows 2000 Professional
> MySQL: 3.23.38-max
> Tables: BDB.
> Driver: mm 2.0.4
> AppServer: JBOSS 2.2.2 with Tomcat 3.2.2
>
> Has anyone seen this problem? It happens after running my stuff for about
3
> minutes - 3 minutes of select and update statem
Hello Delphi/C++Builder developers,
1. MySQLDAC v.1.3.2 (MySQL Direct Access Components for
Delphi/C++Builder) just released. Download:
http://www.microolap.com/trials/md.zip
2. Mail lists was launched yesterday:
http://www.microolap.com/newsletter.htm
You are welcome!
---
Best regards,
Edward
Hello..
I need help in this:
When I use this query on my DB:
"OPTIMIZE TABLE xxx..." - all look fine... but when I want optimize next
table I get this error message from MySQL server: Command Out of Sync - You
cannot run this command now
When I disconnect and connect my DB again all is al
Hello Delphi/C++Builder developers,
1. MySQLDAC v.1.3.2 (MySQL Direct Access Components for
Delphi/C++Builder) just released. Download:
http://www.microolap.com/trials/md.zip
2. Mail lists was launched yesterday:
http://www.microolap.com/newsletter.htm
You are welcome!
---
Best regards,
Edward
testing
Hi all,
I'm new to this list, fairly new to PHP and mySQL and I have a question
about syncing two databases. I search all over the web for this, including a
win32 version of rsync, but that's not suitable in my case, so here it goes:
I have a MySQL database A running on my local machine (Windows
Hello,
although i am not a newbie to mysql and rdbms i am new to the list and
have a problem connecting an application to MySQL. The application is
written in OpenScript which was the language of the Toolbook IDE from
Assymetrix. Now: although we are able to link the ODBC dll, when we try
to decl
Nothing of any use ... Sometime between 6/4 and 6/12, it stopped
listening... It says it starts, but if you try and connect from the mysql
client, it just hangs.
...
010604 22:25:55 /usr/local/mysql/libexec/mysqld: Shutdown Complete
010604 22:25:55 mysqld ended
010604 22:26:58 mysqld started
hi
Can anyone please help with regards to long blob data insert.
I have a data which more than 1mb which MySQL long blob field refuse to insert.
However if my data is less than 1mb there if no problem with insert.
What parameter do i need to set up..
Please help
thanks in advance
regards
I counldn't agree more with this email that was sent by Jay.
I really don't see how tables with only three columns would be an advantage
to any systems. On the contrary, I think it would be complicate to select,
insert, update and delete information.
The ecommerce example that I posted in my
Hello!
I've did an big mistake.
I've deleted the mysql-db folder at \var\lib\mysql on my new empty webserver.
Then I copied an mysql-db from my local Computer (Win2000) to the webserver.
Afterwarts MySQL starts an I could make queries on this internal mysql-db.
But I can't make any changes an the
You can start with the mysql manual. Then there is Paul DuBois book, people
say it's supposed to be good.
- Original Message -
From: "WebNomad Inc." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 20, 2001 4:39
Subject: Setting mySQL for a user
> Hello all,
>
> I'm a
Someone else asked this question last week, and it turned out that she had downloaded
the Sun/SPARC version (as you did) and tried to install it on a Sun/Intel system...
If you type "uname -a", what does the display tell you ??
zhiheng_huang wrote:
> Hi,
> I try to install mysql-3.22.32-sun-
On Tuesday 19 June 2001 17:43, Russell E Glaue wrote:
> > . After you've pulled, run BUILD/compile-pentium (for a lean fast binary)
> > or BUILD/compile-pentium-debug - it will build a binary for you.
>
> We run all our MySQLs on the fast SPARCs and PPCs
> is pentium the only supported hardware r
Hi,
I try to install mysql-3.22.32-sun-solaris2.7-sparc on our department's SUN machine
and I failed several times. Is it possible to install this database on general user(
since I am not the root)? I followed the steps to install( ater I got the directory
for mysql-3.22.32-sun-solaris2.7-sparc
At 11:04 PM +0200 6/19/01, Attila Soki wrote:
>| Paul DuBois [mailto:[EMAIL PROTECTED]]
>| When UNIX_TIMESTAMP is used on a TIMESTAMP column, the function will
>| receive the value directly, with no implicit
>| ``string-to-unix-timestamp'' conversion. If you give UNIX_TIMESTAMP() a
>| wrong or out
> . After you've pulled, run BUILD/compile-pentium (for a lean fast binary)
> or BUILD/compile-pentium-debug - it will build a binary for you.
We run all our MySQLs on the fast SPARCs and PPCs
is pentium the only supported hardware right now?
-RG
On Tue, 19 Jun 2001, Sasha Pachev wrote:
> Hel
Can someone please confirm that there isn't a problem with the
configuration files for MyODBC 2.50.37?
When I run make after configure, I get the error:
"Makefile", line 315: Need an operator
make: fatal errors encountered -- cannot continue
Line 315 contains:
-include $(DEP_FILES)
If I commen
Hello, MySQL users/hackers:
As some of you know, we are currently actively working on MySQL 4.0, and are
making some progress. Those who are subscribed to the internals lists get
notified of all of our commits and can monitor the progress.
If you would like to do a pull from our repository and
At 7:27 PM -0400 6/19/01, Mario Kent wrote:
>I installed 3.23.38 from source on a linux server, a status simply says:
>Server version: 3.23.38
>Now, I just installed 3.23.39 from source on another linux server and it
>displays:
>Server version: 3.23.39-log
>
>I want to know what the -log means and
I'm by no means an authority on this kind of stuff but you could write a
portable C program that generates a big ol' SQL script containing INSERT
INTO statements :)
I can't really think of a fast way to do it since you want to go between
MySQL and Access without ODBC and other utilities (I'm not
I installed 3.23.38 from source on a linux server, a status simply says:
Server version: 3.23.38
Now, I just installed 3.23.39 from source on another linux server and it
displays:
Server version: 3.23.39-log
I want to know what the -log means and how it got in there.
[In order to get this messag
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Mario Kent" <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 1:40 PM
Subject: Re: Version question: -log & no -log ?
>
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Mario Kent" <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 1:40 PM
Subject: Re: Version question: -log & no -log ?
>
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass
On 19 Jun 2001, at 13:36, Sinisa Milivojevic <[EMAIL PROTECTED]> wrote:
> Dave FitzPatrick writes:
> > I recently set about upgrading our MySQL install on a Compaq Tru64 4.0f
> > Alpha box from 3.22.25 to 3.23.38.
> >
[snip]
> I edited sql/Makefile and replaced the two occurrences of:
> >
> >
Hello,
I am trying to query a MySQL database on a Linux box from a WNT 4.0 SP6
box. I get this error in my WNT perl script:
Error 1130. Could not connect to database,
DBI:mysql:database=as400;host=search400. Host '10.9.8.8' is not allowed to
connect to this MySQL server
Here are the facts:
Not sure I'll be helpful, but I ran into something similar yesterday. Not
exactly sure how I fixed it, but this is what I believe.
1) You should create a virgin data directory per the standard procedures on
the production machine (install_db and safe_mysqld).
2) Then, if you have existing data,
Hi Paul,
I think CACAW8428 is the NT Nodename and not the DNS Name.
Replace the CACAW8428 in your user and db table with the IP Address of your
Workstation 10.9.8.8 and it should work.
After you veryfied that the connect works reduce the access right to the
needed.
kind regards
Peter Bethke
--
Dear all!
Thanks a lot for attention.
I solve my problem using an alias to COUNT.
Regards for all!
***Paulino Michelazzo Reply***
>Hi all!
>
>I need to get the "count" field in a select instruction like this:
>
>(from My-SQL help)
>
>SELECT owner, COUNT(*) FROM pet GROUP BY ow
I need some advice on how to export a tables data to import later into
Access.
This export HAS to be automated (and I'm using VC++ API for MySQL)
The problems I'm faced with are
(1) Before I can import this data into access I have to create the table
in access; I'm familiar with ADO and creatin
I'm a sysadmin who created mysql installs for users on linux x86 boxen; I
had to create self-contained, architecture-specific packages to comply
with our in-house means of handling software in my department. That took
three weeks to fine-tune and distribute and mysql seemed to run out of the
box
Hello all,
I'm a newbie to the list and mySQL. So please forgive me. I have no
idea what I am doing running a server but i'm doing it!
I have a client who needs mySQL and have no idea how to do this. I
have a cobalt raq4i.
Is there a resource for a real beginner like me to go to with st
hi,
is this normal?
how can i get a timestamp of dates before 1970?
thanks.
ati
mysql> select from_unixtime(-86400);
+---+
| from_unixtime(-86400) |
+---+
| 1969-12-31 01:00:00 |
+---+
1 row in set (0.00 sec)
mysql> select unix_t
This would be an acceptable method of backing up your databases, as long
as your server is not running at the same time you are doing this. If it
is, you risk corrupting your data. You should try one of the utilities
provided for making backups, mysqlhotcopy is a good one to do what you are
trying
Hello,
I am trying to query a MySQL database on a Linux box from a WNT 4.0 SP6
box. I get this error in my WNT perl script:
Error 1130. Could not connect to database,
DBI:mysql:database=as400;host=search400. Host '10.9.8.8' is not allowed to
connect to this MySQL server
Here are the facts:
On Fri, 15 Jun 2001, Jeremy Zawodny wrote:
> On Fri, Jun 15, 2001 at 12:53:04PM -0600, Chris Bolt wrote:
> > > Is this machine basically dedicated to MySQL? If so, I'd try bumping
> > > up the record_buffer to 16 or 32MB and see what that does. I've got it
> > > set at 32MB on a server with 1GB o
Is it possible to observe Handler_read_next and Handler_read_key on a per
table basis? If not, could this feature be added?
I'm not subscribed to this list, please cc all replies back to this email
address.
- Pat Wendorf
-
B
OS: RedHat 6.2 on master and slave
mySQL:3.23.32 on master and slave
Problem: Replication is not working. Symptoms include:
* Connecting OK. 'Show slave status' reports nominally.
* Position on the log file increments correctly when updates occur on the
master.
* The tables do not
Olá, instalei o mysql no Win98 porém o mesmo não está OK. Alguém tem um
passo a passo, porque estou com pressa para procurar na web, mas me parece
que tem que ter o perl instalado, isto confere?
Marcos
P.S.: estou usando Win98 e PWS.
I would try:
select distinct s.some_pk, IFNULL(s.some_pk, 999) as myid
from data_table s, other_data_table
where s.some_pk=232 order by myid;
Although I don't get the purpose of the IFNULL or the order by if you're
selecting only a single value of s.some_pk.
--jfarr
The single val
I would try:
select distinct s.some_pk, IFNULL(s.some_pk, 999) as myid
from data_table s, other_data_table
where s.some_pk=232 order by myid;
Although I don't get the purpose of the IFNULL or the order by if you're
selecting only a single value of s.some_pk.
--jfarr
- Original
I can't reproduce the error using a different database configuration and
I can't use the same database schema to make my test (the machine is now in
production state), so I attached to this mail te sql file used to create
the tables, this database is used by ASPseek 1.2.0, you can download it
at w
Yep. In fact, if I replace 'myid' by s.some_pk the query works as well.
This is what make me think it was a feature (bug?) with IFNULL in that it
would not recognize aliases. But then theres the query that does work :P
Bryan
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
If you drop the order by, does the second query work?
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "BCC" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 12:18 PM
Subject: IFNULL issues??
> Hi,
>
> Maybe someo
Alot of it would depend on what exactly you are doing. If you have alot of small
tables with only 3 columns(I'm assuming thats what you meant) that can make for a
messy server when it starts getting hit by a demand. Also, there are lots of good
books on database design. Que generally has made so
Hi,
Maybe someone could take a moment to explain this behavior?
I am using IFNULL() in an order by statement to push null values to the
end of a table for sorting.
For example:
mysql> select distinct s.some_pk as myid, queryid from data_table s,
userdata.queryinfo q where s.some_pk=q.myid order
Hi,
I want to embed MySql in my application.
Please help me in doing this.
Ankur
I can't reproduce the error using a different database configuration and
I can't use the same database schema to make my test (the machine is now in
production state), so I attached to this mail te sql file used to create
the tables, this database is used by ASPseek 1.2.0, you can download it
at w
I copy the 3 MYD MYI frm of a database to another directory as a way of backup.
Is this the right way to do it. It appears to be not function correctly.
Any help appreciate.
Thanks.
IMHO, (take it for what it is worth)
You shouldn't. Store a reference to the image in the database.(either a file
system reference, or if you are doing HTML, store the URL) I've yet to see
a good reason for stuffing an image in a database. In most cases the OS/file
system will handle the image f
you should probably just store the images on your server, and provide the
location to the image in the table...much quicker.
Tyler
- Original Message -
From: Felicia <[EMAIL PROTECTED]>
To: mysql post <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 11:03 AM
Subject: inserting images in
On Tue, Jun 19, 2001 at 08:48:56AM -0700, Brian Warn wrote:
> Hello,
>
> I want to use two text columns as my primary key. From the DuBois
> book, I see that I cannot do this since my v. 3.22.32 tables are
> ISAM, and BLOB and TEXT columns cannot be indexed. Besides
> upgrading to v. 3.23+, is
Hi,
No problem in my case, i´m using varchar inorder to get url and image paths and works
well, and they are indexed in some cases.
Blob fiels make tables work slower? Does they use much disk? I´m meking a database
with descriptions of buildings usin blob for descriptions. Is there another way
hi,
I'm trying to automate the back up of my databases,
and before I perform my backup I check my tables using
myisamchk and isamchk.
When myisamchk and isamchk report errors I would like to catch that
and maybe perform a restore operation.
hence my question: what could go wrong when running my
I'm generating a pulldown menu using PHP and MySQL. Originally I had the
list order by model where it put everything in alphabetical order. I need to
order them by year of model which luckily coincides with the order that I
dumped them into the database so I would like to ORDER by id which was an
I am new to mysql. I am attempting to place images in one of my columns. As
for my table structure, I have gotten as far as:
image blob NOT NULL,
How should I proceed?
Thanks a bunch
Get free email and a permanent address at
Drop the semi-colon off the end of the SQL Statement you wish to run. You
don't need them in the phpMyAdmin SQL Window.
Enjoy,
Tyrone
- Original Message -
From: "Tommy Beavitt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 8:31 AM
Subject: Re: phpMyAdmin newbi
Hi all,
... running this query
alter table item_dettagli
add fulltext(categoria_prezzo,settore,movimento,soggetto,lingua)
I get this error:
1005 - Can't create table '.\pickwick\#sql-3d0_2.frm' (errno: 140)
Query:
alter table item_dettagli
add fulltext(categoria_prezzo,settore,movi
Hello,
I want to use two text columns as my primary key. From the DuBois book, I see that I
cannot do this since my v. 3.22.32 tables are ISAM, and BLOB and TEXT columns cannot
be indexed. Besides upgrading to v. 3.23+, is there any workaround to this? One
column will simply store really l
Thank you!
It seems to be hard to be understood on this mailling list ;-)
Le Tue, Jun 19, 2001 at 10:17:35AM -0500, Pete Harlan a écrit:
> It would seem that there is a bug, and it's that "create table"
> accepts an 'illegal' definition. It should either convert the integer
> to a literal (makin
At 10:23 am +0100 19/6/01, Tommy Beavitt wrote:
>
>I am wondering why I am unable to use the SELECT statement to access
>data in a MySQL (3.22.32) database I have created using phpMyAdmin
>(2.1.0). Everything else about it is a delight to use (I am
>migrating from SQLAnywhere) and I have manage
Hi All,
The new Mascon version 2.2 was released recently. For more detail and a
complete list of features see http://www.scibit.com/mascon.
Some of the new features:
* Server side result sets
* Support for fulltext index creation in the visual table designer
* Support for sub-part indexes creati
It would seem that there is a bug, and it's that "create table"
accepts an 'illegal' definition. It should either convert the integer
to a literal (making the definition legal and dumpable), or it should
barf on it.
IMO, of course.
--Pete
[Charset iso-8859-1 unsupported, filtering to ASCII...
Is it better to have very small tables with a max of 3 rows, slightly larger
tables with several indexed columns. I am designing a database for a medium
size company. I certainly plan to expand the business and the database. I
want to make sure that I plan the DB correctly from the beginning. I
Hi,
I am using mySQL 3.22.23 on a Linux platform. How can I copy or move Tables between
different Databases? Is there a simple command for that? We do not have the
mysqlhotcopy command; is it safe to download and use for our mySQL version, and can it
do what I want it to do? I cannot find anyt
This isn't so much of a MySQL question as it is a PHP (or ASP or whatever)
question.
At any rate, probably the best way to do this is with nested FOR loops. In
PHP, it would look something like this:
mysql_select_db("database_name");
$qry = "select country_name from table_name where [...conditio
host.ism is in the var/mysql/mysql directory.
chown -R mysql /var/mysql
Subistitute the real path for /var/mysql.
[EMAIL PROTECTED] wrote:
>> Description:
>
>
> Upgraded from 3.22.27 to 3.23.32. Built from source.
>
> When attempting to start the daemon, it immediately terminates. Log file
Make sure my.cnf is mode 744.
David Allen wrote:
> Hi,
>
> I have several problems to do with tuning mysql to run on a Sun E450.
> Firstly, I cannot get the mysql to read the my.cnf file. If it is
> installed in the data directory, mysql boots OK but ignores it, while if
> I copy it into the /e
And the logs say?
Sue Corwin wrote:
> Red Hat 6.2 configured right out of the box ... mysql 3.23.38 . After 15
> days of running fine, the server hangs now (even after reboot) and doesn't
> listen for connections.
>
> Any thoughts?
>
>
> Thanks
> Sue
--
Gerald L. Clark
[EMAIL PROTECTED
1. Start the server.
2. Put the proper socket location in php.ini.
Augusto Cesar Castoldi wrote:
> 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
Thanks for catching this - I had an extremely long merge union, and had a
table missing - no error, so I've been trying to track down a configuration
issue for two days.
- Scott Russell
-
Before posting, please check:
ht
please,
does mysql support unicode?
thanks in advance
-
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
Alex,
this mysql/innobase/trx/trx0undo.c prints trace information
on what it finds at database startup.
Could you try compiling a new mysqld and try starting the database
with the new mysqld. Obviously the recovery goes into an infinite loop,
and this helps to find out why.
Regards,
Heikki
-
Hi Mark,
I had the same problem too.
I downloaded the gcc 2.95.3 and compiled it myself.
Using thatt gcc to compile MySQL, and everything worked fine.
kind regrads
Peter Bethke
-
Before posting, please check:
http://www.my
I use the MD5 command in mysql...I think PHP also has this...
refer to the manual
Hasan
- Original Message -
From: "Mike" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 9:50 AM
Subject: RE: assign auto password
> Using PHP you can. PHP Nuke has this, I us
Sehr geehrte Damen und Herren,
ich bin dabei eine Homepage (Futureworld3000.de) mit php und mysql zu erstellen. Ich
konnte aber bis her keine Informationen über ADO finden.
Über Informationen währe ich ihnen sehr Dankbar!
Mit freundlichen Grüßen
Volker Menten
___
Woyou,
you should use mysql-max.exe on Win 9x an Win ME because
mysqld.exe in 3.23.38 was accidentally compiled with __NT__
defined.
But I recommend downloading the new 3.23.39. It does not have
the above problem.
Regards,
Heikki Tuuri
http://www.innodb.com
Copied message:
...
Hi,
For most of the platforms Mysql has reasonably enough
space for each table itself(in GB).Database wise, also
there should not be any problem for the database size
you are mentioning.For sure,I can say that I have not
worked on Mandrake.But, I feel the size you have
mentioned should not be a pr
On Tue, 19 Jun 2001, Patrizio Bruno wrote:
> > BTW, why did you change the chunksize? By default it is 256000 and I
> > tested it for speed with many different values. 256000 seemed to be best
> > value. If you have any experience showing that I was wrong, please share
> > it with me.
>
> I was
Rolf Hopkins writes:
> That requires the use of foreign keys and that's not supported.
>
The above is true, but in a near future beta version of multi-table
delete will be ready for testing in 4.0 branch.
Syntax will be :
delete t1,t2,t3 from join_of_any_type_involving_at_least_t1_t2_t3
Assuming you are trying to execute MySQL(SQL) commands from 'netsloth.dump',
remove the 'redirect to' after the mysql command. This also assumes you are
logged into the localhost using the command line interface.
Your command would appear similar to the following:
mysql -u jjames -psd342 dbtheNe
r> When begining and commiting a transaction using perl and DBI, does the
r> commit need to come from the same statement handle as the begin or does it
r> just need to be from the same database connection handle?
If you are using DBI for transactions you should have something like:
$db
hi!
> "Steven" == Steven Roussey <[EMAIL PROTECTED]> writes:
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
>> alway
Hi!
Thanks for the nice test case!
Next time you have as nice a test case, please send it to
[EMAIL PROTECTED] for fast treatment!
> "tommie" == tommie <[EMAIL PROTECTED]> writes:
tommie> count() gives 0 but count(distinct) gives 1. is this correct or
tommie> a bug or is there something
Dave FitzPatrick writes:
> 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
Hi,
I am wondering why I am unable to use the SELECT statement to access
data in a MySQL (3.22.32) database I have created using phpMyAdmin
(2.1.0). Everything else about it is a delight to use (I am migrating
from SQLAnywhere) and I have managed to create tables and insert data
into them no
Hi,
Do someone maybe know, if it is possible to transfer a
mysql database?
Is it enough, that I copy the
/mysql/data/$databasename to another computer to have
there the same database with the same tables and
records?
thanks & regards,
Sibel.
__
D
Hi,
I have several problems to do with tuning mysql to run on a Sun E450.
Firstly, I cannot get the mysql to read the my.cnf file. If it is
installed in the data directory, mysql boots OK but ignores it, while if
I copy it into the /etc directory I get the following error
"Starting mysqld daemon
hai
Can anybody help me? I'am query out data(country name) from database,total
count of country if 100.Now i want to arrange the country's name by 3
column() not long list.It should be
example:
AntiguaAustraliaAustria
BarbadosBelgiumBrazil
BulgariaCanadaChina
It's possible?
thanks in advanc
hallo terrell!
> what if i can't get into mysql anymore at all, not even as root, :(
> is there file somewhere i can edit so i can get in again?
>
have you try it with this?
mysql -u root mysql
Gruß & bye
Michael Ott
-
- Siemens AG - I&S IT PS 51 ERL -
-
That requires the use of foreign keys and that's not supported.
- Original Message -
From: "Sibel Toprakkiran" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 16:23
Subject: cascade delete's
> Hi,
>
> I wanted only to know, if there is a possibility in
> mysql f
"mysqladmin --help" will provide you with a list of switches you can use.
If you add "-u root" to the shell command , perhaps you'll have more
success.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 16:37
Subject: create database proble
Hello,
After setting some changes to different databases with GRANT (new users, set
ALL PRIVILEGES for root etc), I get the following problem:
lxs5:/ # mysql -h lxs5 -u root --password=sbcdef OBJEKT69
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to serv
Thx, that helped! We plan it in the sipler scenario (1 mysqld at time) Of
cource we will test it first, before taking it into production. My last
question would be: Does it also work if the lockd and statd is not running
on the machine where mysqld is running?
Stepan
On Tue, Jun 19, 2001 at 09:4
Hi,
I wanted only to know, if there is a possibility in
mysql for cascading delete's? Because in databases
with a lot of tables, it s really difficult to pay
attention to all of the dependencies and it would be
nice, if there is a possibility for automatically
deleting the dependent records.
tha
shell>mysqladmin create trial
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to
database 'trial''
why this happened
i only can use test database by default
-
Before posting, please check:
ht
On Tue, Jun 19, 2001 at 09:47:27AM +0200, Stepan Havel wrote:
>
> The answers I find are on the one hand: Yes, it works perfectly, I
> run mysql on a Netapp filer for hunderts of years! , or on the other
> hand: It simply does not work with nfs and locking it core dumps
> inconsistent isam files a
The answers I find are on the one hand: Yes, it works perfectly, I run mysql
on a Netapp filer for hunderts of years! , or on the other hand: It simply
does not work with nfs and locking it core dumps inconsistent isam files and
so on!
Do you feel my problem? :-)
Stepan
-Ursprungliche Nachr
On Tue, Jun 19, 2001 at 04:49:58AM +0200, Tonu Samuel wrote:
> On Mon, 18 Jun 2001, Jeremy Zawodny wrote:
>
> > I'd use a combination of my.cnf entries and SQL. The my.cnf entry (or
> > entries) woudl list the available directories, like others have
> > suggested. Then, using SQL, you could:
> >
On Tue, Jun 19, 2001 at 09:27:15AM +0200, Stepan Havel wrote:
> Hi Ladies and Gents,
>
> does anybody has experience with mysql + nfs, or mysql + Nettapp
> Storage?
Several folks on this list (or who *were* on this list) do, yes. Check
the list archives and see if you find the answers you seek.
1 - 100 of 103 matches
Mail list logo
