Re: Dumb Question - Moving Data from Access to MySQL

2003-09-22 Thread Daniel Kasak
Jeremy Proffitt wrote: Dumb Question. I need to move my data from their current access database to my new MySQL server through an ODBC connection. The tables on both ends are set up identially. I have added a linked table to the access database called EXPARTAB1. The data is in EXPARTAB. I tri

Question about hot/unattended backups of mysql...

2003-09-22 Thread Mike Klein
I would like to cron my backups... I currently have the following items on my list: mysql, ldap, various files/directories, kerberos, etc. I'm needing the following questions answered: 1. How to 'cleanly'/securely propagate mysql backup user credentials to mysqldump. This will be a user with ful

trying to figure out error in PHP/MySQL

2003-09-22 Thread Will Johnston
Hello, I'm new to the group and hoping someone can help me figure out a problem which must be fairly common to new PHP/MySQL users. I have PHP/MySQL/Apache installed on my Windows XP system. I'm using a supplied PHP script for making calls from Actionscript to MySQL. The calls work great on a remot

Amount of memory: rule of thumb

2003-09-22 Thread Hoeven, Maarten van der
Hi all, Is there a rule of thumb how much internal memory you should install, when pursuing maximum performance? A rule of thumb like: "Internal memory should be equal or more than the size of the database". Example: total database size=3 GB; therefor internal memory should be at least 3 Gb. Is t

Excel 2 CSV into phpMyAdmin

2003-09-22 Thread iamcarmoda
is there a trick to saving Excel spreadsheets into a CSV format that will import into MySQL or phpMyAdmin reliably? my CSV files get jumbled up, if they load in at all. There is a bug i have been told concerning columns that contain alphanumeric and just numeric fields. I use Excel [office 2k ve

Re: Just a small newbie question

2003-09-22 Thread Charlie Brewer
Ok well I reinstalled again and it seems to be working ok now. Thanks anyways ;) --- "Matt W" <[EMAIL PROTECTED]> wrote: Hi Charlie, Don't worry, all questions are OK. :-) Instead of trying to double-click mysql.exe, open your Command Prompt and, assuming the mysql\bin directory isn't in your

Dumb Question - Moving Data from Access to MySQL

2003-09-22 Thread Jeremy Proffitt
Dumb Question. I need to move my data from their current access database to my new MySQL server through an ODBC connection. The tables on both ends are set up identially. I have added a linked table to the access database called EXPARTAB1. The data is in EXPARTAB. I tried: INSERT INTO EXPA

Formatting a string for entry into MySQL

2003-09-22 Thread James Johnson
Hi, This is more of a PHP question, but I can't find the answer. I'm trying to generate a string that contains a , to insert into a MySQL table. It appears the is being stripped out either just before or during the update. ** code ** // has both info, update both $ad_contact = $tr_email; $ad_co

InnoDB, Replication, and Data warehouse: Oil, Water, and little floating plastic men

2003-09-22 Thread Misao
What follows is a short story, all true and quite stressful. No database servers were harmed in the making of this server, but a couple were threatened with loose rack mount rails. We are trying to move over to InnoDB, but we have a few problems that we just can't figure out: First, for some r

Re: newbie gets access denied/invalid authorization (answered)

2003-09-22 Thread Ray Tayek
At 06:04 PM 9/21/03 -0700, Ray Tayek wrote: hi, trying out opnecms. so i installed mysql on slak 8.0. added a root password (something like ... root password opencms) like the doc says, so i can do a: use mysql and create databases and tables if am root on the slak box. but only if i am root. tr

Re: User variables not working

2003-09-22 Thread Victoria Reznichenko
"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote: > > Is there anything I need to set in MySQL in order to use USER variables? > No. What is wrong with user variables for you? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.

RE: Mysqlhotcopy and incorrect database name error - We must be dense

2003-09-22 Thread Dathan Vance Pattishall
I mean look at the --suffix - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] -->Sent: Monday, September 22, 2003 1:26 PM -->To: 'Gilmore

RE: Mysqlhotcopy and incorrect database name error - We must be dense

2003-09-22 Thread Dathan Vance Pattishall
Your not using mysqlhotcopy correctly. /usr/bin/mysqlhotcopy db_name[./table_regex/] [new_db_name | directory] The problem is this mysqlhotcopy -u root --suffix=091703 staff /backups look at -u here is a format from inside mysqlhotcopy mysqlhotcopy --method='scp -Bq -i /usr/home/foo/.ssh/ide

RE: Changing the data directory.

2003-09-22 Thread Jeff McKeon
> At 4:22 PM -0400 9/19/03, Jeff McKeon wrote: > >We've got mysql 3.23 installed on a redhat system via the rpm's that > >come with RedHat 8.0. I'd like to change the default data > directory so > >something other than /var/lib/mysql. I know this is supposed to be > >possible with a start swi

Re: newbie Quote Question

2003-09-22 Thread Mojtaba Faridzad
as I know, there is no any difference between single and double except the environment. in ANSI mode, just you should use single quotation. for more : http://www.mysql.com/doc/en/String_syntax.html - Original Message - From: "Stout, Jeff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent

Re: innodb and fragmentation

2003-09-22 Thread Per Andreas Buer
"Jon Hancock" <[EMAIL PROTECTED]> writes: > When you issue this "null" ALTER TABLE, is the entire table locked > during the build? The table is read-only during the build. > i.e. Is the only way to defragment to effectively take the table > offline during the rebuild? Well. Not quite offline, b

Re: innodb

2003-09-22 Thread Heikki Tuuri
Gustavo, - Original Message - From: ""Gustavo A. Baratto"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, September 22, 2003 7:33 PM Subject: innodb > Does anybody know what this error is all about? and how do to get rid of > it... It started when I upgraded 4.0.1

Mysql and php Installation for Linux.

2003-09-22 Thread Harpreet SINGH
Hi, I am trying to install Mantis on Linux but I am totally new for linux as well as for Mantis. I have managed to install Linux. I was not sure which components are required for Mantis So I have selected all the components. Now my Linux is UP and need you help for the further installation. P

Problem with optimizing table

2003-09-22 Thread Ben Ricker
One of the developers is having a problem optimizing a table in MySQL 4.0.14-standard on Solaris 9. The optimize seems to succeed but when he tries to access the table with a SQL client, we get an error of something to the effect that MySQL "cannot fine MESSAGES.MYI". After running 'myisamchk -o' o

innodb

2003-09-22 Thread Gustavo A. Baratto
Does anybody know what this error is all about? and how do to get rid of it... It started when I upgraded 4.0.13 to 4.0.15 --- 030922 5:17:30 InnoDB: Error: page 1 log sequence number 0 768348475 InnoDB: is in the future! Current system log sequence number 0 330400180. InnoDB: Your data

newbie Quote Question

2003-09-22 Thread Stout, Jeff
I know this may seem like a trivial question, however I am new to SQL and it's syntax. I need to know what the difference between single 'quoting' and double "quoting" a string. When and why do I use one or the other, Any help answering this would be greatly appreciated. Thanks Jeff Stout CSG S

SHA literal String Syntax Help

2003-09-22 Thread Stout, Jeff
I need help with the proper syntax of my INSERT Statement. I have spoken to the support staff of my RADIUS Vendor they stated that enable to support SHA The Coolum for password has to have the encrypted password prefixed with {SHA} not just the hash I need to include the literal string of {SHA} p

Re: Pageouts

2003-09-22 Thread Ware Adams
John May wrote: >On OS X, when issuing the top command in the CLI, my "pageouts" value is: > > large number (0) > >eg: the number in parentheses is zero, but the other number is large. > >Is this a sign of a problem? It's a rather busy server with around >80 databases totalling 500MB or so. I

Re: Querying for continuous bookings

2003-09-22 Thread Mojtaba Faridzad
well, I am working with mysql for less than 2 months so I may not give you right answer but I guess we cannot solve this problem without programming. The point is how to combine the times to have a one POS with continuous time. this query is an example to combine to records: SELECT table1.pos, tab

RE: join not using first primay key, per explain

2003-09-22 Thread Andy Eastham
Jeff, Try creating a new index on Question containing just the question_key field, and try it again. Andy > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 22 September 2003 13:23 > To: [EMAIL PROTECTED] > Subject: join not using first primay key, per expla

