471,050 Members | 1,331 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,050 software developers and data experts.

LOAD DATA

Hi,

I am using Mysql v 4.0.16.

I was doing replication using MYISAM table types. When I set up my
database server on the Slave, I used to LOAD DATA FROM MASTER to get
the first snapshot of my running master. This worked great.

Now we moved to using InnoDB table types to get rollback/commit
features and also to enforce Foreign key checks. I read that current
version of InnoDB does not support LOAD DATA FROM MASTER command.

I would like to be able to setup my slave without taking down the
server. Is there a way to do so without buying the InnoDBHotBackup.

Any input would be appreciated.

Thanks in Advance.
Jul 19 '05 #1
0 1721

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Donald Tyler | last post: by
6 posts views Thread by Shabam | last post: by
6 posts views Thread by JS | last post: by
1 post views Thread by Uthuras | last post: by
1 post views Thread by huyuhui | last post: by
13 posts views Thread by rdudejr | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.