RE: Need help on mysql/php
split code for use username and password to connect to MySQL into other file and use include in every php program instead have username and password code. connect.inc.php ? // define database connect variable $hostname = localhost; $username = root; $password = password; $tblname = yourtablename; $dbName = yourdbname; MYSQL_CONNECT($hostname, $username, $password) OR DIE(Unable to connect to database); @mysql_select_db($dbName) or die(Unable to select database); print Succesful connect...; ? readfile.php ? include (connect.inc.php); ... other php code ... ? Regards, Sommai Fongnamthip At 22:37 5/6/2001 +0100, Jorge Oliveira wrote: Hi again, You are right, your username and password will have to be on every PHP script that needs to use database. However, you don't have to be afraid because nobody can access the source of your PHP scripts - unless they are a good hacker! I think you should pay a visit to http://www.php.net to understand how PHP works. Start with the basics and you will see that is reallY VERY simple. Be cool, Jorge Oliveira [EMAIL PROTECTED] © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com -Mensagem original- De: Ed Peddycoart [mailto:[EMAIL PROTECTED]] Enviada: Quarta-feira, 6 de Junho de 2001 0:29 Para: Jorge Oliveira; Mysql@Lists. Mysql. Com Assunto: RE: Need help on mysql/php Thanks...this helped...Just had success in connecting to the MySQL server and dumping the db contents to the screenOne worrisome bit though...My username and password for connecting to the db on my host is my username and password for the web account. If I want to create dynamic webpages by pulling data from my db, won't I have to put this information (usersname and pw) in the php file and leave it on the server? Sounds pretty darn scary to me...maybe I am confused. Ed -Original Message- From: Jorge Oliveira [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 12:47 PM To: Mysql@Lists. Mysql. Com Subject: RE: Need help on mysql/php Hi, Please refer to http://www.php.net/manual/en/ref.mysql.php Jorge Oliveira [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com -Mensagem original- De: Ed Peddycoart [mailto:[EMAIL PROTECTED]] Enviada: Terça-feira, 5 de Junho de 2001 21:31 Para: [EMAIL PROTECTED] Assunto: Need help on mysql/php I recently move my website to FastWebServers.com. MySQL and PHP is provided. I have a control panel which allows me to initialize MySQL for my use. The initialization creates a db, named celticblues_com (my domain is celticblues.com). So far, I have added a table to my database, and added the neccessary fields. Now I am at a total loss at what to do. I want to use PHP scripts to pull info from the db and search the db etc. I have contacted my support from FWS, but they point me to MySQL.com for Mysql commands technical support. Seems to me I would need to know how to set username/password to access the db from script etc. The bottom line question is can someone point me to information on what I need to do to be able to access(open/close) the db, retrieve/store information, etc. in this type of environment (i.e. MySQL provide by my host service, not installed by me)? Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: which the best
You're right.. wrong place to ask. I don't want to start a kind of religious war.. but I wouldn't go for M$ products. Further good reading on this is presented in this lists archive. Bye, B. I know this is not list for ask about OS, but I wonder to know that which OS you choose for database server in your mind? Linux Red Hat 7.1 Linux Mandrake 8.0 Windows NT 4.0 Windows 2000 Server or anything else from these OS! Regard, Sommai Fongnamthip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL with perl
I've written a couple of scripts and have a thing that I haven't quite figured out. If anyone can shed light on this, I'd appreciate it. When a person submits a form that inserts a record into the database, if they then refresh the page that comes up after the submit, the record will be submitted a second time. I suppose this is due to the fact that the subroutine that is called with the submit contains both the write to database bit and the view bit. So refreshing causes a repeat of both items. How can I do this without that problem? Thanks in advance, Dawn H It's practically impossible to look at a penguin and feel angry. --Joe Moore http://www.rdcss.com/ - RD Computer Solutions http://wow.cooncheese.com/ - WOW.CoonCheese.com http://dpenguin.rdcss.com/ - Cornucopia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Building/installing MySQL under Mac OS X 10.03
Hi Everbody, Forgive if there is a fact somewhere for this. I have benn trying to install mysql 3.23.38 under Mac OS X 10.03 to no avail. The binary distrubution says I need pthreads ! the manual says I do not !?! The only binary arround is for the Mac OS Server (though it should matter much ). My Problems re either: Where can I get pthreads binary or instruction to build ! ORRR Where can I find decent instructions on how to build mysql 3.23.38 ? Do not say the manual !! According to it mysql should compile ! But that note is for Mac Public Beta not Mac OS X 10.03(.0x)! Second when I tried compiling for Mac Server I get syntax errors and can not build or install while compiling the sources !! I have tried several patches (with fresh installs of the sources) for earlier versions of mysql on 3.23.38 to no avial. I have found references to a path to one file in line 12xx or something like that, but another source says it does fit the sources of 3.32.38. Please help ! Thanx in advance Keith. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP MySQL
How'd you put it into the database in the first place? I'm betting that, if
you look at your database directly (not through a UI), you'll find the data
is stored as lt;IMG
Anyway, wouldn't it be easier just to store foo.gif in the database rather
than the full line?
- Original Message -
From: Michele Santucci [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 14:20
Subject: PHP MySQL
I have a stupid problem with PHP MySQL (I'm a newbie of course):
I push in a text/blob record a string like this:
img src=foo.gif border=0
when I read print this record with PHP (using a simple echo statement ) I
got back the string translated in this way:
lt;IMG SRC=\quot;foo.gif\quot; border=\quot;0\quot;gt;
How can I prevent PHP from doing this translation and giving me back just
what I wrote inside the field?
bye by{t}e[s] TuX!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP MySQL
Hi,
PHP will only do this sort of translation if it is made to do so.
Here are the parts of the language that are likely to relate to your
problem:
- The magic_quotes_gpc configuration directive
- The addslashes() function
- The htmlentities() or htmlspecialchars() function
Now, while you don't need to escape the HTML entities before you insert your
data into the database, you will still need to add slashes to the data.
The slashes are used to escape special characters (like and ') that are
likely to prevent a string from being inserted into the database.
When you retrieve that slash escaped data from the database, you can remove
them using stripslashes().
--zak
- Original Message -
From: Michele Santucci [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 12:20 AM
Subject: PHP MySQL
I have a stupid problem with PHP MySQL (I'm a newbie of course):
I push in a text/blob record a string like this:
img src=foo.gif border=0
when I read print this record with PHP (using a simple echo statement ) I
got back the string translated in this way:
lt;IMG SRC=\quot;foo.gif\quot; border=\quot;0\quot;gt;
How can I prevent PHP from doing this translation and giving me back just
what I wrote inside the field?
bye by{t}e[s] TuX!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: which the best
I'd go for Linux Red Hat 7.1. High reliability, wonderful stability. We did it, and it still works perfectly (Linux Red Hat 6.2 to 7.1 + MySQL 3.23.22 to 3.23.37). The right enviroment for MySQL based applications (and if You're thinking of web applications, go for Linux Red Hat 7.1 + MySQL 3.23.38 + Apache 1.3.19 + PHP4pl5). Avoid NT 'cause of reboot issue when installing protocols or changing configuration. Just my 2c$ Corrado Sommai Fongnamthip ha scritto: Dear, I know this is not list for ask about OS, but I wonder to know that which OS you choose for database server in your mind? Linux Red Hat 7.1 Linux Mandrake 8.0 Windows NT 4.0 Windows 2000 Server or anything else from these OS! Regard, Sommai Fongnamthip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with perl
Dawn H writes: I've written a couple of scripts and have a thing that I haven't quite figured out. If anyone can shed light on this, I'd appreciate it. When a person submits a form that inserts a record into the database, if they then refresh the page that comes up after the submit, the record will be submitted a second time. I suppose this is due to the fact that the subroutine that is called with the submit contains both the write to database bit and the view bit. So refreshing causes a repeat of both items. How can I do this without that problem? I was finally forced to add a check that there wasn't already an identical record (using a minimum comparison set of fields) before inserting the record. There really isn't any way to prevent dingbats from refreshing, so... I CYA by emailing a copy of the record/element values to myself when I refuse to add it in, but I havne't had any spurious refusals so far. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Inserting 307,284 lines. Is this ok?
Hi In your lilo configuaration file add append=mem=256 to the linux kernel boot parameters, and then run lilo. When you reboot your server, you will find your missing memory ! MySql can handle large tables, up to 2GB, without any problems. Tables that result in files 2GB need the necessary options built in to the kernel. This is so with most modern kernels. Simon On Tuesday 05 June 2001 22:06, VVM Ravikumar Sarma Chengalvala wrote: Hi, For testing my database,I have inserted about 2 million records and did not find any specific problem. Regards, Ravi --- Rafael Martinez [EMAIL PROTECTED] wrote: ---Reply to mail from Mike Mike about Inserting 307,284 lines. Is this ok? Hello I was wondering if inserting 307,284 is to much to put into one table. Can MySQL handle this? Its a 70MEG File. I have a 550 with 256MEG ram but it only shows 64. [] I have a database with 20-30 tables. One of them has almost 2.000.000 entries and it use around 6GB (17 columns). Another has more than 2.500.000 and uses around 100MB (1 column) No problems at all. I suppose this answer your question. Sincerely Rafael Martinez ---End reply - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700744 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL PROTECTED] This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Thank you for your cooperation and assistance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
From As400 to MySQL ...
Good morning world.
We are facing an interesting problem here. We are thinking of a MySQL-based
datawharehousing
application. The main ERP db is OS400/AS400. We have to sincronize it with MySQL
datawharehousing db.
Anybody out there did the same?
TIA
Corrado
Bombardier Systems Consulting ha scritto:
I am consolidating all the responses back and forth and putting it back out
to the mysql list since it is still not resolvedshucks.
TIA...Jim
Here is the complete error and the connection code.
java.net.UnknownHostException: 127.0.0.1
at java.net.InetAddress.getAllByName0(InetAddress.java:571)
at java.net.InetAddress.getAllByName0(InetAddress.java:540)
at java.net.InetAddress.getByName(InetAddress.java:449)
at java.net.Socket.init(Socket.java:100)
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:114)
at org.gjt.mm.mysql.Connection.init(Connection.java:229)
at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:199)
at TestApp.getConnection(TestApp.java:32)
at TestApp.displayDatabaseValues(TestApp.java:40)
at TestApp.main(TestApp.java:72)
java.sql.SQLException: Cannot connect to MySQL server on 127.0.0.1:3306. Is
there a MySQL server running on the machine/port you are trying to connect
to? (java.net.UnknownHostException)
protected static Connection getConnection() throws Exception
{
Class.forName(org.gjt.mm.mysql.Driver);
String host = 127.0.0.1;
String dbPort = 3306;
String db = SITESTATS;
String url = jdbc:mysql:// + host + : + dbPort + / + db;
return DriverManager.getConnection(url);
}
I can ping 127.0.0.1, localhost, the host name and it's IP address. As
stated before this is a working DB with like data accessible via perl and
DBI/DBD.
I do not have a username and apssword associated with this connect at this
time and haven't tried that (yet) because the error seems to indicate it is
not the problembut what do I know.
- Original Message -
From: Bombardier Systems Consulting [EMAIL PROTECTED]
To: Johan Andersson [EMAIL PROTECTED]
Sent: Tuesday, June 05, 2001 1:50 PM
Subject: Re: Host resolving (was: Re: JDBC - UnknownHostException)
I am currently running all of this on one machine. After I get the JDBC
working I want to hook it into java serving web pages but that is later.
I
currently have perl and mysql serving web pages both on the same machine
and
from any system within my LAN...so it is working (and I think the it is
TCP/IP).
So should I be using localhost, 127.0.0.1, the host name or the host IP
address? AND should I be using 3306 or 1285 as port numbers?
My host name.err file in my /var/lib/mysql seems to be working just fine
and it is not reporting the errors that I am getting from Java. I
personally don't think this is a mysql problem. I think it is between
JDBC
and java on RH7.1.
The search continues
TIA
Jim
- Original Message -
From: Johan Andersson [EMAIL PROTECTED]
To: Bombardier Systems Consulting [EMAIL PROTECTED]
Sent: Tuesday, June 05, 2001 11:04 AM
Subject: Re: Host resolving (was: Re: JDBC - UnknownHostException)
Okey.. but what is the scenario here..
You got 1 workstation where you are running the java app which gets
the unknownhostexception, and a mysqld running on another machine?
Or is the mysqld running on the same machine as the java app ?
The nsswitch.conf sets the order of different lookups. You can from
that file decide whether host lookups should be done first by the
/etc/hosts
file, 2nd from a NIS server and 3rd by DNS (/etc/resolv.conf)..
If you only specify the hosts file, lookups that matches records in your
hosts file will be successful.
I cannot remember the actual format of this file, but it is quite
self-explaining.
Some things about mysql:
If you can connect with the mysql client from the server itself, but not
from
any other machines, you may have disabled TCP/IP support. Then only unix
sockets
are supported (localhost/127.0.0.1 is wrapped to use unix sockets instead
of
tcp/ip)
If you can't see the mysqld in the LISTENING list of the command
netstat -na, it can
depend on the socket support described above. It can also be a problem
with
the mysqld.
Look at the file path/fqdn.err, where path is the datadir of your mysqld
and
fqdn
the Fully-Qualified-Domain-Name which should be the same as the result of
executing
the hostname command in the console.
R,
Johan.
- Original Message -
From: Bombardier Systems Consulting [EMAIL PROTECTED]
To: Johan Andersson [EMAIL PROTECTED]
Sent: Tuesday, June 05, 2001 7:31 PM
Subject: Re: Host resolving (was: Re: JDBC -
Re: PHP MySQL
How'd you put it into the database in the first place? I'm betting that,
if
you look at your database directly (not through a UI), you'll find the
data
is stored as lt;IMG
No the data was stored in the right way! The problem wasn't here but in some
code lines around the one I was writing (I was modifing a script made by
someone else).
There was a calling to $row[$k]=htmlentities($row[$k]), that I just removed
and I got what I was looking for...
Anyway, wouldn't it be easier just to store foo.gif in the database
rather
than the full line?
It could be a good idea but right now I have to improve my skills on
low-level php coding before starting to use advanced features of
php/mysql...
Thnx again to anyone
bye by{t}e[s] TuX!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MAC OS X Server
Howdy: On 06/05/2001 15:42 USA PT (-0800), [EMAIL PROTECTED] ( Angela Neff ), wrote... Below is a link and article sent to me by a Consultant stating that MySQL works with the brand new MAC OS X Server. Has this indeed been thoroughly tested by MySQL programmers? I don't want to get one unless it works like a charm. I've been running MySQL for over a year on Mac OSX Server v.1.2.x with little or no problems ( though the install might be a bit non-standard ), so there shouldn't be any reason why it can't run happily on either the new OSX 10.x, or the newer OSX Server v.2.x ( at least the install will be more standard ). Also, is there or will there be a MAC My SQL listserv? Good question? Glenn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP MySQL
- Original Message -
From: Michele Santucci [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 15:33
Subject: Re: PHP MySQL
How'd you put it into the database in the first place? I'm betting
that,
if
you look at your database directly (not through a UI), you'll find the
data
is stored as lt;IMG
No the data was stored in the right way! The problem wasn't here but in
some
code lines around the one I was writing (I was modifing a script made by
someone else).
There was a calling to $row[$k]=htmlentities($row[$k]), that I just
removed
and I got what I was looking for...
Yea! of course, the htmlentities would cause a problem in this case.
Anyway, wouldn't it be easier just to store foo.gif in the database
rather
than the full line?
It could be a good idea but right now I have to improve my skills on
low-level php coding before starting to use advanced features of
php/mysql...
Actually, it's not that much harder. Use an sql statement to get it into a
variable, $foo say, as normal and then use either
1. ?php print(img src=\$foo\ border=\0\) ?
or
2. img src=?php print($foo) ? border=0
...and you'll probably have to do combinations, depending on what you are
doing.
Thnx again to anyone
bye by{t}e[s] TuX!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP MySQL
I assume that you are using htmlspecialchars() or htmlentities() to
encode characters that have special meanings under HTML. Don't - your
data will be inserted into the database verbatim.
You may have to use addslashes() on your data to escape the quotes
before you insert it into the database - you'll get an SQL error if so.
Just do this:
?php
//$str is your data being inserted
$str = addslashes($str);
//now do db insert
?
If you just want to translate what you've got into working HTML, use
this bit of code:
?php
//$str should contain the string you want translated
//if you are using htmlspecialchars(), change HTML_ENTITIES to
HTML_SPECIALCHARS
$trans = get_html_translation_table (HTML_ENTITIES);
$trans = array_flip ($trans);
$original = strtr ($str, $trans);
?
Ben Gollmer
Jatosoft, LLC
On Wednesday, June 6, 2001, at 01:20 AM, Michele Santucci wrote:
I have a stupid problem with PHP MySQL (I'm a newbie of course):
I push in a text/blob record a string like this:
img src=foo.gif border=0
when I read print this record with PHP (using a simple echo
statement ) I got back the string translated in this way:
lt;IMG SRC=\quot;foo.gif\quot; border=\quot;0\quot;gt;
How can I prevent PHP from doing this translation and giving me back
just what I wrote inside the field?
bye by{t}e[s] TuX!
MySql Client
HI, I am new to mySql and I want to set up MySql Client on different PC's and MySql server on one PC so that every one will access the same database. Is there a way to do this. Any one please help me. Thanks and Regards, Srinivas.M My Mail Id : [EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.259 / Virus Database: 130 - Release Date: 6/5/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with Zeos Component and BLOB
exists a limit of dimension for the blob in mysql? why I do not succeed to write of the blob with the zeos component with dimensions 6M? help excused my maccheronico English - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
need help with cross table update
Hi, I have two tables on mysql: Table1: class char(10) usernamechar(50) etc. etc.. Table2: class char(10) usernamechar(50) timeint unsigned etc.. Table2's class column is a new column addition and therefore does not have any values on it. I wanted to fill it up based on the class value found in table1. I was trying to do something like this: UPDATE table2 set class=table1.class WHERE table1.username=table2.username obviously wrong. what is the correct syntax? thanks. jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Building/installing MySQL under Mac OS X 10.03
I don't understand how yuo can have so much trouble building it ! I just downloaded the latest stable release, unzipped it, and did ./configure make make install mysql_install_db safe_mysqld and it went hoopla running ! (after almost half an hour compiling that is) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Building/installing MySQL under Mac OS X 10.03
PS : here's my versionnnumber : mysql SHOW VARIABLES LIKE version; +---+-+ | Variable_name | Value | +---+-+ | version | 3.23.37 | +---+-+ 1 row in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql Client
Yes there is. Just install the MySQL client in the normal way. When you add users, ensure they can access the server from a remote machine. See the GRANT and REVOKE statements. When they log in, they must specify the address of the MySQL server using the -h option. - Original Message - From: M Srinivas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 12:27 Subject: MySql Client HI, I am new to mySql and I want to set up MySql Client on different PC's and MySql server on one PC so that every one will access the same database. Is there a way to do this. Any one please help me. Thanks and Regards, Srinivas.M My Mail Id : [EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.259 / Virus Database: 130 - Release Date: 6/5/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems with AUTO_INCREMENT
Hi,
on my database I have create a table with an ID like this:
CREATE TABLE test {
id INT(10) unsigned NOT NULL default '0' AUTO_INCREMENT,
another INT(10)
};
and now I have inserted some values - the ID that would be inserted starts
at 1, but I need a ID with 0.
How can I set a ID with 0?
Best regards
Conny Kreyßel
INTER-FORUM Systemhaus GmbH
Sommerfelder Str. 120
04316 Leipzig
Germany
Tel.: +49-341-25 92 00
Fax : +49-341-25 92 020
WWW : http://www.inter-forum.de/
eMail: mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Replication out of sync
Hi Well, what I did was dump my structure to file, then I went an manually added a line to the end of each table saying AUTO_INCREMENT=1 for Site A, Site B was set to 2 and so on, obviously there is a chance one day of Site A's auto_increment reaching 2 but it won't happen for many many many years in my environment. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: Michael Eklund [mailto:[EMAIL PROTECTED]] Sent: 05 June 2001 23:18 To: [EMAIL PROTECTED]; 'Warren van der Merwe' Subject: RE: Replication out of sync How did you work out the auto-ids on different servers issue? Mike -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 2:16 PM To: Warren van der Merwe Cc: [EMAIL PROTECTED] Subject: Re: Replication out of sync On Mon, Jun 04, 2001 at 05:45:44PM +0200, Warren van der Merwe wrote: Hello Firstly, big thank you to all who helped me get my replication going. When I was playing around, I managed to get one of my table out of sync, on the one server I have 8 records and on the other 9. I know exactly what happened, it was when server B was not replicating to the correct address. Now the question is, what is the easiest way of getting them in sync? Do I delete the table from the one server reload it? Run a LOAD TABLE table FROM MASTER on the slave to bring an updated copy of the table to the slave. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 11 days, processed 68,268,148 queries (71/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL on OS/2 machine
Can you help me to set up an mySQL client on OS/2 machine? I have a mySQL/2 server (3.22.26a) which was successfully configured. I can communicate with the server from mySQLgui tool from Windows workstation, so I can proof that the server is set up correctly. The trouble is that I cannot establish connection from OS/2 workstation via TCP/IP. I can only do it from mysql.exe utility via Unix sockets on the local machine. Some information about both the machines: server: OS/2 Warp Server based on OS/2 Warp v.3 + FixPack 32PL, client: OS/2 Warp v.4 PL + FixPack 11P Both machines have EMX 0.9d installed. What command line parameters should I apply for mysql.exe to succeed. Now the command line looks like that:mysql -h 195.115.185.163(I have written here a different IP number than it is real...) and it results with error message: process terminated with SIGSEGV. What it is wrong? According to the manual I should succeed, why I don't? Jan N. Waliszewski, Lodz, Poland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
need help for a simple request
Hi, I have some problems with the following SQL request that I process with phpMyAdmin : select * from TABLE2 where FIELD not in (select FIELD from TABLE1); This request identify all records in TABLE2 which are not in TABLE1 (depending on value of FIELD). TABLE1 and TABLE2 have exactly the same sturcture. I currently use MySql 3.22.34 and phpMyAdmin 2.1.0 What's wrong ? Thank you for your help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Size of the bin log
Hi, Is it possible to make MySQL create another bin log when current one grows to the specified size? Rafal -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Replication out of sync
Okay, do not do this. When your replication takes place, Site A adjusts Site B autoincrement number. ANd so this principle does not work! I really think this replication could be very good if you could specify not to replicate a particular column, or some better way of handling auto numbering. Comments from the MYSQL dev team? ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Warren van der Merwe Sent: 06 June 2001 11:11 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Replication out of sync Hi Well, what I did was dump my structure to file, then I went an manually added a line to the end of each table saying AUTO_INCREMENT=1 for Site A, Site B was set to 2 and so on, obviously there is a chance one day of Site A's auto_increment reaching 2 but it won't happen for many many many years in my environment. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: Michael Eklund [mailto:[EMAIL PROTECTED]] Sent: 05 June 2001 23:18 To: [EMAIL PROTECTED]; 'Warren van der Merwe' Subject: RE: Replication out of sync How did you work out the auto-ids on different servers issue? Mike -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 2:16 PM To: Warren van der Merwe Cc: [EMAIL PROTECTED] Subject: Re: Replication out of sync On Mon, Jun 04, 2001 at 05:45:44PM +0200, Warren van der Merwe wrote: Hello Firstly, big thank you to all who helped me get my replication going. When I was playing around, I managed to get one of my table out of sync, on the one server I have 8 records and on the other 9. I know exactly what happened, it was when server B was not replicating to the correct address. Now the question is, what is the easiest way of getting them in sync? Do I delete the table from the one server reload it? Run a LOAD TABLE table FROM MASTER on the slave to bring an updated copy of the table to the slave. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 11 days, processed 68,268,148 queries (71/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: need help for a simple request
alexandre Roussel wrote: Hi, I have some problems with the following SQL request that I process with phpMyAdmin : select * from TABLE2 where FIELD not in (select FIELD from TABLE1); This request identify all records in TABLE2 which are not in TABLE1 (depending on value of FIELD). TABLE1 and TABLE2 have exactly the same sturcture. I currently use MySql 3.22.34 and phpMyAdmin 2.1.0 What's wrong ? You cannot use subqueries in MySQL. Try something like this: select table2.field from table2 left join table1 on (table2.field=table1.field) where table1.field is null; -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Log file size
I'm running mySQL on Linux and was wondering is there a way to limit the maximum log file size? From time to time I have written a bad script that will query mySQL in a loop (BTW - mySQL can do *lots* of queries/second!) without me realizing my mistake until I run out of room on my log partition which causes all kinds of Bad things to happen. I don't want to reduce the log detail, because normally my logs are just fine, just would like to be able to suspend logging when there is only x% of disk space left. Pete -- http://www.elbnet.com ELB Internet Services, Inc. Web Design, Computer Consulting, Internet Hosting - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FROM C to MYSQL
Hi to all. I would write a C programm for write a lot of variables in MySQL database. There are examples ? I try to write a cgi with Boutell library and then write the form variable in a database Alessandro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: need help for a simple request
On Wed, 6 Jun 2001 11:52:14 +0200, alexandre Roussel [EMAIL PROTECTED] wrote: subselects are not currently supported with MySQL. Hi, I have some problems with the following SQL request that I process with phpMyAdmin : select * from TABLE2 where FIELD not in (select FIELD from TABLE1); This request identify all records in TABLE2 which are not in TABLE1 (depending on value of FIELD). TABLE1 and TABLE2 have exactly the same sturcture. I currently use MySql 3.22.34 and phpMyAdmin 2.1.0 What's wrong ? Thank you for your help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Databases not see with show database query...
Hi All... I m running Mysql 3.23.36 on Redhat Linux 7.0... Installation and configuration has been finished... Mysql is working perfect on some systems but on some systems when i Say show databases it gives the following error... mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | | | | | | | | | +--+ 10 rows in set (0.00 sec) mysql I am not able to see any databases in Mysql while the databases exist in Mysql as iy indicated 10 rows.. what is the problem pls help me. Kind regards Harish Gundecha Systems Administrator Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Versaware Technologies (India) Pvt. Ltd. Phone : +91-20-6136028 Extn: 331
Re: MySQL with perl
When a person submits a form that inserts a record into the database, if they then refresh the page that comes up after the submit, the record will be submitted a second time. I suppose this is due to the fact that the subroutine that is called with the submit contains both the write to database bit and the view bit. So refreshing causes a repeat of both items. How can I do this without that problem? Thanks in advance, Dawn H Two possible suggestions: 1) Provide a unique index field and catch the duplicate error if they try to resubmit the form. Then you can send them a nice Don't do that! message. 2) After the form is submitted redirect them to a second Thanks! page. They can reload that page all they want. Pete -- http://www.elbnet.com ELB Internet Services, Inc. Web Design, Computer Consulting, Internet Hosting - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqld 3.23.36-log stop responding
Martin Bringe writes:
Hi,
I need som help on problems we encounter with mysql. I find nothing in
manual nor this list, that gave me a hint where I can solve my problem:
Environment:
mysql run on an dedicated system with dual pIII-933 and 1 GB RAM. the
mysql-server is used by a webserver via network (switched 100 MBit). The
system is a upgraded potato debian box, kernel 2.4.3. We use reiserfs but
the database files sit on a standard ext2 partition. The system shows a load
about 0,8 to 1 (top), mysqladmin status reports about 70-80 q/s. The mysqld
setup is based upon my_huge.cnf.
After a short period, about some hours, I find about 100 Threads running
and mysql is completely dead. No change to stop mysqld by mysqladmin
shutdown nor by a kill -9. After all there are 3-6 mysql-processes that stay
in the processlist and I had to reboot the system to wipe them out.
Now my questions:
After experience with older systems. I think this system should be able to
drive about 200 - 300 Q/s, but we are far away from this point. How can I
determine the bottleneck?
How can I find out, wich query or what stops mysql responding?
In mysqladmin extended-status I find tmp_disk_table. About 10 % tmp_table
are disk? I interpret this line as mysql writes the results to disk. Is
this the correct interpreation ans how can I find the query caused this?
Many Thank you for any hints.
Martin Bringe
Hi!
If you are not using our binary, then it could be caused by improper
building of MySQL.
If you are using our binary, then you have probably eaten up all
memory with huge variant of my.cnf.
To find out exactly what goes on, mysqladmin proc is a better tool.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug!
To MySql Team. I am trying mysql version 3.23.38 for win 2000 and linux. I use VB and VC++ to develop. There are 2 major problem i have encounter. 1) If i ask for "describe [tablename]" into a Datagrid, I do not get the info back when the tables has an auto_increment field. 2) I use ODBC to access the database. It talks about 2-3 seconds to open / update a recordset using the mysql for windows AND msql for linux. I do not know what is the problem, and why it takes me about 5 seconds to open a recordset and update. I will appreciate it, if you will reply with an answer. P.S I used earlier version of mysql ( 1.6 i think ) for linux and These problems NEVER occur. there for i am sure that my code is correct ( i tried the same code on this DB) Best Regards Ran Salomon E-mail: [EMAIL PROTECTED] ---
Make: Doesn't exist?
Hi, I'm trying to install MySQL 3.23.38 from the source distribution onto RedHat Linux 6.2 (fresh installation). After unpacking the tarball into /usr/local/mysql-3.23.38 I run ./configure etc. but when I type in make from the mysql-3.23.38 directoiry all i get is: bash: make: command not found Could you possibly advise me as to where I am going wrong? Thanks in advance. Richard Kimberley. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
score in search - problem
Hi
I got my fulltext search going and its all fine except for one little thing
that has
been bugging me.
In the mysql manual it says that using MATCH col AGAINST ('something') as x
will output a percent value in x, such as 0.56 i.e.
However, for some reason I keep getting values such as 3.2904656440062,
never a 0,xxx value, and even if I type in an exact match for a column I
never get
99.xxx or something similar (I think the highest I ever got was around 35,...).
I am not too familiar with the settings in mysql since I am more a user (I
havent installed
current version myself). Could it be a problem with the settings? Its the
only explanation
I have. But I dont know what to do about it.
Does anybody have any ideas on this? I just thought it would be nice to
have something
like a percent score in the search output.
Thx in advance ~
Nessi :)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to convert MS Access mdb to Mysql
Hello.. is it possible to convert a whole ms access database (mdb) to a mysql database if so.. howto ? from Milpoer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Break 31 tables in a join limitation with MySql
Hello , I would like to know how to break the 31 tables in a join limitation, In documentation I found that table cache should be at least equal to n*max_connections where n is the maximum tables in a join, so I don't know if modifying table_cache value will help or if there is another way ... /* this is only to bypass the MySql Mailing list filter ;)) */ /* (database,sql,query) */ -- Best regards, SixK // \\ //Amiga spirit will never die \\/ mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
convert an ms access database file
I need to convert an ms access database file to a mysql compatible pipe delimited database file. I downloaded a program to convert the database, but it needs to connect to the mysql server on my dedicated server. When I try to connect it says 'ipaddress.internetprovider' is not allowed to connect to this MySQL server. How can I use the GRANT/REVOKE command through mysql to grant myself access to it? - Sign up for ICQmail at http://www.icq.com/icqmail/signup.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with adding some functions into MySQL
Hi all,
I'm currently working on project, where I need implement some functions to formate
SQL queries.
It's necessary to add these functions into MySQL.
I read about UDF (user def. functions) and I mean, that it is almost what I want.
For examlple,
QUERY() ... UDF function, whitch returns string like: "SELECT * FROM tab;"
What I need is to execute this string like MySQL query.
I know, that it could be done by PHP script (function) like this
function DB_Query( $query, $connection )
{
$tmpquery = "SELECT QUERY( $query );";
$result = MySQL_Query( $tmpquery, $connection );
$entry = SQL2_Fetch_Array( $result );
$dbquery= $entry[ 1 ];
$result = MySQL_Query( $tmpquery, $connection );
return ($result);
}
But the problem is, that it requires two DB calls.
It's necessary to add these functions into MySQL, because if I use other API (for
example
DBI, etc.) I need to write all functions like above again.
Is it possible to create QUERY() function which would execute the query?
(not to return string with query, but return query results)
thanx
--Nykolas
__
Setrite na leto? Lepsi zamestnani pro Vas a dovolene zdarma za 100 000 Kc
na http://www.jobpilot.cz/go/prazdniny.
__
Setrite na leto? Lepsi zamestnani pro Vas a dovolene zdarma za 100 000 Kc
na http://www.jobpilot.cz/go/prazdniny.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Make: Doesn't exist?
sounds like you either dont have make installed on your machine, or it is not in your PATH environment variable do 'find / -name make -print' and see if it is on your machine, if not you will have to get your redhat CD and install it -Original Message- From: Richard Kimberley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 6:38 AM To: [EMAIL PROTECTED] Subject: Make: Doesn't exist? Hi, I'm trying to install MySQL 3.23.38 from the source distribution onto RedHat Linux 6.2 (fresh installation). After unpacking the tarball into /usr/local/mysql-3.23.38 I run ./configure etc. but when I type in make from the mysql-3.23.38 directoiry all i get is: bash: make: command not found Could you possibly advise me as to where I am going wrong? Thanks in advance. Richard Kimberley. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Importing spreadsheet data into MySQL
Is it possible to import spreadsheet data (Excel) into MySQL? I have data on about 2,500 retail locations that I must place into a database on the web and I do not want to type them by hand if I can avoid it. Thanks, Chris Gray --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.256 / Virus Database: 129 - Release Date: 5/31/2001
Stored procedures (really sorry for bringing this up)
The company I work for has been considering moving a key database from MS Access to a proper database. We use linux for a lot of the number crunching we do and I was keen for us to choose MySQL. I happen to think it would be ideal for our applications. Unfortunately, those with the task of converting the application consider stored procedures to be essential. I'm not at all convinced they are necessary (at least in the short term). I fear the arguement is already lost.. but... I saw from the survey that is currently being done that stored procedures are one feature that appears to be in active consideration, but I see from the TODO list that they are only in the to be done sometime category. So the questions are: any idea how long it will be before something is in place? would funding change this? can also offer some help with the coding (have solid C/C++ but no experience with MySQL itself) John Gill. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication out of sync
Actually, in my humble opinion, autoincrements need to have a host component, so each autoincrement is unique on each machine. Also you could have the master negotiate discrepencies, but this is far more complicated. Mike On Wed, 6 Jun 2001 12:25:16 +0200 Warren van der Merwe [EMAIL PROTECTED] wrote: Okay, do not do this. When your replication takes place, Site A adjusts Site B autoincrement number. ANd so this principle does not work! I really think this replication could be very good if you could specify not to replicate a particular column, or some better way of handling auto numbering. Comments from the MYSQL dev team? ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Warren van der Merwe Sent: 06 June 2001 11:11 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Replication out of sync Hi Well, what I did was dump my structure to file, then I went an manually added a line to the end of each table saying AUTO_INCREMENT=1 for Site A, Site B was set to 2 and so on, obviously there is a chance one day of Site A's auto_increment reaching 2 but it won't happen for many many many years in my environment. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: Michael Eklund [mailto:[EMAIL PROTECTED]] Sent: 05 June 2001 23:18 To: [EMAIL PROTECTED]; 'Warren van der Merwe' Subject: RE: Replication out of sync How did you work out the auto-ids on different servers issue? Mike -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 2:16 PM To: Warren van der Merwe Cc: [EMAIL PROTECTED] Subject: Re: Replication out of sync On Mon, Jun 04, 2001 at 05:45:44PM +0200, Warren van der Merwe wrote: Hello Firstly, big thank you to all who helped me get my replication going. When I was playing around, I managed to get one of my table out of sync, on the one server I have 8 records and on the other 9. I know exactly what happened, it was when server B was not replicating to the correct address. Now the question is, what is the easiest way of getting them in sync? Do I delete the table from the one server reload it? Run a LOAD TABLE table FROM MASTER on the slave to bring an updated copy of the table to the slave. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 11 days, processed 68,268,148 queries (71/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: CGI/Perl and MySQL (OT?)
Trying to get text from a CGI textarea box to go into MySQL with the br line breaks instead on generic \n breaks. Is there an easy way to parse the var and make the necessary change? You can use a Perl regular expression. The following seems to work for me: # replace line breaks with HTML BR tags $textarea =~ s/\n/BR/g; Kind regards, Chris Waverley Internet Design http://www.waverley-internet.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
My sql database and faster queries
Hi, I wonder to know which of the following is better in performance and faster . Using table joins for queries. OR Multiple queries without joins using MySql C API Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: convert an ms access database file
Have a look at MySQL-Front: http://www.mysqlfront.de/ it will do extactly what you want. Please be careful: the ODBC/Access-Importing has beta-quality. Ansgar -Ursprüngliche Nachricht- Von: Terrell Johnson [EMAIL PROTECTED] An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Gesendet: Mittwoch, 6. Juni 2001 13:41 Betreff: convert an ms access database file I need to convert an ms access database file to a mysql compatible pipe delimited database file. I downloaded a program to convert the database, but it needs to connect to the mysql server on my dedicated server. When I try to connect it says 'ipaddress.internetprovider' is not allowed to connect to this MySQL server. How can I use the GRANT/REVOKE command through mysql to grant myself access to it? - Sign up for ICQmail at http://www.icq.com/icqmail/signup.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connecting from Sever to Server
Hi I wanted to do some sort of database connection. In the way that I can handle db's from multiple server as I'm doing from one. Let's give you an example DB1 on host asterix DB2 on host obelix DB3 on host miraculix Wenn I connect to db1 on asterix by mysql I want to make selects in one statement to the others to: select * from db1.*, db2@obelix.* db3@miraclix.* where I know I could programm this in perl, java or whatever. I would pefer a solution which fits neatly into mysql. I thinks this sould be much about it for real DB hackers, because different DB's on the same machine can be use already. Has anyone be programming such a thing? To get you full information: I want to distribute the data to different server get better performance on inserting and be scalable with no end. Because each server should do most of the work by it's own power, and just deliver the result to the client server. Thanks Philip Markwalder == Markwalder Philip Consultant [EMAIL PROTECTED] Trivadis AG Kanalstrasse 5 CH-8152 Glattbrugg Tel.: +41- 1-808 70 20 Fax : +41- 1-808 70 21 Mobile: +41-79-445 77 87 http://www.trivadis.com == - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: convert an ms access database file
We haven't had a chance to test it yet, but the documentation for MySQL-Front (http://www.anse.de/mysqlfront/download.php) mentions a new feature which permits import of Access databases. MySQL-Front is a beta / free product at this point ... which we have foudn to very stable and very useful! Gerald Jensen - Original Message - From: Terrell Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 7:41 AM Subject: convert an ms access database file I need to convert an ms access database file to a mysql compatible pipe delimited database file. I downloaded a program to convert the database, but it needs to connect to the mysql server on my dedicated server. When I try to connect it says 'ipaddress.internetprovider' is not allowed to connect to this MySQL server. How can I use the GRANT/REVOKE command through mysql to grant myself access to it? - Sign up for ICQmail at http://www.icq.com/icqmail/signup.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: bug!
At 14:37 06/06/2001 +0200, ran wrote: Hi, When you have an issue involving: client_application MyODBC MySQL The best thing to do is to test the MyODBC and MySQL isolating the client application. For example in your case of describe table_name, I create a small table with the following structure: mysql describe mytest; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | name | char(50) | YES | | NULL|| +---+--+--+-+-++ 2 rows in set (0.00 sec) Then I built a DSN file, to test the same command using MyODBC with the tool ODBCTE32.EXE shipped together with the MyODBC setup. Below the result: Get Data All: Field, Type, Null, Key, Default, Extra id, int(11), , PRI, Null, auto_increment name, char(50), YES, , Null, 2 rows fetched from 6 columns. So I guess that the problem is your application or the machine environment. Notice for example that VB doesn't support BIGINT as column type on auto_increment. Regards, Miguel To MySql Team. I am trying mysql version 3.23.38 for win 2000 and linux. I use VB and VC++ to develop. There are 2 major problem i have encounter. 1) If i ask for describe [tablename] into a Datagrid, I do not get the info back when the tables has an auto_increment field. 2) I use ODBC to access the database. It talks about 2-3 seconds to open / update a recordset using the mysql for windows AND msql for linux. I do not know what is the problem, and why it takes me about 5 seconds to open a recordset and update. I will appreciate it, if you will reply with an answer. P.S I used earlier version of mysql ( 1.6 i think ) for linux and These problems NEVER occur. there for i am sure that my code is correct ( i tried the same code on this DB) Best Regards Ran Salomon E-mail: [EMAIL PROTECTED] --- -- For technical support contracts, go to https://order.mysql.com/ __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Make: Doesn't exist?
I had the same problem with make trying to install mysql last night. It said there was no target. I was already frustrated and gave up. make works on all of my other installs, though. - Original Message - From: Gilfether, Ryan [EMAIL PROTECTED] To: 'Richard Kimberley' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 8:04 AM Subject: RE: Make: Doesn't exist? sounds like you either dont have make installed on your machine, or it is not in your PATH environment variable do 'find / -name make -print' and see if it is on your machine, if not you will have to get your redhat CD and install it -Original Message- From: Richard Kimberley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 6:38 AM To: [EMAIL PROTECTED] Subject: Make: Doesn't exist? Hi, I'm trying to install MySQL 3.23.38 from the source distribution onto RedHat Linux 6.2 (fresh installation). After unpacking the tarball into /usr/local/mysql-3.23.38 I run ./configure etc. but when I type in make from the mysql-3.23.38 directoiry all i get is: bash: make: command not found Could you possibly advise me as to where I am going wrong? Thanks in advance. Richard Kimberley. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Importing spreadsheet data into MySQL
Save as .csv file and then use http://www.mysql.com/doc/L/O/LOAD_DATA.html Hope this helps Simon -Original Message- From: Chris L. Gray [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 14:15 To: [EMAIL PROTECTED] Subject: Importing spreadsheet data into MySQL Is it possible to import spreadsheet data (Excel) into MySQL? I have data on about 2,500 retail locations that I must place into a database on the web and I do not want to type them by hand if I can avoid it. Thanks, Chris Gray --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.256 / Virus Database: 129 - Release Date: 5/31/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Port numbe r
telnet your.mysql.server 3306 On Tue, 5 Jun 2001, sanborn wrote: How is MySQL used over a network? I assume there is a port involved, and some kind of transaction server built into mysql? How do I configure, test this? In the several documents I have read so far, I haven't found much on the subject. Thanks for your input. Gene Sanborn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Importing spreadsheet data into MySQL
Thanks for the response... let's say that I save the CSV as list.csv in my computer as C:/programs/list.csv. What would the full syntax be? I have tried some variations and they do not work. Also, and this may be the king of newbie questions, will MySQL create tables based on my information or do I need to have a table built to house the data BEFORE I import? Chris Gray - Original Message - From: Roger Karnouk [EMAIL PROTECTED] To: Chris L. Gray [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 9:36 AM Subject: RE: Importing spreadsheet data into MySQL Using Excel you can save that data in CSV from then use LOAD DATA INFILE syntax to import it to a MySQL table. -Original Message- From: Chris L. Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 9:15 AM To: [EMAIL PROTECTED] Subject: Importing spreadsheet data into MySQL Is it possible to import spreadsheet data (Excel) into MySQL? I have data on about 2,500 retail locations that I must place into a database on the web and I do not want to type them by hand if I can avoid it. Thanks, Chris Gray --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.256 / Virus Database: 129 - Release Date: 5/31/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: MySQL 3.23.38 on HP UX 10.20
mysql, sql, database I'm trying to post you directly, because of stupid filter on mysql-list which avoid belowed e-mail from posting to list could you help us or redirect it to correct person ? thanks, TOMASZ -Original Message- From: Tomasz Szymczyk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 10:29 AM To: [EMAIL PROTECTED] Subject: MySQL 3.23.38 on HP UX 10.20 I'm trying to install MySQL on HP UX 10.20 after launching scripts/mysql_install_db I can see 'coredump' does anubody know what shall I do to use MySQL 3.23.38 on HP UX 10.20 ? /usr/local/mysqlscripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 010606 10:12:22 Warning: setrlimit couldn't increase number of open files to more than 128 010606 10:12:22 Warning: Changed limits: max_connections: 100 table_cache: 64 scripts/mysql_install_db[292]: 16704 Memory fault(coredump) Installation of grant tables failed! regards, TSZ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Importing spreadsheet data into MySQL
You will have to create the table first make sure you have the same number of fields in your table as in your file Otherwise specify the column names in brackets at the end of the LOAD DATA statement then LOAD DATA INFILE 'list.csv' INTO TABLE yourtable FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n'; This should work I guess -Original Message- From: Chris L. Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 10:36 AM To: Roger Karnouk Cc: [EMAIL PROTECTED] Subject: Re: Importing spreadsheet data into MySQL Thanks for the response... let's say that I save the CSV as list.csv in my computer as C:/programs/list.csv. What would the full syntax be? I have tried some variations and they do not work. Also, and this may be the king of newbie questions, will MySQL create tables based on my information or do I need to have a table built to house the data BEFORE I import? Chris Gray - Original Message - From: Roger Karnouk [EMAIL PROTECTED] To: Chris L. Gray [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 9:36 AM Subject: RE: Importing spreadsheet data into MySQL Using Excel you can save that data in CSV from then use LOAD DATA INFILE syntax to import it to a MySQL table. -Original Message- From: Chris L. Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 9:15 AM To: [EMAIL PROTECTED] Subject: Importing spreadsheet data into MySQL Is it possible to import spreadsheet data (Excel) into MySQL? I have data on about 2,500 retail locations that I must place into a database on the web and I do not want to type them by hand if I can avoid it. Thanks, Chris Gray --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.256 / Virus Database: 129 - Release Date: 5/31/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need help on mysql/php
At 7:49 AM -0700 6/6/01, Ed Peddycoart wrote: It is a shared server Ed Then you're vulnerable, unless the ISP can demonstrate otherwise. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 6:02 PM To: Jorge Oliveira; Ed Peddycoart Cc: Mysql@Lists. Mysql. Com Subject: RE: Need help on mysql/php At 10:37 PM +0100 6/5/01, Jorge Oliveira wrote: Hi again, You are right, your username and password will have to be on every PHP script that needs to use database. However, you don't have to be afraid because nobody can access the source of your PHP scripts - unless they are a good hacker! Actually, anyone else on the Web server host that has permission to install scripts for the Web server can access the source. I couldn't tell from the original message whether the Web server is shared with other people or not, but if you don't have your own server, you're exposed. I think you should pay a visit to http://www.php.net to understand how PHP works. Start with the basics and you will see that is reallY VERY simple. Be cool, Jorge Oliveira [EMAIL PROTECTED] © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com -- Paul DuBois, [EMAIL PROTECTED] -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Importing spreadsheet data into MySQL
Hi, Yes, you can DBTools for Windows (http://dbtools.vila.bol.com.br) that imports from MsAccess, Clipper, Dbase, FoxPro, Paradox, MSExcel and ODBC databases. []'s Crercio O. Silva -Original Message- From: Chris L. Gray [mailto:[EMAIL PROTECTED]] Sent: quarta-feira, 6 de junho de 2001 10:15 To: [EMAIL PROTECTED] Subject: Importing spreadsheet data into MySQL Is it possible to import spreadsheet data (Excel) into MySQL? I have data on about 2,500 retail locations that I must place into a database on the web and I do not want to type them by hand if I can avoid it. Thanks, Chris Gray --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.256 / Virus Database: 129 - Release Date: 5/31/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SELECT DISTINCT
Hi. I need to do a search like this SELECT DISTINCT namep,namef FROM printers,fax WHERE namep LIKE 'Xerox%' AND nomef LIKE 'Xerox%'; I had in the database data like Xerox N-2125 or Xerox N17. I think I must use a subselect or something like because i get duplicate results. Any help will be helpfull. Thanks in advance. Results: +--+-+ | namep| namef | +--+-+ | Xerox N-2125 | Xerox DC255 | | Xerox N17| Xerox DC255 | | Xerox N40| Xerox DC255 | | Xerox N-2125 | Xerox 4LP | | Xerox N17| Xerox 4LP | | Xerox N40| Xerox 4LP | +--+-+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Importing spreadsheet data into MySQL
There is a module for Perl which can read Excel. Then there is DBI for accessing MySQL. Use both to transfer data. If under Windows, you coudl also use ODBC and some ActiveX control under Visual Basic for quick and dirty transfer scripting. - Original Message - From: Chris L. Gray [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 5:15 PM Subject: Importing spreadsheet data into MySQL Is it possible to import spreadsheet data (Excel) into MySQL? I have data on about 2,500 retail locations that I must place into a database on the web and I do not want to type them by hand if I can avoid it. Thanks, Chris Gray --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.256 / Virus Database: 129 - Release Date: 5/31/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL tool
Is there any tool available for managing graphically databases,tables as well as user and their rights for MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LOAD DATA INFILE Question
Ok, the company I work for does not host its own websites, etc.. we pay a company for space on their servers. They use Unix boxes and the database they support is MySQL with a PHPMyAdmin GUI. Here is my dillema.. I need to move some of our existing Microsoft (Excel and Access) databases to MySQL on the server so that we can incorporate them into our websites. I appreciate the feedback I have gotten and I understand now that this is ultimately a function of the LOAD DATA INFILE syntax. What I need to know, though, is what would the syntax be to pull the text file off of my C: drive and into the MySQL table on our remote server? This is all soo confusing. Chris G. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.256 / Virus Database: 129 - Release Date: 5/31/2001
Re: CGI/Perl and MySQL (OT?)
A better solution would be to use the DBI quote() function, see the DBI perldoc for more information. and FYI 99% of web clients pass CRLF not just LF so you'd need \r\n Chris Thompson wrote: Trying to get text from a CGI textarea box to go into MySQL with the br line breaks instead on generic \n breaks. Is there an easy way to parse the var and make the necessary change? You can use a Perl regular expression. The following seems to work for me: # replace line breaks with HTML BR tags $textarea =~ s/\n/BR/g; Kind regards, Chris Waverley Internet Design http://www.waverley-internet.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error in Logs
Once I upgrade to RPM version how do I import my current user information and passwords without corrupting the new install? I already tried this once bye copying my old Data dir in the new Data dir. I used the same passwords for the root user but it did not seem to like that very much and Denied me acceess Thanks Mike. -Original Message- From: Sasha Pachev [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 2:21 PM To: Mike Jimenez; [EMAIL PROTECTED] Subject: Re: Error in Logs On Tuesday 05 June 2001 13:15, Mike Jimenez wrote: I got this error in my logs how do I work with this to figure out what the problem is. And would cause something like this to happen? Thanks Mike mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong Cannot determine thread, ebp=0xb6f4, backtrace may not be correct stack range sanity check, ok, backtrace follows 0x40078552 0x40077f0f 0x80be0fa 0x80be56f 0x80bdced 0x400fa9cb 0x8088731 New value of ebp failed sanity check terminating backtrace Number of processes running now: 0 010604 14:02:25 mysqld restarted /usr/local/libexec/mysqld: ready for connections It is possible that you are hitting a bug in MySQL. But the numbers look like you coredump inside libc, which actually could be a bug in MySQL, eg. a call to memcpy() with a stray pointer. But very likely, it is some glibc problem. Please do the following: * read http://www.mysql.com/doc/U/s/Using_stack_trace.html and obtain a symbolic resolution for your stack trace - even if the steps below fix the problem, I am curious about how your binary coredumped * upgrade MySQL to the latest version ( 3.23.38 ) * use our binary or RPM, see http://www.mysql.com/doc/L/i/Linux.html for some reasons why -- MySQL Development Team For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What is the for in ' safe_mysqld --log '
I lost track of the tutorial where I saw the command safe_mysqld --log What is the for? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need Japanese character set files
On 2001 Jun 06, Anatole [EMAIL PROTECTED] wrote: I brought down mysqld and restarted as before with safe_mysqld --default-character-set=sjis and get the following error message when php tries to connect: Can't initialize character set 13 (path: default) in /usr/local/apache/sites/gaijinpot.com/php/common.inc Ah, the vital clue. You're using PHP, and probably used the mysql that is bundled with PHP (an older version, too), and not an external MySQL library. The PHP version only comes with the latin1 character set. What you need to do is configure PHP using their --with-mysql=/path/to/your/mysql option, and make and install the new PHP. Yes, this is kind of a pain, but that's how it goes. If you have trouble with this process, a PHP list is probably the best place to get help. Oh, you might be able to get around this by just using the most recent version of PHP. We added a hack to ignore the error you are getting, since the client doesn't have to do much with the character sets. But I'm not sure if it will work when the server is using a multi-byte character set - it might just break. The way to be sure that things work is to follow my instructions above. If you just upgrade your PHP, and things don't work, let me know the error you get so maybe I can find a work-around. Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team /_/ /_/\_, /___/\___\_\___/ Boone, NC USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Importing spreadsheet data into MySQL
On Wed, 6 Jun 2001, Chris L. Gray wrote: Is it possible to import spreadsheet data (Excel) into MySQL? I have data on about 2,500 retail locations that I must place into a database on the web and I do not want to type them by hand if I can avoid it. One way: Save as CSV file. Parse CSV file to create multiple inserts Hand parsed output to mysql Another way: Save as CSV file Hand CSV to mysql. RTM : -- Sapere aude My mind not only wanders, it sometimes leaves completely. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
does show create table work?
hi! Does SHOW CREATE TABLE x actually work? When I try it I just get error 1064 (you have an error in your sql syntax near 'CREATE TABLE x') (version 3.22.32 on linux) ta, Rob Agar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compiling in 64-bit Solaris environment
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [Compiling in 64-bit Solaris environment] Description: checking return type of sprintf... configure: error: can not run test program while cross compiling How-To-Repeat: Compile any version of mysql using any version of gcc on any 64-bit install of Solaris (7 or 8) Fix: only compile on 32-bit OS installations. Submitter-Id: Ray McCaffity Originator:Super-User Organization: organization of PR author (multiple lines) MySQL support: [none] Synopsis: cannot run or compile mysql in 64-bit environment Severity: serious Priority: medium Category: mysql Class: sw-bug | doc-bug | change-request | Release: mysql-3.23.38 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: SunOS webstats 5.8 Generic_108528-08 sun4u sparc SUNW,Ultra-5_10 Architecture: sun4 Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc gcc version 2.95.3 20010315 (release)b/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1759264 Jun 1 22:11 /lib/libc.a 1rwxrwxrwx 1 root root 11 May 30 15:49 /lib/libc.so - ./libc.so. -rwxr-xr-x 1 root bin 1136692 Jun 1 22:11 /lib/libc.so.1 -rw-r--r-- 1 root bin 1759264 Jun 1 22:11 /usr/lib/libc.a .so.1wxrwx 1 root root 11 May 30 15:49 /usr/lib/libc.so - ./libc -rwxr-xr-x 1 root bin 1136692 Jun 1 22:11 /usr/lib/libc.so.1 ./configure --with-perl --prefix=/usr/local/mysql --with-gnu-ld - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Chroot problems
Hello, I'm trying to run mysql in a chroot jail, but the server errors out. I've modified safe_mysqld so it would call MySQL with the following command: nice --5 nohup /usr/local/mysql/libexec/mysqld -- basedir=/ --datadir=/var --user=mysql --pid- file=/var/hayek.pid --skip-locking -- chroot=/usr/local/mysql -- language=/usr/local/mysql/share/mysql/portuguese /usr/local/mysql/var/hayek.err 21 When I run safe_mysqld, the mysql daemon dies with the following error (log file): 010606 9:57:58 /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist How's that possible if the table's set up just fine? I tried copying the mysql datafile dir to the real /var directory and it still can't find the 'host' table. Has anyone got mysql running with the chroot option? There really should be a tutorial for this! Thanks in advance, Dario Gomes __ Acesso pelo menor preço do mercado! R$ 14,90 nos 3 primeiros meses! ASSINE AGORA! http://www.bol.com.br/acessobol/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Importing spreadsheet data into MySQL
It is actually a little tricky. You need to build the table in mysql yourself, then
use some utility to import it. I would use perl. The problem with Excel is that when
it exports csv, it does not quote empty fields (I think), So, you can't use
Text::ParseWords (AFAIK). Here is a regexp which will do the pattern matching for you
(courtesy of the O'Reilly Regular Expressions book):
@info = ();
while ($data =~ m/([^\\]*(\\.[^\\]*)*),?|([^,]+),?|,/g) {
push(@info, defined($1) ? $1 : $3 ); }
push(@info,undef) if $data=~ m/,$/;
Then, just use DBI to get the data into MySQL.
Hope this helps.
-Dan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
I am trying to install MYSQL 3.23.38 on an SGI machine running IRIX 6.5 I can gunzip the tar.gz file and tar it aswell, however then when I run the scripts/mysql_install_db it fails saying ' ./bin/mysqld: Program not supported by architecture Installation of grant tables failed! I therefore am stuck and cant install the software, it is the verision specifically for IRIX aswell ?? Please Help Regards Simon === Domain Name Registration At The Right Price - www.domaindomain.co.uk === === Before making any enquiries please refer to our 'frequently asked questions' If you need to reply to this message please do so enclosing any past correspondence, your username and domain name. === The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Knightmaster Enterprises Uk Ltd will accept no responsibility or liability in respect to this email other than to the addressee.
RE: SELECT DISTINCT
There are no duplicates in your results Distinct is on the whole record not on the individual Items for example: | Xerox N-2125 | Xerox DC255 | is not the same as | Xerox N40| Xerox DC255 | because the first field is different and | Xerox N-2125 | Xerox DC255 | is not the same as | Xerox N-2125 | Xerox 4LP | because the second field is different You could do something like SELECT DISTINCT namep,Max(namef) FROM printers,fax WHERE namep LIKE 'Xerox%' AND nomef LIKE 'Xerox%' GROUP BY namep; but you will be missing some values of namef -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 11:08 AM To: [EMAIL PROTECTED] Subject: SELECT DISTINCT Hi. I need to do a search like this SELECT DISTINCT namep,namef FROM printers,fax WHERE namep LIKE 'Xerox%' AND nomef LIKE 'Xerox%'; I had in the database data like Xerox N-2125 or Xerox N17. I think I must use a subselect or something like because i get duplicate results. Any help will be helpfull. Thanks in advance. Results: +--+-+ | namep| namef | +--+-+ | Xerox N-2125 | Xerox DC255 | | Xerox N17| Xerox DC255 | | Xerox N40| Xerox DC255 | | Xerox N-2125 | Xerox 4LP | | Xerox N17| Xerox 4LP | | Xerox N40| Xerox 4LP | +--+-+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL tool
I've had good success with DB Tools: http://dbtools.vila.bol.com.br - Original Message - From: Muhammad Asif [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 8:11 AM Subject: MySQL tool Is there any tool available for managing graphically databases,tables as well as user and their rights for MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: My sql database and faster queries
Hi, THe maximum number of table joins I ned is not more than three.Most of the search criteria is based on Unique or Primary keys and hence I did not opt for indexing.I am using the default myISAM table types of mysql and mysql C_API. Previously someone suggested using C_API functions over joins will make the queries run faster.The database may have to search for all the queries from about 10 rows in each table. Regards, Ravi --- Brandon Lewis [EMAIL PROTECTED] wrote: The all horrible answer depends. The database is just that, a database, and it is intended to be used to store and retrieve relational data. The structure of your tables, and indexes will play a big role, also table\page\row locking factors in greatly. I am sorry to say the answer is not black and white. Sometimes it is better to pull the data out and process it, sometimes it better to do a little of both. Without details I am afraid I can't help much. -Original Message- From: VVM Ravikumar Sarma Chengalvala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 7:45 AM To: [EMAIL PROTECTED] Subject: My sql database and faster queries Hi, I wonder to know which of the following is better in performance and faster . Using table joins for queries. OR Multiple queries without joins using MySql C API Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL tool
MySqlfront (www.mysqlfront.de) Jay At 08:11 PM 6/6/2001 +0500, you wrote: Is there any tool available for managing graphically databases,tables as well as user and their rights for MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Inserting 307,284 lines. Is this ok?
If I'm not mistaken, MySQL can handle millions or even billions of rows, and there is no real limit to the number that reside in a single table. So Mike Mike relax, you are using a serious database here, not a little toy :) -Ken At 01:20 PM 6/5/01 -0500, Johnny Withers wrote: At boot time you can pass a flag to lilo to force a certian amount of ram.. i think it's something like this: lilo: linux mem=256 307,000 rows in mysql is easy, mysql can handle a lot more rows than that. You shouldn't have any trouble with this amount of data. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Mike Mike [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 11:38 AM To: [EMAIL PROTECTED] Subject: Inserting 307,284 lines. Is this ok? Hello I was wondering if inserting 307,284 is to much to put into one table. Can MySQL handle this? Its a 70MEG File. I have a 550 with 256MEG ram but it only shows 64. I don't know how to make it show 256 and running redhat 6.1. The table has 12 colums and does not have much data in each record. My question is should I break this up into a couple of tables so that each table will have say 50,000 records and I can just search through them with dates. Thanks for any help. --Mike __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Telnet to MySQL (Was port number)
Thanks for your many answers. (mysql port default = 3306) . I can't seem to telnet to port 3306 however, I get a message saying '... not allowed to connect to this mysql server'. I am telneting from a windows machine if this makes a difference. Gene Sanborn
Re: events that i can trigger on intervals.
Sure, that is easy. Just add a column to your room assignment table called something like RELEASE_TIME, and put into that column the time you want the room to be released. Then, whenever you want to release rooms, execute something like DELETE FROM ROOM_ASSIGN WHERE RELEASE_TIME NOW() or if you mark a status flag, do an update instead of a delete. Since PHP is primarily intended for web applications, it might be better to execute this SQL statement via a Perl script that is triggered automatically as a CRON job, assuming you are using a real operating system like Unix or Linux. If you are using Windows, then you will have a tougher time since the operating system is severely lacking in basic services like true batch jobs, powerful scripting languages, etc. I have been a Windows developer ever since 3.0 came out, and I recently got introduced to the wonderful world of Linux. The differences are staggering. Hope this helps. -Ken At 11:27 PM 6/5/01 +0500, Hasan Niyaz wrote: Hi, I have a room inventory. Clients can block rooms them but I want to release them after a specified time if they do not release them normally via the given link. I want to be able to trigger an event to release the rooms after the time limit. Is there any way I can do this with MySQL or PHP. Thanks, Hasan ps. I use a PHP interface. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MYSQL++: List of databases, then tables in each database
Using the MySQL++ library is their any call to 1) Get a list of the databases on the Server 2) List tables in a database given a database name. The best I could find was show databases show tables; or show tables from database name; Does anyone have any examples of how to implement these calls in Visual C++ using the MySQL++ API's ANY INPUT APPRECIATED I am using the Visual C++ library for development under MS VC++ 6 on Windows 2000 Advanced Server. *** Just another quick question; I have a line of code (below) but it does not output the query to the screen. In this case the query is Select * from Employees limit 20 but (below) causes just Query: to be displayed. Query query = con.query(); query select * from Employees limit 20; cout Query: query.preview() endl; Sorry if you get this for a second time - I didn't get much of a response from the plusplus mailing list. I assure you I have checked the web site and manual Thanks lots David Ayliffe (mailto:[EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Getting more than 256 connections with MySQL/Linux
Hi, I am receiving errors when setting max_connections=300 basically anything over 256 ends up giving the error : Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug after 256 connections are open. There is plenty of memory available and checking the docs says you should be able to get up to 1500 : If you are using our binary or RPM version 3.23.25 or later, you can safely set `max_connections' at 1500 I am using these rpm's from the MySQL website: MySQL-3.23.38-1.i386.rpm MySQL-devel-3.23.38-1.i386.rpm MySQL-bench-3.23.38-1.i386.rpm MySQL-shared-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm using a linux 2.2.19 kernel and glibc2.1. Has anyone experienced this problem or know how I can get around it? Many thanks Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Rookie admin needs install help
This is probably a silly question, but I'm a new administrator and could use some help. I'm running a Slackware Linux 2.2.16 and am having difficulty installing MySQL 3.23.38. I have downloaded the following rpm files from www.mysql.com: MySQL-3.23.38-1.i386.rpm MySQL-devel-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-shared-3.23.38-1.i386.rpm Then I used rpm2tgz to convert them to .tgz files, and finally ran installpkg on each of them to do the install. The problem comes when I try to start the MySQL server with safe_mysqld. My machine is named 'patrick'. The command returns: touch: /var/lib/mysql/patrick.err: No such file or directory chown: mysql: invalid user Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/safe_mysqld: /var/lib/mysql/patrick.err: No such file or directory /usr/bin/safe_mysqld: /var/lib/mysql/patrick.err: No such file or directory tee: /var/lib/mysql/patrick.err: No such file or directory 010606 11:30:08 mysqld ended tee: /var/lib/mysql/patrick.err: No such file or directory I have looked, and there doesn't seem to be a /var/lib/mysql directory. Simply creating a blank /var/lib/mysql directory myself seems to generate further errors. Has anyone encountered this before? Patrick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MAC OS X Server
Apple has tested MySQL on MAC OS X to the best of my knowledge. Given that MAC OS X is essentially FreeBSD Unix with a pretty wrapping, it makes sense that MySQL would work easily. If someone said MySQL worked on MAC OS 9, or older, I would be more cautious. At 02:42 PM 6/5/01 -0800, Angela Neff wrote: Below is a link and article sent to me by a Consultant stating that MySQL works with the brand new MAC OS X Server. Has this indeed been thoroughly tested by MySQL programmers? I don't want to get one unless it works like a charm. Also, is there or will there be a MAC My SQL listserv? SOURCE: http://maccentral.macworld.com/news/0106/04.mysql.shtml Thanks, Angela Apple releases MySQL update Staff Report, [EMAIL PROTECTED] June 4, 2001, 4:25 pm ET If you're using a Mac configured with Mac OS X Server and MySQL, you should be aware of a new update in circulation. Apple's Software Downloads Web site now lists a new update for MySQL. MySQL 3.23.32 Update is available for download from Apple's site now. MySQL is a relational database management system developed by MySQL AB. The software exists as open source code, and is able to run on Mac OS X Server. In fact, MySQL is included with Mac OS X server, along with many other applications. The new update lists Mac OS X Server 10.0.3 as required to run the software, so make sure you're running the latest version of Mac OS X Server before downloading the update. Angela Neff :) (: Technology Director St. Matthew's Episcopal Day School 16 Baldwin Avenue San Mateo, California 94401 VOICE: 650.342.5436 x214 FAX: 650.342.4019 E-MAIL: [EMAIL PROTECTED] Growth is more than anything, a refining of a sense of truthfulness. --Willa Cather - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What's the best os?
Jeremy Zawodny wrote: On Fri, Jun 01, 2001 at 12:28:17PM +0400, Ilya Martynov wrote: JZ On Fri, Jun 01, 2001 at 01:45:24AM -0400, David Freeman wrote: JZ Assuming you'll use Apache 2.x one day, I'd lean away from FreeBSD JZ until the threading issues are resolved. I could envision you running JZ 1 threaded MySQL server and 1 threaded Apache server. Under FreeBSD JZ (today), you'd have 2 idle CPUs and 2 busy CPUs because it'd never JZ spread the threads from each server across the CPUs the way you'd JZ like. AFAIK you can compile mysql on FreeBSD with LinuxThreads (they have been ported on FreeBSD). In this case threads will spread across the CPUs as on Linux. Funny you mention that... It comes up once in a while, but almost everytime it's someone saying I've heard that you can... I've yet to meet someone who does it and likes it. I'm not saying it's bad, but it just seems like one of those things that people suggest but don't actually have experience with. I haven't tried this myself, but I noticed that a week or so ago linuxthreads support was added to the mysql323-server port, enabled by building WITH_LINUXTHREADS=1. Matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need help on mysql/php
Actually you are only exposed if you have not set up Apache to run with
virtual hosts. It is not difficult to configure Apache so that a person
can only see the scripts that are in his/her directory, and is prevented
from seeing or modifying the scripts in other peoples directories. Also,
it is wise to place your DB passwords in a separate small file, and then
include the file in all your scripts. You can place the password file in a
directory that doesn't have any accessibility from anyone on the
web. Let's say we have a password file called dbpass.inc, and we place
it in a directory called /var/protected off the root. Only the webserver
is set to have permission to access this directory. The password file
should look something like this:
?php
username=username;
password=password;
?
Then in all your scripts include the following line:
include ('/var/protected/dbpass.inc);
-Ken
At 08:02 PM 6/5/01 -0500, Paul DuBois wrote:
At 10:37 PM +0100 6/5/01, Jorge Oliveira wrote:
Hi again,
You are right, your username and password will have to be on every PHP
script that needs to use database.
However, you don't have to be afraid because nobody can access the source of
your PHP scripts - unless they are a good hacker!
Actually, anyone else on the Web server host that has permission to
install scripts for the Web server can access the source.
I couldn't tell from the original message whether the Web server is
shared with other people or not, but if you don't have your own
server, you're exposed.
I think you should pay a visit to http://www.php.net to understand how PHP
works. Start with the basics and you will see that is reallY VERY simple.
Be cool,
Jorge Oliveira
[EMAIL PROTECTED]
© webfroggie.com - Recursos Online!
web: http://www.webfroggie.com
wap: http://www.webfroggie.com
--
Paul DuBois, [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compiling an PHP 4.0 module with MySQL
I need some help upgrading to PHP 4.0 (version 4.0.5) on my Linux web server running Apache containing a PHP module configured with MySQL. I am trying to install PHP from the source tar downloaded from www.php.net. I am following the installation instructions that say that I can get away without recompiling Apache. The steps in the instructions are: 1 check all library locations are listed in /etc/ld.so.conf and then run ldconfig 2 unpack the php tar, configure then make and install 3 amend the httpd.conf file to: 1) verify the paths, 2) check the Module and Type lines are in place, and 3) remove lines referring to the previous PHP 3.0 installation. At step two above I am running the following to configure the PHP module: ./configure --with-mysql=/usr/bin --with-apxs --enable-track-vars the configuration fails giving the following error: cannot find header files under /usr/bin I am using the path /usr/bin/ because this contains the file mysql, and I also tried /usr/sbin/, because this contains mysqld, but with the same results. If I configure without specifying a path in the --with-mysql option I can make and install and run a PHP script. However, when I run a script containing a MySQL connection statement I get the following error displayed in my browser: can't connect to local MySQL server through socket '/tmp/mysql.sock' The Linux kernel is 2.2.13 and has been installed from a Mandrake distribution. This is also the source of Apache, PHP 3 and MySQL. The distribution puts files in non-standard places so I am wondering if the solution to my problem is to find the right base directory to use in the --with-mysql=/path/ syntax, and/or the header files are in the wrong place. I have searched and tried many option but with no success. Can anybody help me please? Thanks for any help. Keith Attfield (UK)
Re: MySQL Port number
I would suggest you obtain a book on the subject, or visit mysql.com and read the documents under documentation. You are asking questions that have very large answers. To get you started, MySQL is accessed over the web by using a scripting language like PHP or Perl. -Ken At 07:35 PM 6/5/01 -0700, sanborn wrote: How is MySQL used over a network? I assume there is a port involved, and some kind of transaction server built into mysql? How do I configure, test this? In the several documents I have read so far, I haven't found much on the subject. Thanks for your input. Gene Sanborn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: which the best
Hands down, your best bet is either Linux versions. You will get the best stability, speed, and cost effectiveness by using these databases. Stay away from Windows for this kind of thing. I have developed software for the Windows platform since it first came out, and have been a software engineer for 23 years. I don't dislike Windows, but for some things it is just not as good as a Unix platform, and this is one of those cases. Linux is a superior platform. At 11:33 AM 6/6/01 +0700, Sommai Fongnamthip wrote: Dear, I know this is not list for ask about OS, but I wonder to know that which OS you choose for database server in your mind? Linux Red Hat 7.1 Linux Mandrake 8.0 Windows NT 4.0 Windows 2000 Server or anything else from these OS! Regard, Sommai Fongnamthip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to upgrade from source version to RPM version
I'm rather new to Mysql. Here is the deal. I'm currently running mysql-3.23.33 from mysql-3.23.33.tar.gz. Now after reading through documentation. I now know that I should have used the RPM Version because I'm running Redhat Linux 6.2. So I then downloaded the new version MySQL-3.23.38-1.i386.rpm everything installed fine and I was able to set the password the same as the previous version. But when I copied my Data directory over to the new versions Data dir the server would not start and it was giving me access denied errors. Now the passwords are the same and there should be no reasons why it would have failed. I know this because I have previously upgraded the versions but from source not RPM. What did I do wrong or what steps did I miss that should be done when you upgrade from source to RPM? Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with perl
You need to have your script operate in different modes. You do this by passing an argument when you call your script to tell the script what it is supposed to do. So in this case, if the script is called with out any arguments, it will display the form, as follows: http://www.sample.com/sample.pl Then, in your HTML, add a hidden field to your form that provides the action you want to do like this: FORM NAME='test' ACTION='sample.pl' FIELD TYPE='hidden' NAME='action' VALUE='1' Now, when you enter the Perl script again, and you extract the parameters, you will have a parameter called action that has a value of 1. Do a conditional test for this value, and if the value is not assigned, as in the original case, just display the form. If the action is set to 1, do your database update, and then show the form again with the new values. If the user hits the reload button, the page will reload, but the action will not be set causing the page to show with first doing a reset. Only if they hit the submit button will the hidden variable be passed to the script causing the action value to be set. Hope this helps. BTW, all this stuff you are wanting to do is MUCH MUCH MUCH easier in PHP which is quite Perl like is some respects, but is so much easier and more efficient, and it works GREAT with MySQL because is has a bunch of MySQL functions built in. Most top web applications these days are developed around what is called LAMP, which stands for Linux/Apache/MySQL/PHP. This is the winning combination. -Ken At 01:42 AM 6/6/01 -0500, Dawn H wrote: I've written a couple of scripts and have a thing that I haven't quite figured out. If anyone can shed light on this, I'd appreciate it. When a person submits a form that inserts a record into the database, if they then refresh the page that comes up after the submit, the record will be submitted a second time. I suppose this is due to the fact that the subroutine that is called with the submit contains both the write to database bit and the view bit. So refreshing causes a repeat of both items. How can I do this without that problem? Thanks in advance, Dawn H It's practically impossible to look at a penguin and feel angry. --Joe Moore http://www.rdcss.com/ - RD Computer Solutions http://wow.cooncheese.com/ - WOW.CoonCheese.com http://dpenguin.rdcss.com/ - Cornucopia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What is the for in ' safe_mysqld --log '
that's a unix shell command that basicly puts the process in the background. if you type that command at your console you'll notice you get a prompt right away. This allows safe_mysqld to run in the background (somewhat like a daemon) thanks, -- Andrew - Original Message - From: mysql list [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 11:29 AM Subject: What is the for in ' safe_mysqld --log ' I lost track of the tutorial where I saw the command safe_mysqld --log What is the for? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: does show create table work?
I believe show ceate table was added in mysql 3.23 and subsequently 3.22 will not have it. thanks, -- Andrew - Original Message - From: Rob Agar [EMAIL PROTECTED] To: Mailinglist MySQL COM [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 11:48 AM Subject: does show create table work? hi! Does SHOW CREATE TABLE x actually work? When I try it I just get error 1064 (you have an error in your sql syntax near 'CREATE TABLE x') (version 3.22.32 on linux) ta, Rob Agar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with perl
Cindy, read my reply to this. You are mistaken. There is actually a way to make a single script do all kinds of different operations. I have single scripts that show a list of records, add a new record, update a record, and delete a record, all in the same script. This is more efficient to do because if the webserver is configured correctly, it will cache the script thereby preventing re-compilation of the script code. -Ken At 12:18 AM 6/6/01 -0700, Cindy wrote: Dawn H writes: I've written a couple of scripts and have a thing that I haven't quite figured out. If anyone can shed light on this, I'd appreciate it. When a person submits a form that inserts a record into the database, if they then refresh the page that comes up after the submit, the record will be submitted a second time. I suppose this is due to the fact that the subroutine that is called with the submit contains both the write to database bit and the view bit. So refreshing causes a repeat of both items. How can I do this without that problem? I was finally forced to add a check that there wasn't already an identical record (using a minimum comparison set of fields) before inserting the record. There really isn't any way to prevent dingbats from refreshing, so... I CYA by emailing a copy of the record/element values to myself when I refuse to add it in, but I havne't had any spurious refusals so far. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Log file size
Look into the Linux logrotate daemon. It allows you to configure what happens with logs. At 06:44 AM 6/6/01 -0400, Peter Billson wrote: I'm running mySQL on Linux and was wondering is there a way to limit the maximum log file size? From time to time I have written a bad script that will query mySQL in a loop (BTW - mySQL can do *lots* of queries/second!) without me realizing my mistake until I run out of room on my log partition which causes all kinds of Bad things to happen. I don't want to reduce the log detail, because normally my logs are just fine, just would like to be able to suspend logging when there is only x% of disk space left. Pete -- http://www.elbnet.com ELB Internet Services, Inc. Web Design, Computer Consulting, Internet Hosting - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Browser Based Mailing List
This has to have been asked before, but I can't find it in the database archives... Is there a web browser based version of this mailing list anywhere? Thanks, Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Recommended ISP (query,mysql)
Hi David, I recommend you AletiaHosting.com as they provide full service at a lower cost... If you wnat a cheaper service you may try Whizhost.com but they are known to have some problems here and there. I have two sites: webfroggie.com and desportoradical.com. The first at whizhost and the second at aletiahosting. From my experience I would have to say that aletiahosting is far more reliable and it's worth the price difference. Jorge Oliveira [EMAIL PROTECTED] © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com - Original Message - From: mscworld To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 10:38 AM Subject: Recommended ISP Hello, My current Domain hosting company charges me US$28.95 for hosting with MYsql support. I am looking a lower cost service provided who can provide normal domain hosting with MYSQL , PERL and PHP support without sacrificing server stablity or up-time. Any recommendation from you all?? regards, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Recommended ISP
Hi, Check out PHP4Hosting at : http://www.php4hosting.com They give what you want for about $10 including root access to Mysql. Regards, David Stubbings - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Rookie admin needs install help
Well today just isn't my day. My mail forwarding was broken till just now. If you responded to this question earlier, could you please send the response to [EMAIL PROTECTED] again? Thank you, patrick - Original Message - From: Patrick Malone [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 12:22 PM Subject: Rookie admin needs install help This is probably a silly question, but I'm a new administrator and could use some help. I'm running a Slackware Linux 2.2.16 and am having difficulty installing MySQL 3.23.38. I have downloaded the following rpm files from www.mysql.com: MySQL-3.23.38-1.i386.rpm MySQL-devel-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-shared-3.23.38-1.i386.rpm Then I used rpm2tgz to convert them to .tgz files, and finally ran installpkg on each of them to do the install. The problem comes when I try to start the MySQL server with safe_mysqld. My machine is named 'patrick'. The command returns: touch: /var/lib/mysql/patrick.err: No such file or directory chown: mysql: invalid user Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/safe_mysqld: /var/lib/mysql/patrick.err: No such file or directory /usr/bin/safe_mysqld: /var/lib/mysql/patrick.err: No such file or directory tee: /var/lib/mysql/patrick.err: No such file or directory 010606 11:30:08 mysqld ended tee: /var/lib/mysql/patrick.err: No such file or directory I have looked, and there doesn't seem to be a /var/lib/mysql directory. Simply creating a blank /var/lib/mysql directory myself seems to generate further errors. Has anyone encountered this before? Patrick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: does show create table work?
I believe SHOW CREATE TABLE was added in 3.23.20... http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html http://www.mysql.com/doc/N/e/News-3.23.20.html On Wed, 6 Jun 2001, Rob Agar wrote: hi! Does SHOW CREATE TABLE x actually work? When I try it I just get error 1064 (you have an error in your sql syntax near 'CREATE TABLE x') (version 3.22.32 on linux) ta, Rob Agar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Importing spreadsheet data into MySQL
Hi there Yes you can do this by going into Access and op[ening the XLS file from there then importing it into a table. This meaning you have a database from where you can move it over to mySQL's table via ODBC connection or how you like moving it from DB to DB. I hope this helps Johannes At 08:15 06/06/2001 -0500, you wrote: Is it possible to import spreadsheet data (Excel) into MySQL? I have data on about 2,500 retail locations that I must place into a database on the web and I do not want to type them by hand if I can avoid it. Thanks, Chris Gray --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.256 / Virus Database: 129 - Release Date: 5/31/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
