How to set character set UTF-8 for mysqldump

How can I set character set as UTF-8 for mysqldump command? When I try this, I get an error - mysqldump --default-character-set=UTF-8 -uNAME -pXXX mydb> mydb.sql mysqldump: Character set 'UTF-8' is not a compiled character set and is not specified in the 'C:\mys ql\\share\charsets\Index' file Ho

Re: mysql.sock file exists, but still cannot connect to server

On Wednesday, January 19, 2005 9:14 PM Michael Stassen wrote: Details should be in the .err file in the data directory Here's the contents of the file: 050119 17:30:02 mysqld started 050119 17:30:02 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/m

Re: sub query is extermely slow

[EMAIL PROTECTED] wrote: I would simplify it by converting everything to us explicit (not implicit) JOIN statements,skipping unnecessary type conversions, and logically merging your conditions. Here is your original query, slightly reformatted. SELECT DISTINCT i.basename FROM inventory i, tran

RE: MySQL Losing database information

Where would I find the .InnoDB files ? As in the error below that I receive when check table is run against the table: mysql> check table ACL; +-+---+--+---+ | Table | Op| Msg_type | Msg_text | +

Re: mysql.sock file exists, but still cannot connect to server

Details should be in the .err file in the data directory (/usr/local/mysql/data/whitestar.alpha.net.err, in your case). Michael Alex Majora wrote: Additionally, this is what I get when I try to launch mysqld manually: $ sudo ./bin/mysqld_safe & [1] 2058 Starting mysqld daemon with databases from

Re: mysql.sock file exists, but still cannot connect to server

Alex Majora wrote: Michael Stassen wrote: That doesn't appear to be mysql. Now that I look closely, that must be a database for RMDB. Sorry I got the two confused. Are you sure mysqld is running? You got a shutdown message right before this. Apparently, it's not running, as there is no mysqld p

Re: mysql.sock file exists, but still cannot connect to server

Additionally, this is what I get when I try to launch mysqld manually: $ sudo ./bin/mysqld_safe & [1] 2058 Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/whitestar.alpha.net.pid 050119 17:13:12 mysqld ended Is there a way t

RE: MYSQL + acquiring table relationships

Was there a reply to this post? If so, I could have (did) missed it. Can you please resend? Rgds Paul. Shawn, what language(s) are you using to parse this? Could you share the code? Thanks, Dave Merrill > I prefer to parse the results of a "SHOW CREATE TABLE..." query. It's > rather trivial

SQL Schema

Hello, I've got a DB design issue here, and I would like to hear your views on this problem. I've got a website where people can post comments on various ressources : news, articles, polls, and so on. So every comments are in a table with a field for the ressource type (news=1,polls=2, and so on)

Error 1034: Incorrect key file for table; try to repair it

Is there a workaround for bug 5686? http://bugs.mysql.com/bug.php?id=5686 We use Debian Linux testing and MySQL 4.1.8 Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

symlink to /var/lib/mysql

Hi all I recently installed SUSE linux and I am running MySQL 4.0.21 The way system is configured, /var ran out of disk space. I have RAID installed and /data is on raid. So I created a new folder mysql in /data and copied all the files from /var/lib/mysql to this folder. I renamed /var/lib/mysql

Re: mysql.sock file exists, but still cannot connect to server

The postmaster is a Postgres daemon, and pg_shadow is the user table for postgres. Clint From: Michael Stassen <[EMAIL PROTECTED]> To: Alex Majora <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: mysql.sock file exists, but still cannot connect to server Date: Wed, 19 Jan 2005 17:42:34

Re: mysql.sock file exists, but still cannot connect to server

Michael Stassen wrote: That doesn't appear to be mysql. Now that I look closely, that must be a database for RMDB. Sorry I got the two confused. Are you sure mysqld is running?  You got a shutdown message right before this. Apparently, it's not running, as there is no mysqld process running in t

Re: mysql.sock file exists, but still cannot connect to server

Alex Majora wrote: I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't start up. In the console I get these messages: The database cluster will be initialized with locale C. creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok creating directory /var/db/RemoteMana

