mysqldump: Error 2013: Lost connection to MySQL server

Hi all. I have a 30GB innodb-only database in mysql-5.0.54. I have always done nightly backups with: mysqldump --opt db_name db_name.sql -p Recently this started failing with: Error 2013: Lost connection to MySQL server I have checked all tables for corruption - nothing found. Also as far as I

Re: Help needed

On Sat, 2008-05-10 at 20:59 +0400, Velen wrote: Hi, I'm testing a program and I need you assistance. Please unzip the file at http://www.biz-mu.com/PCID.zip and run the program. Please supply a Linux version of your virus so I can test. -- Daniel Kasak IT Developer NUS Consulting Group

Re: Cross database queries

-database joins considered good practice? If separating tables into different databases makes things easier for you, then ( at least with MySQL ), I don't see any problems. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2

Corruption? Performance issue + strange 'explain'

tried doing a 'check tables' thing from the MySQL administrator ( the longest one ... 'changed' ). It didn't find anything. Is it time to drop everything and restore from a backup? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61

Re: Corruption? Performance issue + strange 'explain'

in the tlocations table? 1 I'd also assume that since it's named 'id' it would be a primary key (and indexed) ? Indexed, yes. I'll go ahead with that restore from a backup tonight. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T

Re: Where can I get mysql.so?

? Was it with a package manager, or was it already installed by your distro, or did you install it manually? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http

Need a *little* help with a procedure

/ TotalDays ) as ProjectedAnnualSpend from GasLocations where LocID = GasLocationID; END --- -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http

RE: Ouch! ibdata files deleted. Why no catastrophe?

, and imported, and everything went fine. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list

Ouch! ibdata files deleted. Why no catastrophe?

# The only way I can explain the fact that things are still working is that these files are in fact *not* deleted, and are still in use by mysql, but not visible to anything else. But that's ridiculous as well. So what's going on? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific

Re: Ouch! ibdata files deleted. Why no catastrophe?

? At this point, I still think it might be a better idea to do a complete reinstall / restore / transaction log run. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website

Re: Ouch! ibdata files deleted. Why no catastrophe?

again for your response. At least I learned about lsof and recovering deleted files :) -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http

Re: Extensive Project help

the enitre SQL here for u to use, please someone respond as i would like to get this accomplished as soon as possible, Your best bet is to post the problem to the mailing list. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61

Re: Hybrid Environment

( commercial distribution of Wine ). Once you've had a stable, hassle-free desktop for a couple of months, then you can start moving others with some confidence. Enjoy :) -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F

Re: database cache /

on appropriate fields. Generally you want them on fields used in joins, and fields in your 'where' clause. If you post your query and the output of 'show create table TABLE_NAME' for each table involved, someone might suggest which fields to add indexes to. -- Daniel Kasak IT Developer NUS Consulting Group

Re: Document archiving

just tell me, for hack one or develop from scratch. I'm OK with everything apart from the Java bit. Sorry. It's not really my cup of tea ( no offence ... I realise that most Java people say the same thing about Perl ). -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway

Re: Document archiving

can't find anything, and I may ( time permitting, and I obviously can't do it here at work, or it wouldn't be open-source ) have a go at it. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989

Re: more than 10000 fields in the OR clause

performance across slow network connections ( eg DSL ). -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing

Re: Why doesn't the InnoDB count() match table status?

() if it makes you happy. This is absolutely baffling and astonishing how a company so seemingly smart could make such an incredible blunder. :-\ Oh the melodrama! Won't someone please think of the children! -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North

Re: Posting A Question

John Sutton wrote: Hi... How do I go about posting a question about MySQL? I think you're getting the hang of it. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL

Re: Temporary table lifespan

be able to see the table. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives

Re: Temporary table lifespan

or something ). -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http

Re: ODBC connector 3.51/5.0

should go back to the previous stable version ( 3.51.06 ) as recommended, but you will have to also go back to MySQL-4.0.x or tell your post-4.0.x server to use the old authentication method. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia

