Copying Database from One Hard Drive to Another

I've been using a preconfigured package (Apache, PHP, MySQL) from Apache Friends/XAMPP for several months. About a week ago, my computer crashed, and I'm now getting back on my feet. I downloaded the latest XAMPP, which features upgrades for PHP, phpMyAdmin and I think MySQL, too. Everything seems

Permission Denied for INSTALL-BINARY

Hi All, using Fedora2 and trying to install from a .tar file. Extracted to this dir, mysql-standard-4.1.9-pc-linux-gnu-i686 where I see the INSTALL-BINARY file. Using this cmd, ./INSTALL-BINARY gives the following error, [EMAIL PROTECTED] mysql-standard-4.1.9-pc-linux-gnu-i686]# ./INSTALL-BINAR

Re: SELECT DISTINCT Problem

I'm not aware of any problems with DISTINCT, though it often seems that how people expect it to work differs from how it actually works. It would help if you could provide more details. For example, what do you mean by "large gaps"? Do you mean there are rows which match the WHERE condition w

SELECT DISTINCT Problem

I have a large database that I am trying to run a SELECT DISTINCT across. SELECT DISTINCT Date FROM tb_spots WHERE aired_station = '??' However the results I am getting from this query do not match up with the data on the database, instead there are large gaps. Is there any know problem with SE

mysqld error

Hi, I am trying to get mysql working on my Windows ME machine. When trying to start mysqld I get the following error message: 050208 19:43(time) [ERROR] C:\Progra~1\mysql\mysql 4.1 Server\bin\mysqld unknown option '--enable-named-pipe' MySQL version 4.1.9. Any help greatly appreciated. Dick

Re: default values

Jeff Smelser wrote: On Tuesday 08 February 2005 03:32 pm, Emmett Bishop wrote: is it possible to force a field to be NOT NULL but not have any default value (I.E the insert statement must explicitly provide data for the field in question)? of course: col1 int not null Jeff Except that ALL columns

Multiple table join help

All, I have done some reading and research; however, I seem to be at a loss... And this time, I am not sure how to ask Google... Here is the problem: Table A: id INT valuevarchar (10) Table B: id INT valuevarchar (10) Table C: id INT

Re: query problem in num_row

Your not getting a valid result from your query. Add if (!$result) { echo 'Bad query - message: ' . mysql_error();} I think it will give you a syntax error on your query. MySQL syntax for the LIMIT clause is: [quote] The LIMIT clause can be used to constrain the number of rows returned by the SEL

Problems installing MySql...

I already have a version of MySql 4.1.17 running on a different server, but am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's software. I'm finding that 4.0.23 isn't as easy to set up as the later versions. I modified the my.ini file and put it in the \windows directory for Wind

Re: Merge vs multiple innodb performance

Chuck Herrick napisaÅ(a): 200 - 400 tables is too many. Is it too many for merge, innodb or both? Try having one CUSTOMERS table. You know who is logged in, so you can use that information in a WHERE clause. Yes, but If somebody would find a password (maybe using brute-force attack) to one account

Re: mysqld process hangs, cannot terminate

On Tue, Feb 08, 2005 at 03:57:16PM -0600, Brian Erickson wrote: > stops working) and continues to run. Nothing we do will terminate that > process (we have > tried: kill , kill -s 9 , everything that is supposed to > forcibly kill the process and nothing works). A unkillable process like that is us

Merge vs multiple innodb performance

Hi, I'm writing an windows app, which would connect to mysql server and modify user's data. There would be a few hundred of users. Every of them should have access only to few tables. It's not a problem with mysql's authentication mechanism. Kind of compilation of the data from users' tables sh

Re: ERROR 1189 (08S01): Net error reading from master

On Tue, 8 Feb 2005, Bastian Balthazar Bux wrote: Just a shot in the dark do you have "skip-networking" or "bind-address" uncommented in your my.cnf ? Reading better what you write I suppose the answer is yes ;) can you connect from one server to the other using the replication user ? no skip-netwo

mysqld process hangs, cannot terminate

Hello everyone, we are having a problem on our server with the mysqld process hanging. We first notice the problem because our max connections is reached. A "show processlist" query shows 250 queries with a status of "locked." When we try to issue the command: mysqladmin -u root -p shutdown, it do

