<p>It seems that I was doing one of two things wrong. </p>

<p>The most likely problem is that I didn't quite understand how to transfer the database.  I was doing a new install of Craft and then uploading the database.  The right way to go is NOT to install Craft, but rather to just transfer the files and the database and Craft will then automatically be installed (thanks Lindsey D for teaching me this) .</p>

<p>Another possible factor is that I had changed the Tableprefix, perhaps that was also causing a problem.</p>

<p>Either way, it's works now :).  Thanks one and all for your help.</p>

CC BY-SA 3.0
2015-06-11T22:51:17.093Z
You're welcome Moshe! Feel free to mark this answer as "accepted", since it describes how you solved the problem.
Lindsey D
CC BY-SA 3.0
2015-06-12T00:24:28.673Z
Glad to hear you got it working!
RitterKnight
CC BY-SA 3.0
2015-06-12T05:37:10.807Z
Thanks to both of you for your help.  

I'll accept this answer - as soon as the stackexchange system let's me do so :).
Moshe
CC BY-SA 3.0
2015-06-12T08:39:35.737Z
Well done, glad it works!
Phil Gyford
CC BY-SA 3.0
2015-06-11T21:33:57.683Z
2015-06-11T21:33:57.683Z
Moshe
<p>As an aside from what Phil mentioned, change your <code>craft/config/db.php</code> file to point to the online server. </p>

<p>Also, make sure there is actually an instance of phpmyadmin on your remote server and you're uploading to it.  I've made this mistake before... (For example: if there's too many phpmyadmin windows/tabs floating around and you upload  the database to the testing server instead of the new one... it'll drive you crazy!)</p>

<p>Basically there's 2 parts to every Craft install: the database and the file system. Craft's <code>db.php</code> lets it know where to find the database information so when you move an install from another server (or 2 another database, in this case), you'll need to let Craft in on the new information.</p>

<p>When you transfer an existing Craft installation to a new server, make sure everything in the <code>craft</code> folder also goes along for the ride (especially the <code>plugins</code> and <code>templates</code> folders).</p>

<p>Once you get the basics down, a <a href="http://buildwithcraft.com/docs/multi-environment-configs#adding-multi-environment-configs-to-db-php" rel="nofollow">multi environment config</a> can save you some hassle later on when it's time to move the site. (Hat tip: Lindsey D.)</p>

