How to Archive and restore the data in MySQL database.

2003-02-08 Thread Prasad Budim Ram
Hi, Can any of you give me links about Archiving and restoring the data in MySQL database. Are there any utilities for the same? Thanks in advance, Ram - Before posting, please check: http://www.mysql.com/manual.php

Re: Storing a BLOB in a MySQL database with the MySQL C API

2003-02-03 Thread Stephane Wirtel
compare the OUTPUT with the INPUT, and i don't have errors. But when i use a temporary buffer, i have an error. i have this problem with my mysql database. there is a differenct character. perhaps I have an error in my transfer of data with MySQL, or with a simple char *tmp Could i send you my code

Storing a BLOB in a MySQL database with the MySQL C API

2003-02-02 Thread Stephane Wirtel
d'insertion dans la DB); } g_free(data); g_free(query); mysql_close(mysql); return 0; } But when i edit the mysql database with mysqlcc utility, i don't the complete file. now, when i read the Blob from the database, i use this source code. #include glib.h

Re: Storing a BLOB in a MySQL database with the MySQL C API

2003-02-02 Thread Paul DuBois
At 15:21 +0100 2/2/03, Stephane Wirtel wrote: Hi all ! I would like to insert a Blob ( a picture exactly ), here is a small source code to test my insert. You can find 2 sources code, the first is to insert a blob in a table of a database ( this database exists in my MySQL server ) And the

Re: Recover mysql database from hotbackup. This is Urgent!!!

2003-01-27 Thread Heikki Tuuri
Anne, - Original Message - From: Anne [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, January 27, 2003 7:35 PM Subject: Recover mysql database from hotbackup. This is Urgent!!! Hi, We are performing daily hotbackup of the mysql database using the script which uses

Searching a MySQL database

2003-01-16 Thread Tim Thorburn
Hi, I've got a script setup to search two tables in a MySQL database. The first page asks the user to select which table they'd like to search, and then enter in some key words. The second page then determines which table the user selected and performs the search. Right now, I'm going

Re: host table in mysql database

2003-01-11 Thread Paul DuBois
the tables in the mysql database first. :-) Thanks in advance, Guy. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

RE: MySQL Database Design

2003-01-10 Thread M Wells
) VALUES (3,3,.5); -Original Message- From: Colaluca, Brian [mailto:[EMAIL PROTECTED]] Sent: Friday, 10 January 2003 6:56 AM To: [EMAIL PROTECTED] Subject: MySQL Database Design I am in the midst of designing a personal database for keeping track of wines. After perusing through several

RE: MySQL Database Design

2003-01-10 Thread JamesD
ID a4 wine3 x 2 nulls ===end chatter -Original Message- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 6:09 PM To: Colaluca, Brian Cc: [EMAIL PROTECTED] Subject: Re: MySQL Database Design

Fwd: Re: Copying MySql database to others

2003-01-10 Thread Frank Peavy
-0800 To: Stefan Hinz, iConnect \(Berlin\) [EMAIL PROTECTED], [EMAIL PROTECTED] From: Frank Peavy [EMAIL PROTECTED] Subject: Re: Copying MySql database to others Thanks everyone for your input. Stefan, From, within phpMyAdmin? snip 1. In the left frame, choose the database you want to backup

Re: Copying MySql database to others

2003-01-10 Thread Frank Peavy
Stefan, Let's say, you exported database my_database, and you saved the export file as c:\mysql\my_database_export.sql on your QA machine. You can import it with this command (assuming that database my_database exists on your QA machine, but has no tables in it): c:\mysql\bin mysql -uusername

Re: Copying MySql database to others

2003-01-10 Thread Stefan Hinz, iConnect \(Berlin\)
PROTECTED] Sent: Friday, January 10, 2003 8:09 PM Subject: Re: Copying MySql database to others Stefan, Let's say, you exported database my_database, and you saved the export file as c:\mysql\my_database_export.sql on your QA machine. You can import it with this command (assuming that database

