fleeced Posted February 11, 2004 Share Posted February 11, 2004 I have set up a new oscommerce shop and wish to use the sql database I have already in my shop. How do I upload this to the new site,where about should I place the database? Link to comment Share on other sites More sharing options...
Christian Lescuyer Posted February 11, 2004 Share Posted February 11, 2004 You certainly have phpMyAdmin at both sites? Export the database from the first site and upload the backup on the new site. Warning: You'll get the same configuration in both shops, as it is stored in the database. If you don't want this, delete the configuration contents from your backup before uploading. Christian Lescuyer Link to comment Share on other sites More sharing options...
fleeced Posted February 12, 2004 Author Share Posted February 12, 2004 yes,i have phpadmin in my control panel on each site.Do i need to use phpadmin? I was hoping just to upload the database in each new site and change the includes/configuration settings. Link to comment Share on other sites More sharing options...
Christian Lescuyer Posted February 12, 2004 Share Posted February 12, 2004 phpMyAdmin is quite easy to use, which is why I recommended it. If you have direct acces to the MySQL server (not that usual), you can try something as: mysqldump --opt old_database | mysql --host new.host.com new_database Other than that, no, you can't upload the database with FTP, you have to load it via the SQL server. Christian Lescuyer Link to comment Share on other sites More sharing options...
jzee123 Posted February 13, 2004 Share Posted February 13, 2004 i'm trying to bring a database from one store into a new store. And i found how to export using PHP Myadmin but i can find where to import using PHP MyAdmin. Once i export the database from 'store A' how do i import it into 'store B' using PHP MyAdmin? Link to comment Share on other sites More sharing options...
jzee123 Posted February 13, 2004 Share Posted February 13, 2004 never mind figured out how to import. I just went under SQL and imported the file in the browse selection box. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.