Re: Moving to another hard drive

Hi, 1) check with the owner permission of the copied data folder 2) GRANT ALL permission to access that db (name of the copied folder) Thanks ViSolve DB Team - Original Message - From: Kevin Chen [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, February 21, 2008 1:14 PM

[ANN]: MicroOLAP Database Designer for MySQL 1.9.6 has been released

Greetings, Microolap Technologies is happy to announce that the version 1.9.6 of MicroOLAP Database Designer for MySQL is immediately available. This release introduces Minimap Navigator feature: now work with visual DB model is even more convenient. Full changelog:

[ANN]: MicroOLAP DAC for MySQL 2.6.1 released

Greetings, Microolap Technologies is happy to announce that the version 2.6.1 of MicroOLAP DAC for MySQL is available. This release introduces completely refactored TmySQLDump component (now it can dump really large tables when data size exceeds available memory size), significant improvement of

Re: external mysqldump

hmm, i cannot do anything what let users see others data. if there is no possibility then external dumps/inserts of routines using mysqldump/mysql cannot be offered. so routines must separate installed using phpmyadmin over local connect... not satisfying... Thanks for help Andre -

Re: MySQL University session on February 21

Hi, On Wed, Feb 20, 2008 at 7:33 AM, Stefan Hinz [EMAIL PROTECTED] wrote: Hi, this Thursday, Stewart Smith will give a MySQL University session: What time is the session? Thanks! http://forge.mysql.com/wiki/Checking_Memory_With_Valgrind Please register for this session by filling in

Re: MySQL University session on February 21

Hi Baron, Hi, this Thursday, Stewart Smith will give a MySQL University session: What time is the session? Same as the others, 2pm UTC (i.e. in about 45 minutes...) MC -- Martin MC Brown, Technical Writer MySQL AB, http://www.mysql.com Skype: mcmcslp -- MySQL General Mailing List

Re: Certified MySQL Associate (CMA) certification value

So I can relate a little personal knowledge about this. In July of last year I had someone approach me and ask how they could get a job as a DBA. After talking for a bit, it turned out that he had no database experience. He actually use to be a lawyer and decided to make a change. I told

Re: Moving to another hard drive

At 01:44 AM 2/21/2008, Kevin Chen wrote: I am trying to relocate MySQL and a database to another hard drive on the same system. According to this page, http://dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html, I get the impression that I should be able to do this by copying the data

Re: Column level replication q?

On Wed, Feb 20, 2008 at 10:48 AM, Gary W. Smith [EMAIL PROTECTED] wrote: Well, I created the lookup table, created my two triggers (as nothing is ever updated, just added or removed) and did a bulk one time load and it seems to work. Now I just need to replicate that to the other server.

Number of rows not constant

I have a table with millions of rows. I am not sure exactly how many rows it has, I get a different answer every time I ask! What's going on here? This DB is used only by me, and only by explicit commands --- I have no background or on-line tasks using the DB. This is the DB that took 2 days

Re: Number of rows not constant

In the last episode (Feb 21), Mike Spreitzer said: I have a table with millions of rows. I am not sure exactly how many rows it has, I get a different answer every time I ask! What's going on here? This DB is used only by me, and only by explicit commands --- I have no background or

Re: Number of rows not constant

Hi, On 2/21/08 11:41 AM, Mike Spreitzer [EMAIL PROTECTED] wrote: I have a table with millions of rows. I am not sure exactly how many rows it has, I get a different answer every time I ask! What's going on here? This DB is used only by me, and only by explicit commands --- I have no

RE: Column level replication q?

Michael, It seemed to replicate just fine. At least in test. (5.1.22RC). I believe that we are using statement level replication which might be triggering the trigger on the slave node. I noticed that the triggers themselves also replicatated to the slaves, which is something I didn't

Re: Number of rows not constant

Thanks to both Dans, that's it. This even discussed in the refman, at ( http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html). In my case, COUNT(*) found 25,682,600 rows and it took about 7 minutes. Thanks, Mike

mysql configure arguments

Is there a way to find out what configure arguments were used during compile time? -Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: sql help: delete row where only related to one other row

Take a look at http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.ht ml CASCADE: Delete or update the row from the parent table and automatically delete or update the matching rows in the child table. Both ON DELETE CASCADE and ON UPDATE CASCADE are supported. Between two

Advanced Query Error Parsing

Hello All, I was recently approached by someone looking for better error parsing in MySQL. He does queries on large sets of data for research using MySQL, and the vagueness of the you have an error before ; messages often returned leave him desiring more. My goal is to develop some kind of