Windows version Question about the DB location 1

[JustKIDn]

Hi,

I would like to know if it's possible to install the windows version of MySQL like normal but have the DataBase reside in a directory on my Novell Netware 4.11 Server?

If that works. I would like to have the MySQL Tools on two different windows boxes so I could start the DB Service on either one.

Thank you All. tgus

____________________________
Families can be together forever...

 

[QatQat]

Map a drive on a open share on the Novell server from the windoz boxes, let's assume you called it 'Z'. Create a subdir called
z:\mysqldb

On the windoz boxes modify the my.ini file where it says

datadir=c:\mysql\data

to

datadir=z:\mysqldb

This is only useful for backup reasons, if your Novell box is subject to regular backups. In fact you don't need to share the db files in order to work on them from different computers.
I suggest you leave teh files on a windoz box and dump databases on the Novell share periodically

c:\mysql\bin\mysqldump -u root -ppassword DBname > z:\novell_share\db_backup_file.sql


About the second question

If you want to connect and operate on databases stored on a different computer open the prompt and type


c:\mysql\bin\mysql -h ip_address -u root -ppassword

If you instead want 2 different hosts to publish the same database then you have to syncronize the two machines either using replication or creating dump files from the server that has got new records and importing it into the other one.

Remember that only one server at the time can access a database therefore you have to stop the service on one of the two windoz boxes.


Bye


Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[JustKIDn]

It sounds like you're saying yes, I can put the database on the Novell Server. And map a drive to it and include the dir in the mysql.ini file.

You also say that's only if I want to back it up.
Do you mean you don't need to have it in the .ini file so that when you start the MySQL service, it knows where to find the database?

Backups are not my primary concern here. Although that is another benefit. I want it on a server that's always on so it can be accessed from any other PC on the network.

We don't have a dedicated windoze server here. So we would want to start the service for the database from one of the windoze PC's that happen to be on at the time.
As long as I Map the drives the same on the win PC's. (same drive and dir) Will I be able to do this? (Obviously I can only start the service on one PC at a given time.)

Your help is very much appreciated.

Thank you!
tgus

____________________________
Families can be together forever...

 

[QatQat]

Yes you can. However, if you plan on using InnoDB for transactions, make sure that the two machines use the same .ini and .cnf files.

Bye


Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[JustKIDn]

Thanks QatQat,

I've got it working on one PC so far. MySQL is in C:\MySQL. The database is on the server Q:\.

P.S. It helps to have namespace 'Long' on the Netware volume you want it on. (Duh!) I thought I had 'Long' on all my volumes. I guess I missed one.

What is InnoDB for transactions?

Thanks a lot, I think this is going to work great!


tgus

____________________________
Families can be together forever...

 

[QatQat]

InnoDB adds a lot of extra functionality to MySQL, provides row-level locking, referential integrity, automatic recovery and more. It is a storage engine resembling Oracle's one.

I recommend that u get familiar with InnoDB if you are planning to use MySQL extensively

Here is a good reference

http://www.innodb.com/ibman.html

Any future problem or questions we are all here to help.

Bye

Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[JustKIDn]

I'll follow your link and read it.

I feel more questions coming, soon!

I gave you a star for all the help.

Thanks again!
tgus

____________________________
Families can be together forever...

 

[JustKIDn]

QatQat,

Thanks for the help and the link about InnoDB.

I read a lot of it and I liked some of the features so I downloaded MySQL 4.0.12 and installed it using the new InnoDB settings in my.ini file.

It works great.

Thanks again!
tgus

____________________________
Families can be together forever...