>Description:
The command "mysqladmin -h host -u user -ppass flush-logs" does rotate the
logs of mysql but not the errorlog.
>How-To-Repeat:
Self compiled mysql on debian.
>Fix:
Not a real solution but an manual restart of the mysql server reactivates the
errorlog.
>Subm
I suppose it depends on your needs and/or exactly what you want to
accomplish, but I use urSQL (www.urbanresearch.com/ursql) to access data
on MySQL, MSSQL, MS Access, and Paradox databases. I use urSQL frequently
to do ad hoc queries and basic SQL tasks...
I wouldn't really call it an "Admin" t
MysqlFront is thé best tool for me.
http://anse.de/mysqlfront/download.php
Works on remote databases to, nice and smooth interface, exporting tables in
various formats,
export/import from one active db to another ...
B.
-Original Message-
From: Correale, Ernest [mailto:[EMAIL PROTECTED]
Hello all,
Is there any way in mysql to restore the data back after flushing off
all the data already present using a single command.
I am having backup of the db and i want to restore the data back in the
database by flushing off all the data already present.
Thanx in advance
Regards,
Ch
Hello,
is possible to create user which will be not able to create other
users and will have full access to all existing databases and
databases which will be created in future?
Thank you.
Regards,
Michal Dvoracek [EMAIL PROTECTED]
mysql,query,sql
---
When mysqld-max-nt.exe is started with options
--console --standalone
and after issuing "mysqladmin -u root shutdown"
mysqld reports a shutdown, but does not exit.
mysqld-max don't have this problem.
OS Windows 2000.
Roman Vorobiev.
e-mail: [EMAIL PROTECTED]
__
Hi Cal,
Thanks for the tip. But any reasons as to why 3.23.51-max is preferred to
3.23.49-max-nt?
cheers,
Ki Mien
-Original Message-
From: "Cal Evans" <[EMAIL PROTECTED]>
Sent: Saturday, July 13, 2002 11:34 PM
To: "Ki Mien" <[EMAIL PROTECTED]>, "[EMAIL PROTECTED]"
<[EMAIL PROT
I have a MySQL TimeStamp in my table. If I try to do a query via ODBC, I get an
error on the field.
Any suggestions?
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PROTECTED]
--
Hi Carlos and All,
Oh ya, i am also trying to use VB6.0 and mysql in window environment but is
not sure how well they work together, may i know which middle ware you use
to bridge the communication between VB6 and Mysql.
- Original Message -
From: "Carlos Rovetto" <[EMAIL PROTECTED]>
To:
Hi. I am begining using MySQL with Visual Basic 6.0 in Windows 98 first
edition. Some times i to receive this message but i don't know why.
Error on rename of '.\video\products.MYI' to '.\video\#sql2-fffa6015-3.MYI'
(Errcode: 13)
The SQL instruction is:
alter table products add (unitprice do
Hi. I am begining using MySQL with Visual Basic 6.0 in Windows 98 first
edition. Some times i to receive this message but i don't know why.
Error on rename of '.\video\products.MYI' to '.\video\#sql2-fffa6015-3.MYI'
(Errcode: 13)
The SQL instruction is:
alter table products add (unitprice do
try logging in as follows
[william@localhost william] mysql - u root -p
it will then prompt you for your root password
you should have access as root after that
HTH
Peter
---
Excellence in internet and open source software
Hi Kelly,
| I am writting a search engine using Mysql. I am trying to return
| a text object value (which contains all of the html), but it is
| taking about 10 seconds to return each text value matching my
query.
| Is there any way that a text value can be optimized
Yes you can run querys from the mysql prompt and redirct them to a file.
Here's how.
Make a file and call it query. Inside the file put something like this:
use db_mydatabase
select * from tbl_mytable where something=somethingelse;
Then from the prompt (not in the mysql prompt) use this command
I've read the Adding New Users Section and the initial and post setup
section of the manual, but I still need some clarification:
After an install and a working MySQL I see it like this (Mac OS XS):
there are 3 users:
mysql - created manually after installing MySQL and has a password
root - a mys
Can you provide more information like are you using cgi to get the code and
what language. What's your query look like? Are you full text indexing your
text field? Do you have an index on the table? What's the table structure
look like? Can you send a sample record? How many records in the table?
--On Sunday, July 14, 2002 5:24 PM -0500 Dan Nelson
<[EMAIL PROTECTED]> wrote:
>> > The correct thing to do is probably to fix include/my_net.h. poll
>> > requires , not . In addition, there should be
>> > an autoconf check for , instead of assuming that because
>> > you have a poll function
I am writting a search engine using Mysql. I am trying to return a text
object value ( which contains all of the html), but it is taking about 10
seconds to return each text value matching my query. Is there any way that
a text value can be optimized?
www.cs.uno.edu/~kkelly
--
I need to make a presentation about the topics of
mysql like history, phisical structure, logic
structure, like that.
Alexander
--- Jeremy Zawodny <[EMAIL PROTECTED]> escreveu:
> On Sat, Jul 13, 2002 at 11:12:11PM -0300, Alexander
> Burbello wrote:
> > Hi,
> >
> > I need to make a presentati
Hi all.
I just upgraded to MySQL-4.0.2 (great work guys) and noticed that MyCC's
user administration isn't displaying privileges properly, ie doesn't
show them at all. (When I say upgrade, I mean a full uninstall & new
install, and import from mysqldump backups). Granting seems to work OK
(I t
In the last episode (Jul 14), R Blake said:
> --On Sunday, July 14, 2002 2:04 PM -0500 Dan Nelson <[EMAIL PROTECTED]> wrote:
> >In the last episode (Jul 13), R Blake said:
> >>BUG #1:
> >> does not seem to exist in BSD variants (cref:
> >>http://www.netsys.com/bsdi-users/2001-11/msg00093.html), bu
Hi,
WIth the way eSKUeL (a PHP app I found on freshmeat) displays query
results in a table, and the way that copying and pasting that data into
a xls or doc file appears I'm hoping to be able to run queries manually
on the mysql prompt and have the output redirected to a file so that I'm
able to
on 7/14/02 3:29 PM, William Bradley, typed:
> mysql> USE mysql
> ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
> mysql>
use mysql;
:)
-
Before posting, please check:
http://www.mysql.com/manual.php
dan,
thx for your reply!
--On Sunday, July 14, 2002 2:04 PM -0500 Dan Nelson
<[EMAIL PROTECTED]> wrote:
> In the last episode (Jul 13), R Blake said:
>> BUG #1:
>> does not seem to exist in BSD variants (cref:
>> http://www.netsys.com/bsdi-users/2001-11/msg00093.html), but
>> nonetheless, ".
Your patience please :) I am an absolute newbie. When I setup Mysql
I made some mistakes and now I can't seem to get out of them.
When I login as root and type "mysql" on the command line as root, I get
the following:
[william@localhost william]$ su
Password:
[root@localhost william]# mysql
In the last episode (Jul 13), R Blake said:
> BUG #1:
> does not seem to exist in BSD variants (cref:
> http://www.netsys.com/bsdi-users/2001-11/msg00093.html), but nonetheless,
> "./configure" sets HAVE_POLL as defined, causing make to fail with
> sys/poll.h "not found".
>
> WORKAROUND:
> ==
Hi all,
When i use MS access 2000 with odbc to fill my MySQL db(running on linux)
auto_increment seems not to work .
Is that normal?
Or am i missing something?
TIA
Raymond
-
Before posting, please check:
http://www.mysql.co
Hi!
> "Marko" == Marko Djukic <[EMAIL PROTECTED]> writes:
Marko> Anyone know what this syntax error is about? trying to compile the 4.0.2 on a
freebsd server...
Marko> Making all in sql
Marko> gmake[2]: Entering directory `/usr/home/oblo/xfer/mysql-4.0.2/sql'
Marko> byacc -d sql_yacc.yy
ahh sorry for misunderstand. the truth is that i have no idea about the
solution of your problem but i would like to hear from you if you find a
solution.
Sameh Attia wrote:
>
>
> Veysel Harun Sahin wrote:
>
>> http://www.mysql.com/doc/P/r/Privileges.html
>>
>> Sameh Attia wrote:
>>
>>> Hi,
>>
>Description:
No problems during compilation. Nonetheless
the server won't start at all. Been unable to execute
mysql_install_db --force after installation.
hostname.err:
mysqld got signal 11;
This could be because you hit a bug. It is also possible
Veysel Harun Sahin wrote:
> http://www.mysql.com/doc/P/r/Privileges.html
>
> Sameh Attia wrote:
>
>> Hi,
>>Can anybody help me figuring how to control granting users
>> permissions to created functions in MySQL like we do for SELECT,
>> INSERT, ...etc or it is not possible and every one l
http://www.mysql.com/doc/P/r/Privileges.html
Sameh Attia wrote:
> Hi,
>Can anybody help me figuring how to control granting users
> permissions to created functions in MySQL like we do for SELECT,
> INSERT, ...etc or it is not possible and every one logged in to MySQL
> could simply use t
>Description:
This very basic UPDATE command is very slow in 4.02 :
UPDATE lang2 SET ref_id = 0; (could be also = 1, = 2, etc)
It takes several minutes to run on a 235,000 records table, with high disk
activity (fs_usage reveals many seek/read/write accesses).
For comparison, it takes about 5
Hi,
Can anybody help me figuring how to control granting users
permissions to created functions in MySQL like we do for SELECT, INSERT,
...etc or it is not possible and every one logged in to MySQL could
simply use them like any other native function?
Regards
--
Sameh Attia
Senior System
Hi!
> "grant" == grant <[EMAIL PROTECTED]> writes:
>> Description:
grant> when running a "insert data infile" command on a 500MB text file, I
grant> get the error "ERROR 1030: Got error 22 from table handler" from
grant> mysql. I did a listing of the database files and it looks like t
Wouter,
I did open it up in MSWord and found that there were no commands in the
file, just data.
What makes this worse is that each field is preceded with a tab and a
character which identifies the field. Empty fields are omitted to the extent
that although the fields run in the sequence A-Z and
Karl,
- Original Message -
From: ""karl "" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, July 14, 2002 7:41 AM
Subject: Updates
> Hello,
> This is similar to my post earlier...(I'm really racking my brains over
this).
> I'm going to try and rephrase (shorten) my q
You can't subtract dates like that. You need to use the built in date/time
functions. See the following:
http://www.mysql.com/doc/D/a/Date_calculations.html
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
Your query would be something like this:
SELECT TO_DAYS(completion_date) - TO_DA
Hi!
Due to an error in the build process, the rpm of plain MySQL-4.0.2 does not
contain InnoDB.
Please download the rpm of MySQL-Max-4.0.2 instead.
The error in the build of the plain MySQL-4.0.2 rpm will be fixed in the
coming days.
Best regards,
Heikki Tuuri
Innobase Oy
39 matches
Mail list logo