Re: Copying MySql database to others

2003-01-09 Thread Frank Peavy
and field names with backquotes if your table or column names might contain special characters (like ä, ö, ü). 6. Check Save as file. 7. Click Go. Since I have limited command line access (ISP hosted database), I will probably have to use phpMyAdmin. Part of my logic was to copy my MySql database

MySQL Database Design

2003-01-09 Thread Colaluca, Brian
I am in the midst of designing a personal database for keeping track of wines. After perusing through several beginner books on MySQL and PHP, I have decided that my next step would be to embark upon database design. My design is almost complete and normalized, although I do expect to be

Re: Copying MySql database to others

2003-01-09 Thread Stefan Hinz, iConnect \(Berlin\)
Frank, Since I have limited command line access (ISP hosted database), I will probably have to use phpMyAdmin. Part of my logic was to copy my MySql database to another MySql database, so that I can use the second database for QA purposes. When I perform the Export as above, does that make

RE: MySQL Database Design

2003-01-09 Thread Jennifer Goodie
on the naming conventions I have illustrated. Use what you like best. -Original Message- From: Colaluca, Brian [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 12:56 PM To: [EMAIL PROTECTED] Subject: MySQL Database Design For instance, let's say that wine XYZ has 80% GrapeA

Re: MySQL Database Design

2003-01-09 Thread Michael T. Babcock
Colaluca, Brian wrote: I have come to a brick wall on one facet of my design, however. I've come to understand that having a lot of NULLs in your database may be a sign of a poor design. And yet I'm having a problem reconciling this with the wildly un-uniform world of wines from around the

host table in mysql database

2003-01-09 Thread Guy Waugh
Hi there, I'm cleaning up MySQL permissions on one of my servers, and I see that in the mysql.host table, there are 8 rows. All 8 rows contain specific hosts in the 'Host' column (i.e. no wildcards) and specific databases in the 'Db' column. Further, all rows in all privilege columns in the

Re: Copying MySql database to others

2003-01-08 Thread Frank Peavy
I need to copy a MySql Production database to QA. What is the best method of doing this? Do I need to write SQL queries or is there another quicker method? From the command line? From, within phpMyAdmin? - Before posting,

Re: Copying MySql database to others

2003-01-08 Thread Stefan Hinz, iConnect \(Berlin\)
) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Frank Peavy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 6:18 PM Subject: Re: Copying MySql database to others I need to copy a MySql Production database to QA. What is the best method

Re: Copying MySql database to others

2003-01-08 Thread Frank Peavy
and field names with backquotes if your table or column names might contain special characters (like ä, ö, ü). 6. Check Save as file. 7. Click Go. Since I have limited command line access (ISP hosted database), I will probably have to use phpMyAdmin. Part of my logic was to copy my MySql database

RE: Using MS Access as front end to mysql database

2002-12-16 Thread Fernando Grijalba
To: [EMAIL PROTECTED] Subject: Using MS Access as front end to mysql database We have been informed by our web hosting site that we cannot connect remotely to our mysql database using any kind of connection other than a script from a web page or phpMyAdmin. It is our intent to have our data stored

RE: Using MS Access as front end to mysql database

2002-12-16 Thread Mike Grabski
: RE: Using MS Access as front end to mysql database Just be careful because the connection can be looked at and if there is sensitive data going through someone who wants to can get their hands on it. The data travelling from the server to the client is not encripted and as far as I know

Using MS Access as front end to mysql database

2002-12-14 Thread Donna Flanders
We have been informed by our web hosting site that we cannot connect remotely to our mysql database using any kind of connection other than a script from a web page or phpMyAdmin. It is our intent to have our data stored in a mysql database on the web and use MS Access as the front end

RE: Using MS Access as front end to mysql database

2002-12-14 Thread JamesD
as front end to mysql database We have been informed by our web hosting site that we cannot connect remotely to our mysql database using any kind of connection other than a script from a web page or phpMyAdmin. It is our intent to have our data stored in a mysql database on the web and use MS

