Backup problem

This is what I need to do, what is the best approach for doing this? I need to take backup of few tables in mysql, then I need to drop that entire DB, recreate it, (and sth else that's not relevant here) and then restore these backed up tables. This backup and restoring should be as fast as possib

Re: 2 questions: hostname variable and exit if slave

Regarding number 1, you might be able to do something with this: mysql> show variables like 'pid%'; +---+-+ | Variable_name | Value | +---+--

2 questions: hostname variable and exit if slave

I have 2 unrelated questions: 1) Is there any way to get the hostname that the server is running on from within mysql? All I can come up with is (pseudo coded): mysql> system echo insert mysql.hostname `hostname` ... > hostname.sql mysql> s

Delete duplicate entry

Hi, I have a table that looks like: CREATE TABLE `message_inbox` ( `member_id` mediumint(8) unsigned NOT NULL default '0', `message_id` int(10) unsigned NOT NULL default '0', `new` enum('y','n','replied') NOT NULL default 'y', `datetime` datetime default NULL, KEY `idx_1` (`member_id`,`ne

Re: Repeated corruption with MySQL 4.1.x using FULLTEXT indexes

Ed Lazor wrote: -Original Message- From: Christopher L. Everett [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 1:47 AM To: Mysql List Subject: Repeated corruption with MySQL 4.1.x using FULLTEXT indexes I have an application where I create a faily large table (835MB) with a ful

Re: Mysql Query Browser is not launch

Spenser wrote: I just tried installing it on my RedHat Linux 8 laptop and it complained about libXcursor.so. This is the message: error while loading shared libraries: libXcursor.so.1: cannot open shared object file: No such file or directory I downloaded the full tar ball version. I'm using the

Replication problem with a cross database query

I originally posted a query about a problem entitled "Table doesn't exist on query replication problem..." The original title might be a little misleading. The slave replication is halting on a transaction that contains a query that spans two databases - one that is being replicated and the other

Re: Mysql Query Browser is not launch

I just tried installing it on my RedHat Linux 8 laptop and it complained about libXcursor.so. This is the message: error while loading shared libraries: libXcursor.so.1: cannot open shared object file: No such file or directory I downloaded the full tar ball version. I'm using the Gnome 2 deskt

Re: Mysql Query Browser is not launch

[EMAIL PROTECTED] wrote: Dear list. I´m trying to work with Mysql-Query Browser Application. So, I installed it following the manual instructions but when I try to run it cannot be launched. Into the ./mysql-query-browser/bin directory I type mysql-query-browser and I receive this error messag

Mysql Query Browser is not launch

Dear list. I´m trying to work with Mysql-Query Browser Application. So, I installed it following the manual instructions but when I try to run it cannot be launched. Into the ./mysql-query-browser/bin directory I type mysql-query-browser and  I receive this error message: bash:mysql-query-brow

Re: COMPRESS engine

Thanks, I'll give it at try. Richard On Wed, Oct 06, 2004 at 05:14:01PM -0500, Dan Nelson wrote: > In the last episode (Oct 06), Richard Jacobsen said: > > I've got some large tables, ~160GB each with indexes, which are only > > used for read only access. Since obviously all table space doesn't

Re: COMPRESS engine

In the last episode (Oct 06), Richard Jacobsen said: > I've got some large tables, ~160GB each with indexes, which are only > used for read only access. Since obviously all table space doesn't > fit in memory, Will using the compress engine speed reads/seeks on > these tables up at all, or will th

Re: Connection Errors

Dave Goodrich wrote: [Previously posted to MySQL forum] Howdy the group, I have a cluster of email servers all using mysql for authentication. Using vpopmail and spamassassin, all auth requests, pop, delivery instructions, etc, go to mysql. Currently we process between 50k and 65k messages a day

COMPRESS engine

Hi everyone, I've got some large tables, ~160GB each with indexes, which are only used for read only access. Since obviously all table space doesn't fit in memory, Will using the compress engine speed reads/seeks on these tables up at all, or will they slow them down considerably? Thanks, Rich

init.d - need 'status' option

I am implementing mysql on a Redhat Cluster for high availability and will be using replication. I wanted to use 4.1.5, but learned that the cluster suite requires an init.d script that will answer to the 'status' command. 'status' does not seem to be included anymore. [RH will only support a

RE: Long Running Queries

Take a look at the docs for EXPLAIN (manual.html#IDX853). Use the 'possible_keys' column of the results to determine which column indexes will improve your query performance. Make sure your table has a primary key. Whenever possible, use the primary key in your WHERE clause when you SELECT or U

corruption after database restore

I'm having a corruption problem after doing a backup and then a restore with ibbackup (v1.40). After restoring from the backup, when mysqld starts I get: 041006 07:46:53 mysqld started InnoDB: Warning: an inconsistent page in the doublewrite buffer InnoDB: space id 0 page number 5877102, 7'th pa

select query does not work :(

Hi we need to order a field in a select query... The criteria is based on greek language... The problem seems to be no support for greek language I can change everything in the my.cnf so tell what to do ___ Do you Yahoo!?

Re: Long Running Queries

I wish we had thought to have had him benchmark a query before and after he added an index. It would be interesting to see the difference in actual time that an index can make on a table with 450,000 records. On Wed, 2004-10-06 at 15:31, Jason Williard wrote: > Amit, > > You are awesome! Tha

terrible time installing MySql

Please help I'm have a terrible time installing MySql SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: j2d To: [EMAIL PROTECTED] Subject: [50 character or so descriptive s

Re: Date Type Probelm

Yep.. I tried a simpler query and it worked as well as working fine in MySQL Control Center as it is written here. The problem arose when I moved the DB from 4.1?? to 3.23.37, and that is when this showed up. I was wondering it is has to do with the way MySQL 3.23 is formating the date field, a

Re: Long Running Queries

Before: 57 seconds After: <1 second :-D Thank You, Jason Williard Client Services Spenser wrote: I wish we had thought to have had him benchmark a query before and after he added an index. It would be interesting to see the difference in actual time that an index can make on a table with 450,0

Re: User Authentication

Brandon, You'll have to create a user for the PHP script. example: In the above code you'll have to create a user for the PHP script (mysql_user and msyql_password) and make sure that it has the proper permissions. At minimum I would think SELECT, INSERT, UPDATE and DELETE, for that user with

Re: Table doesn't exist on query replication problem...

Hello, I suggest to you have the same version of mysql in both servers. regards El Miércoles, 6 de Octubre de 2004 13:07, Bill Thomason escribió: > Hi, > > I have a mysql 4.0.21 master and a 4.0.18 slave. > > I am trying to maintain a replication of a DB named masterdb. > > My goal is to have

Re: Long Running Queries

Amit, You are awesome! That fixed it quite nicely. Our system is screaming now :-) Thank You VERY MUCH!, Jason Williard Client Services [EMAIL PROTECTED] wrote: Do this and tell me if it helped ALTER TABLE `asticketsdata` ADD INDEX ( `ticketidchar` ) Regards, Amit -Original Message-

RE: Long Running Queries

Do this and tell me if it helped ALTER TABLE `asticketsdata` ADD INDEX ( `ticketidchar` ) Regards, Amit -Original Message- From: Jason Williard [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 1:42 AM To: Wadhwa, Amit Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Long

RE: Speeding up index creation

Use Alter table Disable Keys, before loading the Data to your system, and then Alter table enable keys, This way you wont have to recreate your indexes -Original Message- From: Ananth Reddy [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 10:08 PM To: [EMAIL PROTECTED] Su

Re: Long Running Queries

Thank you for your assistance with this. Here's what you were asking for. Structure Output: # # Table structure for table 'asticketsdata' # CREATE TABLE asticketsdata ( ticketdataid int(11) NOT NULL auto_increment, ticketidchar varchar(255) NOT NULL default '', ticketidno int(11) default NUL

RE: Long Running Queries

Sorry this is still new for me and I'm learning as I go. As I become more knowledgeable my questions will become more specific and detailed. Next question: If I have certain fields within tables that I will be querying often it is beneficial to set them as indexes for speedier lookups correct? I

RE: show processlist state value 'statistics'

I have seen a similar option in PHPMyAdmin which says 'Enable Statistics' I suppose when the status shows statistics, mysql is just updating the statistics in there for the query just run? -Original Message- From: Ananth Reddy [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004

RE: Long Running Queries

What do you mean by "appropriate indexes?" -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 3:43 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Long Running Queries You need Appropriate Indexes on the tabl

Re: Tying records together across multiple tables.

See interspersed. --- [EMAIL PROTECTED] wrote: > Let's do this verbally and maybe the database > structure will become > intuitively apparent > > You are hosting a website that supports job seekers > (maybe more but let's > concentrate on just this side of it) Yep, there is the employer si

Re: Tying records together across multiple tables.

--- [EMAIL PROTECTED] wrote: > Let's do this verbally and maybe the database > structure will become > intuitively apparent > > You are hosting a website that supports job seekers > (maybe more but let's > concentrate on just this side of it) > > Each seeker (a User) can have a profile in

Re: Long Running Queries

Not without more information. At the very least, we need to see the query. Better yet, show us what EXPLAIN has to say about your query . Michael Jason Williard wrote: Hello, I recently began experiencing issues that I would like some assistance

RE: Long Running Queries

"appropriate indexes" would mean indexes on columns specified in your where criteria. On this List, people mostly post table structures, as well as the queries they are firing, or else it really doesn't help. -Original Message- From: Danny Willis [mailto:[EMAIL PROTECTED] Sent: Thursday,

Weirdness (or bug) with DROP TABLE

I am using Mandrake 10, MySQL 4.1.5 from RPM downloaded from dev.mysql.com. Look at this session: $ mysql -u root -p permarn Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 4.1.5-gamma-standard Type 'help;' or '\h'

Re: Long Running Queries

I'm sorry to sound like a novice, but could you explain that? Are you recommending that I set the column I am searching to an Index? Thank You, Jason Williard Client Services [EMAIL PROTECTED] wrote: You need Appropriate Indexes on the tables. -Original Message- From: Jason Williard [

Re: Long Running Queries

Is the table indexed in any way? At 03:40 PM 10/6/2004, you wrote: Hello, I recently began experiencing issues that I would like some assistance with. Server Details: - Windows 2003 - MySQL Max 4.0.20a I have a table with 450,000+ records in it. When I try to run a single query, such as selecti

RE: Long Running Queries

You need Appropriate Indexes on the tables. -Original Message- From: Jason Williard [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 1:11 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Long Running Queries Hello, I recently began experiencing issues that I would like so

Long Running Queries

Hello, I recently began experiencing issues that I would like some assistance with. Server Details: - Windows 2003 - MySQL Max 4.0.20a I have a table with 450,000+ records in it. When I try to run a single query, such as selecting 1 row or deleting 1 row using the WHERE clause, the query can t

Re: update MySQL

On Wednesday 06 October 2004 02:10 pm, Scott Hamm wrote: > Like I said before it "seems" to group by "threads". Therefore, it is > close enough. Right! thats why Microsoft thrives. Because as long as it appears to work, its all good.. :) Jeff pgpAXe4d5h6QD.pgp Description: PGP signature

Re: Tying records together across multiple tables.

Let's do this verbally and maybe the database structure will become intuitively apparent You are hosting a website that supports job seekers (maybe more but let's concentrate on just this side of it) Each seeker (a User) can have a profile in the system Each profile describes who the User i

Re: update MySQL

Hey folks. Apparently I need to say it again: this discussion is off-topic for this mailing list. Please either let it die or take the discussion off-list. Thanks. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

RE: update MySQL

Like I said before it "seems" to group by "threads". Therefore, it is close enough. -Original Message- From: Michael Satterwhite [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 3:05 PM To: [EMAIL PROTECTED] Subject: Re: update MySQL -BEGIN PGP SIGNED MESSAGE- Hash: S

Table doesn't exist on query replication problem...

Hi, I have a mysql 4.0.21 master and a 4.0.18 slave. I am trying to maintain a replication of a DB named masterdb. My goal is to have multiple slaves with a copy of masterdb. On the master I specified in my.cnf binlog-do-db=masterdb. On the slave I specified replicate-do-db=masterdb in my.cnf.

Re: update MySQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 05 October 2004 14:39, Scott Hamm wrote: > Jeff, > > If you sort it by conversation topic, then it will seem to group by > "threads". > I'm running Outlook 2000. Not the same thing. Threading uses the "In-reply-to" header. Messages wi

Re: update MySQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 05 October 2004 14:23, David Brodbeck wrote: > Well, that's nice... > > I just don't see what difference it makes. As far as I can see, the > outcome is identical either way... If the recipients email program threads messages, it makes a b

Re: User Authentication

Try to imagine your PHP code as a "middleman" or "clerk" working a walk-up window for some kind of office. It is that clerk's job to handle incoming requests, file the correct paperwork, hand out a receipts, perform searches, and hand out the requested information. Your clerk (the application

Re: Tying records together across multiple tables.

Shawn, When I read your examples, it is clear as a bell. When I try to map it into my situation it becomes more difficult to clarify :) Using other job boards as examples, there are a couple of ways to go. Most of the bigger players offer job seekers the ability to store 5 resumes online. These

Re: update MySQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 05 October 2004 15:18, Ed Lazor wrote: > Also, back to my original question, what are you seeing that denotes the > difference between whether I reply or create a new message when starting a > new topic? After all, I took care of changing

Connection Errors

[Previously posted to MySQL forum] Howdy the group, I have a cluster of email servers all using mysql for authentication. Using vpopmail and spamassassin, all auth requests, pop, delivery instructions, etc, go to mysql. Currently we process between 50k and 65k messages a day inbound. Each delive

Re: User Authentication

Security is built in shells (much like onions). Application layer- This is where your user interacts with your code. In your case, I believe that you have a web server running code you wrote in PHP responding to user requests. Your web server uses a user account to interact with the operatin

RE: Date Type Probelm

Have you tried a more simple query to make sure that communication between your application and the database is working properly? Have you tried a variable name for 'Tick Date' that does not include spaces? -Ed > -Original Message- > Hello all.. I'm running into a little bit of a proble

RE: User Authentication

Are you talking about user authentication for the purpose of people accessing the MySQL database or are you talking about user authentication in terms of people accessing restricted areas on a website? > -Original Message- > I have never set up a web site running a mysql server, > so I am

show processlist state value 'statistics'

Does anyone know what is the meaning of value 'statistics' in state column of show processlist? It is displaying this state during a SELECT query. I noticed lot of them in DB while our application is being run in a stress mode. This is not documented in Mysql documentation for show processlist TI

User Authentication

I have never set up a web site running a mysql server, so I am little fuzzy on details concerning user authentication. Let's say I am creating a page where the user will enter his/her information. I write a PHP script to update the mysql table when they click 'submit'. Do I have to grant privele

Date Type Probelm

Hello all.. I'm running into a little bit of a problem.. I'm writing a program in VB.NET and every time i try to load query results into my dataset i keep getting: /An Unhandled Exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: Inconvertab

Speeding up index creation

We have MyISAM table with 150 million rows. The data is being laoded from other system. When I load data without indices, it is fast (30 minutes) but creating index is taking 15 hours. Load data with indices is taking 30 hours (worse than the other option) I am wondering if there is a way to spee

Benchmaking queries...

Hi MySql freaks ! Does someone know if it exists a more precise way to compare two queries on an other base than the time to process the request? For example, is it possible to know the numbers of flops needed or memory allocated to process the query ? Thanks in advance! Michael -- MySQL Gener

mysql embedded with TCP support

Hello I am a newbie @ mysql so excuse me in advance for silly questions. I am preparing to develop an embedded application on a PC104 board with linux. I was hoping to use mysql embedded but have disovered in the documentation that it cannot be accessed via TCP from another process. I suppose

RE: Repeated corruption with MySQL 4.1.x using FULLTEXT indexes

> -Original Message- > From: Christopher L. Everett [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 06, 2004 1:47 AM > To: Mysql List > Subject: Repeated corruption with MySQL 4.1.x using FULLTEXT indexes > > I have an application where I create a faily large table (835MB) with a > fu

Lost Connection to MySQL server during Data Load

I'm trying to import data in a sparsely populated table from a text file. I've attempted this with mysqlimport and the LOAD DATA command. In each case I get an ERROR 2013: Lost connection to MySQL server during query. My tables are InnoDB type and the database is small. I'm running Fedora Linux 2.6

Re: Error message on windows xp install

Also keep in mind that if you have XP SP2 installed all of your ports are blocked (except Port 80 of course) You will need to reconfig the Firewall available in Control Panel specifically TCP 3306 4759 BTW: It would be helpful to place Port Assignment information in System Requirements I found it b

Re: Repeated corruption with MySQL 4.1.x using FULLTEXT indexes

I've also found a problem with "myisamchk --sort-keys": christopher:/var/lib/mysql/dmoz# myisamchk -rq xurls - check record delete-chain - recovering (with sort) MyISAM-table 'xurls' Data records: 1981904 - Fixing index 1 - Fixing index 2 - Fixing index 3 Data records: 4332227 christopher:/var/lib/

need documentation of MyISAM file structures

Hi, we are recovering from a drop database and we need a clear description of the structures of all MyISAM data files (especially the dynamic table structure) in order to speed up our present reverse-engineering activities. We are trying to recognize unallocated (disk) blocks to determine whethe

Repeated corruption with MySQL 4.1.x using FULLTEXT indexes

I have an application where I create a faily large table (835MB) with a fulltext index. One of our development workstations and our production server will run the script to load the table, but afterwards we have a pervasive corruption, with out of range index index pointer errors. Oddly, my devel

Problem with order by .......... asc

Hi we need to order a field in a select query... The criteria is based on greek language... The problem seems to be no support for greek language I can change everything in the my.cnf so tell what to do - Do you Yahoo!? vote.yahoo.com -