How to convert the the string row[i] to its real type.

not convinient to me, How to do it in a smart way? -- David

Is there C API function to convert the MYSQL_ROW items from string to Language specified type?

Hi all: Is there a C API function to convert the MYSQL_ROW items from string to Language specified type? I thought there should be one, but I can't find it. Could you give me some advice? Appreciate your help! -- David

maximum size of mysql server-id field

there are better ways of tying a slave server-id to a machine (last few digits of MAC addr, IP addr, etc...) Thanks, David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

CREATE INDEX is sooo slow! any ideas?

ar(250) | YES | | NULL| | | body | text | YES | MUL | NULL| | +---+--+--+-+-+---+ 4 rows in set (0.00 sec) I'm running this on linux redhat 7.3, P500Mhz 512Mb ram -- MySQL version 3.23

Re: CREATE INDEX is sooo slow! any ideas?

ee. Peter <^_^> - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - Original Message ----- From: "david" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 5:47 PM Subject: CREATE INDEX is sooo sl

Re: CREATE INDEX is sooo slow! any ideas?

st to store the text in a text field or is it best to tokenize out the terms and create a word table with index? Thanks David At 06:27 PM 2/16/2003 -0500, Peter Grigor wrote: Well, MySql stores all its index information in one index file, so when you add another index it has to rebuild the WHOLE

Need help optimizing a query

ble to to get it to use an index, can anyone please tell me how to optimize this. - David Darville - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Need help optimizing a query

ble to to get it to use an index, can anyone please tell me how to optimize this. - David Darville - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

error: 'Access denied for user: 'root@localhost' (Using password: NO)'

Well i seem to have gotten MySql working but i can't seem to use mysqladmin: to do anything. When i start MySql with the following: [root@RR davidwri]# safe_mysqld -u root Starting mysqld daemon with databases from /var/lib/mysql it will sit indefinitely as above, is this correct? If i try to

ERROR 1146: Table 'test.test' doesn't exist - Why is mysql adding a postfix to my USE request?

ist and are populated: /var/lib/mysql/mysql /var/lib/mysql/test I have searched the mysql site for a listing for error 1146 with no luck, probably an oversight on my part but any insight is appreciated. -david - Before posting,

MySQL database design, one column, 10 entries?

#x27; 21 '#2 tall' 4 '#3 scary' 2 etc, etc,... I can't just make it a really long varchar(1000) because of the other columns

How do you insert into two tables at once

I have two tables under the one database. What is the best way to INSERT data into both tables at once. Can I use one INSERT statement or do I have to use two? - Before posting, please check: http://www.mysql.com/manual.php

Loop an INSERT from form

I need to insert x amount of rows from one form. The form displays x amount of rows. I then need to insert the values from the form x amount of times. The form loop works fine but how do I INSERT x amount of times within a loop from the values of the form? I think I need to use some sort of ar

Re: Loop an INSERT from form

addsongs.php on line 26 Songname: Array . Any ideas? Don Read wrote: > On 14-Jul-01 David wrote: > > I need to insert x amount of rows from one form. The form displays x > > amount of rows. I then need to insert the values from the form x amount > > of times. The form loop

Re: Loop an INSERT from form

$vals); // chop leading comma //$vals=preg_replace('//^,/', '', $vals); // chop leading comma $qry="INSERT INTO songs VALUES $vals"; echo $qry; $res=mysql_query($qry); Don Read wrote: > On 14-Jul-01 David wrote: > > Thanks for the help > >

Problem inserting array of rows