RE: Using MS Access as front end to mysql database

2002-12-14 Thread Michael She
PROTECTED] Subject: Using MS Access as front end to mysql database We have been informed by our web hosting site that we cannot connect remotely to our mysql database using any kind of connection other than a script from a web page or phpMyAdmin. It is our intent to have our data stored

Re: Users and their priveleges in a mySQL Database

2002-12-03 Thread Roger Baklund
* Andi S. Giri Can mysql have different tables for different users ? Yes. Say user 'TEST1' creates a table called 'XYZ' and also user 'TEST2' creates the same table name 'XYZ' Is it allowed ? Yes, if you give each user his own database. If it is, can this two tables can be accesed by a

re: Users and their priveleges in a mySQL Database

2002-12-03 Thread Victoria Reznichenko
Andi, Tuesday, December 03, 2002, 8:52:33 AM, you wrote: ASG Can mysql have different tables for different users ? Say user 'TEST1' ASG creates a table called 'XYZ' and also user 'TEST2' creates the same table ASG name 'XYZ' ASG Is it allowed ? Yes. Table names must be unique within a database.

RE: backing up mySQL database ?

2002-12-02 Thread David Brodbeck
-Original Message- From: Neil Tompkins [mailto:[EMAIL PROTECTED]] Can anyone recommend a software app. I could buy to be able to dump data and table structures to a text file. Ideally as mentioned before I need to run this on a hourly basis. Backing up the entire database

Users and their priveleges in a mySQL Database

2002-12-02 Thread Andi S. Giri
Hello Can mysql have different tables for different users ? Say user 'TEST1' creates a table called 'XYZ' and also user 'TEST2' creates the same table name 'XYZ' Is it allowed ? If it is, can this two tables can be accesed by a third user say 'Superuser' provided the priveleges are given by

Re: backing up mySQL database ?

2002-12-01 Thread Neil Tompkins
and table structures to a text file. Ideally as mentioned before I need to run this on a hourly basis. Rgds, Neil From: Gerald R. Jensen [EMAIL PROTECTED] Reply-To: Gerald R. Jensen [EMAIL PROTECTED] To: Neil Tompkins [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: backing up mySQL database

Re: backing up mySQL database ?

2002-12-01 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Neil, et al -- ...and then Neil Tompkins said... % % Hi Hi! % % Thanks for that information. But I think I want to purchase a software % application, due to my lack of knowledge for mySQL. In addition to this, % my ISP doesn't allow that

backing up mySQL database ?

2002-11-30 Thread Neil Tompkins
Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g

Re: backing up mySQL database ?

2002-11-30 Thread Joe Stump
, November 30, 2002 10:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front

Re: backing up mySQL database ?

2002-11-30 Thread Gerald R. Jensen
] Sent: Saturday, November 30, 2002 9:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used

Re: backing up mySQL database ?

2002-11-30 Thread Neil Tompkins
I rent my mySQL database from my ISP would this be a problem ? Maybe you provide me with a simple example ? Since I'm very new to mySQL and have no knowledge of unix. Thanks Neil From: Gerald R. Jensen [EMAIL PROTECTED] Reply-To: Gerald R. Jensen [EMAIL PROTECTED] To: Neil Tompkins [EMAIL

Re: backing up mySQL database ?

2002-11-30 Thread Gerald R. Jensen
: # Make backups of databases at 4am daily 0 4 * * * /usr/local/bin/mydbbak.sh - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:11 PM Subject: Re: backing up mySQL database ? I rent my mySQL database from

Moving a MySQL database

2002-11-13 Thread Rick Root
I need to move a whole bunch of web sites from one server to another. This means moving cold fusion, MySQL, qmail, etc.. fun stuff. What's the best way to move *ALL* of the MySQL databases on my system? Do I basically just shut down the database, tar up the /var/lib/mysql directory and move it

Uploading a file into a MySQL database

