Re: MySQL database move

Hi Ace, If you cant affort downtime and if you are using innodb try removing auto extend on the current data file and create a datafile in a different partition and put autoextend on the same. If you are using MyISAM , you can move few tables to different disk use symlinks. -- Thanks Alex http:

Re: MySQL database move

Will try with dump and moving logs. Can I just move my datadir=/usr/local/mysql/data to some other location and change it in my.cnf? Will there be any complications to this? Thanks, Rajan On 7/8/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: Hi Ace, Can't you zip or move old bin-logs to a differe

Re: MySQL database move

Hi Ace, Can't you zip or move old bin-logs to a different disk and release some free space on the current drive. regards anandkl On 7/9/07, Ace <[EMAIL PROTECTED]> wrote: Hi, We have crisis. Disk with MySQL database is full. Now we want to move database to another disk. How can we do it?

Re: MySQL database move

backup and restore would be what i would do. using either mysql administrator or mysqldump. On 09/07/2007, at 3:45 PM, Ace wrote: Hi, We have crisis. Disk with MySQL database is full. Now we want to move database to another disk. How can we do it? -- Thanks, Rajan Regards, Hartlei

MySQL database move

Hi, We have crisis. Disk with MySQL database is full. Now we want to move database to another disk. How can we do it? -- Thanks, Rajan

Re: bin-log position.

Hi Alex, we have another replication setup, i just checked that "Read_Master_Log_Pos" and "exec_master_log_pos" has the same value. regards anandkl On 7/9/07, Alex Arul Lurthu <[EMAIL PROTECTED]> wrote: You will be taking a chance if you use Read_Master_Log_Pos: 106683511. It is not guarantee

Re: bin-log position.

You will be taking a chance if you use Read_Master_Log_Pos: 106683511. It is not guaranteed that whatever is read from master is definitely applied. The apply of the read sqls might have stopped somewhere and in that case Read_Master_Log_Pos and exec_master_log_pos might be different. -- Than

Re: bin-log position.

Hi Alex, Thanks a lot, I missed on taking the "exe_master_log position" value. If i start from Read_Master_Log_Pos: 106683511, will it cause any harm. regards anandkl On 7/9/07, Alex Arul Lurthu <[EMAIL PROTECTED]> wrote: Anand, If the dump was taken from the slave then the binlog positions

Re: bin-log position.

Anand, If the dump was taken from the slave then the binlog positions that were dumped out are that of the slave. Now you might do 2 things : 1. Setup a slave of your master To do this use the binlog positions that you obtained using the command show slave status on your slave. The master

Re: bin-log position.

Hi Alex, Thank you for the response, But i took the dump from slave and slave was in sync with master, so should i still be doing the restore from bin-log 3 from position 311. regards anandkl On 7/8/07, Alex Arul Lurthu <[EMAIL PROTECTED]> wrote: On 7/6/07, Ananda Kumar <[EMAIL PROTECTE

Re: mysqldump on slave.

The version is 5.0.40, i will running on slave db and during night time not much of activites. regards anandkl On 7/8/07, Alex Arul Lurthu <[EMAIL PROTECTED]> wrote: You havent mentioned which version of mysql your are on. If on an older version i would recommend the option --opt. Also if you

Recursive queries

I am trying to set up a forum where there are main posts with replies and replies to replies. Rather than using nested queries in my middleware I am thinking there has to be some kind of recursive query where I can output the results in a format like so: MAIN Reply to main reply to rep

Re: MySQL and 'ODBC'@'localhost' error

You are attempting to login as ODBC If your scripts are using ODBC as the USER you will need to CREATE USER ODBC and GRANT necessary privs doc available at http://dev.mysql.com/doc/refman/5.0/en/adding-users.html M-- This email message and any files transmitted with it contain confidential info

MySQL and 'ODBC'@'localhost' error

Hi, I am very new to MySQL. I have downloaded and installed the " mysql-essential-5.0.41-win32.msi" version for Windows XP. After installation and instance configuration, the following thing runs fine: mysql -u root -p Enter password: * -- gets me to the mysql prompt and the following t

Re: off-topic unsubscribe concern

On 7/8/07, Mogens Melander wrote: On Fri, July 6, 2007 17:55, Michael Dykman wrote: I have been on this list for a pretty long time but in the last few months I have started to receive random 'confirm unsubscribe' messages..They always seem to originate from a Roadrunner IP (I have not thor

Re: Full Text Search, Storage Engine Types

a) You setup a special index (full text). b) Full text indexes can only be created on MyISAM table types. c) MyISAM does support transactions, it works by table locking. If you are not specifically using transactions, you don't need to worry about it. "not transaction safe" just means that t

Re: off-topic unsubscribe concern

On Fri, July 6, 2007 17:55, Michael Dykman wrote: > Hi everyone. > > I have been on this list for a pretty long time but in the last few > months I have started to receive random 'confirm unsubscribe' > messages..They always seem to originate from a Roadrunner IP (I > have not thoroughly teste