I am trying to insert an array of rows or values from a PHP form into a MySQL database. There are six columns in the table songs: id, songname, rating, video, album_id, movie. Here is what I get when I submit the form Add songs for Record Array INSERT INTO songs VALUES (' 1, blah', ' ***', ' 45',

Re: Problem inserting array of rows

Hi, I was missing two single quotes in the $val line after $id[$i] and before songname : Here is the corrected code $vals .=", ('$id[$i]', '$songname[$i]', '$rating[$i]', '$video[$i]', '$album_id[$i]', '$movie[$i]')"; Now the problem is it only inserts one row into the table, when there s

Paycheck database Design

I want to log my paychecks in my own database for my own personal use. I am in the design phase: Do I need a table for year to date since this can be calculated automatically? I don't want to have to enter a lot of information when entering the data for each pay period. How many tables are normal

Whitespace in file names

This maybe more of a PHP question. I have a problem with file names that have white space or special characters stored in the database. When I try to link to them from a webpage I get file not found error which is probably because of whitespace in filename Example I have a file name stored in da

Strange problem

When submitting a form to insert/replace data into my database with values loaded from the previos page I show that everything is entered except for these fields: Why? I am using version mysql-3.23.32-1.7 | Field| Type | Null | Key | Default | Extra | rating

Reserved words in MySQL update

upgrade to 3.23 >Fix: Manually edited the .frm file - didn't feel right Need something to either do it automatically on upgrade, or a standalone utility to modify the mysql files directly. >Submitter-Id: >Originator:David Croft >Organization: >MySQL support: none >S

encrypting a column

maildb.Username, and (encrypted) into maildb.passwd. I have a text file that contains the user and passes but I have had no success in getting a bash script to work either. Any suggestions would be appreciated. David - Before posting

Primary key ID gets messed up after deleting/adding

I have a primary key listed as ID When I first added about 10 records and then deleted a few records and then added more records it didn't replace the missing records. When I select all records to view I now get: 1 2 why didn't it go to 3, 4 and 5 after 2? 6 7 8 When I add a record it becom

Best way to add over 5,000 mp3 file names to database

I have a hard drive dedicated to mp3 files that are stored in the following format: /mp3/artist/album/song1.mp3. What is the best way to add these file names to a database. I have been adding a few via a web interface but can only do one at a time which is not going to work. I also tried just l

RE: Automatic Mathmatical Computation

appen automatically, I don't want to have to issue a SELECT statement for this procedure. Thanks for your help. David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

MySQL and PHP issue

I tried posting this in the PHP newsgroup but received no response so thought I would try here since issue involves MySQL I am trying to make a simple HTML menu system with data stored in a MySQL database.. I am having problems displaying menu links under the correct submenu from a loop. I have

Re: MySQL and PHP issue

> 2. Why do the menu items need to be in a database anyway? Just have > "static" menus in your web pages. There are a number of ways to bring up > menu items, as you described, using javascript: > > - Original Message - > From: "David" <[EMAIL PROTECTE

Re: Install problem

> I am having a problem installing the MyODBC drivers. I run setup but > nothing happens. Any ideas? > > David [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must in

Re: mysqldump

? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Hi, From the manual, http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html use -A or --all-databases as an option Regards David Logan South Australia When in trouble, or in doubt Run in circles, scream and shout

Re: Should we petition GoDaddy?

, or if you do, you'll be asked to upgrade or close your account because of the high processing load needed to push that much traffic. Who is GoDaddy and should I care? Is this an international issue? Regards -- David Logan South Australia when in trouble, or in doubt run in circles, screa

Re: MySQL Optimization error ?

This isn't a bug, it's a missing feature. The parent query won't use indexes, just the subquery. There's been a lot of complaints about how it renders sub queries less than useful. I seem to remember that it might be fixed in 5.1, but I'm not a reliable source

Timeseries

automatically figure out that I need the measurements from 7:56, 8:13 and 8:27. Any simple way to do that would be immensely appreciated. Thanks in advance, -- -- David Lindelöf Station 18 LESO-PB/EPFL 1015 Lausanne tel +41-21-693.5556 mob +41-79

Re: Timeseries

On Apr 28, 2006, at 7:12 PM, David Lindelöf wrote: Is there an easy way to get the last timestamped record not later than a given date/time? Well, yeah, that part is easy. select * from your_table where timestamp < target_time order by timestamp desc limit 1 Your problem seems

How can I get my disk space back?

I have a really simple (two tables, one relation) but big (~70 GB) innodb database containing rather dynamic data. After deleting lots of records from the tables, the innodb data files still take the same amount of disk space as before. What is the correct way of freeing the disk space? The gene

Re: How can I get my disk space back?

Barry <[EMAIL PROTECTED]> writes: > David Israelsson schrieb: >> I have a really simple (two tables, one relation) but big (~70 GB) >> innodb database containing rather dynamic data. After deleting lots >> of records from the tables, the innodb data files still take

Re: Q1. What would run faster?

RAID you are using, and how well the RAID implementation (typically the RAID controller) works. /David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Backups with MySQL/InnoDB

, compressed, fast, no-max-size. ( In order ) -- David Hillman LiveText, Inc 1.866.LiveText x235

Re: Unidata to Mysql

ion Member ID #LPA135259 > (www.omnipilot.com/www.lassopartner.com); > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL

Re: MySQL commercial licence

commercial one by default. How many people actually check on that before purchase? Are they aware they have purchased a GPL product and are now obligated under that license to GPL their distributed products? Regards -- David Logan South Australia when in trouble, or in doubt run in circles,

Re: i'm at a complete loss?

t, user, password) values ('127.0.0.1', 'mysql', password(mysql)); and "INSERT INTO USER (host, user, password) values ('localhost', 'mysql', password(mysql)); Don't forget to do a "flush privileges;" afterwards (again, no quotes); The my

Re: MySQL documentor - not MySQL Workbench

. http://embarcadero.com/products/erstudio/erdatasheet.html David Miles Thompson wrote: Is there a tool, preferably open source, that can read database schema scripts (for lack of a better term) or connect to the database, and generate a diagram? This for a MySQL 5.x database. I've

Re: Alter table command don't work

be able to copy it using an INSERT SELECT (not sure though, haven't had to do it) Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Find rows in table A where table B = 'hello' AND table B = 'world'

That's a lousy subject line, but I don't know how to describe this problem. I've been banging my head against this for a couple of days, and I'm certain there's a simple solution I'm missing. I've got a URL table, a keyword table, and a joining table, so each URL has a list of keywords applied

Re: Need to speed up deletes

the least cardinality in the where-clause of your delete script. That might not be feasible, however. Finally, try converting the table to InnoDB (you'll need to do some configuration in your my.cnf) - it tends to perform better in circumstances such as yours. I would do this on a test server

Re: 'on duplicate key update' and 'last_insert_id'

_INSERT_ID ();" then I don't get the id of the 'updated' table, I get the *next* auto increment value. Is the last bit a bug? Yes, http://bugs.mysql.com/bug.php?id=19243 -- David Hillman LiveText, Inc 1.866.LiveText x235

Database or table level logging?

would prefer to be able to use the built-in logging if possible to avoid having to make changes to existing applications. Thanks. David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Database or table level logging?

Right, sorry, this is 5.0.x (5.0.18 at the moment). Thanks for the pointer on 5.1.6, though that looks like it has the ability to log to a table instead of a file, not log access to a specific table. David On Jul 18, 2006, at 9:23 PM, Chris wrote: David Felio wrote: Is it possible to

Re: Database or table level logging?

g and retrieve from there, but logging everything is not an option. I am looking for a way to log just a specific database or a few specific tables. David On Jul 19, 2006, at 9:06 AM, Dan Buettner wrote: Through judicious use of SQL you could easily get the log entries for a specific table

Slave Replication issues

Hi, we have been losing slaves due to errors in replication. See error message below. Would appreciate if anyone could share if they have seen same issues. It seems something may be getting corrupted in the binary log. Thanks. The error reads: Last_error: Error 'Duplicate entry '12312942' for

Re: Row count discrepancy when converting from MyISAM to InnoDB

only maintains an estimate of the number of rows in each table. This is why "select count(*) from table" takes a long time on big InnoDB tables. Usually the InnoDB count will be off by 50% or so. http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html -- David Hillman Live

Re: Slave Replication issues

On Jul 25, 2006, at 12:47 PM, David Nance wrote: Hi, we have been losing slaves due to errors in replication. See error message below. Would appreciate if anyone could share if they have seen same issues. It seems something may be getting corrupted in the binary log. Thanks. The error reads

ODBC - MySQL 5 bug!

Good day, After a whole day of researching I finally found an answer for Ms Access not displaying the columns of more than one table in a MySQL 5 view... The bugfix was posted in a mysql forum here: http://forums.mysql.com/read.php?65,52721,100434#msg-100434 which contains a link to a download fi

Windows Server Configuration

running on this system? Also, what is the general advice for separating MySQL and the MySQL/Data on different disks? I'm sorry if this sort of question has already been answered. Any help would be appreciated. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Windows Server Configuration

d in choosing abnd setting up your hardware. > > (Third time today I've plugged that book - I don't own stock or > anything, really) > > Dan > > > On 8/22/06, JamesDR <[EMAIL PROTECTED]> wrote: >> David Lazo wrote: >>> We want to get: >>

Re: First View

and found nothing, so hopefully someone here can help... where can I download MySQL 10 from? ;) -- David Hillman LiveText, Inc 1.866.LiveText x235

Re: Windows Server Configuration

Thanx again. For the time being, we will keep 4 drives with Dan's suggestion. OS and MySQL running from there. On 8/25/06 11:03 AM, "Dan Buettner" <[EMAIL PROTECTED]> wrote: > James, with just 4 drives, you can set up one big RAID 10 disk > (usually called a "logical disk", with Dell PERCs I

Installing MySQL on Windows Server 2003 Standard x64 Edition

5.0.24 Please advise. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing MySQL on Windows Server 2003 Standard x64 Edition

c:\windows\system32 > or the similar folder of your system? > > "David Lazo" <[EMAIL PROTECTED]> escreveu na mensagem > news:[EMAIL PROTECTED] >> I'm having problems with MySQLInstanceConfig.exe - Unable To Locate >> Component >> >> This app

Re: Installing MySQL on Windows Server 2003 Standard x64 Edition

ull path, i.e. > c:\Program Files\...\mysql\bin to the variable. > > -Original Message- > From: David Lazo [mailto:[EMAIL PROTECTED] > Sent: Friday, August 25, 2006 2:54 PM > To: mysql@lists.mysql.com > Subject: Installing MySQL on Windows Server 2003 Standard x64 Edition

Re: MySQL 5.1

The cluster engine has been available since the 4.0 tree, I believe. You can begin using it immediately with 5.0 (which is GA). David Logan, David (SST - Adelaide) wrote: Hi Folks, Does anybody have any idea when 5.1 may come to General Release? I am particularly interested in MySQL

mysql_upgrade script problems on MySQL 5.0.24

pp/mysql datadir=/u07/mysql/data --- This is on my test box (I'm no dummy - or at least I like to think that), so no harm no foul. However, I'd like to upgrade my Production box, but am waiting for this to be resolved first. MySQL 5.0.24 seems to run fine wit

RE: mysql_upgrade script problems on MySQL 5.0.24

script successfully? -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 2:02 AM To: Whisler, David Cc: mysql@lists.mysql.com Subject: Re: mysql_upgrade script problems on MySQL 5.0.24 > error: Found option without preceding group in config

Is there a way to load non-native Date type with LOAD DATA

I have a pretty large file with a Date column in the format M/D/. Is there a way to either change the Date data type in the table or a method to indicate the date format in the LOAD DATA statement in order to handle this? Thanks in advance for any help! David -- MySQL General Mailing

MIT Kerberos integration with MySQL

Does anyone know if MySQL currently integrates with MIT Kerberos authentication (http://web.mit.edu/Kerberos/) . And if not, are they working on this for a future release? MIT Kerberos has broad use in government, academic and research institutions as well as some

speed up index creation on existing tables?

I have a table with ~100,000,000 rows. I recently discovered that I need to start using one of the non-indexed columns in WHERE clauses. As expected the performance is horrid. I decided to bite the bullet and create an index (innodb): mysql> show full processlist\G *** 1

Moving Database from PC to Apple

I recently purchased a MacBook Pro laptop and hired someone to help me set up Apache, PHP and MySQL on it. Now I want to import my database tables from my PC. So my main question is this: Is there a quick, simple of importing an entire database? If not, I figured I'd simply export each database

Re: Moving Database from PC to Apple

Also, when >I create a new database on my Mac, what should I choose for Collation - or >should I just leave it alone (presumably the default setting)? The >following default settings are already registered: Language: English >(en_utf_8) MySQL Connection Collation: utf8_general

Re: Moving Database from PC to Apple

Ah, that's better. I learned how to use Terminal just the other day. I'll check out the other programs you recommended, too. Thanks. - Original Message From: Douglas Sims <[EMAIL PROTECTED]> To: David Blomstrom <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sen

Setting Up MySQL Administrator

I just downloaded MySQL Administrator and am now trying to set it up. Can anyone tell me what "stored connection" and "Server Host" mean? I'm using Apache on Windows XP, but I'm not sure what they mean by Server Host. 3306 is listed under "Port" by default. Also, what are the default username a

Re: Setting Up MySQL Administrator

OK, I'm halfway there. But I don't understand what you mean by "saved settings." Is there some sort of default value I can try? Also, if I can't recover my password, is there a file I can open and retrieve it from? I tried it with localhost, Port 3306, Username: root and the password of one of

Importing a Database (.mpb file)

Hopeffully this will be the last question in this series. :) I want to copy a database from my PC to my Apple laptop. I installed MySQL's GUI Tools on both computers, created a file named Backup.mpb on my PC, then put a copy of it on my Mac. Now I'm trying to figure out how to get Backup.mbp int

Re: Moving Database from PC to Apple

OK, now I get it. I'll give that a try. Thanks for the tip about the OmniWeb browser, too. - Original Message From: Chris Sansom <[EMAIL PROTECTED]> To: David Blomstrom <[EMAIL PROTECTED]>; mysql@lists.mysql.com Sent: Sunday, October 8, 2006 1:51:33 AM Subject: Re: Mov

RE: java.util.Date versus java.sql.Date

A java.sql.Date does not have time information - just the day-month-year. A java.util.Date has date and time information. If you need date and time, use java.sql.Timestamp. It's not very pretty moving from one to the other. David -Original Message- From: Feliks Shvartsburd [m

Grant privs to multiple tables at once?

vail. Please tell me I'm not going to have to explicitly grant privs to each table. There are actually several set of tables for a total of several hundred tables to which I will need to apply permissions. Thanks. David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Grant privs to multiple tables at once?

It doesn't. That was one of the multiple wildcard variations I already tried. David On Oct 12, 2006, at 3:13 PM, Anders Lundgren wrote: I think you should try % that is used as wildcard instead for one or many characters. Granting on 'foo_%' might work. Regards, An

Optimizer Bug?

e rows? How can it look at more than "ALL" rows? Why does dropping an index that it wasn't using change, well, anything? Can someone make some sense of this for me? This is on version 4.1.18. Thanks. -- David Hillman LiveText, Inc 1.866.LiveText x235

Re: Optimizer Bug?

always refers to what /will/ happen, and "rows" refers to how many rows /might/ be looked at. Thanks. -- David Hillman LiveText, Inc 1.866.LiveText x235

Re: Optimizer Bug?

much like Bill Clinton, what exactly does "ALL" mean, then? -- David Hillman LiveText, Inc 1.866.LiveText x235

Re: Workbench

If you mean trying to rename a table, you should be able to double click on the name to bring up the specifics of the table. I'm using the newest version of workbench, for OSX. It should be the same for all platforms of workbench. -David Thole On Oct 22, 2006, at 11:37 AM, João Câ

Re: Check date interval in SELECT

etting id3 if I'm understanding the requirements correctly and that's the idea that you want an event that doesn't start or end in that interval. -David Thole On Oct 29, 2006, at 4:14 AM, spacemarc wrote: Hi I have 3 fields like this: id date_in date_out 1 2

Re: can innodb_buffer_pool_size be set > 2Gb on FreeBSD?

. A good page that talked about this was, http://www.oracle-base.com/articles/Linux/LargeSGAOnLinux.php Good luck. David Jeff Smelser wrote: On Friday 17 June 2005 02:38 pm, Brady Brown wrote: Have any of you MySQL/FreeBSD cats successfully set innodb_buffer_pool_size > 2G without

Optimizing Per-Table-Tablespaces

d their related tablespaces can be put on different disks, but doesn't really get into the specifics. David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql-test-run --external?

According to the README, mysql-test-run supports an --external option: db1 mysql-test # grep -a1 external README If you want to run the test with a running MySQL server use the --external option to mysql-test-run. However it doesn't actually support it: db1 mysql-test # ./mysql-test-run --exte

Re: mysql-test-run --external?

Petr, Thanks for the reply! > I think you are looking for --extern option of the test suite. I > corrected the README file. The changes should be propagated to the > public repository soon, but you could check the commit mail for more > details right now: > http://lists.mysql.com/internals/26266

myisam insta corruption in 4.1.12

db1 corruption # cat > my.sql DROP TABLE IF EXISTS service_contacts; CREATE TABLE service_contacts ( croeated datetime NOT NULL default '-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO service_contacts VALUES ('2006-06-14 10:27:40'); db1 corruption # mysqladmin -u root -

Combining several sum queries

When i run the queries below they all work just fine SELECT sum(consultation)+ sum(laboratory) FROM nairobi,familymembers WHERE familymembers.dependantid = nairobi.memberid and familymembers.memberid = "AKI1" SELECT sum(consultation)+ sum(laboratory) FROM riftvalley,familymembers WHERE f

Re: Optimizing Per-Table-Tablespaces

ks for the link - some very interesting presentations there (wish I had gone to the conference - next year maybe). David Dr. Frank Ullrich wrote: David, David Griffiths wrote: The manual is a little unclear on per-table-tablespaces in 4.1/5.0 (http://dev.mysql.com/doc/mysql/e

Re: How to SELECT something (CONCAT) and search the field

select first_name, lastname from user where first_name like '%$user%' or last_name like '%$user%' ; --- Matt Babineau <[EMAIL PROTECTED]> wrote: > Hey All- > > Got a fun question - I hit the manual but not much > luck on my question. I > want to combine 2 fields and then search them > > SE

Dynamic insertion of date for LOAD INFILE

Im trying to get dynamically insert the current date into a LOAD FILE statement for some ETL automation, but Im having difficulty passing the string into the LOAD statement: This will not work. SELECT @Today:=CURDATE(); LOAD DATA LOCAL INFILE '/s3/data/[EMAIL PROTECTED]' INTO TABLE Data; Anyone

Avoiding full table scans

Hi I our database there is one table that will grow into tetrabytes within a short time. I would like to know how i can reduce full table scans. I have used separate tables as per region for now but the problem is if i create a new table i am forced to recompile the application. I can easil

Re: database structure question...

You may want to look into normalization to keep everything organized. However if you want pure query speed, you will have to de-normalize some of your tables to get optimum speed. Have a look here for info on normalization: http://databases.about.com/od/specificproducts/a/normalization.htm HTH -

Using "START SLAVE [SQL_THREAD] UNTIL" syntax

rk extremely well and be well suited to scripting... In fact, I was surprised I wasn't able to google anything about it. Thanks for all feedback! David Ulevitch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Using "START SLAVE [SQL_THREAD] UNTIL" syntax

On Jul 12, 2005, at 6:15 AM, gerald_clark wrote: Nightly backup and binlogs can take you to any point in the day. I failed to make my entire point clear then. That's true. But when someone does the "oh fsck, I think I just ran a catastrophic query on our production database" we would now h

Re: innodb performance issues

the queries that are hitting the database while you're having these issues. David tony wrote: Hi, A few days ago i posted a quaestion about performace, I now have a little more info, hopefully someone can help. I have a table, tblShoppingCart with 3 fields, cartUid (int 11 auto increment)

Re: innodb performance issues

nd here: http://dev.mysql.com/doc/mysql/en/innodb-configuration.html You might also want to consider High Performance MySQL. There is lots of good info in there on setup, tuning, replication, etc. David tony wrote: Hi David, On Fri, 2005-07-15 at 10:25 -0700, David Griffiths wrote:

Mac OS PrefPane

Greetings! I have begun using the preferences pane that came in the official binary [4.1.12] instead of always manually starting & stopping the server. This is a nice improvement as Mac OS X client edition doesn't come with this, and i've only recently seen it in the package. However, it d

Re: SQLyog Enterprise

ould be be able to generate a delta of database changes using the GUI (ie reverse engineer the database into a diagram, make changes, and have a database patch generated for you). It's more expensive (at $135 for a business license for Windows, $95 for Linux) but it's well wort

MySQL vs XML

I've been gathering data for an animal kingdom database for quite some time and am now trying to figure out how to organize and display it. So far, I have a table that lists every order, suborder, family, subfamily, genus and species of mammal in a child-parent relationship, like this: NAME | PARE

Re: MySQL vs XML

Thanks for all the tips. That makes it much clearer. I think I'll stick with PHP and MySQL and gradually introduce a little XML if it fits in. I just downloaded a content management system called Plone, which is supposed to be a good choice for hierarchical databases. _

Re: MySQL vs XML

Wow, this is turning into quite a research project. Thanks for the tip about ontologies; it doesn't make much sense to me yet, but I'll take a closer look at the article. In the meantime, I'm thinking of using a content management system called Plone. Unfortunately, I've so far been unable to inst

  1   2   3   4   5   6   7   8   9   10   >