Removing space characters ... char(160)? ... char(194)?

). It defies logic. Who knows what's going on? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List

Re: Visual Basic 6 + MySQL

://entropy.homelinux.org/axis/ It's a whole lot faster than VB, and also cross-platform ( tested heavily under Windows 2000 and Gentoo Linux, and initial development done on OS-X ). If you don't wanna use Perl, then try the PHP bindings for Gtk2 instead :) -- Daniel Kasak IT Developer NUS Consulting Group

Include a stored procedure ( that returns a recordset ) in another query

the SP to the query, but in some other cases, the SP bit will be quite complex. Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http

Re: Selecting Different Tables Based on Value. Case seems to fail.

-join all the tables, and then put the case statement in the select statement. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au

Re: Selecting Different Tables Based on Value. Case seems to fail.

through hoops to join to the right table. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List

Re: Help optimizing this query?

for each record? It's possible that it does. You could try doing this in a separate query / calculation, and then pass the result into the query. Anyway, investigate it ... as I said, I'm not sure how MySQL handles this. Maybe others can comment. -- Daniel Kasak IT Developer NUS Consulting Group

Illegal mix of collations

(latin1_swedish_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation 'replace' I have no idea what it's talking about. How do I fix it? Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2

Re: Where to get Source Distribution of MySQL Server 5.0 Standard for FreeBSD?

VeeJay wrote: Hi Where one can find Source Distribution of MySQL Server 5.0 Standard for FreeBSD? Not on the website, that's for sure. Have you tried the usual warez sites, p2p networks, etc? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW

InnoDB: What happens when a single AUTOEXTEND file goes past 2GB?

Hi all. I'm about to import a LOT of data ( 20 GB ) into some InnoDB tables. At the moment, I have: innodb_data_file_path = ibdata1:10M:autoextend in my /etc/mysql/my.cnf The ibdata1 file is 499MB at the moment. What happens when this goes past 2GB? Do I automatically get allocated

Re: InnoDB: What happens when a single AUTOEXTEND file goes past 2GB?

Carlos Proal wrote: Daniel, innodb data files keep growing as needed, it even be of 20Gb or more. I was under the impression that you should avoid files 2GB on 32 bit systems, which have to do some dodgy stuff to support files bigger than 2GB. Does this advice apply? If you want several

Re: InnoDB: What happens when a single AUTOEXTEND file goes past 2GB?

Paul DuBois wrote: At 10:57 AM +1100 12/4/06, Daniel Kasak wrote: Carlos Proal wrote: Daniel, innodb data files keep growing as needed, it even be of 20Gb or more. I was under the impression that you should avoid files 2GB on 32 bit systems, which have to do some dodgy stuff to support

Re: Views accessed as table in MS Access

), and then delete the MS Access link when you're done ( and delete the temporary table ). You can write a function that does this, and call it view_my_view() or something :) -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F

Re: check bugs.

many records are present. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives

Re: Oracle query..

there will be able to give you more accurate advice than people here? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General

Re: Oracle query..

' to find the exact format and commands to use. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List

Re: Oracle query..

tools are going to be the best bet, as they will set up your table definitions. There is a *remote* chance that Oracle will be able to import from a 'mysqldump' backup. You can also check that out, but I doubt it will work somehow. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77

Re: Importing a Database (.mpb file)

for you. It's been a very long time since I looked at these - probably 5 years or so. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http

Re: Locked Table Issue..

Access apps. If you know some Perl, you can always use something like: http://entropy.homelinux.org/axis_not_evil -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED

Re: Seperating Application server and Database server

? Performance. And keep in mind that communication between MySQL and your application server will be *considerably* faster when they're both on the same system. If you put them on separate systems, obviously communication between the 2 will now be over the network. -- Daniel Kasak IT Developer NUS

Re: First View

