Does mysql have any form of public cvs or svn repository?
__
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at
Yahoo! http://uk.docs.yahoo.com/ymail/new.html
--
MySQL
This one time, at band camp, Perrin Harkins [EMAIL PROTECTED] wrote:
In your case, you might be able to just cheat it with some
MySQL-specific LIMIT stuff:
Thanks very much Perrin, this is most useful and I can take it from
here.
Kind regards
Kevin
--
MySQL General Mailing List
For list
Hello Jerry,
You might want to try our Schema Compare tool inside Database Workbench.
This tool also has a script recorder that can record any changes you
make
to (meta)data in order to help you keep your change scripts.
[JS] Ah! I just discovered that if I hit what looks like the record
I have this query:
SELECT DISTINCT t1.string FROM t1
LEFT JOIN t2 ON t1.string=t2.string
LEFT JOIN t3 ON t1.int_a=t3.int_a
LEFT JOIN t4 ON t1.int_b=t4.int_b
WHERE
t1.string != '' AND
t2.string IS NULL AND
t3.int_a = some integer
ORDER BY
Hi All,
Connecting to mysql server is taking lot of time near around 4 to 5 seconds.
Its a pentium box with 512Mb ram max_connections=200
what can be the reason ?
--
Krishna Chandra Prajapati
Thanks, but I decided to grunt through it using PHPMyAdmin. This doesn't
happen very often, so I can't see investing in a tool at this point.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Perrin Harkins wrote:
Assuming you're using InnoDB tables, SELECT...FOR UPDATE will lock
the rows as you describe. It can prevent other inserts and updates to
neighboring rows as well, depending on what isolation level you're
running (default is REPEATABLE READ).
Thanks, in fact it even
Not sure how someone can intelligently comment on your table structure
when you haven't given any details of the data you are storing. In my
experience, the fact that you have 75 fields in your table is a strong
indicator that your data is not normalized. If that is the case you
tables are
Thanks Chris for your comments.
The table is actually storing CVs of jobseekers. With most fields being
Varchar (50), varchar(100), varchar(150).
The database is using MyISAM.
I agree with you that the table could be optimized. The problem is that
when we setup that table and that project the
Can someone tell me why I am getting this message whenever I issued a
CHANGE MASTER command?
@4000489f38462d0bedd4 080810 13:49:32 [ERROR] Failed to initialize
the master info structure
Thanks
This message is intended only for the use of the
The first thing that occurs to me is to double-check the r/w
permissions in your data directory. I assume you are logged into
mysql as root when you attempt this command?
- michael dykman
On Mon, Aug 11, 2008 at 1:47 PM, Brown, Charles [EMAIL PROTECTED] wrote:
Can someone tell me why I am
On Mon, 11 Aug 2008, Glyn Astill wrote:
Does mysql have any form of public cvs or svn repository?
Take a looke at
http://dev.mysql.com/
And especially this link below.
http://dev.mysql.com/tech-resources/articles/getting-started-with-bazaar-for-mysql.html
--
Boyd Gerber [EMAIL PROTECTED]
If you're good at Chinese ,just visit here.
http://blog.chinaunix.net/u/29134/showart_375303.html
On Thu, Aug 7, 2008 at 10:34 PM, Magnus Smith
[EMAIL PROTECTED] wrote:
I think got it in the end by doing a union and a join.
delete AA, PA from ACCOUNTACTION AA, ACCOUNTPAYMENTACTION PA
where
Delete all your relay log ,restart mysqld and use a new change master to
statement to do a slave configuration.
On Sat, Aug 9, 2008 at 2:32 PM, Brown, Charles [EMAIL PROTECTED] wrote:
Could not initialize master info structure;
Can someone help me. I am getting the above message
Add additional option to my.cnf
[mysqld]
relay-log-purge=1
On Mon, Aug 11, 2008 at 2:21 AM, Brown, Charles [EMAIL PROTECTED] wrote:
Here is what I'm getting
mysql change master to master_host = 'naxbmisq01.bmi.com', master_user
= 'repl', master_password = 'repl';
ERROR 1201 (HY000): Could
Remove line contains naxbmisq02-relay-bin.000157 in your
naxbmisq02-relay-bin.index file.
On Fri, Aug 8, 2008 at 1:58 AM, Brown, Charles [EMAIL PROTECTED] wrote:
Please advise me on how to restart MYSQL slave instance.
All efforts have failed. When I issued the START SLAVE command it came
If you have the whole backup ,then you can simply use reset slave statement
to purge all the relay log on your slave machine and use change master to
statement to do a new slave configuration.
On Tue, Aug 12, 2008 at 2:59 AM, Michael Dykman [EMAIL PROTECTED] wrote:
The first thing that occurs
Check if your connections are too large to afford any other connections.
On Mon, Aug 11, 2008 at 8:54 PM, Krishna Chandra Prajapati
[EMAIL PROTECTED] wrote:
Hi All,
Connecting to mysql server is taking lot of time near around 4 to 5
seconds.
Its a pentium box with 512Mb ram
you can also do,
reset slave This will remove/delete any old master and relay log
information
and use the CHANGE MASTER command.
On 8/12/08, Moon's Father [EMAIL PROTECTED] wrote:
Delete all your relay log ,restart mysqld and use a new change master to
statement to do a slave
19 matches
Mail list logo