Re: MysqlDump destination file
Hi Nanu, According to me You could use 1. --result-file=file, -r file 2. file (complete path or present working directory would be the place where your file would be saved) Since you are not mentioning the output to be in any different format apart from SQL, it would be a sql file. You 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, Nanu Kalmanovitz n...@kalmanovitz.co.ilwrote: Hi! I'm a newbie trying to use the backup\dump command. My questions are: 1. When using the command mysqldump --single-transaction --quick -uroot -p --all-databases, what is the default destination path (server\volume\folder) and the default file name? 2. If using a redirection destination_file_name, is it possible to add a path before the filename (server\volume\folder) and what is regular\correct file name? TIA Nanu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=amitsha...@affle.co.uk
Re: Stopping using a server as a slave
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 to change it over to a regular server now. I could simply stop the slave (STOP SLAVE), however, I'm concerned that if I re-boot the server, then it'll re-start the slave. What else do I need to do to stop using a server as a slave? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: How could i check the following values in MySQL Server 5.0
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 to check or set the following values in MySQL Server . How can that be done ? 1. MySQL Database Free Space for any database. 2. Maximum Database size allowed. 3. Calculate Index Size. 4. Maximum table size 5. Free table space 6. Free Index space 7. Calculate Table size Thanks Regards Sudhir
RE: LEFT JOIN and RIGHT JOIN
Example: mysql select * from tableA; +---+--+ | name | age | +---+--+ | Amit | 27 | | Sumit | 31 | | Anand | 29 | | Parry | 32 | +---+--+ mysql select * from tableB; +---++ | name | Salary | +---++ | Amit | 5 | | Sumit | 6 | | Anand | 55000 | | Alex | 1 | | Ben | 9 | +---++ TABLEA RIGHT JOIN TABLEB mysql Select tableA.Name, tableA.Age, tableB.Salary from tableA right join tableB on tableA.Name=tableB.Name; +---+--++ | Name | Age | Salary | +---+--++ | Amit | 27 | 5 | | Sumit | 31 | 6 | | Anand | 29 | 55000 | | NULL | NULL | 1 | | NULL | NULL | 9 | +---+--++ TABLEA LEFT JOIN TABLEB mysql Select tableA.Name, tableA.Age, tableB.Salary from tableA left join tableB on tableA.Name=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 PROTECTED] Sent: Tuesday, July 22, 2008 7:59 PM To: mysql@lists.mysql.com Subject: Re: LEFT JOIN and RIGHT JOIN At 09:05 AM 7/22/2008, you wrote: Hi All, Can u please let me know when should i use LEFT JOIN and when should i going for a RIGHT JOIN. Please let me know some examples. regards anandkl anandkl, Take a look at the tutorial at http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.php Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problems Adding User
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 December 2007 22:57 To: mysql@lists.mysql.com Subject: Problems Adding User Hi; I can create the following just fine: grant all on data1.* to myuser IDENTIFIED BY 'pass'; grant all on data2.* to myuser IDENTIFIED BY 'pass'; ...but when I try this: CREATE USER myuser IDENTIFIED BY 'pass'; ERROR 1396 (HY000): Operation CREATE USER failed for 'myuser'@'%' ...and this: 1044, Access denied for user 'myuser'@'%' to database 'data1' Why? TIA, Victor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Does anyone know how mysql works for mutiple kernels of a cpu.
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: www.affle.co.uk -Original Message- From: Moon's Father [mailto:[EMAIL PROTECTED] Sent: 18 December 2007 12:33 To: mysql@lists.mysql.com Subject: Does anyone know how mysql works for mutiple kernels of a cpu. Any reply is appreciated,thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