Querying for continuous bookings

2003-09-22 Thread Ville Mattila
Hi there, My problem at this time is following: I have a table of position bookings, having information of a position code, beginning time of the booking and end time: Pos | Begings | Ends APP | 2003-09-30 11:00:00 | 2003-09-30 12:15:

Pageouts

2003-09-22 Thread John May
On OS X, when issuing the top command in the CLI, my "pageouts" value is: large number (0) eg: the number in parentheses is zero, but the other number is large. Is this a sign of a problem? It's a rather busy server with around 80 databases totalling 500MB or so. If this is a problem, how do

Difference between FLOAT and DECIMAL numbers

2003-09-22 Thread Director General: NEFACOMP
Will someone tell me the real difference between FLOAT numbers and DECIMAL numbers? What are the implications when I use either of those types? Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office

User variables not working

2003-09-22 Thread Director General: NEFACOMP
Hi group, Is there anything I need to set in MySQL in order to use USER variables? Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTE

Re: Mysqlhotcopy and incorrect database name error - We must be dense

2003-09-22 Thread Egor Egorov
"Gilmore, Jason" <[EMAIL PROTECTED]> wrote: > > A mysqlhotcopy issue has stumped no less than three of us here today at > work, ensuring that the solution is glaringly obvious. We're trying to > use mysqlhotcopy to copy a few databases. We want to make a local copy, > nothing exotic, just want to

Re: MySQL user privileges

2003-09-22 Thread Håkon Nilsen \(Exinet AS\)
Thank you, Egor, I *had* the anonymous user, but I deleted it since I couldn't find the use for it. But I figured out what the problem was. I was using --safe-show-database, but it didn't seem to work. My error was that I gave users privileges. I also gave the privileges to the user on the databa

GIS (ARC GIS, ARC info, IDRISI, ...) & MySQL Interaction?

2003-09-22 Thread Jan Verbesselt
Dear all, At the moment I'm working via an R (geoR) & MySQl for the querying, analysis and displaying of geographical data. The problem is that this is not a GIS environment. Does somebody not how I can query results via ARC INFO (or another GISpackage) out of our mySQL database and create a rast

Re: LOAD DATA INFILE failing on OS X Server

2003-09-22 Thread Bill Leonard
Thank you for the response Victor! On 9/22/03 4:02 AM, "Victoria Reznichenko" <[EMAIL PROTECTED]> wrote: >> One of our users is trying to execute the LOAD DATA INFILE command (using >> PHP to talk to MySQL). It is failing for some reason... Everything I believe >> is set properly, i.e: >> >> - t

Re: MySQL user privileges

2003-09-22 Thread Egor Egorov
"H?kon Nilsen \(Exinet AS\)" <[EMAIL PROTECTED]> wrote: > > All my MySQL users have access to all databases and all tables, allthough > I've only given them access to one. > > How can I correct this? Do you have entry for anonymous user in the table 'user'? > > Is it possible to have them *onl

Re: Replication fails after reboot of master

2003-09-22 Thread Egor Egorov
S?ren Neigaard <[EMAIL PROTECTED]> wrote: > I have two MySQL machines, each is both master and slave for each other (to > en sure high availability). > > Then today I rebooted one machine, and when the machine came online again, > the other machine did not replicate from the rebooted machine any m

join not using first primay key, per explain

2003-09-22 Thread jeffrey_n_Dyke
I have four tables that i'm trying to join together most are pretty small(100-200 rows tops) and one, the Response table is 127,000 rows. The query i'm currently executing is SELECT Business_Unit.Business_Unit, Question.Text_Long, AVG(Response) from Question INNER JOIN Response on Question.Questi

errors

2003-09-22 Thread Datatal AB - Gauffin, Jonas
Hello I often get these errormessages. Why? * X clients is using or hasnt closed the table properly (No clients are using the table.) * found X parts, should be X * table is marked as crash (table stopped working, i need to repair it) Im using mysql-nt 4.0.12 Myodbc 2.x on some

FW: Mysqlhotcopy and incorrect database name error - We must be dense

