lost data

Hi, I've run a safe recover on a table after I had to recreate the index file: # myisamchk --tmpdir=/proxydb/mysql/tmp --safe-recover internet_usage - recovering (with keycache) MyISAM-table 'internet_usage' Data records: 290804216 Data records: 519541696 # After that I ran a query on the table,

Re: repost w/code : can mysql work in Windows but not Solaris?

Hello. Can you succesfully execute your query in mysql client program on your solaris server? leegold [EMAIL PROTECTED] wrote: Is there any reason you can see why the fulltext php/mysql code below works OK on my win2k php4.3.6. mysql 4.1.3 pc but does *not* work when put on a

Re: Replication between different versions

Hello. Besides, is 4.1.8a-1 from Debian identical to 4.1.8 directly from Mysql? There can be some differences. MySQL recommends to use official binaries of the latest release (4.1.9 now). Kay Obermueller [EMAIL PROTECTED] wrote: Hello everybody, I want to setup replication between

Re: How to set utf8 as default character set insteasd of lantin1 ?

Hello. Put the following line in [mysql] section of your config file: default_character_set=utf8 I'm currently using mySQL 4.1.8 with a bug-tracking application- JIRA. (http://www.atlassian.com/software/jira/) In order to display chinese character in JIRA for bug issues, it needs

Re: MySQL 4.1.8 InnoDB: data unavailability among different connections

Jose, to get definitely the latest data, especially if you use the result within your transaction in the next SQL statements, you must use a locking read: SELECT ... LOCK IN SHARE MODE; Regards, Heikki - Alkuperäinen viesti - Lähettäjä: Jose Antonio [EMAIL PROTECTED] Vastaanottaja:

Can Mysql hold possible field values?

Hi, I am attempting to create a database and have a query. Is it possible for mysql to contain the possible field values in the database rather than creating the options in the application? For example Field_A can only be Yes or No, Field_B can be 50% or 80% etc. I feel that creating the

Re: Can Mysql hold possible field values?

Shaun, Check out the enum and set column types in the manual. Enum works well for things like 'Yes', 'No'. For a percentage field, that has to be checked in the application. -Eric On Mon, 17 Jan 2005 14:12:53 +, shaun thornburgh [EMAIL PROTECTED] wrote: Hi, I am attempting to create

Re: Can Mysql hold possible field values?

At 2005-01-17 15:12, shaun thornburgh wrote: I am attempting to create a database and have a query. Is it possible for mysql to contain the possible field values in the database rather than creating the options in the application? For example Field_A can only be Yes or No, Field_B can be 50% or

Re: Can Mysql hold possible field values?

Hi Guys, Thanks for your replies, i have also found SET which appears to do the same thing, is there a reason why everyone suggested ENUM as opposed to SET? Thanks for your help From: Mattias J [EMAIL PROTECTED] To: shaun thornburgh [EMAIL PROTECTED], mysql@lists.mysql.com Subject: Re: Can Mysql

DELETE FROM statement seems not to use my index...

Here is create table def: CREATE TABLE `tblmainupdateinfo` ( `MainID` int(11) unsigned NOT NULL default '0', `ClientID` int(11) unsigned NOT NULL default '0', `UpdateInfo` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY (`MainID`,`ClientID`), KEY `ClientID` (`ClientID`) )

restoring database

hai, i have written a bat file in which the data databackup has been taken in sql it runs automatically every 1 hour and sends a automatically through email now at the other end i have to manually restore the database can any one give me the codes to restore the database automatically

Re: MYSQL + acquiring table relationships

Paul Wallace [EMAIL PROTECTED] wrote on 01/17/2005 12:04:13 AM: Hi, How can I, if at all, acquire table relationships - in particular one-to-may/many-to-one relationships? I have looked into the DatabaseMetaData object (Java) , but have not as yet been able to acquire the said

Re: Can Mysql hold possible field values?

shaun thornburgh [EMAIL PROTECTED] wrote on 17/01/2005 14:57:39: Hi Guys, Thanks for your replies, i have also found SET which appears to do the same thing, is there a reason why everyone suggested ENUM as opposed to SET? SET and ENUM are different things. An ENUM can have only one value

RE: repost w/code : can mysql work in Windows but not Solaris?

Hi, Try to use the same version of php in Solaris as in Windows. Li -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Monday, January 17, 2005 3:24 AM To: mysql@lists.mysql.com Subject: Re: repost w/code : can mysql work in Windows but not Solaris? Hello.

Excluding tables from MySQL bin-log.

