MySQL Server

Hi ALL I have RHL 9.0 installed on my box, and I have installed mysql-3.23.54a-11.i386.rpm mysql-server-3.23.54a-11.i386.rpm, due to some reason i deleted the folders from /var/lib/mysql, I mean mysql and test folder located under /var/lib/mysql I have re-installed the package mysql and mysql-s

MySQL

Hi ALL [EMAIL PROTECTED] mysql]# mysql -u root -h saabworld.com -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 20 to server version: 3.23.54 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use mysql; Can't read dir o

Access denied

Hi ALL I am faced with a issue of creating database , The issue is I am able to enter to the MySQL Server with the password, but when i try to create database I get Access Denied Below are the details [EMAIL PROTECTED] root]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Comma

Re: Access denied

t help you out. Kaushal Shriyan wrote: > Hi ALL > > I am faced with a issue of creating database , The issue is I am able > to enter to the MySQL Server with the password, but when i try to > create database I get Access Denied > > Below are the details > > [EMAIL P

How can i decrypt password

Hi I have a situation here how can i decrypt the mysql database userrs password Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Incremental Backup

Hi ALL I would like to know following 2 things. 1) if i would like to take mysql incremental backup weekly cp /var/lib/mysql/ /backup/mysqlbak/ how can i do it by above command as i would like to run cron weekly for take mysql backup. i would like to take backup using cp command only as we ha

Re: Incremental Backup