2002-11-10 Thread Jean-Yves Besserer
Bonjour, I just would like to know if there is a way to upload and store a file via query into a BLOB field... Anyone ? Cordiales salutations, -- --- Jean-Yves Besserer Dial / Taskers Art Designers http://Taskers.ovh.org Dial on IRCnet amigafr, #artbas, #bigboss ICQ #51667972

Re: Uploading a file into a MySQL database

2002-11-10 Thread Jean-Yves Besserer
Hello John On 10/11/2002, you wrote: Here's some example code from PHP if (strlen(trim($strPicture)) 0 strlen(trim($strPicFieldName)) 0) { $fp = fopen($strPicture,rb); $bArray = fread($fp,$strFileSize); fclose($fp); $strQuery = UPDATE . $tableName .

publishing mysql database to cd-rom

2002-11-06 Thread ROBERT MCPEAK
I've got a web-based mysql database solution that I'd like to publish to cd-rom. It's a catalog solution using PHP and mySQL. Is it possible to publish a website such as this to a cd-rom as a stand-alone application? Could somebody point me towards some resources for doing this or outline

publishing mysql database to cd-rom

2002-11-06 Thread ROBERT MCPEAK
I've got a web-based mysql database solution that I'd like to publish to cd-rom. It's a catalog solution using PHP and mySQL. Is it possible to publish a website such as this to a cd-rom as a stand-alone application? Could somebody point me towards some resources for doing this or outline

publishing mysql database to cd-rom

2002-11-06 Thread ROBERT MCPEAK
I've got a web-based mysql database solution that I'd like to publish to cd-rom. It's a catalog solution using PHP and mySQL. Is it possible to publish a website such as this to a cd-rom as a stand-alone application? Could somebody point me towards some resources for doing this or outline

RE: publishing mysql database to cd-rom

2002-11-06 Thread Salada, Duncan
Systems Corporation 301-925-3222 x375 -Original Message- From: ROBERT MCPEAK [mailto:RMCPEAK;jhuccp.org] Sent: Wednesday, November 06, 2002 3:03 PM To: [EMAIL PROTECTED] Subject: publishing mysql database to cd-rom I've got a web-based mysql database solution that I'd like to publish

RE: publishing mysql database to cd-rom

2002-11-06 Thread ROBERT MCPEAK
/microweb.htm. Duncan --- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -Original Message- From: ROBERT MCPEAK [mailto:RMCPEAK;jhuccp.org] Sent: Wednesday, November 06, 2002 3:03 PM To: [EMAIL PROTECTED] Subject: publishing mysql database

How to distribute a MySQL database?

2002-10-12 Thread Tim Collins
Hi folks, I am using the MySQL C++ API to put together a football management game. I won’t bore anyone with the implementation details, basically I would like to know how to distribute the game’s database so that an end-user does not need to have MySQL installed to run it. I am running MySQL

Creating a DataSource and Connection in Tomcat for MYsql Database

2002-10-08 Thread Arul
Hi All I had created a DataSource in Tomcat Admin Console. But i am not getting a connection ds.getConnection() results in error. The error is java.sql.SQLException : cannot load JDBC Driver class null But while creating the datasource i had given the driverclassname as

Re: Creating a DataSource and Connection in Tomcat for MYsql Database

2002-10-08 Thread Niclas Hedhman
On Tuesday 08 October 2002 22:29, Arul wrote: Hi All I had created a DataSource in Tomcat Admin Console. But i am not getting a connection ds.getConnection() results in error. The error is java.sql.SQLException : cannot load JDBC Driver class null But while creating the datasource i

connecting to mysql database from php...

2002-10-03 Thread Allen Wayne Best
hi all: i am attempting to connect to a mysql database from php, using the following syntax in the php: $dsn = mysql://webuser@localhost/doug ; $db = DB::connect( $dsn ) ; if ( DB::isError($db) ) { print $dsn.\n ; die( $db-getMessage().\n ) ; } i get this message: mysql