Hello, I have a several databases that have one table in them that have thousands of inserts per day. These tables are not mission critical I would like to exclude them from the MySQL bin-logs. As far as I know, MySQL is not capable of excluding tables, just databases. Would this be a valid

Re: Can Mysql hold possible field values?

Thanks for your replies, i have also found SET which appears to do the same thing, is there a reason why everyone suggested ENUM as opposed to SET? ENUM is a type that has many alternative values for one single property: e.g. eye colour is one of these alternatives: brown, green, blue, grey.

Re: InnoDB race condition inserting into a table with a unique constraint

Hi, I'm not sure if this reply to your problem, but it will surely put you on the correct answer. http://dev.mysql.com/doc/mysql/en/InnoDB_Next-key_locking.html Philip Ross wrote: MySQL 4.1.8 I have an InnoDB table with a unique constraint: CREATE TABLE TEST ( ID bigint NOT NULL

create view - what does the algorithm clause do?

I'm using 5.0.2 and playing with views. The documentation indicates: CREATE [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] VIEW . . . I can't figure out what that alrorithm setting changes (it's not discussed in the MySQL documentation). I don't see it in the SQL:2003 docs I have. It looks like

SHOW COLUMNS Syntax Using 3.23.54

Hi, I am trying to get all field names from my table that begin with letter X or Y, however the following statement and many variations I have tried produce an error: SHOW COLUMNS FROM TABLE LIKE X% OR LIKE Y% Any help here would be much appreciated :) -- MySQL General Mailing List For list

RE: MYSQL + acquiring table relationships

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 to detect which rows in the result of that statement are your FOREIGN KEYS. They not only indicate which

Re: DELETE FROM statement seems not to use my index...

