Using spatial extensions

[Rainer M. Krug]

Hi

is there an easy way (through e.g. VCL components) to 
use the spatial features which will be offerd by 
MySQL 4.1 from Delphi?

Rainer

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Urgent problem

[Rainer M. Krug]

Hi

I did something stupid: I locked myself out of the 
MySQL server...

My problem: I use MySQLFront to change the allowed 
hosts and did it for all users. They were 'localhost' 
and I set them to 'localhost; EcolMod1' where the 
EcolMod1 is the name of my computer where the MySQL 
server is installed on. After these changes, I 
couldn't log on any more.

Windows 2000, MySQL 4.012.

Any help welcome what I could do to access the data 
again,

Rainer

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Urgent problem

[Rainer M. Krug]

Hi

I did something very stupid: I locked myself out of the 
MySQL server (all accounts, incl administrator)...

My problem: I use MySQLFront to change the allowed 
hosts and did it for all users. They were 'localhost' 
and I set them to 'localhost; EcolMod1' where the 
EcolMod1 is the name of my computer where the MySQL 
server is installed on. After these changes, I 
couldn't log on any more.

Windows 2000, MySQL 4.012.

Any help welcome what I could do to access the data 
again,

Rainer

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication - Slave Backup to Master

[Rainer M. Krug]

Hi

thanks a lot for your prompt reply. The second email 
went out on accident - apologies.

I managed to fix it - I found localhost; EcolMod1 
in user.myd.

Thanks again,

Rainer

On 13 Nov 2003 at 10:41, nm wrote:

 
 Hi there
 
 I have a question regarding replication.
 This is the situation:
 
 Mysql-Max4.0.16
 
 192.168.0.10 master
 192.168.0.11 slave
 
 I would like to use the slave as the backup server
 and use it in case the master goes down for any reason.
 
 I'm looking for a safe method to re-update the master when we take it
 up again. I read that 2-ways replication is dangerous so for peace of
 mind I would avoid it.
 
 I was considering a simple dump of the database on slave,
 when I have to reconnect the master server.
 
 I would:
 
 1. disconnect the slave
 2. create a dump file form salve
 3. put the dump on the master
 4. reconnect the master and slave
 
 Questions are..
 
 a. I use innodb tables. Any problems to nofify?
 b. Are auto_increment values correct/safe after such operations. I
 guess so but I'm not 100% sure c. Do you have comments and suggestions
 regarding 2-ways replications
 
 
 Any suggestion / comment is welcome ;)
 
 Thanks!!
 
 
 
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
 


-- 
Rainer M. Krug, Dipl. Phys. (Germany), MSc 
Conservation 
Biology (UCT)

Department of Conservation Ecology
University of Stellenbosch
Matieland 7602 
South Africa

Tel:   +27 - (0)21 882 8862
Fax:   +27 - (0)21 808 3304
Cell:  +27 - (0)83 9479 042
email: [EMAIL PROTECTED]
   [EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]