2003-09-22 Thread Gilmore, Jason
Good morning, We're still battling with this; haven't heard back from anyone on the list... Resending one more time in the hopes that it catches somebody's eye. Thanks so much, Jason -Original Message- From: Gilmore, Jason Sent: Wednesday, September 17, 2003 1:36 PM To: [EMAIL PROTECTED

Replication fails after reboot of master

2003-09-22 Thread Søren Neigaard
I have two MySQL machines, each is both master and slave for each other (to en sure high availability). Then today I rebooted one machine, and when the machine came online again, the other machine did not replicate from the rebooted machine any more. Why can that be, do I have to do something spe

Decimal digit problem

2003-09-22 Thread Alessandro Morsa
Hi, I have a serious problem with a site. It's a ASP site running on IIS5 and MySQL 4.0.15. I have a DECIMAL(10,2) field in a table. I've now experienced that on some days, the decimal digit is ignored, meaning that a value of ie. 14.00 is represented af 1400, 135.00 as 13500. I have search all t

MySQL user privileges

2003-09-22 Thread Håkon Nilsen \(Exinet AS\)
Hi, All my MySQL users have access to all databases and all tables, allthough I've only given them access to one. How can I correct this? Is it possible to have them *only* see their database when i.e. typing 'show databases;', and also refuse them connection to any database but their own? Tha

AW: AW: FOREIGN KEY() REFERENCES ON UPDATE CASCADE ON DELETE RESTRICT

2003-09-22 Thread Morten Gulbrandsen
Dear Toro Hill, Thank you for the gentle explanation, I believe you mean this: Hence it is not possible to insert, update or modify anything into TABLE PRODUCT_ORDER Because : No is auto Increment, cannot be directly manipulated, product_category product_id customer_id

Re: plz help

2003-09-22 Thread Wajih-ur-Rehman
I know about this limit statement but even if i write the following query, it *still does not work* because of the nested select statement: "SELECT Max(id) FROM (select id from systemevents where infoId in ( 3 ) AND id > 100 order by id ASC LIMIT 50) AS t1 " - Original Message - F

Re: plz help

2003-09-22 Thread Catalin PLACINTA
Use the LIMIT clause in mysql instead of TOP clause for access and mssql. Luck ! - Original Message - From: "Wajih-ur-Rehman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 12:22 PM Subject: plz help > I have this statement that works perfectly fine in Acc

Re: SHOW SLAVE HOSTS returns nothing ?

2003-09-22 Thread Victoria Reznichenko
Ion-Mihai Tetcu <[EMAIL PROTECTED]> wrote: > > I had set up replication between 2 4.0.14 servers and everything seems to work OK. > Except that SHOW SLAVE HOSTS on muster returns nothing. What am I missing ? > Use report-host option on the slave: http://www.mysql.com/doc/en/Replication_

plz help

2003-09-22 Thread Wajih-ur-Rehman
I have this statement that works perfectly fine in Access and MSSQL: (In words, i first get the top 50 id values according to the where clause and then i get the maximum of those id values) "SELECT Max(id) FROM (select top 50 id from systemevents where infoId in ( 3 ) AND id > 100 order by id A

Re: OS X Installation and Setup

2003-09-22 Thread Andy Callan
After successfully setting up PostgreSQL and better understanding the user and permission problems I attempted to reinstall mySQL which had been running but b/c of permission stuff i could only access databases that began with "test". I installed the OS X bundle with Startup module and then got th

Re: LOAD DATA INFILE failing on OS X Server

2003-09-22 Thread Victoria Reznichenko
Bill Leonard <[EMAIL PROTECTED]> wrote: > Let me preface this by saying I am not a MySQL guru myself, but more of a > general sys admin... ! > > One of our users is trying to execute the LOAD DATA INFILE command (using > PHP to talk to MySQL). It is failing for some reason... Everything I believe

Re: How to update/set a default value for field via delete statement

2003-09-22 Thread Victoria Reznichenko
"Daevid Vincent" <[EMAIL PROTECTED]> wrote: > I have my schema set so that a field in a table has a default value of 16. > > I also have a script that "initializes" the database, but I don't want to > delete the record since I want the other fields' data preserved. Is there a > way to find out wha