replacing/choosing a mysql database

2002-09-24 Thread lin ad
I have installed Mysql and php on my rh 7.3 while installing o/s. I have tested php server and is working. I have been sent a database to use (file.sql) but am having difficulties figuring out where to put this file. When I try to connect to 127.0.0.1 get error unable to connect to database. I

new mysql database

2002-09-24 Thread lin ad
first, when i installed rh 7.3 i chose mysql and php and apache, i have tested apache and php independently and they work fine. next i can login into mysql with mysql -utest fine, basically, i have the mysql server running but never had a database. now i have a database but i don't know where

RE: new mysql database

2002-09-24 Thread Nestor Florez
To: [EMAIL PROTECTED] Subject: new mysql database first, when i installed rh 7.3 i chose mysql and php and apache, i have tested apache and php independently and they work fine. next i can login into mysql with mysql -utest fine, basically, i have the mysql server running but never had a database

RE: new mysql database

2002-09-24 Thread Chris Kay
To: [EMAIL PROTECTED] Subject: new mysql database first, when i installed rh 7.3 i chose mysql and php and apache, i have tested apache and php independently and they work fine. next i can login into mysql with mysql -utest fine, basically, i have the mysql server running but never had

Problem displaying results from MySQL database

2002-09-18 Thread Robert McKerlie
Hi I have a php script that 'should' get data from a MySQL database and display it in a web page. When I test the script using 'zend development environment' the output appears fine, all the data records, html tags and all. When I try and run it from a browser I keep getting a parse error

Mysql database lockup (v3.23.49)

2002-09-10 Thread Kevin Slean
All, We are experiencing a strange problem where one minute everything is running fine on mysql, then the next minute, all queries seem to lockup. Can anybody provide guidance to me so I can determine the cause of the lockups? So far I dump the proc logs every minute via cron. I have found

stocking pictures in mysql database ?

2002-09-06 Thread navarra/mail.satori.fr
Hello, How can i stocking pictures in mysql database ? i've tried to open a file as binary, i've replaced ascii(0) by '\O', etc. i've done an 'insert into table set field='datas'' but doesn't work please help me Pierrot

Re: stocking pictures in mysql database ?

2002-09-06 Thread Gerald R. Jensen
: Friday, September 06, 2002 3:57 AM Subject: stocking pictures in mysql database ? Hello, How can i stocking pictures in mysql database ? i've tried to open a file as binary, i've replaced ascii(0) by '\O', etc. i've done an 'insert into table set field='datas'' but doesn't work please help

Re: stocking pictures in mysql database ?

2002-09-06 Thread Gurhan Ozen
Hi, You have to use LOAD_FILE() function to load a file into a blob column. See:http://www.mysql.com/doc/en/String_functions.html Gurhan On Fri, 2002-09-06 at 04:57, navarra/mail.satori.fr wrote: Hello, How can i stocking pictures in mysql database ? i've tried to open a file as binary

Mysql database permissions questions

2002-08-16 Thread Paras pradhan
hi all when i connect to my mysql database server using mysql -h a.b.c.d -u xyz -pmypass It logs on and it's fine and in mysql shell when i do use mysql then it is allowing me to acess the mysql default mysql database. i dunn't want this. when i type use mysql then it sud say access

RES: Mysql database permissions questions

2002-08-16 Thread Ray da Costa
. Ass.: RaydaCosta -Mensagem original- De: Paras pradhan [mailto:[EMAIL PROTECTED]] Enviada em: Sexta-feira, 16 de Agosto de 2002 09:08 Para: [EMAIL PROTECTED] Assunto: Mysql database permissions questions hi all when i connect to my mysql database server using mysql -h a.b.c.d

Mysql database of Net

2002-08-16 Thread Ray da Costa
. Ass.: RaydaCosta -Mensagem original- De: Ray da Costa Enviada em: Sexta-feira, 16 de Agosto de 2002 09:18 Para: 'Paras pradhan'; [EMAIL PROTECTED] Assunto: RES: Mysql database permissions questions Expensive colleagues, all good! I am here in the Brazil! I need an aid to have access

