I have mysql on a Linux machine and can connect to through 'localhost' and
its real IP/hostname. I cannot connect to it from other machines. Is there
anything I need to do to make this happen?
Michael Piko
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi everyone!
My silly questions for today concern the not-silly-at-all InnoDB table
backend.
1. If I do an ALTER TABLE tbl_name TYPE=InnoDB on an InnoDB table,
Heikki has
indicated that a defrag of that table should happen. Does anyone have
any comments regarding the
result of a power
I should have mentioned the error:
[kryten2] ERROR 2013: Lost connection to MySQL server during query
- Original Message -
From: Michael Piko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 29, 2003 9:01 AM
Subject: Querying a Linux machine
I have mysql on a Linux machine
Grant,
From my old relational database days we'd create a table of courses and
index this so it could be linked from your semester table. This way, you'd
have a single entry for each course. Should the course change, the
maintenance nightmare is alleviated by only having to change the course
When I execute the following query I get duplicate product_id's as shown
below:
SELECT * FROM product, product_category_xref, category WHERE
product_parent_id=''
AND product.product_id=product_category_xref.product_id
AND category.category_id=product_category_xref.category_id
AND
All,
After installing MYSQL, APACHE, PHP.. My first goal was to get PHP working with MYSQL.
That is pretty easy (Just requires editing the php.ini file) and now you have the Web
Based
PHP communicating with your MYSQL database. So at least you know something is working
and in fact, I got the
I use a CPanel Shared hosting environment where MySQL user is not permitted
with FILE privilege. Please help me by telling what is the alternate
process to LOAD DATA from a text data file to MySQL table.
Thanks in advance
--
MySQL General Mailing List
For list archives:
Hi,
I'm very new to MySQL. I normally use MS Access but my project needs
MySQL. I'm able to set a field(categoryID) in table A(product) a lookup
field to another table(category) in Access but I can't find anywhere that
teaches me how to do that in MySQL.
I'm managing MySQL through a web
Hi,
I have downloaded the folder which contains MySQL 4.1 alpha. For the notes in the
documentation, i still can not understand how to upgrade to version4.1. I am just
start to use MySQL and straigh forward want to upgrade to 4.1 but there is not setup
file there. How to do? Thanks.
On Fri, 29 Aug 2003 09:15:48 +1000
Michael Piko [EMAIL PROTECTED] wrote:
I should have mentioned the error:
[kryten2] ERROR 2013: Lost connection to MySQL server during query
check your MySQLd log to see what happends.
usually you can find it in /var/log/
---
WBR,
Antony Dovgal aka tony2001
On Fri, 29 Aug 2003 01:02:57 -0400 (EDT)
Jordan Morgan [EMAIL PROTECTED] wrote:
Hi,
I'm very new to MySQL. I normally use MS Access but my project needs
MySQL. I'm able to set a field(categoryID) in table A(product) a lookup
field to another table(category) in Access but I can't find
Here it is:
/var/log/mysqld.log
Number of processes running now: 1
mysqld process hanging, pid 17153 - killed
030829 09:28:31 mysqld restarted
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
gerald_clark wrote:
Andreï V. FOMITCHEV wrote:
Hello everyone,
I use Valgrind to check my programs and this last found leaks in
libmysqlclient.so.
My code is simple:
char * requete = SELECT * FROM NOM_TABLE_1;
Looks like a misplaced '' .
lol
#define NOM_TABLE_1 files
The problem is a
Hello
If You need some elp You have to give us more details:
What version You use?
Does exist one fulltext index on title + keywords?
The schema and indexes.
The result of:
explain select count(*) from resources where match title,keywords
against('common word');
I think index file size is
Good morning.
In a normal case, to install Mysql in windows we need to run setup.exe and
it's launch a wizard when we define some things like a destination
directory.
I want to know (if somebody can help me) if it is possible to install mysql
and the wizard not be launched.
How to do it??
Hello.
I have to do an script to create MySQL users, the name
of the new user have to be a parameter of the script.
I have no idea, someone can helps me.
I'm an NT user.
Thanks:
Enrique Andreu
___
Yahoo! Messenger - Nueva versión GRATIS
Super
florence florence [EMAIL PROTECTED] wrote:
I have downloaded the folder which contains MySQL 4.1 alpha. For the notes in
the documentation, i still can not understand how to upgrade to version4.1. I am
just start to use MySQL and straigh forward want to upgrade to 4.1 but there is not
Michael Piko [EMAIL PROTECTED] wrote:
I have mysql on a Linux machine and can connect to through 'localhost' and
its real IP/hostname. I cannot connect to it from other machines. Is there
anything I need to do to make this happen?
Please, provide some more info
1. Version of MySQL
2. Do you
Its a standard RedHat 8.0 install. MySQL version is 3.23.52-3 installed from
the standard RPMs
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 29, 2003 7:56 PM
Subject: Re: Querying a Linux machine
Michael Piko [EMAIL
When I execute the following query I get duplicate
product_id's as shown
below:
SELECT * FROM product, product_category_xref, category WHERE
product_parent_id=''
AND product.product_id=product_category_xref.product_id
AND category.category_id=product_category_xref.category_id
AND
Hello,
I have found a very interesting UDF function called MyPHP. There is no
problems with UDF installation on Linux based machine but my latop and
all developing tools are working on windows and I don't know how to
install UDF on windows. Can anyone help me with this ??
ML
--
MySQL
If it's going to be a simple batch file then use %1, %2, ... inside the
script to get the parameters passed to it.
Or better install use a real scripting language like perl. ;-)
Lian Sebe, M.Sc.
Freelance Analyst-Programmer
www.programEz.net
-Original Message-
From: Enrique Andreu
Hi all.
It's about time I tried out MySQL-5.0. I want to get comfortable with
the stored procedures so I'm ready to go when it's released.
I'm running Gentoo ( current, of course ).
I ran:
export WANT_AUTOMAKE=1.5
export WANT_AUTOCONF_2_5=1
These are ( I think ) Gentoo-specific commands that
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I use a CPanel Shared hosting environment where MySQL user is not permitted
with FILE privilege. Please help me by telling what is the alternate
process to LOAD DATA from a text data file to MySQL table.
You can use LOAD DATA LOCAL. In this case
Hello, I think I have explained bad. I want to pass
the arguments to the sql script.
The argument is for the sql script.
For example:
myscript.sql should be:
GRANT ALL PRIVILEGES ON *.* TO 1@'%'
where 1 would be parameter 1
I want to do something like that:
dosmysql mysql -u root -p
Is it giving you access denied, or is it failing to find the host machine?
if it's access denied you will need to add the username and hostname (of
whichever machine you are connecting from) and grant that user access.
use the 'mysql_setpermission' script to do this.
If you can't actually see the
* Enrique Andreu
Hello, I think I have explained bad. I want to pass
the arguments to the sql script.
The argument is for the sql script.
For example:
myscript.sql should be:
GRANT ALL PRIVILEGES ON *.* TO 1@'%'
where 1 would be parameter 1
I want to do something like that:
dosmysql
Hi Team,
I couldn't start the mysql in the red hat 8, due the bad
configuration in my.cnf and non availability of data file for
the database. I want to reinstall the mysql, kindly let me know how to.
I have also tried rmp -e File.rpm' and removed the files from
/var/lib/mysql. Reinstalled
This is perfectly legal and right. A null should not be used for a
value, and null should be used where a value will be put but has not
been yet, so if I plan on putting 3 entries in where they are all the
same but that in future will be different this is correct. Anyways two
NULLS should not
Hello,
we're trying to do a BOOLEAN full text search over a table with about
200.000 entrys and 650MB of data (full text index is about half the size
of the data, the average row length is about 3,2kB) on the System stated
below. A sample statement we're trying to run is:
SELECT
id, title
Hello,
Is it possible to store Java objects in the mysql database?
Kind regards,
Dennis
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
--
MySQL General
Suresh Babu A. [IT Engineer] [EMAIL PROTECTED] wrote:
I couldn't start the mysql in the red hat 8, due the bad
configuration in my.cnf and non availability of data file for
the database. I want to reinstall the mysql, kindly let me know how to.
You can just edit my.cnf file.
I have also
Michael Piko [EMAIL PROTECTED] wrote:
Its a standard RedHat 8.0 install. MySQL version is 3.23.52-3 installed from
the standard RPMs
Run mysqld with --thread-stack=192K option:
http://www.mysql.com/doc/en/Linux-x86.html
- Original Message -
From: Victoria Reznichenko [EMAIL
Hi all,
I was wodnering if someone has a better way of re-sync'ing a slave when
replication fails.
Here's my setup:
1 - MASTER
5 - SLAVES
Now sometimes, one of the slaves will fail. Usually when it's the sql that stops
running, I can fix it and get it back. However sometimes, I also get the
Hi,
I am not sure how to upgrade to MySQL4.1-alpha (window) from MySQL4.0, so i
just copy the file in the folder which i downloaded from web and then paste in the
mysql folder in C:\mysql . But later i found out that the winmysqladmin in the bin
folder can not be opened( i double click
At 05:17 PM 8/28/2003, you wrote:
Hi,
no - adding a limit doesn't really help.
thanks,
- Mark
Mark et al,
Has anyone tried MNOGoSearch (http://search.mnogo.ru/) as a full
text replacement for MySQL? Although it 's primary focus is to index web
pages, it can also be used directly on
Hello,
I have set up a master/slave replication environment using
4.0.13 but would like to know if there is a way to set up
master/master replication between two databases, both able
to be inserted/updated/deleted, tables created, etc., with
the changes on both databases propagated to each other.
Hi,
How do you copy a table in mySQL.
I know I can do it in phpMyAdmin but I want the actual syntax.
Thanks!!
Tim Winters
Creative Development Manager
Sampling Technologies Incorporated
1600 Bedford Highway, Suite 212
Bedford, Nova Scotia
B4A 1E8
www.samplingtechnologies.com
[EMAIL
Keith Bussey wrote:
Hi all,
I was wodnering if someone has a better way of re-sync'ing a slave when
replication fails.
Here's my setup:
1 - MASTER
5 - SLAVES
Now sometimes, one of the slaves will fail. Usually when it's the sql that stops
running, I can fix it and get it back. However sometimes,
I wonder if you could serialize your object, and then store it in a blob
column.
I'd be interested to know ...
Dennis Knol wrote:
Hello,
Is it possible to store Java objects in the mysql database?
Kind regards,
Dennis
Get
I need to access a database thru internet. It is secure to do this using MySql?
Thanks
Flavio Tobias
Sure. If you use a secured connection.
A$
-Original Message-
From: Flavio Tobias [mailto:[EMAIL PROTECTED]
Sent: Friday, August 29, 2003 1:11 PM
To: [EMAIL PROTECTED]
Subject: It is secure to access MySQL thru internet?
I need to access a database thru internet. It is secure to do this
Hi all,
Now that technologies such as Reiser4 are emerging that offer atomic
filesystem operations, is it expected that MySQL
will take advantage of them?
I guess I'm asking a massive number of questions with the above
simplistic statement. Admittedly, this is currently a
Linux-centric thing
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Spam Bait wrote:
Hi all.
It's about time I tried out MySQL-5.0. I want to get comfortable with
the stored procedures so I'm ready to go when it's released.
I'm running Gentoo ( current, of course ).
I ran:
export WANT_AUTOMAKE=1.5
export
Dear MySQL gurus,
I am trying to update on a Perl program that connectes to Oracle through DBI.
I want to develop to a local MySQL database because I don't have access Pro*C to build
DBI::Oracle on my Sun box.
The problem is that my update statement is giving errors. The query as written
Greg,
Since you're executing this from a perl script. Try saving the result of
SELECT MAX(cycle) FROM test.results WHERE snum = '$snum'; to a variable.
Then use that variable in your embedded SQL statement. This alleviates that
issue all together. If you're updating multiple rows, you're query
I have the mysql dump for only 1 table from a database and i want to populate only
that table back into the database.
how do i do that ?
-
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
I'm trying to get a query to work by listing all the people in a row with
the same last name and first name.
key, fname, lname
1 ,John, Smith
4, John, Smith
5, Cody,Edwards
2, Cody, Edwards
Don't list anyone that has a unique first name last name. Is this possible?
Trying to use the Count
sorry got it
Sanya Shaik [EMAIL PROTECTED] wrote:I have the mysql dump for only 1 table from a
database and i want to populate only that table back into the database.
how do i do that ?
-
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
I am having problems to start MySQL replication. I followed all the
steps outlined on the website, but replicaiton is not working. slave
status shows the following:
mysql show slave status\G
*** 1. row ***
Master_Host: mail.dbi.tju.edu
Grant,
Sure, anything's possible. Assuming you're table looks something like this:
CREATE TABLE people (
id INT NOT NULL,
fname VARCHAR(15) NULL,
lname VARCHAR(20) NULL
) Type=InnoDB;
With data something like this:
INSERT INTO people (id, fname, lname) VALUES (1, 'John', 'Smith');
INSERT
What do you mean with secure connection, ssh?
How to configure this on MySql?
- Original Message -
From: Fortuno, Adam [EMAIL PROTECTED]
To: 'Flavio Tobias' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, August 29, 2003 2:17 PM
Subject: RE: It is secure to access MySQL thru internet?
Hi
I have a little problem with my sql skills.
I have a table with the following fields:
id (int) | value (varchar) | date (date)
I need to show for a given id the value of the oldest date.
Normally, I'd do something like this:
select value from tableName where date in (select max(date)
Flavio,
Sure. If you wanted to MySQL into a DB over the internet. I'd think ssh'ing
would do the trick. This actually has nothing to do with MySQL, but allot to
do with your OS. If you're running OS X, Linux, or some forms of Unix. SSH
is probably a default package. Follow-up with the
select value from tableName where date in (select max(date) from
tableName where id = 4);
But, it doesn't work with mysql 4.0.
Any ideas? Does anybody had this problem before?
What about:
SELECT value, date
FROM tablename
WHERE id = 4
ORDER BY date ASC
Just pick the first row.
--
I think your thinking of SSL.
There is some work for mySQL that allows a sol connection and even some
work to sol the replication over the net.
Look for SSL on mysql.com
---Original Message-
--From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
--Sent: Friday, August 29, 2003 12:59 PM
--To:
Actually, Secure Shell is built on Secure Socket Layer.
You generally speak of SSL with HTTPS connections.
You can open an SSH session with a remote Unix box (or anything with an sshd running)
then MySQL through that and it's encrypted. You can also create tunnels with SSH, but
I've never
As stated before, it is possible via ssh.
This assumes 2 things:
1: Your client machine is windows
2: Your server is running a ssh server. (Which USUALLY means it's a flavor
of Unix but there are ssh servers for windows...why, I don't know but
there are.)
First, grab putty. Putty is a ssh client
Can we 'unanalyze' a table? I'd like to remove the statistical
information from my analyzed table, for testing purposes.
Thanks
Kevin
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 29 Aug 2003 15:59:18 -0400, Fortuno, Adam wrote:
I need to access a database thru internet. It is secure to do this using
MySql?
If the database traffic is encrypted, yes. I do not know if that is an option in
Mysql.
If you did not do
I'd be willing to bet if you implement serializable, serialize it and dump
it to a binary column (blob) .. you should be able to restore...
On Fri, 29 Aug 2003, Dennis Knol wrote:
Hello,
Is it possible to store Java objects in the mysql database?
Kind regards,
Dennis
We use a point to point VPN between server sites for this... so the
security/encryption is totally transparent to mysql, it's just connecting
to an IP address on tcp/3306 and the vpn appliances down the line deal
with all the data security...
There are cheaper solutions such as using freeswan,
Hi,
It looks like your slave can't connect to the master you've defined.
Here are the steps you need to follow :
1- On shell type
mysql -h mail.dbi.tju.edu -urepl -pPASSWORD
You need to replace word PASSWORD with your actual password. This will
show you if you can connect to master from
That seems like a lot of work to do when mysql has it built in.
http://www.mysql.com/doc/en/Secure_basics.html
4.3.9.1 Basics
Beginning with version 4.0.0, MySQL has support for SSL encrypted
connections. To understand how MySQL uses SSL, it's necessary to explain
some basic SSL and X509
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
I'd be willing to bet if you implement serializable, serialize it and dump
it to a binary column (blob) .. you should be able to restore...
If you use PreparedStatements, Connector/J will do it 'automagically'
for you as
Fortuno, Adam wrote:
I would suggest a SQL statement like this to get the results you're looking
for.
SELECT COUNT(a.id), a.lname, a.fname
FROM people AS a
GROUP BY a.lname, a.fname
HAVING COUNT(a.id) 1;
That's a great way of doing it if Grant doesn't need the IDs, which he
*did* have listed in
Flavio Tobias wrote:
I need to access a database thru internet. It is secure to do this
using MySql?
Sure. If you use a secured connection.
What do you mean with secure connection, ssh?
How to configure this on MySql?
I'ld think about SSL
http://www.mysql.com/doc/en/Secure_basics.html
I'm new to MySQL and have tried many attempts myself and looked all over for
this answer to no avail. How do I write MySQL joins to accomodate the
Oracle equivalent listed belowany help would be appreciated.
From
iteration,
story,
person tracker,
person customer,
person
I have a test results table that looks like this
student_id test_id score
1 1 90
1 1 100
1 1 80
2 1 95
2 1 85
2 1
Luis Lebron wrote:
I have a test results table that looks like this
student_id test_id score
1 1 90
1 1 100
1 1 80
2 1 95
2 1 85
2
Mark Matthews wrote:
[snip]
On the same page, there's a note about requiring Bison-1.75 or newer to
compile MySQL-4.1 (the same holds true for 5.0 as well). You can check
what version you have by issuing 'bison --version' in your shell.
Regards,
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software
* [EMAIL PROTECTED]
I'm new to MySQL and have tried many attempts myself and looked
all over for
this answer to no avail. How do I write MySQL joins to accomodate the
Oracle equivalent listed belowany help would be appreciated.
From
iteration,
story,
person tracker,
72 matches
Mail list logo