Ruben Edna wrote: Here is create table def: CREATE TABLE `tblmainupdateinfo` ( `MainID` int(11) unsigned NOT NULL default '0', `ClientID` int(11) unsigned NOT NULL default '0', `UpdateInfo` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY (`MainID`,`ClientID`), KEY `ClientID`

RE: MySQL 4.1.8 and storing east characters

Japanese AND Cyrillic based languages such as Romania is still messing up. - The Greek and Cyrillic looked ok to me - Unfortunately they are not, some characters are also being given the wrong UTF-8 char code, resulting in the dreaded question marks :-(. - The web browser doesn't have a

Some questions about MySQL engine

Hello there, Any answers to those questions please? 1. Is MySQL coded to work in real-time - or are there some tuneable MySQL parameters that effectively limit the amount of system resources it will use? If yes, what are they? If no, would you therefore expect at least one measureable system

RE: actual size of a innodb tablespace

Thank for your answer. I did a show table status and this is convenient for what I want. But I was surprised that two of the 26 tables give a row number different each time I process a show table status. The size remains the same. In a 3 times show table status I got 699-634-731 rows. A

RE: actual size of a innodb tablespace

I think I can summarize what has been explained before: 1) InnoDB does not always know exactly how many rows are in the database from the point of view of each user. This is a side effect of the row-level locking system. Each user has the potential to see a different set of rows depending on

How Uninstall 3.23 and 4.0?

Hi all. I had both 3.23 and 4.0 separately listed in my WinXP/Home Add or Remove Programs list. I was able to remove 4.0 but not 3.23. (It says it's stopping because it can't locate file uninst.isu.) Also, I still have MYSQL listed in ctl panel / admin tools / services and don't see how to

RE: lost data

Just reposting in case anyone missed it! Or have I asked a dumb question?! Hi, I've run a safe recover on a table after I had to recreate the index file: # myisamchk --tmpdir=/proxydb/mysql/tmp --safe-recover internet_usage - recovering (with keycache) MyISAM-table 'internet_usage' Data records:

RE: lost data

Hi, The only other method I've used is documented in the mysql manual, method 3, this worked fine and brought the table back to life. If your data file is corrupt though, that may mean time to look at your backup. It seems that myisamchk will only really work on the indexes not the data (I may

RE: Insert if Update failed without Select

Hi, Try using the DBI-trace(2) method. This will print a lot of stuff on your screen however it shows the UPDATE after it has bound all the variables etc. You will see the statement as it will be passed to the database. This has saved me a lot of work recently in showing up bugs very quickly.

Replication Slave I/O Thread won't start on 4.1.8

Hey all, I have setup replication in the past on 4.0.x servers so I figured I knew what I was doing...silly me. I reread all of the docs and best I can tell I followed them sufficiently. When I start my slave, the SQL Thread starts, but the I/O thread never starts, and thus the Master Thread

Indizes fr groe Datenbank

Hallo Liste, ich stehe gerade vor dem Problem, dass ich eine große Datenbank (ca. 2 Mio. Datensätze) optimieren muss. Bisher habe ich Webapplikation entwickelt, deren Datenbanken wesentlich kleiner und damit performanter waren. Also stellte sich das Problem bisher nicht. Die Problem-Tabelle

ANN: Gtk2::Ex::DBI-0.6

I'm pleased to annouce the 6th release of Gtk2::Ex::DBI ... http://entropy.homelinux.org/Gtk2-Ex-DBI/ Gtk2::Ex::DBI is an open-source helper object that makes your Gtk2-Perl apps data aware. It handles querying, 'painting' records on your Glade-generated form, passing updates back to the

How do I ... SQL question

Hi there: I have a How do I... SQL question regarding selecting distinct values from a field not included in an aggregated query when LIMIT is in effect, illustrated by the following example: Table a contains the names of individuals, the places they have visited and the year in which they were

Re: How do I ... SQL question

Can't you do: SELECT count(*) AS count, name, year FROM a WHERE place IN ('south','west','east') GROUP BY name, year ORDER BY count DESC, name ASC LIMIT 4 OFFSET 1; [EMAIL PROTECTED] wrote: Hi there: I have a How do I... SQL question regarding selecting distinct values from a field not

Rollback and INSERT_ID() or LAST_INSERT_ID()

Hi List, I have a field in one of my tables that uses auto-increment from MySQL 4.1.8-nt (Windows XP). My problem is to get the last insert ID when the insert fails and I use rollback. The MySQL is still incrementing the field. How can I avoid this if it is possible? I am trying to avoid to use

Re: Indizes fr groe Datenbank

From: Andreas Brandl ich stehe gerade vor dem Problem, dass ich eine große Datenbank (ca. 2 Mio. Datensätze) optimieren muss. Since this list is in English I'll answer you in English, so the others can join the fun! You have to optimize a large database (2 Million records). Feld 'bid' als

mysql_store_result - Error: 2000 (CR_UNKNOWN_ERROR) Message: Unknown MySQL error

Hello, I have searched high and low for more specifics to the problem I am having but to no avail. Hopefully someone here can help. I really appreciate any knowledge that may be imparted. On to the question! We have numerous mail servers running qmail/vpopmail with MySQL used as the backend.

Re: Rollback and INSERT_ID() or LAST_INSERT_ID()

Just let it increment. Keeping it incremented is MySQL's way ot insuring that the same id doesn't get used twice for different records. It's doing everything correctly. -Eric On Mon, 17 Jan 2005 19:06:45 -0500, Andre Matos [EMAIL PROTECTED] wrote: Hi List, I have a field in one of my tables

MySQL Losing database information

ALL, I have an issue where MySQL has lost all of the table information for an existing database, I do not know of anything that has changed and there was no maintenance being done in MySQL. Below you will find the error message as I receive it from MySQL. ANY ideas or suggestions on how to

Build of HPUX-11 client library with +z

Hi, I have a change request. Could you add the +z (or +Z) flag to the compile flags of the standard static mysql client library (libmysqlclient.a) on HPUX. I am building a shared library in my application and it links with libmysqlclient.a. However, on HPUX I have to build my own version of

error 1114 appearing for some tables and not for other tables

hello everybody, We are working on mysql 4.1.8 version and windows XP platform. As every one knew the default table type here is innodb.All innodb data files and index files are stored in ibdata1 tablespace. We started creating user defined tables called sam1 consisting

Re: Rollback and INSERT_ID() or LAST_INSERT_ID()

Thanks Eric, but I can let it increment because I cannot have a gave in the numbers. I think I will need to use MAX() in this case. Thanks. Andre On 1/17/05 8:14 PM, Eric Bergen [EMAIL PROTECTED] wrote: Just let it increment. Keeping it incremented is MySQL's way ot insuring that the same

Ask for input during SQL script execution

All, Can someone point me in the right direction ? I am trying to right sql scripts for queries that will prompt for information. Here is the gist of it, I have a sql script that will query a database however I need the script to ask the user for IP address, and other information that will

Re: Rollback and INSERT_ID() or LAST_INSERT_ID()

At 21:27 -0500 1/17/05, Andre Matos wrote: Thanks Eric, but I can let it increment because I cannot have a gave in the numbers. I think I will need to use MAX() in this case. Using MAX() won't guarantee that you won't have gaps. What you're describing cannot be achieved in the general case.

mysqldump access denied error

I've put together a shell script that is simply - /usr/bin/mysqldump -u user -ppassword db dbBackup.sql When I run this script I get the error 1045: Access denied for user ' [EMAIL PROTECTED]' (Using password: YES) when trying to connect When I log into mysql - user#mysql -u user -p password

RE: mysqldump access denied error

Hi Tait, Have you tried show databases to make sure that user can actually use that database? mysqlshow databases; That will tell you if that user has access as it won't show up in the listing. They may well be able to log into mysql but can they actually access that database is more the

RE: mysqldump access denied error

yes the user can see the databases with 'show databases;' I was thinking that there might be a permissions issue... but it doesn't seem so. thanks, tait tait sanders computer support technician element IT services information services gold coast campus griffith university 9726 australia e

Re: Rollback and INSERT_ID() or LAST_INSERT_ID()

Yes, I know about this. What I plan is to remove the auto_increment. I will do this by hand locking the entire table just right before inserting the field. Actually, it is running like this. I am just upgrading the PHP. I will keep the auto_increment in other tables that does not have this kind

RE: mysqldump access denied error

Check that the user has FILE privileges, given that a SELECT ... INTO OUTFILE sounds awfully like a mysqldump :- The FILE privilege gives you permission to read and write files on the server host using the LOAD DATA INFILE and SELECT ... INTO OUTFILE statements. A user who has the FILE

Error - #1251

I upgrade to 4.1.9 last night and I keep getting this error in PhpMyAdmin after I changed the root password (yes I changed both pw's). Does anyone have a solution on how to fix this? I'm running a Mac 10.3.x #1251 - Client does not support authentication protocol requested by server;

RE: mysqldump access denied error

The user does have file privileges but - I just tried running the same script without the password included. Like the following: /usr/bin/mysqldump -u user -p db dbBackup.sql instead of /usr/bin/mysqldump -u user -ppassword db dbBackup.sql and this worked... so does anyone know what could be

? MySql Server on Suse Linux XP Workstations?

Hi Lists, Question: Who has opinion or experience installing a MySql version 4 or 5 into a Suse Linux Enterprise Server version 9 as a server and ... the clients workstations are Windows XP Profesional? Does it work? How? Any references to read? Thanks, Teddy -- MySQL General Mailing List For

SOLVED:RE: mysqldump access denied error

the solution here is that my password contained metacharacters and therefore I needed to include escapes before eac metacharacter like such: /usr/bin/mysqldump -u user -pg/#o/$ogle db dbBackup.sql this did the trick. thanks all for your help tait -Original Message- From: Tait

Re: ? MySql Server on Suse Linux XP Workstations?

On Tue, 18 Jan 2005 07:51:18 +1100, Teddy Apostol [EMAIL PROTECTED] wrote: Hi Lists, Question: Who has opinion or experience installing a MySql version 4 or 5 into a Suse Linux Enterprise Server version 9 as a server and ... the clients workstations are Windows XP Profesional? Does

backup of database

hello, how to take a backup of database? i have a database with name1 now i want to move all the tables into another database? how to do? kavi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

'TYPE = InnoDB'

Hi, I need to obtain FK data from my DB. I am designing the database using DBDesigner. Using the said tool, do I have to export my schema as SQL and manually append the table type (TYPE = InnoDB) at the end of the table definition? For each table?! For those of you who are using DBDesigner

I'd like to know SQL query for table description.

Hi. ALL i have a database in MySQL. A middleware request to MySQL DB server. and then, result is table description. ex) dbms_type,table_name,column_name,data_type,data_size,constraint_type What SQL query can I get this information ? thank you. -- MySQL General Mailing List For list

[ANN]: DBACentral for MySQL v.1.4 has been released

Hello, The new version of DBACentral for MySQL has been released. DBACentral v1.4 introduces PHP-based web pages for viewing and editing table data, secure SSH tunneling, and other features. Download link: http://microolap.com/products/database/mydbacentral/download/?r1=mailr2=central14

Re: Error - #1251

At 2005-01-18 04:53, Craig Hoffman wrote: I upgrade to 4.1.9 last night and I keep getting this error in PhpMyAdmin after I changed the root password (yes I changed both pw's). Does anyone have a solution on how to fix this? I'm running a Mac 10.3.x #1251 - Client does not support

create view not working on mysql 4.1.8

we are working on mysql 4.1.8 and windows XP platform. This version supports views.We created a view like this mysqluse sample mysqlcreate view v1 as select * from sam2; sam2 is a table We got an error errror 1024(42000):you have an error in your sql syntax; we checked the manual

Re: create view not working on mysql 4.1.8

sirisha gnvg wrote: we are working on mysql 4.1.8 and windows XP platform. This version supports views.We created a view like this mysqluse sample mysqlcreate view v1 as select * from sam2; sam2 is a table We got an error errror 1024(42000):you have an error in your sql syntax; we checked the