and zero bugs, and progressively remove features and add bugs, while decreasing the version number. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http

Re: #deleted records in access

are used by a application I don't want to break. Is a solution without the need to change the tables ? You won't break anything by adding a timestamp field. Trust us :) And no, there is no way around this problem other than adding a timestamp field. -- Daniel Kasak IT Developer NUS Consulting

Re: #deleted records in access

Andreas Moroder wrote: Daniel Kasak schrieb: Andreas Moroder wrote: Hello, when I open mysql table with access 97 using the latet mysql-odbc driver ( 3.51.12 ) I see only deleted records. What is happening ? I found many posts about this problem, but I can not, as told in this posts

Very long pauses on particular tables

? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Very long pauses on particular tables

the names that are connecting to it? (ie is reverse dns set up properly). Um. Don't know that one. I'll forward this off to their IT guy and see. Thanks for the quick response :) Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T

Re: Very long pauses on particular tables

to make sense ... apart from the fact that this only seems to affect particular tables. But anyway, I'll certainly DNS lookups for MySQL. Thanks for your help. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F

Re: Returning Resultsets from Stored Routines

are in luck. If you are using MyODBC, then you will have to wait until the v5 connector is complete. If you are using DBD::mysql, then I'd be interested to hear how it works out - I'm about to start testing that in the next couple of days. I don't know the status of the JDBC or PHP drivers. -- Daniel

Views can't refer to temporary tables

Greetings. Continuing on from my previous question, I've discovered that I *can't* create views which refer to temporary tables. Is there any plan to drop this requirement? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2

Question on views, stored procedures temporary tables

that creates and populates the temporary tables? Thanks :) Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL

Re: MS Access gives error no. -7776.

column isn't larger than an int ( ie don't use int unsigned, and don't use bigint ). -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http

Re: Using MySQL as backend

sharvan kumar wrote: Dear Sir/Madam I am working on a project where I am to use PHP as front end and MYSQL as backend.MySQL stand alone is working properly,but it is not connecting with PHP.Please tell me solution. Connect it. -- Daniel Kasak IT Developer NUS Consulting

Re: MS Access gives error no. -7776.

-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Works in SQL Manager, but not PHP?

and execute them 1 after the other. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list

Re: Reset (or Defrag) the AUTO_INCREMENT columns

. Instead, use a numeric column and write some code to create your next primary key value. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http

Re: Reset (or Defrag) the AUTO_INCREMENT columns

mediumint. The 'unsigned' bit means that the field won't store negative values - this gives you twice the positive numbers you can store. Otherwise if you're already using an unsigned data type, then just go up to the next data type ( eg mediumint to int, or int to bigint, etc ). -- Daniel Kasak

Re: UPDATE from one server to another

://entropy.homelinux.org/axis_not_evil And also please send feature requests, bug reports, and contributions :) Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED

Re: How do I get off this list that I do not remember joining in the first place!!!!

. Otherwise, see the list administrator. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List

Re: How do I get off this list that I do not remember joining in the first place!!!!

Phil Robbins wrote: NOTHING Perhaps you should read the notice at the bottom of each post that you receive from the list !!! -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922

Re: Output to a file

logfile.txt Or you can start mysql with the --tee switch, eg: mysql --tee logfile.txt -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au

Re: HELP --- Slow SP

in a join or a where clause if ONLY that field is included in the index. If you pack 3 fields into an index and then try to join on ONLY ONE field, the index can't be used. So look at your joins and where clauses and make sure your indexes match. -- Daniel Kasak IT Developer NUS Consulting

Re: HELP --- Slow SP

strange. Anyway, what output do you get if you put 'explain ' in front of your queries? Are the indexes being used? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED

Re: HELP --- Slow SP

are using the index, then setting up a new primary key and indexes will not help. Personally, I would do it anyway, but this won't help out in your current case. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F

Re: Document / Image (Blob) archival -- Best Practices