Re: default values

On Tuesday 08 February 2005 03:32 pm, Emmett Bishop wrote: > is it possible to force a field to be NOT NULL but not > have any default value (I.E the insert statement must > explicitly provide data for the field in question)? of course: col1 int not null Jeff pgpKRoQG6Ktfo.pgp Description: PGP

default values

Howdy all, is it possible to force a field to be NOT NULL but not have any default value (I.E the insert statement must explicitly provide data for the field in question)? Cheers, Tripp __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best s

Re: ERROR 1189 (08S01): Net error reading from master

Just a shot in the dark do you have "skip-networking" or "bind-address" uncommented in your my.cnf ? Reading better what you write I suppose the answer is yes ;) can you connect from one server to the other using the replication user ? Olivier Kaloudoff ha scritto: Hi, As no one answered to t

Install Question - mysql starts and then stops immediately

Here's hoping you can help. I have installed Redhat Linux Fedora Core 3, server version from ISO's burned on 2/2/05. I have downloaded the latest MySQL 4.1.9-0 rpms, done an rpm -e and upgraded the MySQL-server, MySQL-client, MySQL-devel and MySQL-shared. Basically, I followed the instructions in

Re: Selecting first non-null values from a set of rows

Eli ha scritto: Hello, Say I get these rows in a regular query: col1col2col3 --- NULL B1 NULL NULLNULLNULL A3 B3 NULL A4 NULLC4 A5 B5 C5 NULLB6 C6 (It's important to keep the rows in that order). I want to get 1 row o

Problems with decimal numbers

Hello, When I try to insert decimal numbers like 12857.59, 13858.58 or 14785.60, they are inserted as 12857.58, 13858.57 and 14785.59 ?! DataType is DECIMAL 10,2 Any idea of a way to avoid this annoying issue ? Thanks. Regards. Stéphane. -- MySQL General Mailing List For list archives: http://lis

Simmering FT Queries

I'm evaluating MySQL FT search, and so far it's been very disappointing. The queries on a test table of about 2 million rows with Text columns (average 75 words per text column) are extremely slow, compared to a regular FT search engine, like Lucene. What's disturbing is that it doesn't consume an

Re: Selecting first non-null values from a set of rows

Eli <[EMAIL PROTECTED]> wrote on 02/08/2005 03:27:42 PM: > > Eli <[EMAIL PROTECTED]> wrote on 02/08/2005 02:26:41 PM: > > > > > >>> Hello, > >>> > >>> Say I get these rows in a regular query: > >>> > >>> col1 col2col3 > >>> --- > >>> NULLB1NULL > >>> NULLN

Re: ERROR 1189 (08S01): Net error reading from master

Hi, As no one answered to the question below, I'm wondering wether it's a FAQ ... or a bug for which I should fill a report .. My network is ok between the two machines, I can ssh from one to another and any traffic can flow. But this error prevents me to start replication a

Re: Selecting first non-null values from a set of rows

Eli <[EMAIL PROTECTED]> wrote on 02/08/2005 02:26:41 PM: Hello, Say I get these rows in a regular query: col1 col2col3 --- NULLB1NULL NULLNULLNULL A3 B3 NULL A4 NULLC4 A5 B5 C5 NULLB6 C6 (It's important to keep the row

Install MySql 4.0.23???

I already have a version of MySql 4.1.17 running on a different server, but am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's software. I'm finding that 4.0.23 isn't as easy to set up as the later versions. I modified the my.ini file and put it in the \windows directory for

optimize table and replication failure

I issued a optimize table statement on my master which failed with a "lock wait timeout" message due to some competing queries running at the same time. Now the statement has been replicated to my slaves, and it completes successfully. However it's killing the slave input thread with the following

Re: Selecting first non-null values from a set of rows

Eli <[EMAIL PROTECTED]> wrote on 02/08/2005 02:26:41 PM: > Hello, > > Say I get these rows in a regular query: > > col1 col2col3 > --- > NULLB1NULL > NULLNULLNULL > A3 B3 NULL > A4 NULLC4 > A5 B5 C5 > NULLB6 C6 > >

Re: Mysql permissions

"Nupur Jain" <[EMAIL PROTECTED]> wrote on 02/08/2005 01:26:06 PM: > I have problems with access permissions on a Solaris 9 installtion > of MySql-max 4.1. My user table shows this > > select * from user; > | Host| User | Password > | Select_priv | Insert_priv | Update_priv | Delete

Converting Text columns from mysql 4.0 to 4.1

Hi! We have a problem converting our 4.0 text columns from a Hong Kong database to 4.1. In order to get the conversions to work generally speaking we build our databases with default character set utf8 - it means the German products still work, and the English ones, and the Chinese ones, and the...

AW: selection problem

Jan Bartholdy wrote: > Dear All, > I have the following problem: > The table in a database is organized like this one: > Samplespecies_species_b species_c > A10 5 0 > A20 0 3 > A31

Selecting first non-null values from a set of rows

Hello, Say I get these rows in a regular query: col1col2col3 --- NULLB1 NULL NULLNULLNULL A3 B3 NULL A4 NULLC4 A5 B5 C5 NULLB6 C6 (It's important to keep the rows in that order). I want to get 1 row of the first non-

Re: [PHP-DB] mysqli connection problem

My intention of setting the reply-to was not to offend, or claim you were wrong - merely to move the discussion to the list I felt (and still feel - as I've done it again) is most appropriate for the question. anyway, back to the task at hand ( first: I'm assuming you restarted apache after chan

Time Zones and Daylight Saving

I'm storing datetime values in UTC for an international site. Then retrieving the data using 'select convert_tz(created, 'GMT','MST') from table_name', so that the datatime appears in the correct local datetime for the user. Does this method take into account daylight savings? If not, how can t

Re: max key file length

Hello, Am Montag, den 07.02.2005, 17:16 + schrieb sirisha gnvg: ... > Thank you for your reply.You suggested me that both > key_reflength and max_key_file_length can be read from "key > file".We just need to find the offset at which they are stored > in "key fil

Re: InnoDB crash and runaway rollback - help pls

Tobias, - Alkuperäinen viesti - Lähettäjä: "Tobias Asplund" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: Lähetetty: Tuesday, February 08, 2005 7:46 PM Aihe: Re: InnoDB crash and runaway rollback - help pls On Tue, 8 Feb 2005, Heikki Tuuri wrote: You shoul

Mysql permissions

I have problems with access permissions on a Solaris 9 installtion of MySql-max 4.1. My user table shows this select * from user; | Host| User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv

Re: Recursive category table problem (whatever you define it). Help!

There are lots of ways to do this, from simple (lookup table and bridge table) to more complex (eg dynamic trees of nodes and edges). You'll likely have to experiment to find the solution that performs best in your context. Often simple is best. Here's a simple representation I used for a movie

selection problem

Dear All, I have the following problem: The table in a database is organized like this one: Sample species_species_b species_c A1 0 5 0 A2 0 0 3 A3 1 1 5 I woul

Re: InnoDB crash and runaway rollback - help pls

On Tue, 8 Feb 2005, Heikki Tuuri wrote: > You should upgrade to 4.1.9. That version commits ALTER TABLE at every 10 > 000 rows, and a runaway rollback can no longer happen. This is very nice! Are there any plans for the same with INSERT ... SELECT -type statements? -- MySQL General Mailing List

Install MySql 4.0.23???

I already have a version of MySql 4.1.17 running on a different server, but am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's software. I'm finding that 4.0.23 isn't as easy to set up as the later versions. I modified the my.ini file and put it in the \windows directory for

Re: Difference between 'LIKE' and '='

| Hi All, | | From what I understand the LIKE keyword allows you to do things like include | wildcards and match against regular expressions. | | But I have a question: is there any difference between the following? | | SELECT lname, fname FROM contacts WHERE lname = 'smith'; | SELECT lname, fname

Re: Difference between 'LIKE' and '='

I should have included the context of this question when I originally asked it, but I'll include it here now with my apologies: The reason I am asking is because I have a search method in a PHP class that searchs a table based on a specific field. By way of example, you would do something like

Re: Difference between 'LIKE' and '='

Hi Joshua, all! Am Di, den 08.02.2005 schrieb Joshua Beall um 17:18: > Hi All, > > >From what I understand the LIKE keyword allows you to do things like include > wildcards and match against regular expressions. > > But I have a question: is there any difference between the following? > > SEL

Re: Difference between 'LIKE' and '='

Joshua Beall wrote: Hi All, From what I understand the LIKE keyword allows you to do things like include wildcards and match against regular expressions. But I have a question: is there any difference between the following? SELECT lname, fname FROM contacts WHERE lname = 'smith'; SELECT lname, fna

Re: Query problem

On Tue, 08 Feb 2005 15:52:02 +0100, Joachim Klöfers <[EMAIL PROTECTED]> wrote: > Oh, oh, Joachim, > not able to calculate, but asking questions about queries. > > Coz , of course its supposed to be 1955 (id 13 & 47) > > Joachim > > > Coz Web schrieb: > Just to confirm, is amount2 for region 1

Difference between 'LIKE' and '='

Hi All, >From what I understand the LIKE keyword allows you to do things like include wildcards and match against regular expressions. But I have a question: is there any difference between the following? SELECT lname, fname FROM contacts WHERE lname = 'smith'; SELECT lname, fname FROM contacts

RE: [PHP-DB] mysqli connection problem

> > Hello, > > > > This question was asked many times, but I can't find a good answer. > > I am getting this error message while trying to connect to MySQL server > (PHP > > + PEAR::DB_DataObject): > > > > "Can't connect to local MySQL server through socket '' (111)" > > > > (notice '' - is that

Re: mysql_init() issue on HPUX

Hello. > Operating system error number 13 in a file >I check the permission on the files and directories. The user 'mysql' > and group 'mysql' have access to the data directory and to the files. Check that you really run the mysqld under the 'mysql' account. Have you applied the patches

Re: Slow query log?

Hello. You have an application which executes prepared statements. See: http://dev.mysql.com/doc/mysql/en/c-api-prepared-statements.html MySQL doesn't log to the slow log a prepared statement. You can enable general query log which logs prepared statements. Andrea Gangini <[EMAIL

Re: ERROR 1189 (08S01): Net error reading from master

Hello. >mysql> grant replication slave, file on . to [EMAIL PROTECTED] >identified by 'pass'; >Query OK, 0 rows affected, 1 warning (0.00 sec) You should additionally grant SUPER, RELOAD, and SELECT privilege for all tables that you want to load. See: http://dev.mysql.com/doc/mysql/e

RE: How do I create a database 179503

[snip] I posted a message yesterday 179503, with my problems in getting to the stage of creating a database, I have had an Email with approx 50 .ezm attachments, eventually I found the document on the MYSQL lists to tell me how to set up my "file types" to access these Emails, but without going thr

How do I create a database 179503

Hi   I posted a message yesterday 179503, with my problems in getting to the stage of creating a database, I have had an Email with approx 50 .ezm attachments, eventually I found the document on the MYSQL lists to tell me how to set up my "file types" to access these Emails, but without goi

Strage behaviour with Innodb on MySQL-4.1.9

I use MySQL for my application with InnoDB as primary table. I found a very strage behaviour of InnoDB table after i alter table TABLE drop a field at there since this field is not used anymore. WHen i executre show processlist i found | 2221 | root | 10.1.20.10:43071| DB | Qu

Re: Syntax for Compound "IF" Statements?

"Sue Cram" <[EMAIL PROTECTED]> wrote on 02/08/2005 01:18:48 AM: > Thanks to the people who helped me with my IF statement question > last night. Now I need to carry it one step further to a compound > 'IF' statement. Again, can't find much information in the manuals -- > > Several people sent

Re: Query problem

On Tue, 8 Feb 2005 11:37:20 +, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > On Tuesday 08 February 2005 08:09, Joachim Klöfers wrote: > > Hi, all > > > > I hope somebody can help me. > > > > > > Many thanks in advance > > Joachim > > That is a very thorny problem. May I observe that you wi

query problem in num_row

here a syntax $query=&$conn->Execute("select * from itemlocation where id limit 1 - 50"); $result=mysql_query($query); $num_result=mysql_num_rows($result); and error message are syntax error in $num_result=mysql_num_rows($result); object unknown can someone please give a direction all I want to

Re: Query problem

Just to confirm, is amount2 for region 1 supposed to be 1630 (id 47) or 1955 (ids 13 & 47)? Coz > What I would like to have is a result like this: > ++---+--+ > | region | sum(amount1) if current=J | sum(amount2) | > ++---

Re: Query problem

On Tuesday 08 February 2005 08:09, Joachim Klöfers wrote: > Hi, all > > I hope somebody can help me. > > Many thanks in advance > Joachim That is a very thorny problem. May I observe that you will find things much easier, if you add unique primary keys to tables 2 & 3, thus: ALTER TABLE ADD p

Re: Syntax for Compound "IF" Statements?

Harald Fuchs wrote: That's correct, but it can be written shorter and clearer: CASE Lccation WHEN 1 THEN 'Downstairs Cat Room' WHEN 2 THEN 'Kitten Room' WHEN 3 THEN 'Quarantine' ELSE 'Unknown' END AS Location - surely it would be better to have the location ids and location names in a lookup ta

ERROR 1189 (08S01): Net error reading from master

Hi, I have some problems here with two mysql servers, version 4.1.8; on the master server, binary logs are activated, free disk space is not null; [EMAIL PROTECTED]:~# ls -l /repl/mysql/data/master.* -rw-rw 1 mysql mysql 1814256 2005-02-08 11:43 /repl/mysql/data/master.01 -rw-

Recursive category table problem (whatever you define it). Help!

Dear friend, I am classifying some items. The items will be stored in a large MySQL database (probably InnoDB engine). At storage time, we would like to append a series of descriptive categories to the item, in order to facilitate "friendly", very flexible searches later. For instance item A

Re: InnoDB crash and runaway rollback - help pls

Devananda, the ALTER TABLE creates a temporary table #sql... The rollback is running in that table. The manual contains instructions on how to rename and drop such table. You should upgrade to 4.1.9. That version commits ALTER TABLE at every 10 000 rows, and a runaway rollback can no longer hap

Re: Syntax for Compound "IF" Statements?

In article <[EMAIL PROTECTED]>, Johan Höök <[EMAIL PROTECTED]> writes: > Hi, > I guess your "CASE" statement should look something like: > CASE WHEN Location=1 THEN 'Downstairs Cat Room' > WHEN Location=2 THEN 'Kitten Room' > WHEN Location=3 THEN 'Quarantine' > ELSE 'Unknown' EN

Re: InnoDB and Transactions

No the transaction will not be rolled back... BUT (always the BUT thing)... If you're not carefull to open a NEW link in MySQL setting the fourth parameter to "mysql_connect" to TRUE... PHP will not open a new link but return the already created one... thus entering in the same transaction... t

Re: Syntax for Compound "IF" Statements?

I didn't found an IF ... ELSE ... in MySQL ... and I'm using it for at least 4 years !... since the old 3.23.xx times !!! So you will have to do: SELECT a,b,c, IF(Location=1, 'Downstairs Cat Room', IF(Location=2, 'Kitten Room',

Re: Syntax for Compound "IF" Statements?

Hi, I guess your "CASE" statement should look something like: CASE WHEN Location=1 THEN 'Downstairs Cat Room' WHEN Location=2 THEN 'Kitten Room' WHEN Location=3 THEN 'Quarantine' ELSE 'Unknown' END AS Location /Johan Sue Cram wrote: Thanks to the people who helped me with my IF state

Query problem

Hi, all I hope somebody can help me. Situation Three tables 1. ++++ | id | name | region | ++++ | 13 | Name1 | 1 | | 15 | Name2 | 2 | | 47 | Name3 | 1 | | 57 | Name4 | 2 | | 65 | Name5 | 2 | | 77

Re: MySQL upgrading

Was not the command mysqldump -u user -p your_database > dump.sql easier to do ? Robert L Cochran wrote: I myself want to go from version 4.1.7 to 4.1.9, so I read the upgrade page, which advises you to back up your databases. You do that with mysqldump, and that is briefly explained here: http: