Magento

I need to move my magento local installation to a live server but I can’t do a clean install on the live server with the exact same database settings as my local server. For instance, my local server database connection users root > root (as username and password). But my live server can only be configured to use something like mydomain_root as the username.

Is there a config file or something where I can update the database username and password ?

If you want to move your installation form directory or domain, you need to follow this setps.

1) Delete the content of the folder /var

2) Change the values of the file /app/etc/local.xml
There you can find your connection string data (database user, host and name).

3) Once you got your database uploaded, you need to make some changes.

- Run this query:

You gonna get something like this:

- Now, change that values for your new url.

If you run the first query, now you gonna get something like this:

That’s all.
Of ocurse, the url’s that I’ve used are just examples.

Good Post Damián

Just to make it a tiny bit easier for everybody in regards of the URL, http://www.tudominio.com.ar/ = http://www.yourdomain.com

Thanks Tomas, your’re right.
I use an own blog post (and I wrote in spanish) (my fault)

I know, i’ve checked your blog a couple of times

Damián Culotta - 01 January 2009 04:04 PM

If you want to move your installation form directory or domain, you need to follow this setps.

1) Delete the content of the folder /var

2) Change the values of the file /app/etc/local.xml
There you can find your connection string data (database user, host and name).

3) Once you got your database uploaded, you need to make some changes.

- Run this query:

SELECT * FROM core_config_data WHERE path = 'web/unsecure/base_url' OR path = 'web/secure/base_url';

You gonna get something like this:

+-----------+---------+----------+-----------------------+--------------------------------------+
| config_id | scope   | scope_id | path                  | value                                |
+-----------+---------+----------+-----------------------+--------------------------------------+
|         2 | default |        0 | web/unsecure/base_url | http://www.tudominio.com.ar/magento/ |
|         3 | default |        0 | web/secure/base_url   | http://www.tudominio.com.ar/magento/ |
+-----------+---------+----------+-----------------------+--------------------------------------+

- Now, change that values for your new url.

UPDATE core_config_data SET value = 'http://www.tudominio.com.ar/' WHERE path LIKE 'web/%/base_url';

If you run the first query, now you gonna get something like this:

+-----------+---------+----------+-----------------------+------------------------------+
| config_id | scope   | scope_id | path                  | value                        |
+-----------+---------+----------+-----------------------+------------------------------+
|         2 | default |        0 | web/unsecure/base_url | http://www.tudominio.com.ar/ |
|         3 | default |        0 | web/secure/base_url   | http://www.tudominio.com.ar/ |
+-----------+---------+----------+-----------------------+------------------------------+

That’s all.
Of ocurse, the url’s that I’ve used are just examples.

great tip.  *Subscribing to this thread*.

Ok, I tried this, and it worked! Thanks. However, when I now open the site, or click on a link, it adds the domain name twice in the URL.

This is what my core config data table entries looks like:

mysql> SELECT * FROM magento_core_config_data WHERE path = ‘web/unsecure/base_url’ OR path = ‘web/secure/base_url’;
+-----------+---------+----------+-----------------------+-----------------------+
| config_id | scope | scope_id | path | value |
+-----------+---------+----------+-----------------------+-----------------------+
| 2 | default | 0 | web/unsecure/base_url | http://192.168.1.181/ |
| 3 | default | 0 | web/secure/base_url | http://192.168.1.181/ |
+-----------+---------+----------+-----------------------+-----------------------+

I’m on a local intranet dev server, so I don’t have a domain and make use of the IP address internally. It worked 100%, until I made a network change, which changed the dev server’s IP address. So I found this post and it worked, but now shows my URL like so:

http://192.168.1.181/192.168.1.181/?SID=b81570020fb6c74830200d95844a9d2f

I’ve also tried using ONLY the ip address (so no slashes and http: and stuff) as the update in the table, but it also gives almost exactly the same result. Any help here would be greatly appreciated. It’s not a huge issue to reinstall (since I have made nearly no changes) but I would like to know how to fix this, if this happens again.

Thanks very much.

I am trying to move my site from the /magento/ folder to the top level, i.e. from http://localhost:8888/magento/ to http://localhost:8888/

After copying the files to the top level and changing the core config information, all i get is a blank page :S

if i look at the site in /magento/ it loads find but all links are pointing to the top level (even the css, javascript etc but they all pull through correctly) but sub pages do not load. can anybody help with this weird issue?

thanks

Hi
for beginners like me:
don’t click on the tab “Query”, click on “SQL’ and paste the query there.
Michael

And what about Magento Connect?. It fails one you have migrated your site.

Anybody has solved the problem?.

Thanks,

Well thanks for the details, I also got url forwarded to old server one solved with this details.

But still giving login/password keeps me there itself not moving me in the admin panel.

I give http://localhost:81/magentofin/index.php/sspadmin

I use WampServer2.0g-1 based php/mysql.

Please help me.

Thanks & Regards,

Nbt

wonderful thread.  thank you so much for this.

Hi

I have done all these steps, but my home page is still blank.

Admin login page is working fine, but after the login, the admin home page is also blank, if i am writting the “/admin” after the ‘admin’ in url its only showking the Logo of Admin home page and nothing else.

please help me to solve this problem.

It’s too bad. It seems v1.3.2.3 changed this setting. We need modify somewhere else.

Hi,thanks for all of those who shared their insights. Very useful indeed…

Regards,
peropi101
Placement financier

Can anyone also comment on taking a production magento site and copying it locally to a Xampp install to test and develop?

I tried exporting my production SQL database and also taking the content of my public_html folder and copying to the htdocs folder on my local Xampp install but had no luck.

I’m sure I’m missing a bunch of steps.