RE: I seem to have lost a table somehow :-(

Hi Vicki, If you have a backup of the .MYD file, you should be able to copy this over the existing one and run myisamchk -r to rebuild the index. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mob

RE: I seem to have lost a table somehow :-(

At 3:21 PM -0800 1/18/05, Dathan Pattishall wrote: >Somehow your table was zero'ed out, i.e. TRUNCATE / DROP-CREATE. > >MYD - data of the table >MYI - index of the table >Frm - TABLE definition > >I hope you have a backup. Ewwch. I may have a backup. I definitely have the data. Unfortunately, ther

mysql.sock file exists, but still cannot connect to server

I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't start up. In the console I get these messages: The database cluster will be initialized with locale C. creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.da

RE: Adding user commments to database records

CREATE TABLE userComments ( -- comments_id int unsigned NOT NULL DEFAULT 0 AUTO INCREMENT, commenter_id int unsigned not NULL default 0, commented_id int unsigned not null default 0, relationship tinyint unsigned not null default 0, comment TEXT NOT NULL default '', PRIMARY KEY (

Re: bind-address question

Hello. Systems call bind() calls only one time for IP socket and one time for socket file (from sql/mysqld.cc). So you can specify only one IP address. Use firewall to suppress undesirable connections. Cere Davis <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I would like to bind mysql

RE: sub query is extermely slow

I think it might also be better to remove the function "date(tt.date)" if possible ie change date(tt.date) <= "2005-01-31" to tt.date <= "" This will remove the function on the tt table field which I believe will force a full table scan on what is probably the largest table? Andy > -Origi

Re: Doubt about Performance

Shawn, Thank you very much for your tips. I´ll do that. Ronan - Original Message - From: <[EMAIL PROTECTED]> To: "Ronan Lucio" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, January 18, 2005 6:36 PM Subject: Re: Doubt about Performance "Ronan Lucio" <[EMAIL PROTECTED]> wrote on 01/18/2005 02:

Re: Logging Data: Should I use MyIsam or InnoDB?

> > > > I have a curious issue here, maybe someone can help. > > > > > > > > I have a single process that inserts data into tables that contain > > > > purely logging information. This table is then searched by our Care > > > > department to troubleshoot issues. I am looking for the best way to

Re: sub query is extermely slow

sam wun <[EMAIL PROTECTED]> wrote on 01/19/2005 07:02:37 AM: > Hi list, > > The following sql statement takes 3 mintues to complete the query. How > can I improve its speed? > select DISTINCT i.basename from inventory i, transaction t, customer c > where i.prodcode = t.prodcode and c.custcode =

RE: sub query is extermely slow

Check ALTER statement in MySQL doc. It explains how to add/modify an index after a table has been created. > -Original Message- > From: sam wun [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 19, 2005 10:00 AM > Cc: mysql@lists.mysql.com > Subject: Re: sub query is extermely slow >

Re: sub query is extermely slow

Clint Edwards wrote: Sam, Can you create an index on transaction.date, then run your query again? If that is not better send me the output of 'explain ' again. This index may not be a good idea, depending on how many transaction are in the table on a specified date. May I ask how to add index

Re: sub query is extermely slow

Sam, Can you create an index on transaction.date, then run your query again? If that is not better send me the output of 'explain ' again. This index may not be a good idea, depending on how many transaction are in the table on a specified date. Clint From: sam wun <[EMAIL PROTECTED]> To: Clin

Re: Logging Data: Should I use MyIsam or InnoDB?

"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 01/19/2005 03:33:32 AM: > Hello Jeremy, > > > > I have a curious issue here, maybe someone can help. > > > > > > I have a single process that inserts data into tables that contain > > > purely logging information. This table is then searched by our C

Re: Regarding replication

Hello. > Is replication of database is possible in MySQL 4.0.21?. Yes. >from which version it is available?. 3.23.15 >Could any one of you please provide >some helpful information about how to do the replication?. See: http://dev.mysql.com/doc/mysql/en/Repli

Re: Setup question on mysql under Linux

Have you tried using mysqld_safe --user=mysql 'mysql' being the name of the user you want mysqld to run as. -Eric On Tue, 18 Jan 2005 20:33:38 -0800, Russ <[EMAIL PROTECTED]> wrote: > I'm having trouble getting myslqd to run as a user other than root when it is > started by mysqld_safe. I folow

Adding user commments to database records

I would like for logged-in site visitors to be able to submit comments to be appended to my database records. I've seen some databases that use a post-it-note style system. What might be the best way to go about this. The following conditions apply: Multiple users may post comments on the same

Re: sub query is extermely slow

Sam, Can you send the following information: When was the last time 'analyze table ' (inventory, transaction, customer) was executed? OS: MySQL Version: Available Ram: Output from 'SHOW CREATE TABLE ' (inventory, transaction, and customer): Output from "SHOW VARIABLES LIKE '%buffer%';": Clint F

Re: sub query is extermely slow

Clint Edwards wrote: Sam, Can you send the output of the following: #>explain \G Thanks for the suggestion, here is the output of the explain query: mysql> explain select DISTINCT i.basename from inventory i, transaction t, customer c where i.prodcode = t.prodcode and c.custcode = t.custcode and

RE: sub query is extermely slow

Sam, Can you send the output of the following: #>explain \G Clint From: sam wun <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: sub query is extermely slow Date: Wed, 19 Jan 2005 20:02:37 +0800 Hi list, The following sql statement takes 3 mintues to complete the query. How can I improve its

sub query is extermely slow

Hi list, The following sql statement takes 3 mintues to complete the query. How can I improve its speed? select DISTINCT i.basename from inventory i, transaction t, customer c where i.prodcode = t.prodcode and c.custcode = t.custcode and i.basename is not NULL and i.prodname is not NULL and ((da

RE: getting error with mysql_fix_privilege_tables

Steve, Below is output from the mysql_fix_privilege_tables script: "You can safely ignore all 'Duplicate column' and 'Unknown column' errors because these just mean that your tables are already up to date." I would not worry about the "Duplicate Key" error, because that is likely the same case a

Re: Regarding replication

On Wed, 19 Jan 2005 [EMAIL PROTECTED] wrote: > Hi, > > Is replication of database is possible in MySQL 4.0.21?. Yes. > If not from which version it is available?. Could any one of you please > provide some helpful information about how to do the replication?.

Re: Logging Data: Should I use MyIsam or InnoDB?

Martijn Tonies wrote: Hello Jeremy, I have a curious issue here, maybe someone can help. I have a single process that inserts data into tables that contain purely logging information. This table is then searched by our Care department to troubleshoot issues. I am looking for the best way to st

Re: Logging Data: Should I use MyIsam or InnoDB?

Hello Jeremy, > > I have a curious issue here, maybe someone can help. > > > > I have a single process that inserts data into tables that contain > > purely logging information. This table is then searched by our Care > > department to troubleshoot issues. I am looking for the best way to > > st