Nope. That's just granting replication privileges so it can read updates
on all tables on all databases. It cannot select anything.
Why are you trying to connect with a replication slave user?
On 4/2/13 1:47 PM, "Richard Reina" wrote:
>I did a "GRANT REPLICATION SLAVE ON *.* TO 'user'@'19
On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina wrote:
> use DBI;
> my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, {
> RaiseError => 3 } );
> my $dbs = $dbh->selectcol_arrayref("show databases");
>
> #my $dsn = "dbi:mysql:information_schema:192.168.0.1:3306";
> #my $dbh =
I did a "GRANT REPLICATION SLAVE ON *.* TO 'user'@'192.168.0.23' IDENTIFIED
BY 'psswd';
on the master. Doesn't *.* mean everything? Why would it just show me to
databases?
2013/4/2 Larry Martell
> On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina
> wrote:
> > use DBI;
> > my $dbh = DBI->conn
; mysql@lists.mysql.com
Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com
Subject: RE: Please help me.
Velentin,
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
Note the section for the droping of foreign keys used the contraint name,
not the key name. Try this
Velentin,
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
Note the section for the droping of foreign keys used the contraint name, not
the key name. Try this and see if it solves the first problem (of removing the
constraint). Then you should be able to drop the c
- Original Message -
From: "Russell E Glaue" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, November 06, 2007 8:55 PM
Subject: Re: Please help to solve a serios problem
>
> The mysql.sock location '/var/lib/mysql/mysql.sock' att
The mysql.sock location '/var/lib/mysql/mysql.sock' attempted to be used by your
connecting client may be wrong.
linux$ ls -la /var/lib/mysql/mysql.sock
Does the file exist?
You say this is the sock file created by mysqld:
>
> srwxrwxrwx mysql mysql system_u:object_r:mysqld_var_run_t mysql.soc
On Tue, 2007-11-06 at 09:32 -0600, [EMAIL PROTECTED] wrote:
> i believe you need to have root create the file /var/lib/mysql/mysql.sock
> and then make it readable and writable by the user that owns mysql.
>
> You can make that same file owner by the user that runs mysql.
>
>
>
>
> -Origin
i believe you need to have root create the file /var/lib/mysql/mysql.sock
and then make it readable and writable by the user that owns mysql.
You can make that same file owner by the user that runs mysql.
-Original Message-
>From: Ali Nebi <[EMAIL PROTECTED]>
>Sent: Nov 6, 2007 9:24 AM
"Nikita Tovstoles" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Do both of your SELECT statements use the same index (`token`) when setting
locks on the rows? My guess is that the situation is as follows.
TX2: SELECT ... WHERE id = ... FOR UPDATE
TX2 sets an exclusive lock for a ro
VeeJay wrote:
How and at What place, can I configure the Makefile under
/usr/ports/databases/mysql50-server/
to have MySQL server working with above mentioned configurations?
Why not just use MySQL that comes from ports?
If you really want to build from source, read:
http://dev.mysql.
" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, June 27, 2006 5:15 PM
Subject: Re: Please Help - Stored Procedure Issue
On Tuesday 27 June 2006 01:52 pm, Jesse wrote:
@cInvNo
replace all instances of this with just cInvNo. cInvNo is already
declared as
an OUT variable, and @cInvNo wi
On Tuesday 27 June 2006 01:52 pm, Jesse wrote:
> @cInvNo
replace all instances of this with just cInvNo. cInvNo is already declared as
an OUT variable, and @cInvNo will be set to that value when you run:
CALL sp_GetNextInv(-1,@cInvNo);
--
Chris White
PHP Programmer/DBBD
Interfuel
--
MySQL Gen
On 6/2/06, yuan edit <[EMAIL PROTECTED]> wrote:
my operating system is linux redhat 9.0.
i am installing mysql 5.0.x binary distribution.
Which edition is the most fit in the following editions?
You notices most of those files are .asc and .md5 used to verify the
integrity of the archive after
May 31, 2006 12:25:50 PM CDT
To: "Joseph Alotta" <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Subject: Re: please help optimize this query
I'd start by looking at your schema.. Quite a lot of use of
varchars... I'd suggest using chars (takes more space but processes
fas
I'd start by looking at your schema.. Quite a lot of use of
varchars... I'd suggest using chars (takes more space but processes
faster).. Or even better, normalize the data so that you have a table
for symbols that is linked to this table via an integer based foreign
key.
Also it seems wierd fo
Randy Paries wrote:
Hello,
Not sure what is going on
i have mysql Ver 12.22 Distrib 4.0.17,
I have a database that i can not delete.
i do this
#mysqladmin drop billmax -u admin --password
Enter password:
Dropping the database is potentially a very bad thing to do.
Any data stored in the databa
What makes you think the delete of the database failed? It looks like the
message from the DROP command indicates that the database was dropped
successfully.
--
Rhino
- Original Message -
From: "Randy Paries" <[EMAIL PROTECTED]>
To:
Sent: Saturday, April 22, 2006 9:22 AM
Subject: pl
Thanks for coming to the rescue, Mark and Bruce.
Mark Leith wrote:
This is actually for Linux/Unix, not Windows.
What error do you get from MySQL when trying to log in? Does the
mysqld(-nt) process show within Task Manager? What does the new error
log say?
You may need to reset permissions:
not sure, but it may be worth trying the following
run the script:
mysql_install_db --user=root
In the installation dir
this should change ownership and make mysql recognise the data dir.
good luck
Ade
Foo Ji-Haw wrote:
Hi all,
My Windows-based database server crashed (no fault of MySQL. pr
This is actually for Linux/Unix, not Windows.
What error do you get from MySQL when trying to log in? Does the
mysqld(-nt) process show within Task Manager? What does the new error
log say?
You may need to reset permissions:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Hi!!
$dbQuery = "select * from table where 1" ;
$result = mysql_query($dbQuery) or die("Error trying to execute the query:
".mysql_error());
If(mysql_num_rows($result)<1){ //also: "==0" works
echo "NULL";
-Original Message-
From: Kane Wilson [mailto:[EMAIL PROTECTED]
Sent: Wednes
Hello.
> $dbQuery = results;
Have you forgotten to put '$' before the 'results'? Do you
have display_errors = On in your php.ini?
Kane Wilson <[EMAIL PROTECTED]> wrote:
>
>
> hi ,
>
> I wanted to check the following condition and if it is
> success i wanted to display a massag
Kane Wilson wrote:
I wanted to check the following condition and if it is
success i wanted to display a massage.I tried as
follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die("Couldn't get
file list");
if (!isset($result))
{echo "NULL";}
John thegimper wrote:
This is what i need:
Posted by gogman on Monday May 5 2003, @10:42am on the mysql website:
MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext
search engines default to an 'AND'. These include: AltaVista, Fast Search,
G
efaults to AND instead of OR.
> > Almost every search engine i have tried, google etc. works like this.
> > "black horse cat dog" only show results with all words present.
> >
> > This is what i did, set global ft_boolean_syntax = ' +-><()~*:""&|'
&
7;
>
> I really appreciate your help!!
>
> >From: Sergei Golubchik <[EMAIL PROTECTED]>
> >To: Jessica Svensson <[EMAIL PROTECTED]>
> >CC: [EMAIL PROTECTED]
> >Subject: Re: Please help me: Boolean fulltext searches, AND instead of
> OR
> >Date: Wed,
Drew Reid wrote:
Hello I need to download a version of mySql v4, but I don't know which one
to download.
As the server is mySql compatible they must already be running mySql on the
system.
Uh-oh -- not the perennial faceless "they", again!?
Shouldn't you ask "them" what version is on the server
>
> This is what i did, set global ft_boolean_syntax = ' +-><()~*:""&|'
>
> I really appreciate your help!!
>
> >From: Sergei Golubchik <[EMAIL PROTECTED]>
> >To: Jessica Svensson <[EMAIL PROTECTED]>
> >CC: mysql@list
t dog" only show results with all words present.
This is what i did, set global ft_boolean_syntax = ' +-><()~*:""&|'
I really appreciate your help!!
From: Sergei Golubchik <[EMAIL PROTECTED]>
To: Jessica Svensson <[EMAIL PROTECTED]>
CC: mysql@lists.mys
Hi!
On Mar 23, Jessica Svensson wrote:
> Is there any way i can get results with AND instead of OR?
> Trying to search for "black cat" should only return records that contains
> both black and cat.
>
> I'm using the following code to get my result:
>
> SELECT * FROM `searchtbl` WHERE MATCH (tex
I couldn't find much on the variable you were trying to change.
Although it may have changed and now be called ft_boolean_syntax. But
that still won't help you since it doesn't appear to have an option to
change the default separator.
I think you will need to add the + to each word if you want t
> But when I execute a complex query, it hangs there forever. I don't have
> a chance to see the result because I need to go home to have dinner. The
> same query run in a FreeBSD system in Mysql5.01 just takes 2 seconds.
Please, execute this statements while the huge query is running,
and se
At 11:15 AM 10/1/2004, you wrote:
Content-Type: text/plain; charset="UTF-8"
Content-Language: en
Hi,
I am trying to install MySQL without any joy. I would appreciate if you
could help me please. Here I have listed the steps I took it to install.
1. I double click on âINSTALL-BINARYâ in âmysql
Brent Baisley wrote:
If you are using 4.1, you can look into the GROUP_CONCAT function.
Otherwise, try a self join like this:
SELECT A.LastName,A.OrderNum,B.OrderNum
FROM Orders AS A
LEFT JOIN Orders AS B ON A.LastName=B.LastName
WHERE A.OrderNum!=B.OrderNum
ORDER BY A.LastName
That joins the Order
If you are using 4.1, you can look into the GROUP_CONCAT function.
Otherwise, try a self join like this:
SELECT A.LastName,A.OrderNum,B.OrderNum
FROM Orders AS A
LEFT JOIN Orders AS B ON A.LastName=B.LastName
WHERE A.OrderNum!=B.OrderNum
ORDER BY A.LastName
That joins the Order table with itself on
Please post the structure of your orders table. (SHOW CREATE TABLE
orders). I need to know what you are using as a primary key in order to
help you to uniquely identify each duplicated row.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Paul Fine" <[EMAIL PROTECTED]> wro
on 05/19/2004 08:36 AM, Brent Baisley at [EMAIL PROTECTED] wrote:
> I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
> network, or RAM). Since you are using "professional" software, I
> wouldn't try to change the queries. Have you made changes to your
> my.cnf file? Since you
On Wed, May 19, 2004 at 11:36:38AM -0400, Brent Baisley wrote:
> I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
> network, or RAM). Since you are using "professional" software, I
> wouldn't try to change the queries. Have you made changes to your
> my.cnf file? Since you h
I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
network, or RAM). Since you are using "professional" software, I
wouldn't try to change the queries. Have you made changes to your
my.cnf file? Since you have enough ram to hold all the data, ram is
probably not your bottlene
On Wed, May 19, 2004 at 08:47:28AM -0400, Brent Baisley wrote:
> Something that small shouldn't really need optimizing. What is the size
> of your data (mb?, gb?) and what does your query look like? If you are
> doing a wild card search on a large text field without a full text
> index, then tho
Something that small shouldn't really need optimizing. What is the size
of your data (mb?, gb?) and what does your query look like? If you are
doing a wild card search on a large text field without a full text
index, then those times may be the best you're going to get. Many times
it's about op
sorry Egor Egorov, Mutt sent the mail to your private inbox ;)
resending to the mailing list.
On Wed, May 19, 2004 at 02:02:29PM +0300, Egor Egorov wrote:
> Mohammed Sameer <[EMAIL PROTECTED]> wrote:
> > I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
> > MySQL 4.0.18 compiled from s
Mohammed Sameer <[EMAIL PROTECTED]> wrote:
> I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
> MySQL 4.0.18 compiled from source.
>
> We have 2 webservers running apache, And this is the backend database server.
> The server is really slow.
> a select on a table with 138,247 rows take
Ginger Cheng <[EMAIL PROTECTED]> wrote:
> Here is the error msg:
>
>
> 040408 08:47:14 mysqld started
> Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
> If you do not want to use transactional InnoDB tables, add a line
> skip-innodb
> to the [mysqld] section of init parameters i
I got it fixed with the msg from --err-log. THank you so much for all your
help. I couldn't have made it without your hints.
ALl the best
ginger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Here is the error msg:
040408 08:47:14 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables
I don't have such files. Unfortunately. Am I hopeless?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What information is being logged in *.err?
-Original Message-
From: Ginger Cheng
To: [EMAIL PROTECTED]
Sent: 4/8/04 10:20 AM
Subject: Please HELP !!! Can not restart server
Hi, MySQL Gurus,
Version of mysql is Distrib 3.23.54, for redhat-linux-gnu
(i386). I
started mysql server w
Please look in your data directory and post the contents of the .ERR file that you find there. That will give folks the information
they need to help solve your problem.
-Original Message-
From: Ginger Cheng [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 10:21 AM
To: [EMAIL PRO
"Hiep Ho" <[EMAIL PROTECTED]> wrote:
> i have problem adding user to mysql. I can create a database and there is no
> problem however I got this ERROR 1047: Unknown command when I tried to add
> new user. I don't think I have this problem before.
>
> I run this command
>
>
> GRANT ALL ON *.* TO
Erica L Ridley <[EMAIL PROTECTED]> wrote:
> I need help with rewriting a sql query. Nested queries that work in MS
> databases apparently do not work in MySQL databases. Here is what I need
> in MS query pseudo code:
>
> SELECT table1.myfield1, table2.myfield2
> FROM table1, table2
> WHERE ta
"Aaron P. Martinez" <[EMAIL PROTECTED]> wrote:
> I am trying to set up a table from a script that came with some software
> "Value accounting/CRM" and i'm getting a few errors, one of which i
> can't seem to figure out/fix.
>
> My system is RH 3.0 ES with mysql-server-3.23.58-1. I have innodb
>
Matthew Stuart wrote:
mysqldump is run at the system command-line, not within the mysql
client environment.
This is most likely to be my problem then. I assumed that what is called
the system command line to be the mysql client environment. The tutorial
book that I have been going through ins
On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart
<[EMAIL PROTECTED]> wrote:
Similarly.
SELECT intDEVID,txtDEVPOSTCODE INTO OUTFILE "c:/aaa/dump.sql" from
ytbl_development;
(dump.sql file must NOT already exist)
zzapper (vim & cygwin & zsh)
--
vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-
mysqldump is run at the system command-line, not within the mysql
client environment.
This is most likely to be my problem then. I assumed that what is
called the system command line to be the mysql client environment. The
tutorial book that I have been going through instructs me to issue this
Matthew Stuart wrote:
I am really struggling with a mysqldump. I am trying to create a dump of
a complete database called csi_db01 and I am trying to save the dump
file to My Documents on the C drive.
I am sure I am doing right, but could somebody email me the full syntax
to use which comes af
On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart
<[EMAIL PROTECTED]> wrote:
>I am really struggling with a mysqldump. I am trying to create a dump
>of a complete database called csi_db01 and I am trying to save the dump
>file to My Documents on the C drive.
>
>I am sure I am doing right, but c
>I am really struggling with a mysqldump. I am trying to create a dump
>of a complete database called csi_db01 and I am trying to save the dump
>file to My Documents on the C drive.
>I am sure I am doing right, but could somebody email me the full syntax
>to use which comes after the mysql>
At 9:10 +0700 11/17/03, Thai Thanh Ha wrote:
Hi all,
I have a problem with my query on mySQL 4.0.
DB Error: unknown error
I don't know what is the problem. Please help me!!! Thanks in advance.
Joins can join up to 31 tables in MySQL.
Looks like you're exceeding that limit.
Regards,
Thai
SELECT t.
Typically, this is the kind of query I see at MS-SQL houses. :)
-- R. Deuce
- Original Message -
From: "Matt W" <[EMAIL PROTECTED]>
To: "Thai Thanh Ha" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, November 18, 2003 5:28 PM
Subject: R
Hi Thai,
I think you're just joining wy too many tables! LOL
Matt
- Original Message -
From: "Thai Thanh Ha"
Sent: Sunday, November 16, 2003 8:10 PM
Subject: Please help DB Error: unknown error
> Hi all,
> I have a problem with my query on mySQL 4.0.
> DB Error: unknown error
> I
ut I don't know how to resolve
this problem.
Regards,
Thai
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 8:02 PM
To: 'Thai Thanh Ha'; '[EMAIL PROTECTED]'
Subject: RE: Please help DB Error: unknown er
Can you please post the error?
-Original Message-
From: Thai Thanh Ha [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 8:10 PM
To: '[EMAIL PROTECTED]'
Subject: Please help DB Error: unknown error
Hi all,
I have a problem with my query on mySQL 4.0.
DB Error: unknown error
I do
do a show status like 'open_files'
and a show variables like 'open_files_limit'
-Original Message-
From: William Bailey [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 6:56 AM
To: [EMAIL PROTECTED]
Subject: Please help. MySQL Error.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA
> Now, how can I save only these 1000++ data into a file in my pc?
Normaly you should get the data into a file with that
something you sent the query to mysql with. What is that
something in your case?
Regards,
TomH
--
PROSOFT EDV-Lösungen GmbH & Co. KG
Geschäftsführer: Axel-Wilhelm Wegmann
AG
me/data.txt"
Nitin
- Original Message -
From: "Pey Ling" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 28, 2003 3:31 PM
Subject: Re: please help out
> Hi, how to write this :"full path an
Hi, how to write this :"full path and file name"? can i copy it to my local
pc rather than the server?
best regards,
Pey Ling
From: "Nitin" <[EMAIL PROTECTED]>
To: "Pey Ling" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 28, 20
Easy, use:'select * INTO OUTFILE "full path and file name"
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n" from user where race='chinese' and
state='US'Nitin- Original Message -
From: "Pey Ling" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October
I'd cross post to the mysql-java/jdbc mailing list... Most likely you
need to modify mysql config to allow larger packet sizes.. search the
list archive/website for max_allowed_packet info..
On Fri, 8 Aug 2003, Ma Mei wrote:
> Dear administrator,
> Now I have a quesion and want to get your help
Iulian,
this is in the manual. Look at
Database Administration
Localisation
Character arrays
Regards,
Thomas Spahni
On Wed, 30 Jul 2003, Primaria Falticeni wrote:
> I can copy the latin2.conf into new one, but I need to know what each code
> from the conf file represents and
I can copy the
latin2.conf into new one, but I need to know what each codefrom the conf
file represents and how can I obtain the relation from thesecodes and the
chars.So that's two problems:1) Can I use asc function or what function I
need to know to obtain thecodes from the chars?2) How is
Hi!
On Jul 28, Primaria Falticeni wrote:
> Hello,
>
> Simply I made a table with romanian characters "aAsStT". I tried to
> sort it, in fact to order it in a query.
>
> How can I do this? Please give me an example at how can I change the
> latin2.conf in a romanian one to fairly sort the
As this is really a PHP specific question, you may get a better response on the PHP
general mailing list at http://www.php.net/mailing-lists.php
Anyway, if my limited experience in PHP serves correctly, you may need to call
echo(mysql_error()); near the potentially troublesome code.
Regards,
Try using 'max_allowed_packet=16M' instead of your current value. You may also
find help by reviewing the below.
http://www.mysql.com/doc/en/Packet_too_large.html
Is there a reason you are including the BLOBs in the database instead of just
linking via it? I know it's generally considered better
:[EMAIL PROTECTED]
Sent: 03 April 2003 15:00
To: TRANTER,STEWART (HP-Germany,ex1)
Cc: '[EMAIL PROTECTED]'
Subject: Re: Please HELP!!! Re: Database Core Dumps
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
TRANTER,STEWART (HP-Germany,ex1) wrote:
| Hello Everyone,
|
| Yesterday I posted t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
TRANTER,STEWART (HP-Germany,ex1) wrote:
| Hello Everyone,
|
| Yesterday I posted the message listed below. I have some more
information.
| We have found the command that "pushes our database over the edge"!
It is:
|
| SHOW VARIABLES;
|
| All other db c
Stewart,
> Yesterday I posted the message listed below. I have some more information.
> We have found the command that "pushes our database over the edge"! It is:
> SHOW VARIABLES;
> All other db commands work (such as SHOW VARIABLES "%a";) except for:
> SHOW VARIABLES "%"
This should be "SH
On Friday 28 March 2003 13:59, Ing.Peter Misovic wrote:
> i have deleted mysql database,
> can i restore it with start defaults ?
mysql_install_db is your solution. :)
> Thailon, Slovakia
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored b
Natale,
please address these general questions to [EMAIL PROTECTED]
InnoDB requires that the indexes are created explicitly. It would require a
change to MySQL to automate the creation of them.
Without indexes foreign key checks would be very slow because then every
check would have to do a tabl
nect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
To: "Stefan Hinz" <[EMAIL PROTECTED]>; "MySQL Main List"
&
Hi,
Perror 13 means :
perror 13
Error code 13: Permission denied
So it seems you don't have the permission to create the temporary table is
this directory.
Regards,
Jocelyn
- Original Message -
From: "Stefan Hinz" <[EMAIL PROTECTED]>
To: "MySQL Main List" <[EMAIL PROTECTED]>
Sent: M
Hi there!
After include /usr/local/bin on the library path as was suggested
by ED appears to work because isn't complaining about any more but
It broke again on something different.
Please any Idea?
Thanks
Jose Albert
Here the output
\...
I'm still trying to build mysql-3.23.51
/local/mysq
Ed thanks for your replay
But the libraries are there on the path
PATH="/usr/local/lib:/usr/lib:/usr/local/:/usr/local/bin:/usr/bin:/u
sr/ccs/bin/:/usr/ucb:/etc:."
bash-2.05$ ls /usr/local/lib/libstdc++.so.5
/usr/local/lib/libstdc++.so.5
- Jose
>> g++ -O3 -DDBUG_OFF -fno-implicit-templates -
On Tue, 1 Oct 2002, DeNewbie wrote:
>
> I am a newbie and I am having a chronic problem getting mysql started up and
>running. I got so frustrated that I uninstalled the mysql rpms and started over again
>but its hasn't helped my situation. My whole problem revolves around mysql_install_db
>se
On Tuesday, Oct 1, 2002, at 16:39 America/Phoenix, DeNewbie wrote:
>
> I am a newbie and I am having a chronic problem getting mysql started
> up and running. I got so frustrated that I uninstalled the mysql rpms
> and started over again but its hasn't helped my situation. My whole
> problem
Hi there
Try This:
SELECT products.product_name, products.fg_number, images.image_name,
images.thumbnail, images.image_path, images.color_depth,
images.width_inches, images.height_inches, images.resolution,
images.filesize, images.filetype, images.notes
FROM products LEFT JOIN images ON produc
Files never get smaller. They can only grow.
Deleteing a record marks the area used as available, but does not remove it
from the file.
I believe you will have to optimize the table to pack out the unused
records.
This is another good argument for storing images in the filesystem, and
only thei
Either I'm misunderstanding what you're trying to do or that Oracle query is
a really complicated way of doing something simple.
create table Customer ( name text, id int auto_increment primary key );
create table Skill ( description text, id int auto_increment primary key );
create table Custome
At 23:49 29/5/2002 -0400, Charles Brown wrote:
Hi,
>I removed the "user=" and "password=" entries from the my.ini
>file, because I didn't like seeing a password exposed in plain text.
>This seemed to have no effect on MySQL at all. What are those
>entries for? Do I need them? What should they b
Mohamadally,
Monday, May 20, 2002, 4:53:05 AM, you wrote:
M> I believe this question is very simple and hope u ppl can
M> help me out. Well i'm trying to develop a site using
M> chinese characters where my users
M> can login. I'm suppose to store their username which will
M> be in chinese charact
Get rid of percentage signs in your keyword...
See: http://www.mysql.com/doc/F/u/Fulltext_Search.html
Gurhan
-Original Message-
From: Shehryar Shafiq [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 12:46 PM
To: [EMAIL PROTECTED]
Subject: please help: search database - code attach
Whats your INSERT statement look like? And does it give any errors back?
-Nick
> I am
using MySql with Visual Basic.
>
> I Got an ERROR when trying to add a new record in
situation as under.
>
> I have a table Company
> and a field in that table EmpName char
(20)
> and one record is there valu
well i can do the select that way, but i was wondering how the following
delete command would only pick up the rows in the select. isn't there a way
of imbedding delete in the select statement?
can anyone else help as well please?
thanks
sunny
At 19:46 14/03/02 -0500, Jim Philips wrote:
>To
To select the rows you are looking for, you can use:
select * from messages
left join topics on topics.topic_id=messages.topic_id
where topics.topic_id is null;
This works fine for selecting. But for some reason the corresponding SQL
for a delete fails:
mysql> delete from messages
-> left j
John Dean <[EMAIL PROTECTED]> writes:
> Hi
> All you need to do is include a symlink on libmysqlclient.so.11 to
> point to libmysqlclient.so.10
>
> e.g ln libmysqlclient.so.11 libmysqlclient.so.10
Not a good suggestion for libraries in general. If a library so name
has changed, it means it not
At 13:26 01/03/2002 -0700, Van wrote:
>Ronald Arenas wrote:
> >
> > I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on
> > my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql
> > 3.23.49) I get a "Php-mysql.4.xx requires libmysqlclient.so.10". My
> atte
Hi
All you need to do is include a symlink on libmysqlclient.so.11 to point to
libmysqlclient.so.10
e.g ln libmysqlclient.so.11 libmysqlclient.so.10
At 15:18 01/03/2002 -0500, Ronald Arenas wrote:
>I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on
>my RH 7.2 box. Now
PHP is looking for the client library that gets installed with MySQL
3.23.4+. Now, you can try a QUICK fix that might not work, but it's worth a
shot. Go to the directory that has the libmysqlclient.so.11 file and type
the following:
ln -s libmysqlclient.so.11 libmysqlclient.so.10
That should cr
Hi,
Try to upgrade PHP to the latest version (4.1.2) , it should run fine.
Regards,
Jocelyn Fournier
- Original Message -
From: "Ronald Arenas" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 9:18 PM
Subject: Please Help! MySql 4.01/PhP 4.06 looking for
1 - 100 of 153 matches
Mail list logo
