469,160 Members | 2,063 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,160 developers. It's quick & easy.

how to run a database off an external harddrive?

xz
i've got mysql 5.0 and I have 50 million records in a text file on an
external USB 2.0 hard drive. I can import the file into a mySQL
database on my laptop - but I don't want the database on my laptop. I
want that database to be physically located on that usb connected hard
drive instead of my laptop. Can anyone tell me how to set up the
database on my laptop, but with a physical location of the data on the
external hard drive? Oh - not that it helps, but I'm using Navicat (my
first day using it).

Thanks!
jason shohet

Aug 17 '06 #1
2 7733
xz
sorry it posted twice :)
I have another aspect to the question. If I just copy the 'data'
directory (MySQL Server 5.0/data) onto the external hard drive, and
then I delete that directory on my laptop.... and then a month from now
I copy that data directory back from the external hard drive onto my
laptop where mySQL is located -- can I start from where I left off.
Is that a good way of restoring my database. My problem is that due to
some constraints, I'm not allowed to leave this building with the
database on my laptop. So I'm thinking - I copy the entire data
directory onto the external hard drive, then copy it back afterwards
and hopefully all my tables / data will be there (?)

thanks again

Aug 17 '06 #2
xz wrote:
sorry it posted twice :)
I have another aspect to the question. If I just copy the 'data'
directory (MySQL Server 5.0/data) onto the external hard drive, and
then I delete that directory on my laptop.... and then a month from now
I copy that data directory back from the external hard drive onto my
laptop where mySQL is located -- can I start from where I left off.
Is that a good way of restoring my database. My problem is that due to
some constraints, I'm not allowed to leave this building with the
database on my laptop. So I'm thinking - I copy the entire data
directory onto the external hard drive, then copy it back afterwards
and hopefully all my tables / data will be there (?)

thanks again
You can copy the data directory that way, however, make sure mysql is
not running when you do it.
Aug 17 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Steve | last post: by
2 posts views Thread by =?Utf-8?B?anVuaW9yLWdlZWtldHRl?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.