dreamscape Posted November 23, 2002 Posted November 23, 2002 hello all... I am developing my system on localhost, but after it gets developed and the database is populated, I will be moving it to a webhost. Now for my question: How do I transfer my populated database to the webhost (don't have a mySQL host yet, no sense to pay for one when I am just developing)... Sorry, I am used to working with ACCESS where it is as simple as uploading the database file, but it seems to be much much different with mySQL. The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke
mattice Posted November 23, 2002 Posted November 23, 2002 It's al SQL in the end... so you just export your database (local) to a plain text SQL file (as in text file) and upload that to your hosting site, in the osCommerce backup dir. Then you go to Database Backup and run that SQL file. And if you can get phpMyAdmin installed, that is a web interface to mySQL and IMHO the best of it's kind. HTH Mattice "Politics is the art of preventing people from taking part in affairs which properly concern them"
dreamscape Posted November 23, 2002 Author Posted November 23, 2002 It's al SQL in the end... so you just export your database (local) to a plain text SQL file (as in text file) and upload that to your hosting site, in the osCommerce backup dir. Then you go to Database Backup and run that SQL file. And if you can get phpMyAdmin installed, that is a web interface to mySQL and IMHO the best of it's kind. HTH Mattice I figured it would be as easy as that... only problem is I don't know how to export my database The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke
mattice Posted November 23, 2002 Posted November 23, 2002 Admin -> Tools -> Database backup -> Backup :D "Politics is the art of preventing people from taking part in affairs which properly concern them"
dreamscape Posted November 23, 2002 Author Posted November 23, 2002 ah thanks... I didn't have that... had to create the backup directory to get the option to backup... thanks again! The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.