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 tested
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
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
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
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
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
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
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 PROTECTED]
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
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
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.
--
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 guaranteed
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
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,
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?
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
16 matches
Mail list logo