Re: Large import into MYISAM - performance problems

You could load the data into several smaller tables and combine them into a merged table which would have no real effect on the schema. Ade Simon Collins wrote: I'm loading the data through the command below mysql -f -u root -p enwiki < enwiki.sql The version is MySQL 5.0.51a-community I've

Re: Query question.

you need to group the result sets by date, look at the manual link below: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html Richard Reina wrote: I have a database table paycheck like this. empno, date, gross, fed_with 1234 "2007-09-01" 1153.85 108.26 1323 "2007-09-01"

Re: query question

there should be no space between function name and () i.e. it should be group_concat(hosts.name) (unless you have the sql mode IGNORE_SPACE set) Andrey Dmitriev wrote: I knew I’ve seen this error before ☺ Thanks a lot. -andrey From: Peter Brawley [

Re: Pointers about replication

Hi Multi-master replication is safely possible with MySQL 5.0 when they introduced auto_increment_increment and auto_increment_offset variables. Before this it was possible to run into problems with auto increment columns generating non-unique numbers between servers. Try the following link

Re: Selecting just the first 2 values

add "LIMIT 2" to the end of the statement goose wrote: Hi All, I have the following SQL statement SELECT channel.channel_name, program_title, start_time, finish_time FROM program, channel WHERE program.channel_id='3' AND program.channel_id=channel.channel_id UNION SELECT channel.ch

Re: mysqldump slows to crawl

Try dropping the indexes first if you can, would save you about half the time and then re-build them after the dump finishes. Obviously you would need to do it at a quite time though when the DB is not being used. Is a binary backup not an option? at 29G is a large text file to write Ade D

Re: HELP!

Not the best start to the day, if you have a fairly recent backup and have enabled binary logging then you can recover up to the point before you screwed the data. Peter Lauri wrote: Hi, I did something terrible similar to UPDATE table SET testdate=NOW() And I kind of forgot the WHER

Re: Too many table-locks

Assuming that the locking issues occur mainly when an insert is being performed (i.e. replying to a post) then what about using read local locks for selects so that you can perform con-current inserts? If you have a lot of old threads that are no longer updated but viewed regularly then you co

Re: Selecting Common Data

John I think you are saying you want the "Mode"? if you are then the following might work: SELECT col2 as val, count(col2) AS cc FROM my_table GROUP BY val ORDER BY cc DESC LIMIT 1; in your case this will retrun the value '2' Regards Ade John Nichel wrote: Running MySQL 4.0.20 on a RHEL3 b

Re: Replacing A Value

UPDATE Query Tip No. 1: Manuals, Google etc Tip No. 2: Posting a question like this may result in sarcastic responses and possibly mass flaming Ed Curtis wrote: I have a column in a table I need to replace a value of certain records in. The current value is /realtors/Value/. I need to ch

Re: Multiple engines in one DB a problem?

MySQL has a pluggable storage engine architecture which means that you can use multiple storage engines within your databases. What you need to do is investigate the different features of the engines and devide which one best fits your system i.e. level of locking required, InnoDB=row level My

Certification examples

Hi I have bought the MySQL certification study guide (v 5.0) and am almost ready for the exams, does anyone know if the questions in the self study guide are very similar to the ones that you get in the exam? and is there anywhere else that i can get more questions like this for practice pur

Re: How to rename a DB

Stop the server, go to the MySQL data directory and physically change the name of the directory that corresponds to the database. Restart MySQL server and SHOW DATABASES to see the change take effect. George Law wrote: Hardi I rotate tables out on a monthly basis. The way I do it is: ren

Re: Coded fields

I would approach this in practically the same way as yourself but used an enum field in the student table (like what you were thinking). When a user wants to add or remove an enum value you can build an appropriate MODIFY statement like: ALTER TABLE my_table MODIFY my_col ENUM('K','X') NOT NU

Re: LOAD DATA giving BIG mysql-bin files ...

I think this is normal as the binary log will contain a record of all changes made to the data, therefore if you are loading large files regularly- the bin logs will be quite large. If you do not want the binary logging, edit the my.cnf file, comment out the line log-bin (#log-bin) and restart

Re: Please help: recovering db from crash

not sure, but it may be worth trying the following run the script: mysql_install_db --user=root In the installation dir this should change ownership and make mysql recognise the data dir. good luck Ade Foo Ji-Haw wrote: Hi all, My Windows-based database server crashed (no fault of MySQL. pr

Re: query problem

one solution (may not be the best but would work) would be to use 'like' instead of '=' and then put wildcards %%$var % around the variable so that if it is not there then it wount effect the query. Ade [EMAIL PROTECTED] wrote: I am fairly new to sql and am now getting into the area of slight

Re: simple addition in a query?

I think the following should work, try taking a look on the net for help on MySQL queries that use aggragate functions, there is probably a lot of info on there. select exim.hour,sum(exim.count) from exim,servers where exim.machine=servers.id and servers.type='MX' and exim.date='2006-02-22' g

MySQL Certification Questions

Hi Does anybody know where i can get a load of sample questiosn for the MySQL certificate exams, i know there are a few on mysql's site but i was hoping to find quite a few to practice on. Thanks Ade -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

MySQL PDA Synch

hi I have an online registration system made with PHP and MySQL that i would like to make available for use with PDA's. We have a wireless network that covers only certain parts of our area and when the PDA's can connect there will be no problem as I have PDA style sheets set up. When the w

Re: Sudden Mysql Crashes - table damage?

Thanks for the reply yep mysqldump also causes the service to crash. i have a few innodb tables mixed in amongst the myisam, it seems that it is the innodb tables that may be causing the problems but i am not sure why ??? Imran Chaudhry wrote: On 1/31/06, Adrian Bruce <[EMAIL PROTEC

Sudden Mysql Crashes - table damage?

HI MySQL 5.0 (windows XP) I have a problem where i think some of my tables have somehow been corrupted, if i try to run a check table command against some tables the mysql service crashes and i have to restart it. I am not sure how this damage has occurred but has anyone got any suggestions

Auto-increment & indexes

Hi, im hoping to solve a problem that is bugging me! I just moved a database from a development server to production (test), several of the fields have auto-increment ticked but as it is mainly a data warehouse i thought nothing of it. I then found that a lot of my queries were running slow

Re: table missing

The table may be damaged and seemingly unavaible to languages like php(has your box crashed recently??), run 'SHOW TABLES' from the command prompt and it should appear.If it does try running 'CHECK table' to see if is damaged or not Jon Miller wrote: I've created a database with a table and

Re: Semi-complicated delete

IN MySQL 5 you could use a sub query( http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html). However, i would try using a left join between cart and products and then bring back the results where the products.id field is 'NULL'. There may be a better way of doing this but that