Re: Mysql database replication

2002-08-14 Thread Gerald Clark
I highly recommend you update the slave to the same version as the master. Mark D. Wallace wrote: I'm trying to set up a replication database and cannot get the slave to parse the log files on the master. The slave is connecting to the master as indicated in the log file. I have tried to

Mysql database replication

2002-08-13 Thread Mark D. Wallace
I'm trying to set up a replication database and cannot get the slave to parse the log files on the master. The slave is connecting to the master as indicated in the log file. I have tried to connect directly to the master database from the mysql client on the slave and have no problem using

Re: MySQL database design, one column, 10 entries?

2002-08-11 Thread Quinten Steenhuis
2002, david wrote: Date: Sun, 11 Aug 2002 00:43:14 -0400 From: david [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MySQL database design, one column, 10 entries? I am creating several tables in MySQL and linking via primary keys. I am held up on one issue, for one row in one table i have

MySQL database design

2002-08-11 Thread trogers
MySQL queries.. tables... design. http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif There you will see a rough draft of what I am trying to do. Perhaps you will see some places that I will need to use a table_map? Or you can advise me of how to arrange my keys, or otherwise develop this db?

Re: MySQL database design

2002-08-11 Thread Pekka Saarinen
At 8/11/2002, you wrote: MySQL queries.. tables... design. http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif There you will see a rough draft of what I am trying to do. Perhaps you will see some places that I will need to use a table_map? Or you can advise me of how to arrange my keys, or

lost mysql database tables

2002-08-11 Thread Dave Reinhardt
I seem to have lost the mysql database tables. I have other databases that work. what is the best way to add the right tables to mysql Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: lost mysql database tables

2002-08-11 Thread Iikka Meriläinen
Hello Dave, Phew... what a situation! ;-) You can always run mysql_install_db script on *NIX, but it clears your existing permissions. On Windows you can do an xcopy for your mysql database from the distribution package, but that doesn't save your permissions, either. First, though, make sure

Re: MySQL database design

2002-08-11 Thread trogers
on 8/11/02 2:47 PM, Pekka Saarinen, typed: At 8/11/2002, you wrote: MySQL queries.. tables... design. http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif There you will see a rough draft of what I am trying to do. Perhaps you will see some places that I will need to use a table_map?

Re: MySQL database design

