Can I dump a database while the database is running in mysql ?
--
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There's no place like 127.0.0.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
would u have an example of how to use union then ? like on the second select
i need to reutn a heap of rows from a field from the first select
-Original Message-
From: MyLists [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 10:42 AM
To: MySQL List; otherguy
Cc: Terry Vanstory
Subje
How about a UNION statement? If the two queries are independently returning
what you need, then you can just "append" the two results by using UNION.
Good Luck!
Dennis
- Original Message -
From: "otherguy" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Cc: "Terry Vanstory" <[EM
Hey guys, I'm about to dump a doozy on your collective knowledge and
goodwill, and hope for some help or some pointers. I'm not great with
advanced SQL, and I've gotten as far as my brain and the resources I've
been using will allow me to get for the time being.
I need help with two things:
1)
Bruce Feist wrote:
One
-->possibility would be to break the values out into multiple columns,
one
-->for each view, and have indexes on each of those columns, or at least
-->the views that you consider most important. It might help to make
them
-->compound indexes, with each including several vie
Hi Keith,
I understood that the backup done by f.e mysqldump would dump the create
statement only for the index - not the actually data fo the index. That would
make the backup option create smaller files than lets say if you copy it 1x1
on the OS command line basis f.e with cp.
This option al
2003年 6月 27日 金曜日 22:39、Gantier さんは書きました:
> Hello,
> I work with apache, tomcat and linux redhat 7.3 and mysql 4.0.9
> When I try to connect to my database from my application with the user
> XXX with password YYY, the next message appears :
>
> INVALID AUTHORIZATION SPECIFICATION :
> ACCESS DENIED
If you can identify the log files to apply, you can issue the following command:
mysqlbinlog log_file_to_apply | mysql -h server-name
hth,
SB
-Original Message-
From: Nils Valentin [mailto:[EMAIL PROTECTED]
Sent: Friday, June 27, 2003 5:53 PM
To: gerald_clark; Subhakar Burri
Cc: Keith C.
Hi Gerald,
Do you know some good information about it, seems like I need to brush up a
bit on this.
I dont understand how you want to do a roll forward for a MySQL table -
especially if the backup is lets ay from 8 AM and the crash is at 2 PM.
Best regards
NIls Valentin
Tokyo/Japan
2003年 6月
-->-Original Message-
-->From: Bruce Feist [mailto:[EMAIL PROTECTED]
-->Sent: Friday, June 27, 2003 3:51 PM
-->To: Dathan Vance Pattishall
-->Subject: Re: How can a single row with a single column represent 2
values
-->without bitwise data representation
-->
-->Dathan Vance Pattishall wro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 27 Jun 2003 02:49:21 -0400, [EMAIL PROTECTED] wrote:
>I don't understand how to morph the following with your specification:
>SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
>make, propID, addressIP, OS FROM people, make
Dathan Vance Pattishall wrote:
Say you have a column in a search table by the name of politics.
So, my question is how can multiple values for a single field get
represented in a single row and receive the benefits of an index? How
can this data be represented?
I don't think that there's a per
On Fri, Jun 27, 2003 at 05:27:02PM -0500, Michael Brunson wrote:
> On Fri, 27 Jun 2003 14:50:58 -0700, "Dathan Vance
> Pattishall" <[EMAIL PROTECTED]> wrote:
>
> | So, my question is how can multiple values for a single field get
> | represented in a single row and receive the benefits of an inde
On Fri, 27 Jun 2003 14:50:58 -0700, "Dathan Vance
Pattishall" <[EMAIL PROTECTED]> wrote:
| So, my question is how can multiple values for a single field get
| represented in a single row and receive the benefits of an index? How
| can this data be represented?
Try using a SET column type and the
Say you have a column in a search table by the name of politics.
Each political view is represented as an integer from 0 - 16. A user can
choose multiple political views, and those views have to be represented
in the db as a single row. How can a single column for a single row of a
searched tab
I'll second the recommendation of Welling & Thomson's book. It's a great
starter with numerous real-world examples, and it includes a CD of all the
source code, which all decent books do. I find that I've generally outgrown it
already, but they always told me I was a fast learner!
Edward Dudlik
You're running a join on table two which will result in the following set (if
you remove the group by and sum()s):
ABCCORP 500, 150, 350 (from table 1, row 1, join table 2, row 1)
ABCCORP 500, 50, 300 (from table 1, row 1, join table 2, row 2)
ABCCORP 500, 50, 250 (from table 1, row 1, join
On 27 Jun 2003 at 16:47, Daniel Whitener wrote:
> mysql> SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST
> ('V000*'); Empty set (0.00 sec)
>
> any good reason why that wouldn't work?
Sorry, my mistake. The asterisk only works in Boolean mode (which
requires MySQL 4). Try this inste
On Fri, Jun 27, 2003 at 04:47:43PM -0400, Daniel Whitener wrote:
> Thanks for the quick reply! Actually I read through that page before and I
> tried it and still nothing
>
> mysql> SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST ('V000*');
> Empty set (0.00 sec)
>
> any good rea
Hey Keith,
Thanks for the quick reply! Actually I read through that page before and I
tried it and still nothing
mysql> SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST ('V000*');
Empty set (0.00 sec)
any good reason why that wouldn't work?
Thanks again,
Daniel
Keith C. Ivey
Ben,
You can also access MySQL databases from PHP, FYI.
I've learned a lot from the book:
"PHP and MySQL Web Development" By Luke Welling & Laura Thomson
ISBN: 0-672-31784-2
Hope that helps!
Len
--
Len French
Technical Applications Specialist
Lutron Electronics, Inc.
[EMAIL PROTECTED]
1-800-5
On 27 Jun 2003 at 16:30, Daniel Whitener wrote:
> an example of this string is V00021 - they all start with v000
[snip]
> mysql> select ID from emails where body like '%v000%';
[snip]
> mysql> SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST
> ('v000');
Full text searching searches
Hello MySQL folks,
I'm searching through my database (version 4.0.13) looking for certain
strings that start with - v000 - but the fulltext index doesn't seem to be
indexing that string of letters/numbers. If I do a normal WHERE LIKE, it
shows me what I need, but when I try and use the fulltext i
Hi,
I'm using 3.23.51 and I'd like to update a field in a certain order. I've
got a table of images for a slide show and the format of the table is:
image varchar(128) not null
order_number integer not null primary key
So we might have something like:
duck.jpg 1
cat.jpg 2
horse.jpg 3
I want th
The permissions on my /var/lib/mysql directory are: File Owner: mysql
- MySQL Server; Group is mysql.
I did discover that I had not set a user in /etc/my.cnf. Once I did
that, the mysql.sock "file" was set up (doh! sorry about that).
Here's a portion of what I get when I do ls -l /var/lib/m
On 27 Jun 2003 at 14:49, David Brodbeck wrote:
> FWIW, if size is a problem, mysqldump files compress quite well with
> gzip. (Lots of repeated text.) The same is true of update logs, if
> you're keeping those.
The same is also true of the original tables (the .MYD files), so I
stand by my stat
Jeremy/Gerald
I just tested it with an insert statement on a MyISAM table and an Innodb table, and I
saw the both insert statements in the binary log. So, I can roll forward these
changes, right?
I still don't see how your answer (MyISAM doesn't have transactions) relate to my
initial question
I only know good references:
the manual: http://www.mysql.com/documentation/index.html
the Bible: MySQL by Paul Dubois ;)
for the access to mysql from webpages, you'll need to use perl dbi and
acquire some notions about how CGI works
Wavyx
Ben Ferderer wrote:
I am so new to mysql that I only k
> -Original Message-
> From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 26, 2003 5:49 PM
> The dump file will be larger than the MyISAM data file for the
> original table -- especially if you have many non-text columns
> (dates, numbers, ENUM columns, etc.). In som
I am so new to mysql that I only know it can be used to as a database
linked to WebPages via perl.
This is what I want to do with. I have had such experience with asp.
What are some good web tutorials to teach me installation and the basics
of mysql adding perl is always a bonus.
Make it
Ok, update log.
Jeremy Zawodny wrote:
On Fri, Jun 27, 2003 at 08:08:40AM -0500, gerald_clark wrote:
Yes, if you have transaction logging turned on.
You can edit the transaction log, and run it against the restored database.
MyISAM doesn't have transactions.
Jeremy
--
MySQL General M
MySQL GUI is no longer supported. Try using MySQL CC instead and let us know if
you still have problems.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
From: "Tang, Sean X"
Thank you for replying.
I can change DISTNAME in Makfile.common, but then I might not be able to
uninstall it. I am relatively a novice, and I don't want to mess anything
up.
In order to use MySQL, will I need to download both the client and the
server? I don't have a lot of space on my HDD, and
On Fri, Jun 27, 2003 at 09:20:45AM +0200, [EMAIL PROTECTED] wrote:
>
> I have an installation of MySQL where the data directory is located
> on an NFS share. Client and server are connected by Full Duplex
> Gigabit Ethernet (both hosts run Linux 2.4.21). The NFS is exported
> with "sync" option.
>
On Fri, Jun 27, 2003 at 08:08:40AM -0500, gerald_clark wrote:
> Yes, if you have transaction logging turned on.
> You can edit the transaction log, and run it against the restored database.
MyISAM doesn't have transactions.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yah
On Thu, Jun 26, 2003 at 08:33:15PM +0100, Aodhan Cullen wrote:
>
> I've got an interesting problem for you all. I'd love to hear what
> you think.
>
> I've simplified the database design of my web application to its
> root problem, so it'll be very easy to see my difficulty, and if
> you're feelin
# [EMAIL PROTECTED] / 2003-06-27 14:44:55 +0200:
> I have a question regarding mysqlhotcopy's use.
> I'd like to use the --flushlog option in order to have a nice backup &
> synchronized log for my replication slave in case of recover need
> (without stopping the master).
> But the lock used by m
SQLyog v3.51 - The definitive Windows Front End for
MySQL, has been released.
SQLyog is a superfast, compact and easy to use Front
End for MySQL.
Some of the new features added in SQLyog 3.51 are -
-- Complete support for MySQL 4.1.
-- Improved SQL Editor.
-- Improved ODBC Import Tool.
-- BLOB
# [EMAIL PROTECTED] / 2003-06-20 11:07:09 -0400:
> Hello,
> I am trying to compile MySQL 3.23.57 on NetBSD 1.6.1. I downloadded
> pthreads-1_60_beta6-mysql.tar.gz from your site and extracted it to
> mysql-3.23.57/ I ran ./configure --with-mit-threads in mysql-3.23.57 and
> everything went fine.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mike Hillyer wrote:
> Plain text. Use of the upcoming MyODBC 3.52 will make it in binary form,
> but not encrypted. Is the remote server MySQL 4.x? You could possibly
> use Stunnel (www.stunnel.org) to access the server via SSL.
>
The MySQL protocol
Plain text. Use of the upcoming MyODBC 3.52 will make it in binary form,
but not encrypted. Is the remote server MySQL 4.x? You could possibly
use Stunnel (www.stunnel.org) to access the server via SSL.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Mike Fish (Shoal C
Did you try increasing max_connections ?
Michael Edlund wrote:
I've developed a CMS using PHP and MySQL 4.1 alpha.
It ran just fine with the standard MySQL 4.1a binaries both on my
Powerbook running Mac OS X as well in a production environment on my
FreeBSD server. However, after having insta
Hi
I'm connecting to a MySQL server on the internet from a VB6 app on Win2K
using MyODBC.
I understand that the connection itself is not secure. I cannot implement
SSH for the connection as my ISP does not support this with MySQL.
However, when MyODBC sends the username and password etc to the My
This is a shot in the dark, but perhaps you need to optimize your
indexes. By default, MySQL assumes an even distribution of values for
indexes. I'm not sure when it diverges from this default, I assume it
does at some point. MySQL uses the data distribution values/assumptions
to determine how
'localhost 127.0.0.1' is not a valid host.
Use 'localhost' if you want to use the local socket.
Use '127.0.0.1' if you want to use the TCP port.
Gantier wrote:
Hello,
I work with apache, tomcat and linux redhat 7.3 and mysql 4.0.9
When I try to connect to my database from my application with the u
Well, without seeing your table structures and key definitions, how
could we tell?
You are selecting on code="87901" , but there is no indication here
about what tbale that column belongs to.
Did you run analyze on your tables to update key distribution
information so the server could make a b
In that case they are probably fixed width files. If they are not fixed
with and are in fact delimited by tab or comma, you can use LOAD DATA to
bring them in.
See http://www.mysql.com/doc/en/LOAD_DATA.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Ben Ferderer
The extension of the data files specific to my companys inventory and
accounting info. If it helps this programs seems to be written in
cobol or acucobol.
Ben Ferderer
System Administrator
Radio & TV Equipment
[EMAIL PROTECTED]
800.288.9134
-Original Message-
From: Paul DuBois [mailto:
At 10:36 -0500 6/27/03, Ben Ferderer wrote:
Are .fil files associated or view able with sql at all. Someone
mentioned to me that they might be. My companys database uses .fil
files and I want to be able to link to the information in them for web
based inventory display.
What's a .fil file?
O
Are .fil files associated or view able with sql at all. Someone
mentioned to me that they might be. My companys database uses .fil
files and I want to be able to link to the information in them for web
based inventory display.
Or --- Am I way off base here?
Make it a great day!
Ben Ferd
I've developed a CMS using PHP and MySQL 4.1 alpha.
It ran just fine with the standard MySQL 4.1a binaries both on my
Powerbook running Mac OS X as well in a production environment on my
FreeBSD server. However, after having installed everything on a clean
Debian Linux system, there are some oc
I posted to this thread yesterday indicating that I had the same
problem. After playing with it some more I realized that I was not
starting MySQL with the appropriate user/group. As mentioned below,
the user has to have write permissions to this directory in order to
create the unix domain s
Ok, I added IN BOOLEAN MODE and now it somewhat works...It is just a matter
of optimizing it now. Thanks.
- Original Message -
From: "Cliff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 8:13 AM
Subject: Problem with FULLTEXT searches
> I am trying to get the f
Hi Fred, group,
I wrote--
>I'm trying to get just a total of the funds amount for a
> Job, Sub and Task like this --
> SELECT Jobs.Job, Jobs.Sub, Jobs.Task, sum(Funds_Recd.Amt) AS Amount
> FROM Jobs, Funds_Recd WHERE Jobs.Job=Funds_Recd.Job and
> Jobs.Sub=Funds_Recd.Sub and Jobs.Task=Funds_Recd
I am trying to get the fulltext search working properly as described in the
manual but some queries do not seem to be working correctly. When I run this
query:
SELECT allusa.name,title,full_text,match(title,full_text) against ('chicken
soup lemon') from recipes, bb.allusa where innid = bb.allusa.i
Thanks. I've installed package perl-CGI and now it works.
Iago Sineiro
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviado el: viernes, 27 de junio de 2003 15:48
Para: Iago Sineiro; MySql Mail List
Asunto: RE: perl error when execute mysqlaccess
This more a perl q
Thanks to everyone for their help, I actually managed to fix the problem by bypassing
MySQL's optimization using STRAIGHT_JOIN. Out of curiosity can anyone tell me why
MySQL failed so miserably at optimizing my query? (The two hour long query took 10s
with Straight_join).
mysql> explain select
Can any one help me?
Yasir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have had similar performance concerns, but on a much smaller scale.
The data was well indexed, but took far too long to query (particularly
with aggregate queries).
Check the individual row size of your table. In my case, I had a TEXT
field that would frequently be fairly long. Moving that fiel
Shaun Callender <[EMAIL PROTECTED]> wrote:
calculate the balance by account #
TABLE 1 contains
ACCOUNT #, INVOICE #, INV TOTAL
TABLE 2 contains
there can be multiple payment records associated with an invoice
ACCOUNT #, INVOICE #, PAYMENT, PAYMENT DATE
select TABLE1.accountno,
SUM(TABLE1.inv
OK.
I sent to you once on the list, and to the original poster, but it was
returned from his email server (who knows).
Here it goes.
The most probable reason reason that file is not there is permissions. When
mysqld starts (under user mysql or mysqld) it writes the file in the
directory spe
>I think it's always a bad idea to create complex setups like you are
>contemplating.
I'd agree. They are very hard to maintain if you need to change things in the
future.
>see any reason to use varchar, that creates variable length records
>which you want to avoid if you can. Especially with
This more a perl question.
You need to install CGI.pm for perl.
The CGI module should be available from RPMs.
HTH,
Lian
> -Original Message-
> From: Iago Sineiro [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 27, 2003 1:32 PM
> To: MySql Mail List
> Subject: perl error when execute mysq
Hello,
I work with apache, tomcat and linux redhat 7.3 and mysql 4.0.9
When I try to connect to my database from my application with the user
XXX with password YYY, the next message appears :
INVALID AUTHORIZATION SPECIFICATION :
ACCESS DENIED FOR USER '[EMAIL PROTECTED] 127.0.0.1' USING PASSWORD(
Exactly that's the problem!
how can I rewrite the query syntax avoiding the multiplication?
Thanks
Patrizio
-Messaggio originale-
Da: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Inviato: giovedì 26 giugno 2003 22.15
A: [EMAIL PROTECTED]
Oggetto: Re: sum() problems - I don't understand
On
Part of the problem may be the size of the returned set. If you are
having MySQL return the date on 11K rows, your bottleneck may be the
network or disk. Remeber, MySQL has to read all that data from the
database and transfer to your program or display it for the command
line. Even if you had a
> adding an integer 'userid' to member table and using it as a foreign key
> in member_log table instead of username.
You're right. The main reason i'm doing this, is due to legacy reasons.
> Also, I don't know what you mean by 'medint' but if it is a mediumint,
> you will be in trouble since its
Kevin H. Phillips wrote:
Well, the find / -name mysql.sock didn't return anything at all so this
*is* an odd predicament. Would it work if someone with a similar
version e-mailed me a copy of their mysql.sock file?
Kevin
>
>
> John Nichel wrote:
It doesn't look as if you have any conflictin
On Fri, Jun 27, 2003 at 09:05:48AM -0400, Moulder, Glen wrote:
> G'day all,
>
> Having trouble with SUM, could use a hand. I inherited a table, Funds_Recd that
> looks like this:
>
> ID Job Sub Task Amt
> 1A01 A1910,001.00
> 102 B53 A201 79.47
> 213 X99 L8838
Yes, if you have transaction logging turned on.
You can edit the transaction log, and run it against the restored database.
Subhakar Burri wrote:
Can I roll forward if I do backups using Mysqldump? Say, I did backups using Mysqldump @ 8:00 AM and my instance crashed @ 2:00 PM. I can restore the ta
That can't be the output of the query.
The fourth column would me titled 'soma'
There is no seperator bar between the data for sw_or_local and soma on
the data lines.
Fabio Bernardo wrote:
hi there
I wrote this querie :
select pop, prot, sw_or_local, sum(qtd_porta) as soma from clientes where
s
Hi all,
> -Original Message-
> From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 27, 2003 3:18 PM
> To: [EMAIL PROTECTED]
> Subject: Re: incorrect SUM() results
>
>
> Shaun Callender <[EMAIL PROTECTED]> wrote:
> >
> > I'm using mySQL 4.0 trying to solve what I think
G'day all,
Having trouble with SUM, could use a hand. I inherited a table, Funds_Recd that looks
like this:
ID Job Sub Task Amt
1A01 A1910,001.00
102 B53 A201 79.47
213 X99 L8838,289.02
284 A01 A19126.98
I do not have ownership and *MAY NOT* change
It's not the insert that are taking a long time, it's the selects.
Trying running the command with and explain in front of it to see where
you query is bottlenecking. Perhaps you don't have an index on one of
your search fields.
The first query is probably running faster because you have a few
I have a question regarding mysqlhotcopy's use.
I'd like to use the --flushlog option in order to have a nice backup &
synchronized log for my replication slave in case of recover need
(without stopping the master).
But the lock used by mysqlhotcopy made me split the backups into
something like:
I think it's always a bad idea to create complex setups like you are
contemplating. I would try everything else first. For instance, I don't
see any reason to use varchar, that creates variable length records
which you want to avoid if you can. Especially with the number of
records you are comp
Shaun Callender <[EMAIL PROTECTED]> wrote:
>
> I'm using mySQL 4.0 trying to solve what I think is a simple problem.
>
> to calculate the balance by account #
> can this be done without the use of temporary tables ?
>
> TABLE 1 contains
> ACCOUNT #, INVOICE #, INV TOTAL
>
> TABLE 2 contains
> t
Syamsul Arifien <[EMAIL PROTECTED]> wrote:
>I have :
>"call to undefine function mysql_connect() atphp line"
>that's the message..
First of all, please, answer to the mailing list, not to me directly.
This error means that PHP isn't compiled with MySQL support.
--
For technical suppor
[EMAIL PROTECTED] wrote:
Ok, this is good:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
make, propID, addressIP, OS FROM people, make, models, machines
WHERE people.peopleID = machines.peopleID AND make.makeID =
models.makeID AND models.modelID = machines.modelID LIMIT
On Friday, June 27, 2003, at 05:34 AM, Maurice Coyle wrote:
i have a table in my mysql database with around 66 million rows in
it. when i query this table, it takes anywhere from 3 minutes to 10
minutes to return the results. i've tried this both from within the
mysql command line and from j
Hi Maurice,
I would be interested to see how your SQL reuqest looks like. Perhaps it is
possible to optimize at this point, just a guess so.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 27日 金曜日 18:34、Maurice Coyle さんは書きました:
> hi all,
> i have a table in my mysql database with around 66 mil
Hi.
When I execute the perl script mysqlaccess I receive the following error
Can't locate CGI.pm in @INC (@INC contains:
/usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl
Hi
http://www.mysql.com/doc/en/Fulltext_Search.html
the create and insert of data went ok but when i do
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database');
i get SQL-query
I am using RH8.0 and mysql 3.23.56 and php 4.3.2
I connect ok and my other code works SELECT term, expl
Gantier <[EMAIL PROTECTED]> wrote:
> Hello,
> I do the next request on a table with a column type varchar2
> insert into XX ('test\annuaire\');
> the request succeeds but in the table '\" have disapeared.
> testannuaire
>
You must escape this char:
http://www.mysql.com/doc/en/Stri
Ed Kiefer <[EMAIL PROTECTED]> wrote:
> I keep getting this error when I try to create a new database:
>
> mysql> create database cheese_catalog;
> ERROR 1044: Access denied for user: '@localhost' to database'cheese_catalog'
User doesn't have permissions to create database.
--
For technical su
Seth Redmond <[EMAIL PROTECTED]> wrote:
> I've been having a few problems loading blobs via the LOAD_FILE function
>
> I've tried things along the lines of:
>
> UPDATE table SET binaryRecord=LOAD_FILE("/Users/shared/filename.mov")
> where refNo=1;
>
> It only seems to happen when loading someth
"Mike" <[EMAIL PROTECTED]> wrote:
>
> Where can I find more info on converting and what can be converted.
Check the following section of the manual:
http://www.mysql.com/doc/en/Using_mSQL_tools.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This emai
Gantier <[EMAIL PROTECTED]> wrote:
> Is it possible to load from the database a field entry with
> password(XXX) and see it not crypted, as if we 've made a
> unpassword(XXX) action ?
Nope. This encryption is non-reversible.
--
For technical support contracts, goto https://order.mysql.com/?ref=
Replace \ with \\
Ulterior
=
Global FTP Search - www.filesearch.lt
- Original Message -
From: "Gantier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 9:11 AM
Subject: Pb with insert
> Hello,
> I do the next request on a table with
select * from TableName LIMIT NumberOfRows
George Christoforakis
- Original Message -
From: Maurice Coyle
To: [EMAIL PROTECTED]
Sent: Friday, June 27, 2003 12:34 PM
Subject: very long query time
hi all,
i have a table in my mysql database with around 66 milli
hi all,
i have a table in my mysql database with around 66 million rows in it. when i query this table, it takes anywhere from 3 minutes to 10 minutes to return the results. i've tried this both from within the mysql command line and from java programs.
Section 1.2.4 in the manual says th
Hello,
Is it possible to load from the database a field entry with
password(XXX) and see it not crypted, as if we 've made a
unpassword(XXX) action ?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sorry to reply to myself but after reading your post again,
I think you can use replication to maintain member table in sync:
it is possible to restrict replication to a some tables within a
database: check 'replicate-do-table' option.
Hope this helps
Joseph Bueno
Joseph Bueno wrote:
I don't have d
I don't have direct answers to your questions but you should consider
adding an integer 'userid' to member table and using it as a foreign key
in member_log table instead of username. It will make selects and joins
faster, data and index sizes smaller.
Also, I don't know what you mean by 'medint' b
Hi Sergei,
Thank you for the reply. I could indeed install the tables on the rpm
installation (4.1 alpha).
However on the the xx.tar.gz (4.0.13) version I get this:
./mysql_install_db: line 1: my_print_defaults: command not found
Didn't find ./bin/mysqld
You should do a 'make install' before ex
Hi!
On Jun 27, Daniel Rossi wrote:
> sorry i worked it out put it after the table , i got some interesting results
>
> Queried The Database 1 times for 9.9892050027847 seconds
>
> +---+--+--+--+-++--+-+
> | t
Hi!
On Jun 27, Nils Valentin wrote:
> Hi MySQL Fans,
>
> I understood that within the mysql command line client there exist two help
> pages:
>
> a client help page - accessable with "help"
> a server help page accessable with "help all"
>
> I found that the file (seems like a table within the
Hi Nico,
I understood that DROP FOREIGN KEY is not supported before Version 4.0.13.
( In such case you will have to drop the table and recreate it.)
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 27日 金曜日 16:45、Nico Gr さんは書きました:
> Hello,
>
> how can i delete an foreign key between two tables?
I have an installation of MySQL where the data directory is located on an NFS share.
Client and server are connected by Full Duplex Gigabit Ethernet (both hosts run Linux
2.4.21). The NFS is exported with "sync" option.
Read performance is really fine, but when it comes to writing e.g. an A
# [EMAIL PROTECTED] / 2003-06-27 09:45:06 +0200:
> how can i delete an foreign key between two tables? Is there a drop foreign
> key - command available?
yes, read:
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
--
If you cc me or remove the list(s) completely I'll most likely ign
1 - 100 of 105 matches
Mail list logo
