@sherrie - when you export the database, do you leave all the options as they are? I presume you click “select all” and choose SQL. What about the SQL options and compression?
I have trouble importing the saved/exported database.
I have managed to import the database (make a backup from the Magento admin and import from phpMyadmin) - but when I try to connect the copy of my site to the new database during the installation, it does not work. After the screen where it asks me for the database details, instead of proceeding to the next screen, it takes me to my home page, ie www.site.com - which is weird, as it should at least take me to www.site.com/test
It just will not go past that screen and continue the installation!
I have changed the rewritebase to /test/ but that did not help. Any suggestions?
Thanks!
i dont exactly know what happened in your case, but if you just copy all the files and duplicate the db you can simply change the db settings in the etc/local.xml to your backup db (no need to delete local.xml). in case you changed the url the links will still point to your old path though. if you locked yourself out of the admin you can change the path in the db. just execute
SELECT * FROM core_config_data WHERE path like'url';
please note that the url in the query above needs to be enclosed in % signs. somehow the forum messed with me and didnt allow me to put it up there like that..
and change the base_urls (those two fields (secure, unsecure) should be enough, unless you changed some other paths in your orig installation.
Many thanks for your reply. You might be on to something here - but shouldn’t the new installation overwrite the old base URLs with the new ones I specify during the installation?
My problem is that the installation will not continue past the point I mentioned previously - it just goes back to the home page of the non-testing live site, instead of www.site.com/test
i dont exactly know what happened in your case, but if you just copy all the files and duplicate the db you can simply change the db settings in the etc/local.xml to your backup db (no need to delete local.xml). in case you changed the url the links will still point to your old path though. if you locked yourself out of the admin you can change the path in the db. just execute
SELECT * FROM core_config_data WHERE path like'url';
please note that the url in the query above needs to be enclosed in % signs. somehow the forum messed with me and didnt allow me to put it up there like that..
and change the base_urls (those two fields (secure, unsecure) should be enough, unless you changed some other paths in your orig installation.
Hey - many thanks for the suggestion above:
change the base_urls (those two fields (secure, unsecure)
Noone didn’t suggest Cart2Cart as an option. They offer migration of your data from your current Magento store to a fresh installation. Here is more detailed information. From my personal experience I can say that it is much simpler and error-free than using some standard modules.
