Re: MysqlDump destination file

2008-12-19 Thread Amit Sharma
can name it as an extension of .sql, however while you import it back it doesnt matter whether your backed up file is on .sql extension or not. Though the idea of keeping extensions is to always help you identify the type of files. Best regards, Amit Sharma On Fri, Dec 19, 2008 at 1:11 PM, N

Re: Stopping using a server as a slave

2008-11-25 Thread Amit Sharma
Hi Jesse, Just add 'skip-slave-start' to your configuration file, restart & there you go. Best regards, Amit Sharma On Tue, Nov 25, 2008 at 7:12 PM, Jesse <[EMAIL PROTECTED]> wrote: > I have a server that I've been using as a MySQL Slave for a while now. I > want

Re: How could i check the following values in MySQL Server 5.0

2008-10-09 Thread Amit Sharma
Hi Sudhir, #show table status command will give you most of what all is required. Have a look at the results & post any further query if you have. Regards, Amit Sharma On Thu, Oct 9, 2008 at 6:44 PM, Sudhir Menon <[EMAIL PROTECTED]> wrote: > Hi all, > > I would like

RE: LEFT JOIN and RIGHT JOIN

2008-07-22 Thread Amit Sharma
=tableB.Name; +---+--++ | Name | Age | Salary | +---+--++ | Amit | 27 | 5 | | Sumit | 31 | 6 | | Anand | 29 | 55000 | | Parry | 32 | NULL | +---+--++ Regards, Amit Sharma @ Affle -Original Message- From: mos [mailto:[EMAIL PROT

RE: Problems Adding User

2007-12-20 Thread Amit Sharma
My guess: The user could already be there. Is this a fresh DB, can you check the server logs for more info? Regards, Amit Sharma E: [EMAIL PROTECTED] M: +91 9971 490 700 W: www.affle.co.uk > -Original Message- > From: Victor Subervi [mailto:[EMAIL PROTECTED] > Sent: 20 Dece

RE: Does anyone know how mysql works for mutiple kernels of a cpu.

2007-12-17 Thread Amit Sharma
Hi Moon's Father, I thought you meant how mysql works for multiple processors of a cpu. If so, have a look at 'http://www.google.com/search?q=mysql+for+multiple+processors' Regards, Amit Sharma [EMAIL PROTECTED] Amit Sharma E: [EMAIL PROTECTED] M: +91 9971 490 700 W: