I'm trying to use mysqladmin to change root's password. I am root.
However, when I used the command I get the following error
mysqladmin: unable to change password; error: 'Table 'user' is read only'
This happens no matter what method I try to change the user table.
How can I make a table not rea
hi,
I am not able to create the third table i.e. AUTHENTICATE, In the first
two tables I have no problem ( i.e. DOMAIN and USER), I am giving you
the structure of all the three table along with the error i am getting..
I am not able to find out the mistake have done, please, help me..
---
I should have been more clear...
http://www.mysql.com/doc/m/y/mysqldump.html
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 24, 2002 10:03 PM
To: 'Pax'; 'MySQL'
Subject: RE: database structure script
Yes.. Use the DUMP command
-Origina
Yes.. Use the DUMP command
-Original Message-
From: Pax [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 24, 2002 9:25 PM
To: 'MySQL'
Subject: database structure script
Is there an easy way to create SQL script from existing database and use
it to create a new database?
Tks
Pax
Hello,
When I tried to run mysqlgui, this is the error message that I received:
"can't connect to local MySQL server trough socket (111)"
I've checked and created all the client files. What does it mean? How can
I correct it? MySQL server is up and running.
Thank you.
Rex Yuan
Senior IT Eng
Yes. You want to use mysqldump.
http://www.mysql.com/doc/m/y/mysqldump.html
On Sun, 24 Feb 2002 22:24:39 -0500, Pax wrote:
>Is there an easy way to create SQL script from existing database and use
>it to create a new database?
>
>Tks
>Pax
-
The example query comparing a datetime column against NOW() returns an empty
set of rows under 3.23.49. The same query against the same database returns
two rows under 3.23.48. In my opinion the 3.23.48 behaviour is correct and
3.23.49 appears to be incorrect. This happens under Linux 6.2 using t
Is there an easy way to create SQL script from existing database and use
it to create a new database?
Tks
Pax
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I'm about to try a full text index in a very similar situation, which has
the potential to grow fairly big. I'd also be interested in hearing how
MySQL's full text index works for your large dataset.
Thanks,
--jeff
- Original Message -
From: "Luke Muszkiewicz" <[EMAIL PROTECTED]>
To: <[E
Jaime:
Have you tried creating a FULLTEXT index? If so, I'd like to hear about
how well it works on such a large database.
http://www.mysql.com/doc/F/u/Fulltext_Search.html
Best of luck.
-luke
Luke Muszkiewicz
Pure Development, LLC
http://puredev.com
> Hi,
>
> I have a table and currently ha
Hi all,
Please forgive the elementary question but I am new to MySQL and DBs in
general.
I have inherited a MySQL DB to which the root password is not available, I
have read the documentation on the subject but my best efforts have failed
to elicit the desired result from MySQL.
Could some one
Jamie,
I think your approach of a cross-reference table is a good start. This is
similar to creating a stemming index. Perhaps you might like to look into,
for example, some perl Modules for stemming (like Linga::Stem) to further
reduce your data space.
Perhaps since there may be a large results
Hello,
I am using MySQL 3.23.47 under Windows 98 (mysql-opt) and I am having a strange
problem. I issued the "LOCK TABLES ;" command at the command prompt and I
got the following error:
"ERROR 1064: You have an error in your SQL syntax near '' at line 1"
The syntax looks correct to me as per
Hi,
I have a table and currently has about 1.6 million entries.
It is a table of events with date/time and description of the event.
mysql> describe eventlog;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extr
Hi,
On Sat, 2002-02-23 at 01:14, Tod Harter wrote:
> This is an example of a class of problem that crops up in a lot of
> applications, like GIS systems all the time.
>
> Unfortunately B-Tree type indexes, like RDBMS systems generally use are just
> not well adapted to this type of query. I kn
Hi Tim,
On Sat, 2002-02-23 at 02:46, Tim Allwine wrote:
> So it appears there is a maximum of 32 keys (indexes) that can be
> created on a table. Is there any way to increase this? If so how?
I think it is very important to ask the "WHY" question here can you
post your table CREATE statemen
Hi,
On Sun, 2002-02-24 at 07:06, Steve Rapaport wrote:
> I'm just trying to draw attention to a possible software
> malfunction in the "commentary" section of the online docs.
> [...] etc., etc.
> All valuable and appropriate comments, no doubt. FOR SOME OTHER
> PART OF THE MANUAL. I hope some
>Description:
I am using linux red hat 7.1, linux kernel 2.4.*.
First, try to install mysql-max-3.23.49 RPM. After installation, mysqld never
starts up automatically. And try to run mysqladmin or mysql, always has "illegal
instrucation (core dumped)" error message.
Then
Hi Anthony,
On Fri, 2002-02-22 at 23:43, Anthony W. Marino wrote:
> > On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote:
> > > > Is there a timeline/status for 4.x functionality available?
> > > > I would like to use MySQL 4.x, however, I'm looking for some of the
> > > > highly requested func
Does anyone know to accomplish having 'mysqld' startup at system boot on Mac
OS X 10.1.3?
(Mark Liyanage's startup item doesn't work for me, or I'm not using it
correctly.)
Thanks in Advance,
Ted Rogers
-
Before posting, pleas
Hello,
I'm part of a shared hosting environment that uses the above software, and I'd
like to create my own databases without having to email the support guy. We've
discussed this, and the hoster will allow me to do this, but the sysadmin can't
seem to get PHPMyAdmin to allow users of a shared My
Don't know if this is the right forum, but you can always flame me if
I'm wrong :-)
I tried using the mySQL OLEdb (ADO) driver with Delphi. ALthough I can
get a data connection and see the table names, the field lists don't
appear. Calling a valid field name in a SQL clause causes a 'field n
I've had good success with
' exportSQL version 2.0
' www.cynergi.net/prod/exportsql/
'
' (C) 1997-98 CYNERGI - www.cynergi.net, [EMAIL PROTECTED]
' (C) Pedro Freire - [EMAIL PROTECTED] (do not add to mailing
lists without permission)
'
' This code is provided free for anyone's use and is theref
After chewing this problem over for a while I think libwrap is more at
fault than MySQL, but I'll fling this to the list anyway in case somebody
else has seen it before.
Whenever a client tries to connect to a MySQL server that has been denied
by the server's TCP wrappers, libwrap executes the r
Ok well the only reason I was using 4.0.0 is because I hadn't finished
developing the application and figured I'd just leave what I installed at
start before upgrading. I will install 4.0.1-max now and try that out and if
I have further problems I will let you know.
All my tables are innodb and f
We us a shell script that calls a cronjob (root) at 3am daily.
The line in the cronjob is:
+ACo- 3 +ACo- +ACo- +ACo- /usr/local/bin/dbbakup.sh username password
The shell script:
+ACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACM
Hello everyone,
I am trying to do backups using the crond daemon on my Linux server.
Can I write a similar line as below on my crontab file. Any examples would be
appreciated.
mysqldump impex > siteroot/home/hasan/backup/backup.sql
Alternatively i am thinking of running a perl file ...which
Richard,
>(gdb) thread 1
>[Switching to thread 1 (process 31905, thread 1)]
>#0 0x82011ce in memcpy ()
>(gdb) bt
>#0 0x82011ce in memcpy ()
>#1 0x82a33c0 in mysql_bin_log ()
>#2 0x80b7cd8 in ha_commit_trans ()
>#3 0x8076e24 in mysql_execute_command ()
>#4 0x80788c8 in mysql_parse ()
>#5 0x
Try myodbc?
-Original Message-
From: Admin [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 24, 2002 11:21 AM
To: [EMAIL PROTECTED]
Subject: migrate Microsoft Access Data into MySQL
How to migrate Microsoft .mdb Database into MySQL under Unix
environment?? Who can tell me?? Any Doc??
How to migrate Microsoft .mdb Database into MySQL under Unix
environment?? Who can tell me?? Any Doc??
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hello everyone,
I am trying to do backups using the crond daemon on my Linux server.
Can I write a similar line as below on my crontab file. Any examples would be
appreciated.
mysqldump impex +AD4- siteroot/home/hasan/backup/backup.sql
Alternatively i am thinking of running a perl file ...wh
Hello everyone,
I am trying to do backups using the crond daemon on my Linux server.
Can I write a similar line as below on my crontab file. Any examples would be
appreciated.
mysqldump impex +AD4- siteroot/home/hasan/backup/backup.sql
Alternatively i am thinking of running a perl file ...wh
Dear Vincent,
> I have 2 numeric column a,b in my table.
> I want to retrieve rows which a in range
> x~y, but b not in this range. So I wrote
> a SQL statement
>
> select * from where
> ( a > x and a < y ) and ( b < x or b > y )
>
> But wrong result returned with this
> statement. Is this SQL w
One relative question:
If with "binary" flag OFF the database makes upercase conversion to the
field then where does it keep it? It dublicates it for search purposes?
Because it is kept with origin form too, of course. Or it makes it on the
fly? To slow I suppose and another friend on this list to
Dear all,
I have 2 numeric column a,b in my table.
I want to retrieve rows which a in range
x~y, but b not in this range. So I wrote
a SQL statement
select * from where
( a > x and a < y ) and ( b < x or b > y )
But wrong result returned with this
statement. Is this SQL wrong?
Thanks for yo
Dear all,
I have 2 numeric column a,b in my table.
I want to retrieve rows which a in range
x~y, but b not in this range. So I wrote
a SQL statement
select * from where
( a > x and a < y ) and ( b < x or b > y )
But wrong result returned with this
statement. Is this SQL wrong?
Thanks for y
Why is porting MySQL to BeOS still on the TODO list? The OS is
esentially dead, right?
Just wondering...
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 16 days, processed
No need, Marco. Assuming you can run Mysql at the remote machine,
you can simply take the export file and run it in mysql.
Either, from the mysql prompt, type
mysql> use mynewdatabase;
mysql> source dumpfile;
or you can do it from a command line like
% mysql -e "use mynewdatabase; source dumpfi
Hello every one...
We are going into making the final changes to our
production MySQL server.
production server configuration is
Free BSD PIII dual processor 800 mhz, 750 MB RAM.
back_log = 20 DEFAULT
back_log = 200 CHANGED
flush_time = 1800 sec DEFAULT
flush_time = 3600 sec CHANGED
key_buf
39 matches
Mail list logo