CC BY-SA 3.0
2015-06-11T15:48:03.773Z
Thanks for the response.  What do you mean by an online server?  I had to configure db.php correctly to install Craft and I didn't change the file since then.  In terms of uploading to phpmyadmin, I'm selecting the proper database, clicking on import and then importing the file.  I assume that's what I'm suppose to do.
Moshe
CC BY-SA 3.0
2015-06-11T16:20:28.767Z
Yes you got that a part down. From your additional information, it looks like your MySQL server credentials are the same but the database is different. In your ``craft/config/db.php`` file on the new install,  you'll want to change that database to point to ``mysitedb2`` instead of ``mysitedb``.
RitterKnight
CC BY-SA 3.0
2015-06-11T17:24:28.653Z
When @RitterKnight says "change the database" connection info, take a look at [**multi-environment configs**](http://buildwithcraft.com/docs/multi-environment-configs#adding-multi-environment-configs-to-db-php)... This allows you to list all of your DB connections at once, so you can keep your `db.php` file the same across environments.
Lindsey D
CC BY-SA 3.0
2015-06-11T17:45:23.757Z
@RitterKnight Do I want to transfer everything in the craft folder BEFORE or AFTER I install the new version of Craft?  Also, please see my further update in my original question up above.  It seems that something is going wrong with the importing of the sql file.
Moshe
CC BY-SA 3.0
2015-06-11T17:48:15.260Z
@LindseyD: Good point, I'll add it to the answer above.
RitterKnight
CC BY-SA 3.0
2015-06-11T17:50:12.050Z
@Moshe: You don't need to do a fresh install if you're moving existing content from one "environment" to another. Just copy the files over to the new location and upload the new database.
RitterKnight
CC BY-SA 3.0
2015-06-11T17:57:35.697Z
BTW: Not sure why the new tables aren't showing up when you import those.   What you might want to try is create a new database  say ``newdb3`` and upload the "finished" database to that one.  Then point your new Craft install to that database instead.
RitterKnight
CC BY-SA 3.0
2015-06-11T18:20:51.037Z
@RitterKnight  I created a new database and uploaded the sql file to that database (the sql file was exported from phpmyadmin from the database I want to copy).  I then edited db.php to point to that new database.  When I went to my craft install I got the Begin button and it reinstalled craft.   And while the database has the right files, I don't see any sign of it on the backend or frontend of my site.
Moshe
CC BY-SA 3.0
2015-06-11T19:29:23.370Z
Anyone able to help -- I am basically stuck.  The database is populated, but nothing changes on my site.  What should I do?
Moshe
CC BY-SA 3.0
2015-06-11T20:30:37.613Z
Let us [continue this discussion in chat](http://chat.stackexchange.com/rooms/24736/discussion-between-moshe-and-ritterknight).
Moshe
CC BY-SA 3.0
2015-06-11T15:43:14.763Z
2015-06-11T17:46:53.300Z
2015-06-11T17:46:53.300Z
RitterKnight
<p>I have set up Craft on my local computer and now wish to move it online.  However, I am having some difficulty doing this.</p>

<p>I have tried this method:  <a href="https://craftcms.stackexchange.com/questions/1079/migrating-a-whole-website-between-craft-instances">Migrating a whole website between Craft instances</a>, but with no success.  By no success I mean that none of my entries, assets, fields or sections are transferred over.</p>

<p>In terms of transferring the database, I tried downloading it via the Settings page and uploading it via phpmyadmin.  Nothing got transferring.  I then tried downloading the database from the original site via phpmyadmin and uploading it to my new site (again via phpmyadmin, after having dumped all the tables).  Again, nothing was transferred.</p>

<p>I also have tried using various plugins to transfer fields, sections and entries with partial success (but with a lot of manual work left to do).  </p>

<p>There must be some way to easily transfer/migrate a site.  </p>

<p>Basically, I have my entries, assets, fields and sections which I want to transfer from one site to another without having to manually set everything up again.  </p>

<p>How can I do that?</p>

<p>Thanks,</p>

<p>Moshe</p>

<p><strong>ADDITIONAL INFORMATION</strong>
I wrote that I am ready to move the site online, but what I did was to first set up ANOTHER Craft site on my local server so that I could make sure that I got the process of transfer done properly and then transfer online.  </p>

<p>It is to that second install of Craft that I am trying to transfer my site to and which I am having no success.  </p>

<p>In other words, on my local (Windows) computer I have localhost/mysite1 and localhost/mysite2.  I have the site set up properly on mysite1 and am trying to transfer it to mysite2.  </p>

<p>Similarly, on phpmyadmin I have mysitedb1 and mysitedb2.  What I have been doing is selecting mysitedb2, clicking on the Import tab and then importing the sql file.  phpmyadmin indicates that the import is successful, but nothing changes on the site itself.</p>

<p><strong>FURTHER UPDATE</strong>
I did a fresh install, made sure that the db.php file is correct and made sure to transfer ALL of the files from the craft folder.  I then downloaded a new database backup file from the settings page of my original install and imported that into the new database for the new install.  </p>

<p>So far so good.  </p>

<p>I received a message which made it seem like everything went smoothly: </p>

<blockquote>
  <p>Import has been successfully finished, 2080 queries executed</p>
</blockquote>

<p>However, when I look at the tables for the database I do not see any of the new data there.  I checked the sql file for the names of some of my entry types and they are in the file, but they do not appear in the entrytypes table (other tables also don't have any of the new data).</p>

<p>Any idea what is going wrong?</p>

CC BY-SA 3.0
2015-06-11T13:09:50.637Z
Is the data actually in the database - can you see it in phpMyAdmin on the server?
Phil Gyford
CC BY-SA 3.0
2015-06-11T14:18:02.547Z
As an aside from what Phil mentioned, make sure you changed your ``craft/config/db.php`` to point to the online server. Make sure there is actually an instance of phpmyadmin on your remote server and you're uploading to it... I've made that mistake before (too many phpmyadmins floating around and you reupload to the test server instead of the new one...)
RitterKnight
CC BY-SA 3.0
2015-06-11T15:25:03.083Z
@RitterKnight Solid response! Consider writing that as an official answer.
Lindsey D
CC BY-SA 3.0
2015-06-11T15:43:43.070Z
TY - will do that.
RitterKnight
CC BY-SA 3.0
2015-06-11T16:00:04.033Z
@PhilGyford -- Looks like it.  I checked a number of tables relating to assets, fields and entries and they all seem to have the same data.
Moshe
CC BY-SA 3.0
2015-06-11T16:00:44.063Z
I added some more info above to my question which may be helpful.  [and btw, thanks everyone for your comments]
Moshe
<database><migration>
Can't Transfer Site
# Can't Transfer Site

(Asked by: username_0 on 2015-06-11)

I have set up Craft on my local computer and now wish to move it online. However, I am having some difficulty doing this.

I have tried this method: [Migrating a whole website between Craft instances](https://craftcms.stackexchange.com/questions/1079/migrating-a-whole-website-between-craft-instances), but with no success. By no success I mean that none of my entries, assets, fields or sections are transferred over.

In terms of transferring the database, I tried downloading it via the Settings page and uploading it via phpmyadmin. Nothing got transferring. I then tried downloading the database from the original site via phpmyadmin and uploading it to my new site (again via phpmyadmin, after having dumped all the tables). Again, nothing was transferred.

I also have tried using various plugins to transfer fields, sections and entries with partial success (but with a lot of manual work left to do).

There must be some way to easily transfer/migrate a site.

Basically, I have my entries, assets, fields and sections which I want to transfer from one site to another without having to manually set everything up again.

How can I do that?

Thanks,

username_0

**ADDITIONAL INFORMATION**
I wrote that I am ready to move the site online, but what I did was to first set up ANOTHER Craft site on my local server so that I could make sure that I got the process of transfer done properly and then transfer online.

It is to that second install of Craft that I am trying to transfer my site to and which I am having no success.

In other words, on my local (Windows) computer I have localhost/mysite1 and localhost/mysite2. I have the site set up properly on mysite1 and am trying to transfer it to mysite2.

Similarly, on phpmyadmin I have mysitedb1 and mysitedb2. What I have been doing is selecting mysitedb2, clicking on the Import tab and then importing the sql file. phpmyadmin indicates that the import is successful, but nothing changes on the site itself.

**FURTHER UPDATE**
I did a fresh install, made sure that the db.php file is correct and made sure to transfer ALL of the files from the craft folder. I then downloaded a new database backup file from the settings page of my original install and imported that into the new database for the new install.

So far so good.

I received a message which made it seem like everything went smoothly:

> Import has been successfully finished, 2080 queries executed

However, when I look at the tables for the database I do not see any of the new data there. I checked the sql file for the names of some of my entry types and they are in the file, but they do not appear in the entrytypes table (other tables also don't have any of the new data).

Any idea what is going wrong?

**Tags:** database, migration

> **Comments:**
> **username_1**: Is the data actually in the database - can you see it in phpMyAdmin on the server?  
> **username_2**: As an aside from what Phil mentioned, make sure you changed your ``craft/config/db.php`` to point to the online server. Make sure there is actually an instance of phpmyadmin on your remote server and you're uploading to it... I've made that mistake before (too many phpmyadmins floating around and you reupload to the test server instead of the new one...)  
> **username_3**: @username_2 Solid response! Consider writing that as an official answer.  
> **username_2**: TY - will do that.  
> **username_0**: @PhilGyford -- Looks like it.  I checked a number of tables relating to assets, fields and entries and they all seem to have the same data.  
> **username_0**: I added some more info above to my question which may be helpful.  [and btw, thanks everyone for your comments]  

---

## 2 answers

### Answer by username_0 on 2015-06-11. Score: 3 | Accepted answer

It seems that I was doing one of two things wrong.

The most likely problem is that I didn't quite understand how to transfer the database. I was doing a new install of Craft and then uploading the database. The right way to go is NOT to install Craft, but rather to just transfer the files and the database and Craft will then automatically be installed (thanks username_3 for teaching me this) .

Another possible factor is that I had changed the Tableprefix, perhaps that was also causing a problem.

Either way, it's works now :). Thanks one and all for your help.

> **Comments:**
> **username_3**: You're welcome username_0! Feel free to mark this answer as "accepted", since it describes how you solved the problem.  
> **username_2**: Glad to hear you got it working!  
> **username_0**: Thanks to both of you for your help.    I'll accept this answer - as soon as the stackexchange system let's me do so :).  
> **username_1**: Well done, glad it works!  

---

### Answer by username_2 on 2015-06-11. Score: 2

As an aside from what Phil mentioned, change your `craft/config/db.php` file to point to the online server.

Also, make sure there is actually an instance of phpmyadmin on your remote server and you're uploading to it. I've made this mistake before... (For example: if there's too many phpmyadmin windows/tabs floating around and you upload the database to the testing server instead of the new one... it'll drive you crazy!)

Basically there's 2 parts to every Craft install: the database and the file system. Craft's `db.php` lets it know where to find the database information so when you move an install from another server (or 2 another database, in this case), you'll need to let Craft in on the new information.

When you transfer an existing Craft installation to a new server, make sure everything in the `craft` folder also goes along for the ride (especially the `plugins` and `templates` folders).

Once you get the basics down, a [multi environment config](http://buildwithcraft.com/docs/multi-environment-configs#adding-multi-environment-configs-to-db-php) can save you some hassle later on when it's time to move the site. (Hat tip: username_3.)

> **Comments:**
> **username_0**: Thanks for the response.  What do you mean by an online server?  I had to configure db.php correctly to install Craft and I didn't change the file since then.  In terms of uploading to phpmyadmin, I'm selecting the proper database, clicking on import and then importing the file.  I assume that's what I'm suppose to do.  
> **username_2**: Yes you got that a part down. From your additional information, it looks like your MySQL server credentials are the same but the database is different. In your ``craft/config/db.php`` file on the new install,  you'll want to change that database to point to ``mysitedb2`` instead of ``mysitedb``.  
> **username_3**: When @username_2 says "change the database" connection info, take a look at [**multi-environment configs**](http://buildwithcraft.com/docs/multi-environment-configs#adding-multi-environment-configs-to-db-php)... This allows you to list all of your DB connections at once, so you can keep your `db.php` file the same across environments.  
> **username_0**: @username_2 Do I want to transfer everything in the craft folder BEFORE or AFTER I install the new version of Craft?  Also, please see my further update in my original question up above.  It seems that something is going wrong with the importing of the sql file.  
> **username_2**: @LindseyD: Good point, I'll add it to the answer above.  
> **username_2**: @username_0: You don't need to do a fresh install if you're moving existing content from one "environment" to another. Just copy the files over to the new location and upload the new database.  
> **username_2**: BTW: Not sure why the new tables aren't showing up when you import those.   What you might want to try is create a new database  say ``newdb3`` and upload the "finished" database to that one.  Then point your new Craft install to that database instead.  
> **username_0**: @username_2  I created a new database and uploaded the sql file to that database (the sql file was exported from phpmyadmin from the database I want to copy).  I then edited db.php to point to that new database.  When I went to my craft install I got the Begin button and it reinstalled craft.   And while the database has the right files, I don't see any sign of it on the backend or frontend of my site.  
> **username_0**: Anyone able to help -- I am basically stuck.  The database is populated, but nothing changes on my site.  What should I do?  
> **username_0**: Let us [continue this discussion in chat](http://chat.stackexchange.com/rooms/24736/discussion-between-moshe-and-ritterknight).  

---