. If other people show an interest I'll have one up over the next couple of days / weeks. It will of course be cross-platform. Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL

Re: Reserevd Error -7776 -- Urgent

work the 4th time ... -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives

Re: auto_increment and the value 0

things up, and then move the data I would take the 2nd option. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL

Re: auto_increment and the value 0

the primary key of the existing record. Either way, you will have issues with restoring from backups if you keep an auto_increment column with a zero value around ( as you've discovered ), so what ever you do, you need to get rid of those zero values. -- Daniel Kasak IT Developer NUS

Re: 1 day left: 75% discount on MySQL/Firebird/InterBase/Oracle/SQL Server developer tool!

the volume of traffic generally, I don't think it's justified to start chasing ( on-topic ) commercial announcements out of the list. I don't know about any official policy. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2

Re: How stable will mysqld [compiled from source] be on linux 2.4 with glibc 2.3.2 (gcc 3.3.4)?

, the first thing they will suggest is that you try one of their binaries -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au

Re: mysqlimport, \r\n and \n

it in my cgi-bin folder, and opening Firefox from Access, passing the script some pointers to the file. But that's dodgy. I suppose while I'm working with Access I'd better get used to dodgy solutions, eh? ;-) -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney

mysqlimport, \r\n and \n

way to ease my pain here, short of importing with one format, counting the number of records, truncating the table, importing wit the other format, counting the number of records, and then selecting the format with the most number of records? -- Daniel Kasak IT Developer NUS Consulting Group

Re: MySQL says, Ich don't think so (Subquery woes)

it to create a temporary table *with* *indexes* on fields you will be joining on. I was hoping MySQL would support automatically indexing result fields inside a sub-query like this, but apparently it's not on the cards :( -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway

Re: dependency issues: coreutils and perl(DBI)

, or you can force an install without checking for dependancies. I haven't used rpm in over 5 years, so I can't really give you any specifics, but 'man rpm' will help. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676

Re: MySQL View Optimization Help

[EMAIL PROTECTED] wrote: Views differ from tables in that they cannot be indexed. I've just started experimenting with derived tables under 4.1.14, and I had a hunch this was so. Is there any plan to include index support for views / derived tables? -- Daniel Kasak IT Developer NUS

Re: MySQL 5.0.15 in Linux OS

at the INSTALL-SOURCE file in the source distrubution. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List

Re: MySql 5 replacement for computed default column value

Harald Fuchs wrote: In article [EMAIL PROTECTED], Daniel Kasak [EMAIL PROTECTED] writes: Bryan Cantwell wrote: Trying to migrate to MySql 5 from Sybase asa. I have a tables that have column values that are calculated based on other columns in the table. How can I accomplish the same

Re: MySql 5 replacement for computed default column value

, so I can't help you with exactly how to do it. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing

Re: GUI (linux X based or web based) for mysql

modules. Hopefully over Christmas I'll get time to finish it off. Oh yeah ... did I mention that it's all cross-platform goodness? :) I've tested on Linux, Windows 2000 and OS-X. You will of course need to install Gtk2 for the last 2, but it's not that hard - at least on Windows. -- Daniel Kasak

Re: Report tool - Mysql

defense, it's not particularly hard to do :) After you've written the report definition, you load an array of data ( eg from a database query ), and pass it to PDF::ReportWriter. There's a simple example on the webpage, along with a screenshot of the output ( inside gpdf ). -- Daniel Kasak

String Formatting

of if(), length(), locate() etc? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives

Re: String Formatting

-and-time-functions.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine Thanks :) -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website

Re: Character set issue ( maybe )

Octavian Rasnita wrote: From: Daniel Kasak [EMAIL PROTECTED] OK then. Lets re-word the question ... Has anyone been able to successfully enter text of a non-standard character set ( Latin 1, UTF8 ) into Query Browser? How about upload via a Perl script? Yes you can insert those

Re: Character set issue ( maybe )