On 7/18/06, Kaushal Shriyan <[EMAIL PROTECTED]> wrote: On 7/18/06, Tim Lucia <[EMAIL PROTECTED]> wrote: > > > > -Original Message- > > From: Chris [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, July 18, 2006 2:43 AM > > To: Dan Trainor >

Incremental Backup

Hi ALL Can we have incremental backup of MySQL Database and if its there How do we do it Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Cluster

Hi ALL I want to implement MySQL Cluster, are there any step by step guide to implement it Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Cluster

On 7/25/06, Kaushal Shriyan <[EMAIL PROTECTED]> wrote: Hi ALL I want to implement MySQL Cluster, are there any step by step guide to implement it Thanks and Regards Kaushal Hi Is cluster suite is available only in version of MySQL 5 and above. Regards Kaushal -- MySQL General M

Re: MySQL Cluster

On 7/25/06, Kaushal Shriyan <[EMAIL PROTECTED]> wrote: On 7/25/06, Kaushal Shriyan <[EMAIL PROTECTED]> wrote: > Hi ALL > > I want to implement MySQL Cluster, are there any step by step guide to > implement it > > Thanks and Regards > > Kaushal > Hi Is clu

mysqldump error

Hi ALL I am getting the below error [EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt drupal mysqldump: Got error: 1: Can't create/write to file '/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' Thanks and Regards Kaush

Fatal error

Hi ALL I have taken backup of http://mydomain.com/?q=admin/database through drupal 4.6.3 by selecting all tables and it asked me to save as backup.sql. Now when i run [EMAIL PROTECTED] root]# mysql -u kaushal -h bdc31096e.in.office.aol.com -p drupal < /home/kaushal/drupal/backup.sql Enter pass

Re: Fatal error

On 8/3/06, Martin Jespersen <[EMAIL PROTECTED]> wrote: Looks like drupal had an error when doing the backup - mysql is complaining over the fact that your backup.sql file contains a html formated fatal error message. Kaushal Shriyan wrote: > Hi ALL > > I have taken backup of http

Backup SQL

Hi I have a query is i have taken backup from druapl due to timeout error in three backup files a-l.sql m-s.sql t-z.sql Now my understanding is if i do mysql -u kaushal -h example.com -p drupal < /home/kaushal/drupal/new/a-l.sql and then do mysql -u kaushal -h example.com -p drupal < /home/kau

Error code 121

Hi what does error 121 means in mysql. is there a way to find out the description of error code 121. Thanks and Regards Kaushal

Re: Error code 121

On Mon, Apr 13, 2009 at 3:21 PM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > prajap...@debian:~$ perror 121 > OS error code 121: Remote I/O error > > > On Mon, Apr 13, 2009 at 3:16 PM, Kaushal Shriyan > wrote: > >> Hi >> >> what doe

Re: Error code 121

16:10:02 +0530 > > Subject: Re: Error code 121 > > From: prajapat...@gmail.com > > To: kaushalshri...@gmail.com > > CC: mysql@lists.mysql.com > > > > > Give the details what you are doing which gives the below issue. > > > > On Mon, Apr 13, 2009 at 4:03

Re: Sun bought by Oracle

On Mon, Apr 20, 2009 at 11:14 PM, John Meyer wrote: > I'm wondering what the DOJ is going to think of that deal. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=kaushalshri...@gmail.com > > DOJ ? does it

MySQL DB Server - 5.1

Hi, I have enabled ubuntu backports in Ubuntu 8.04 to install mysql-5.1 server, but i dont find it after apt-get update ? Please suggest/guide Thanks, Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=ar

mytop

Hi, I have issue with the mytop application. I have installed mytop-1.6.tar.gz from http://jeremy.zawodny.com/mysql/mytop/ MySQL on localhost (5.0.54) up 60+00:11:46 [21:52:35] Queries: 6.3G qps: 1301 Slow: 0.0 Se/In/Up/De(%):00/00/00/00 qps now: 1730 Slow qps: 0

MySQL Plugin

Hi I am running collectd (http://www.collectd.org/wiki/index.php/Plugin:MySQL) version 4.9.0 on Ubuntu Linux 8.04 (Hardy) Server. Host "localhost" User "nagios"

Re: MySQL Plugin

On Wed, Dec 23, 2009 at 5:38 PM, Kaushal Shriyan wrote: > Hi > > I am running collectd > (http://www.collectd.org/wiki/index.php/Plugin:MySQL) version 4.9.0 on > Ubuntu Linux 8.04

Re: MySQL Plugin

On Sun, Dec 27, 2009 at 10:40 AM, Kaushal Shriyan wrote: > On Wed, Dec 23, 2009 at 5:38 PM, Kaushal Shriyan > wrote: >> Hi >> >> I am running collectd >> (http://www.collectd.org/wiki/index.php/Plugin:MySQL) version 4.9.0 on >&

Re: HT Feature

On Thu, Apr 12, 2012 at 6:38 PM, Johan De Meersman wrote: > - Original Message - > > From: "Kaushal Shriyan" > > > > Any performance bottleneck if HT (Hyper Threading) is enabled in quad > > core processors on CentOS 5.8 running MySQL DB Server ? Ple

mysql script

Hi I have created a script http://pastebin.com/m2c9cc100. is this syntactically correct, just want to make sure before running it Thanks and Regards Kaushal

rsync errors

Hi I am running the command on Gentoo OS /usr/bin/rsync -avO /var/lib/mysql [EMAIL PROTECTED]:/var/lib/ > /tmp/rsync-${TIMESTAMP}.log 2>&1 I am getting the below error in the log file mysql/ rsync: failed to set permissions on "/var/lib/mysql": Operation not permitted (1) rsync: failed to open

mysql replication

Hi Is there a documentation on replication of MySQL Database on Gentoo Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Two instances of MySQL

Hi I am referring to http://dev.mysql.com/doc/refman/5.0/en/multiple-unix-servers.html to create multiple instances of MySQL Database Server. I wanted it for Gentoo Linux is there a HowTo for configuring multiple instance of MySQL Database Server on Gentoo Linux Thanks and Regards Kaushal --

Master - Slave MySQL Database Server

hi, Is there a step by step guide to set up Master - Slave MySQL Database Server Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Master - Slave MySQL Database Server

On Wed, Apr 2, 2008 at 1:09 PM, Kaushal Shriyan <[EMAIL PROTECTED]> wrote: > hi, > > Is there a step by step guide to set up Master - Slave MySQL Database Server > > Thanks and Regards > > Kaushal > Hi, what are the different test cases used for this set u

MySQL Master Slave Replication

hi is this a correct documentation http://howtoforge.com/mysql_master_master_replication for Master Slave Replication Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Master Slave Replication

On Mon, Apr 7, 2008 at 11:58 AM, Kaushal Shriyan <[EMAIL PROTECTED]> wrote: > > On Mon, Apr 7, 2008 at 11:32 AM, Néstor <[EMAIL PROTECTED]> wrote: > > Kaushal, > > > > > > I will try it tomorrow to see if it works. It is similar to something I > &

Re: MySQL Master Slave Replication

ation-in-mysql-centos-rhel-fedora/ > > Thanks, > > Néstor :-) > > > On Sun, Apr 6, 2008 at 11:28 PM, Kaushal Shriyan <[EMAIL PROTECTED] > > > wrote: > > > On Mon, Apr 7, 2008 at 11:32 AM, Néstor <[EMAIL PROTECTED]> wrote: > > > Kaushal, > >

Re: MySQL Master Slave Replication

On Tue, Apr 8, 2008 at 12:14 AM, Kaushal Shriyan <[EMAIL PROTECTED]> wrote: > On Tue, Apr 8, 2008 at 12:02 AM, Néstor <[EMAIL PROTECTED]> wrote: > > > Kaushal, > > > > That worked. I found out that my problem was that my firewall was not > > allowin

MySQL Master and Slave Database Server

Hi, what are the different test cases to test MySQL Master and Slave Replication Database Server. Thanks and Regards Kaushal

MySQL Master and Slave Database Setup

Hi, I need to run a longer running insert and test it in the Master Slave Replication Database Server. And interrupt the Insert query on the Master and check on slave to ensure that the data is in sync. How can i do it, are there benchmark tools to do that. Thanks and Regards Kaushal

mytop

Hi How can i monitor multiple MySQL Database using mytop or are there any other tools to monitor it. Thanks and Regards Kaushal

MySQL Slave

Hi Is there a way to find out when the MySQL Slave has been restarted. Thanks and Regards Kaushal

Re: MySQL Slave

ve is done for you in the MySql dashboard program > suit. > > Ben > > > Kaushal Shriyan wrote: > > > Hi > > > > Is there a way to find out when the MySQL Slave has been restarted. > > > > Thanks and Regards > > > > Kaushal > > &

mysqldump

Hi I get # mysqldump -u root -p dashboard >/home/mysql_backup/dashboard.sql Enter password: mysqldump: Got error: 1033: Incorrect information in file: './dashboard/Actions.frm' when using LOCK TABLES what am i missing Thanks and Regards Kaushal

MySQL (mysql-5.0.54)

Hi I am not able to restart MySQL Database Server (mysql-5.0.54) on Gentoo, I see the below information in the mysqld.err file ## 06 6:30:13 [Warni

MySQL purge logs

Hi I am referring to http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html whats the exact syntax to purge this MySQL Binary Logs -rw-rw 1 mysql 701 1.1G May 5 07:39 host1-bin.000681 -rw-rw 1 mysql 701 1.1G May 5 09:09 host1-bin.000682 -rw-rw 1 mysql 701 1.1G May 5 10:4

Error number 5 means 'Input/output error'.

Hi when i start mysql db server on a particular host. 080718 3:29:09 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this

multiple domain names mapped to a single IP

Hi, Is there any pros and cons to multiple domain names mapped to a single IP work in MySQL client server setup like in case of httpd webserver there is a concept of VHost having multiple domain names mapped to a single IP? For example :- int-mysqldbserver1.example.com :- 192.168.0.11 int-mysqld