2002-08-11 Thread Pekka Saarinen
At 8/11/2002, you wrote: I believe that what you called intermediate table books are calling table map, or something with the word map in it. Hi Lloyd, Books are nice to have (you can lie down to a sofa or sit in the loo with a book), and what I started with (SAMS Teach Yourseft MySQL in 21

MySQL database design, one column, 10 entries?

2002-08-10 Thread david
I am creating several tables in MySQL and linking via primary keys. I am held up on one issue, for one row in one table i have a column 'favorites' where i want to hold up to 10 unique entries, how do i implement this? userTable userId varchar(20) name varchar(30) email varchar(40)

Re: MySQL database design, one column, 10 entries?

2002-08-10 Thread Bhavin Vyas
I am not very sure I understand the questionbut maybe column type 'enum' is what you are looking for. - Original Message - From: david [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 10, 2002 9:43 PM Subject: MySQL database design, one column, 10 entries? I am

RE: MYSQL Database updates

2002-07-23 Thread Ingrid Kast Fuller
I need help with MySQL. I just moved my servers and have new DNS names and IP addresses. I need to update the databases to reflect the changes. I used PhpAdmin to make some of the changes, but I am still getting Internal Server Error's. Any help in directing me for help would be appreciated.

MySQL Database Designer

2002-07-17 Thread Daniel Kiss
Hi all, I have created a Database Designer for the MySQL databases on Windows. I wanted to attach it to this mail, but it's more than 300K, so I wouldn't be a good idea to send it to the mailing list, I think. But I would like some of you to check it out. So, if you would like to be a beta

need help conceptualizing my first mySQL database

2002-06-26 Thread Timothy J. Luoma
I'm trying to figure out how to setup my first mySQL DB... I hope this isn't too OT for this list. The DB will serve several purposes, which I think will each go into a different table w/in one DB. Here's what I want to be able to accomplish: pull up a listing of: 1) names and email addresses

Re: Can I connect to a MySQL Database on a unix platform from a PC?

2002-06-13 Thread Francisco Reinaldo
! --- Liqiang Feng [EMAIL PROTECTED] wrote: As a potential MySQL customer, I am trying to find the answer to the question Can I connect to a MySQL Database on a unix platform from a PC through TCP/IP network? If the answer is yes, what other additional supporting software will be needed

Re: Can I connect to a MySQL Database on a unix platform from a PC?

2002-06-13 Thread Mark.Andrachek
To: Liqiang Feng [EMAIL PROTECTED] cc: MySQL [EMAIL PROTECTED] Subject:Re: Can I connect to a MySQL Database on a unix platform from a PC? Hi, I've been able to connect from an Windows XP to a HP Solaris and LINUX. Make sure that you can ping the UNIX computer from

Fw: mysql database quota problems.

2002-06-07 Thread asong
- Original Message - From: asong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 07, 2002 8:40 AM Subject: mysql database quota problems. Hello, I want to set quota to mysql database by every database or by every user, I can not find any issues from mysql official

mysql database quota problems.

2002-06-06 Thread asong
Hello, I want to set quota to mysql database by every database or by every user, I can not find any issues from mysql official website, and I don't think the Linux or FreeBSD File System quota solution is effective, who can help me? Thank you in adanced. Regards, Asong

Can I connect to a MySQL Database on a unix platform from a PC?

2002-06-05 Thread Liqiang Feng
As a potential MySQL customer, I am trying to find the answer to the question Can I connect to a MySQL Database on a unix platform from a PC through TCP/IP network? If the answer is yes, what other additional supporting software will be needed on the Unix platform and on the PC? Any pointers

Re: Can I connect to a MySQL Database on a unix platform from a PC?

2002-06-05 Thread Dan Nelson
In the last episode (Jun 05), Liqiang Feng said: As a potential MySQL customer, I am trying to find the answer to the question Can I connect to a MySQL Database on a unix platform from a PC through TCP/IP network? If the answer is yes, what other additional supporting software

Re: Can I connect to a MySQL Database on a unix platform from a PC?

2002-06-05 Thread Hisseine Dj.
As a potential MySQL customer, I am trying to find the answer to the question Can I connect to a MySQL Database on a unix platform from a PC through TCP/IP network? If the answer is yes, what other additional supporting software will be needed on the Unix platform and on the PC? Any pointers

Re: mysql database quota solution for help!!

2002-06-02 Thread Benjamin Pflugmann
archive as quota issues come up regularly and you may find an answer there. Bye, Benjamin. On Sat 2002-06-01 at 17:54:43 +0800, [EMAIL PROTECTED] wrote: mysql database quota solution for help!! -- [EMAIL PROTECTED

mysql database quota solution for help!!

2002-06-01 Thread asong
mysql database quota solution for 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

MySql Database Compare

2002-05-28 Thread Thi Cao
All, Is there a good GUI application out there that allows me to compare two mysql databases and view the differences? Thanks, Thi - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re[2]: query for search on mysql database

2002-05-15 Thread Aleksandar Bradaric
been filled in. Need some pointers on how to start that. Thanks! Mike - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: MikeParton [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 3:49 PM Subject: RE: query for search on mysql database

Re: MySQL database files

2002-05-15 Thread Augey Mikus
Those files got so big that I had no more space on my hard drive and queriess would stop returning without any message telling me what was going on. All for the log files? Doesn't that seem like something that should be changed (atleast for the default install) ? It seems to me that there

Re: Re: MySQL database files

2002-05-15 Thread Victoria Reznichenko
Augey, Wednesday, May 15, 2002, 4:25:15 PM, you wrote: AM Those files got so big that I had no more space on my hard drive and AM queriess would stop returning without any message telling me what was AM going on. All for the log files? Doesn't that seem like something that AM should be

RE: query for search on mysql database

2002-05-14 Thread Roger Baklund
* Aman Raheja I am making a search program. I am looking for a query. I want to allow the user to search Any or All. Anyhow, suppose the database contains the following Author | Rim Torus | | Jerry Pal Deprado | | Roan P. Classy | ---

query for search on mysql database

2002-05-14 Thread Aman Raheja
Hi All I am making a search program. I am looking for a query. I want to allow the user to search Any or All. Anyhow, suppose the database contains the following Author | Rim Torus | | Jerry Pal Deprado | | Roan P. Classy | --- If the user

Re: query for search on mysql database

2002-05-14 Thread MikeParton
for search on mysql database * Aman Raheja I am making a search program. I am looking for a query. I want to allow the user to search Any or All. Anyhow, suppose the database contains the following Author | Rim Torus | | Jerry Pal Deprado | | Roan P

RE: query for search on mysql database

2002-05-14 Thread Roger Baklund
* MikeParton I have a similar query in a PHP script. I want to allow users to use fields in a page to search for the records. BUT, I want them to be able to enter the first few characters. I would think my query, below, would do it (the entire search works when the WHERE statement has

Re: query for search on mysql database

2002-05-14 Thread MikeParton
in. Need some pointers on how to start that. Thanks! Mike - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: MikeParton [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 3:49 PM Subject: RE: query for search on mysql database * MikeParton I have

Re: query for search on mysql database

2002-05-14 Thread MikeParton
PM Subject: Re: query for search on mysql database I think that was what roger is saying. If you simply change the OR's to AND's your searchwill work as you want it to. For example some one looks for a person by the last name of Smith.so all the other fields will be blank and your statement

RE: query for search on mysql database

2002-05-14 Thread Roger Baklund
* MikeParton I guess what might help is to explain that the form fields are on a page with method=POST action=results.php The sql I provided originally is in results.php and I use the superglobal $_POST to pull the variables from the form field. I want the query results to be based on the

MySQL database files

2002-05-14 Thread Augey Mikus
what are the host-bin.001 002 003 etc.. files in the mysql_dir/var directory? On my system they range in size from bytes to gigs. What are they and can they be cleaned? Augey - Before posting, please check:

Re: query for search on mysql database

2002-05-14 Thread MikeParton
on mysql database Maybe :) Ok, I'm still a bit confused on how you are doing it, but it sounds like to much workfor me :) Here is what I would do. You have your search.php which holds the search form. You take whatever the values of the fields the user enters and post them to a secondpage

Re: MySQL database files

2002-05-14 Thread Dicky Wahyu Purnomo
On Tue, 14 May 2002 18:49:48 -0400 Augey Mikus [EMAIL PROTECTED] wrote: what are the host-bin.001 002 003 etc.. files in the mysql_dir/var directory? On my system they range in size from bytes to gigs. What are they and can they be cleaned? it's mysql binary log file ... if you don't

Re: MySQL database files

2002-05-14 Thread Ritu Singla
they r the binary log files... Ritu On Tue, 14 May 2002, Augey Mikus wrote: what are the host-bin.001 002 003 etc.. files in the mysql_dir/var directory? On my system they range in size from bytes to gigs. What are they and can they be cleaned? Augey

problem with password auth in mysql-database

2002-05-13 Thread Dennis Peyerl
Hello dear group I have a problem with an authentication in mysql. I got a database-table 'user' with columns for 'login' and 'passwort' and several other columns. A customer shall be able to enter his UserID and Password into fields (html input types) and these are posted to the following

<    1   2   3   4   5   6   7   8   >