ukracer Posted December 11, 2002 Posted December 11, 2002 Hi I have been told that DB Tools is the thing I need to endable me to copy one mysql database to another one on another server........ I cant get it to connect and wondered if any of you have done this before either using DB Tools or using something else?? Many thanks in advance.
mattice Posted December 11, 2002 Posted December 11, 2002 Try http://www.phpmyadmin.org in the config.inc.php file set the same values as as in osCommerce configure.php and you're on your way. You could even go as far as using osC backup tool. Download the backup, upload to the new server and 'restore' it. "Politics is the art of preventing people from taking part in affairs which properly concern them"
ukracer Posted December 11, 2002 Author Posted December 11, 2002 Try http://www.phpmyadmin.org in the config.inc.php file set the same values as as in osCommerce configure.php and you're on your way. You could even go as far as using osC backup tool. Download the backup, upload to the new server and 'restore' it. Thanks mattice. You might have spotted that this project has had to be brought forward so the two or 3 months I was going to use for learning about all the tools and functions etc have had to be brought forward.. :) PHPmyadmin is installed on the server I wish to back up but I cant see anything that says back up. I can see a drop empty or print view and lower down a save file but it makes little sense and the docs are even worse :) what about using easypopulate?? I need the quickest easiest and most convenient way of moving the data base. Having said that there is so little in it I could get away with a new install...........it was more to learn how to do it while it did not matter <grin> A new install would make more sense as I assume the snapshot version has changed in the past 6 weeks its just that I cant remember all the changes I have made :) But I need to document them anyway so ........arrgg I have indigestion now! The back up in admin I assume?? might try that as well :)
mattice Posted December 11, 2002 Posted December 11, 2002 in phpmyadmin you do not 'backup' you 'export' the tables / and or / their content in sql. Look for the 'export' function. I've done it a few times using osC stock backup tool and download/upload to the new site. If you back it up to your 'home' computer you can also 'import' that file with phpMyAdmin again. It's all SQL in the end ;) For the changes on your pages use a diff program (differences) One that is popular among the osC users is Beyond Compare (it's not free but it has a trial version) Think it is www.scootersoftware.com or something. It will make the job of merging your code in a new snapshot A LOT easier. HTH Mattice "Politics is the art of preventing people from taking part in affairs which properly concern them"
wasson65 Posted December 11, 2002 Posted December 11, 2002 what about using easypopulate?? I need the quickest easiest and most convenient way of moving the data base. Having said that there is so little in it I could get away with a new install...........it was more to learn how to do it while it did not matter <grin> A new install would make more sense as I assume the snapshot version has changed in the past 6 weeks its just that I cant remember all the changes I have made :) But I need to document them anyway so ........arrgg I have indigestion now! The back up in admin I assume?? might try that as well :) EasyPopulate is for the products and categories only. Anything else like store setup is not part of it (yet?...) 8-) So I'd say you're better off doing the phpmyadmin, or backup thing if nothing else. Tim
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.