access-trouble using root

2005-03-27 Thread X y
Over on http://forums.mysql.com/read.php?10,20058,20058#msg-20058 I posted a msg connected to me having trouble to login to my MySQL database handler. I might save some space here in your email by asking you to go to the above forum-thread, and my last post in the thread goes; Ok, so I did the fo

Re: How to import data from Dbase3?

2005-03-27 Thread Ehrwin Mina
BG Mahesh wrote: Actually I prefer to dump the dbase file on a Linux machine and directly import it into MySQL. Yap, it is posible to dump the file in a linux machine but you must import it first into a windows mysql and later you dump it to a linux macine mysql. - Original Message -

Re: mysqlimport blocks all access to database

2005-03-27 Thread valentin_nils
Hi Joseph, > I have been trying to use mysqlimport to load a primarily read only database with data at regular intervals. My problem occurs when my tables are myisam. In this case all access to the database and the tables blocks until mysqlimport completes. The -lock-tables=false parameter does no

mysqlimport blocks all access to database

2005-03-27 Thread Joseph Blackette
I have been trying to use mysqlimport to load a primarily read only database with data at regular intervals. My problem occurs when my tables are myisam. In this case all access to the database and the tables blocks until mysqlimport completes. The -lock-tables=false parameter does not help. Is th

RE: show duplicate entries

2005-03-27 Thread Tom Crimmins
On Sunday, March 27, 2005 19:48, Louie Miranda wrote: > mysql> select count(*) - count(distinct username,email) as 'duplicate > names' from users; > +-+ >> duplicate names | > +-+ >> 2 | > +-+ > 1 row in set (0.00 sec) > > I got this

show duplicate entries

2005-03-27 Thread Louie Miranda
mysql> select count(*) - count(distinct username,email) as 'duplicate names' from users; +-+ | duplicate names | +-+ | 2 | +-+ 1 row in set (0.00 sec) I got this select syntax to count how many duplicate entries i have. But i dont know

General substring update query required

2005-03-27 Thread zzapper
Hi, I want to replace every occurence of a string with another. The following query works fine (appears to anyway) update tbl_websitepages set page_content=replace (page_content,'develop','bucket'); But is there any way to get any Regexp into the substitution? -- MySQL General Mailing List F

Re: Need help coverting MDB > SQL

2005-03-27 Thread EWA Goodson-Wickes
IM imagine you mean mdb > mysql ? navicat from premium soft can“t be beat in my opinion, it has a 30day trial and does the conversion without any errors - Original Message - From: Rhino To: Ricky Groleau ; mysql@lists.mysql.com Sent: Saturday, March 26, 2005 2:28 PM Subject: Re

Database access

2005-03-27 Thread Russ
I run SuSE 9.1 with mysql 4.0.18. I have two databases plus the two created by my sql. I working on a new security program for one of the databases where the user will login to a webpage for information. The program is presently running on localhost. When I added the necessary user id and passwo

Re: Need help coverting MDB > SQL

2005-03-27 Thread Karam Chand
I have been using SQLyog for quite some time now to import data from Access and SQL Server database. www.webyog.com Regards, Karam --- Ricky Groleau <[EMAIL PROTECTED]> wrote: > > > Hello, > > I have tried and i have failed. I am trying to help > out a non-profit site in their move. The old s

Character Set problem

2005-03-27 Thread Stephen Moretti (cfmaster)
Hi there, I'm on mysql 4.1.10a on Windows 2003 Server. I'm getting : File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22) Character set '#33' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file when some PHP applications try accessing thei

Re: Slow access Apache + PHP + MySQL

2005-03-27 Thread Santino
It could be a DNS problem, but you must give us more details. Santino At 10:47 -0500 26-03-2005, Andre Matos wrote: Hi List, I have 4 web based systems developed using PHP4 and MySQL accessed for 10 users. The Web Server and Database Server were running ok on a Mac OS X 10.3 G4 dual. However, since

SQLException in tomcat with mysql-connector-java-3.1.7

2005-03-27 Thread vladimir
Hi , I have the following problem. I run tomcat with mysql-connector-java-3.1.7 for connecting to mysql server 4.1.10a-standard.When server just a little loaded I see a lot of exceptions in tomcat log: java.sql.SQLException: ResultSet is from UPDATE. No Data. at org.apache.torque.util.BasePeer.th