the data in ( query browser / in-house Perl Gtk2 app ), the data *looks* perfect when I paste it in, but when I return to look at it later it's corrupted. Thanks for the reply, by the way :) Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW

Character set issue ( maybe )

DBD-mysql-2.9007, compiled against mysql-5.0.something. I've got gtk+-2.8.6. Anyone got any ideas? Is this a Gtk2 problem ( Query Browser and my app are using Gtk2 ), or is it a driver issue, or a table issue? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North

Re: Character set issue ( maybe )

exactly the same results. I can't go back to using the mysql console, as other people have to be able to do this, and they require a GUI. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989

Re: Newbie question to both lists on listing open issues regardless of project

is: if ( condition, value_if_true, value_if_false ) You can also use 'case' statements: case when condition then value_if_true else value_if_false end Substitute your: - condition - value_if_true - value_if_false into the above syntax. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific

Re: com_* show status variables broken in MySQL 5

of thing a while ago: http://bugs.mysql.com/?id=14307 Unfortunately it's been marked as 'not a bug', which I disagree with, but since it's only a cosmetic problem in our case, I decided not to throw any more energy at it. Feel free though ... -- Daniel Kasak IT Developer NUS Consulting Group Level 5

Re: MySQL 5 is 25% slower then 4.1

than issuing separate inserts per record. You don't want to include *too* many records at once - there's a maximum packet size or something like that that you can't exceed. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2

Re: MySQL 5 is 25% slower then 4.1

solution is in order? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http

Re: Character set issue ( maybe )

OK then. Lets re-word the question ... Has anyone been able to successfully enter text of a non-standard character set ( Latin 1, UTF8 ) into Query Browser? How about upload via a Perl script? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW

Problem ( large problem ) with date fields after 4.0.x to 4.1.x upgrade

| | | -00-00 || etc ... Should I report it? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http

Re: Problem ( large problem ) with date fields after 4.0.x to 4.1.x upgrade

Jim Winstead wrote: On Wed, Nov 09, 2005 at 02:06:59PM +1100, Daniel Kasak wrote: Background on data: mysql select ID, Loc_FK, BatchNo, EAPDate from EAPosting where Loc_FK=7249; +---++-++ | ID| Loc_FK | BatchNo | EAPDate

Re: Access 2002 hangs with MyODBC 3.51.11

. 3.51.06 worked well for me. Alternatively, you can track down 3.51.12 - there was a link posted to it in the MyODBC mailing list. It also works for me, but it's not actually released yet, so you might be better going with 3.51.06. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77

Re: Tracking changes in the database

learn to use the binary log. As I noted before, the plain-text log has some issues. I'm not sure what all of them are, but I've encountered issues when using plain-text logs and temporary tables ( eg 2 users create temporary tables - in the plain text log, it looks like the 1 user ). -- Daniel

Re: ANTs Benefits as Oracle Acquires InnoDB

protection around http://mail.yahoo.com You damn well bet I'm tired of spam, current thread included. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http

Re: Tracking changes in the database

way. There's also a plain-text log, but you'll run into issues if you're using temporary tables, amongst other things. Also, the plain text log has been removed from 5.0.x ( I believe ). You can enable either with startup switches or with entries in the my.cnf file. -- Daniel Kasak IT Developer

Backup / Restore database with foreign keys

a new database and try to load the dump file: mysql NEW_DATABASE db.sql -p I get an error when I hit an InnoDB table that has a relationship set up with a table that hasn't yet been created. How do I get around this? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway

Re: Backup / Restore database with foreign keys

by server; consider upgrading MySQL client have died down, *then* it's time to upgrade the server. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http

Re: Documenting and visualizing a database

directory listings. I don't suppose there's a Linux download yet? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL

Re: money fields

Chris Ripley wrote: What's a good (or best) field type for money or currency data. Mysql doesn't have a MONEY type for structure, so what would I have the best luck with? double -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia

  1   2   3   4   5   >