473,765 Members | 1,968 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 8111
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
1857
by: vishal | last post by:
i am creating a news site. i am adding new news in database and it must be visible to user at top. and then second latest news and so on. i am displaying 15 news on each page and then put a link for next 15 news on page. my site is accessed by millions of people everyday. so for each when he want to see news he click on news link and in my php program query is run in database. so my database access became very slow because if one...
3
2185
by: eddy princen | last post by:
Hello, i'm need some help, i want to run a website on a server with an sql database ( that in itself is no problem, i've done this before) but with a possibility to update the sql database with data stored on a local harddrive in an acess database, can ianyone give me some hints or websites with related info ? thanks in advance
2
1315
by: bryanilton | last post by:
Hi, I really hope one of you gurus can help me out here. I need to create a webform that has two drop-down boxes and allows a user to select a harddrive manufacturer and another for a harddrive capacity and then spit out a price. I don't have access to a database or server side scripting and cannot link to an outside source. (The file will reside on a public folder on the company network).
1
3338
by: Martin_Hurst | last post by:
Is it possible to establish a connection from within a postgres database to another external database on the network, i.e., not a java or scripting connection, BUT by some type of table definition within the postgres database of that external database table source - something similar to a proxy definition. Examples of external database could be MSAccess, Oracle, Sybase, MSQLServer, etc. The idea behind this would to be able to at least...
1
6009
by: Daniel Manes | last post by:
Some facts: 1) I have an Access database (.mdb file) sitting on my harddrive. 2) I have Visual Studio 2005, Sql Server Express, and Sql Server Management Studio Express. 3) I do *not* have Microsoft Access. What I'm trying to do: I simply want to import the Access database into Sql Server Express. In
1
1745
by: steveBelfast | last post by:
Having trouble installing my 180 day Visual Studio 2005 trial disk. The CD that was sent is actually a DVD not a CD. My home PC only has a CD drive. I attempted to install on an external drive using a work PC with a DVD drive and then use the external drive from my home PC. Unfortunately the install process puts files on the hard drive of the work PC as well as on the external drive. So I can not run the software from my home PC using the...
0
1188
by: xz | last post by:
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 -...
3
22304
by: Stephan | last post by:
Hi all, I am new to access and I face the following "issue": I would like to create a database, to which users can upload files (=pdf, doc, xls...). The files shall be stored locally on a server. The database needs to be accessed via Access form (no html, asp,...) as we don't have an internal web server running. I would like to create a form that allows the user to browse his local harddrive, select the file and upload it directly...
12
6252
by: Steve | last post by:
I have a database that raises an error when you try to open it and it doesn't open. Trying to open the database with the OpenDatabase method raises the same error. Trying to import any objects (tables, queies, forms, etc) from the database raises the same error. Trying to link to the tables in the database raises the same error. I am guessing there is an autoexec macro or code in the open event of the opening form that contains the error....
2
4777
by: =?Utf-8?B?anVuaW9yLWdlZWtldHRl?= | last post by:
I have seen similar questions posted here but no result for my situation so here goes. I have a fairly new Maxtor OneTouch III Turbo Terabyte external drive (raid) and a new Dell 690 Precision also raid.....on XP. The maxtor was working fine and I was backing up data to it for a couple of months. Then all of a sudden the computer did not recognize it. I tried device manager, uninstalling & reinstalling driver, etc. I tried other USB...
0
9568
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10161
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10007
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9955
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9833
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7378
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6649
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3924
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2806
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.