FlyingMonkey Posted April 9, 2004 Posted April 9, 2004 Can I use our SQL database offline? and if so how? Thanks! :) Most likely your question has been answered, please do a search first.
peterr Posted April 9, 2004 Posted April 9, 2004 Hi, I assume you have the osC database currently hosted on a website with a domain name. Usually, to use an MySQL db offline, you can install MySQL on a Windows box, I have done this , works fine. But no doubt, you don't want to go through the exercise, or exporting and importing, just to use the db offline. Tell us more of what you want to do please. Peter
FlyingMonkey Posted April 9, 2004 Author Posted April 9, 2004 I'd just like to be able to make a copy of my database to use locally for testing purposes. Most likely your question has been answered, please do a search first.
bluepony Posted April 9, 2004 Posted April 9, 2004 If you have access to PHPMyAdmin, then just export your database structure and data to a sql text file. Then on your local machine, import from that sql text file. It will create the tables and populate them with your data. As Peter stated, you'll need to have MySQL installed on your local machine. I'd rather be flying!
Guest Posted April 9, 2004 Posted April 9, 2004 i second bluepony, PHPMyAdmin is definitely the way to go.
peterr Posted April 10, 2004 Posted April 10, 2004 Hi, Yes, I second what Henry and Tom have said, definitely the easiest way to do it. Installing MySQl on a Win box is easy (and free of course), I even have it on a Win95b box. :) If you want to test the db locally, sounds like you would like to run osCommerce locally; this is also possible of course, on a Win box (just install PHP for Win).. As there are lots of contributions with osC (and new releases from time to time), and I'd like to test the contributions (not on a live site), I simply paid for another domain (about USD $10), and now I have an osC 'test' site. But then, I have loads of room to spare, as I'm a web hosting re-seller. :D Peter
Databuilder Posted April 10, 2004 Posted April 10, 2004 In some cases you may not even have to purchase a new domain. I am also a web host, and I simply created a subdomain, testdomain.mydomain.com on an existing domain. If you are using WHM, you can create an account for the subdomain and everything is seperate from your second level domain. Domains are cheap, but I am even cheaper. Jason
peterr Posted April 10, 2004 Posted April 10, 2004 Yes, your solution is cheaper; I use WHM also. Peter
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.