moving site/db from personal to web service

Problems with the Windows version of XAMPP, questions, comments, and anything related.

moving site/db from personal to web service

Postby edyoung » 22. July 2010 14:42

I'm moving my php web site from my personal server on my machine to a web service.

I have a db that I created with the phpMyAdmin and connected to web pages through dreamweaver. I can see the db and use the db with dreamweaver but when I search my computer I cannot find the db.

Where is the Database located and will it automatically transfer with the rest of my site? If not how do I move it?
edyoung
 
Posts: 2
Joined: 22. July 2010 14:33

Re: moving site/db from personal to web service

Postby Altrea » 22. July 2010 15:00

Your Datebase is located in your data folder inside mysql folder.
Its not transfered automatically with your Homepage (HTML/PHP)-Files.
You have to backup/Export your Database to bring it up to your browser.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: moving site/db from personal to web service

Postby edyoung » 22. July 2010 15:13

Altrea wrote:You have to backup/Export your Database to bring it up to your browser.


So I will most likely have to change my web page when I get my site moved, so it knows where the db is. Or are databases always kept in the same place on all servers? Also do I backup/Export it useing dreamweaver?

I did find my db...not sure why my computer search did not see it. thanks.
edyoung
 
Posts: 2
Joined: 22. July 2010 14:33

Re: moving site/db from personal to web service

Postby Altrea » 22. July 2010 15:39

edyoung wrote:So I will most likely have to change my web page when I get my site moved, so it knows where the db is. Or are databases always kept in the same place on all servers?

Thats the bad thing with IDEs like Dreamweaver. You have absolutely no idea how you connect to a database if you just drag and drop a database in your GUI...
It is not important where the Database is located on the server. The only important thing is, on which server and which port it is located. On many webhosts the database is on the same server as your webserver service. In this case localhost is the right host-parameter to connect to your database. Some Webhoster deactivate the "localhost" domainname, but your hoster can give you the info if this is the case. If your Database is not on the same server as your Webpages, you have to access your database-server with his IP or Domainname. If this is the case, your hoster will give you the info, too.

edyoung wrote:Also do I backup/Export it useing dreamweaver?

I don't know much about Dreamweaver.

edyoung wrote:I did find my db...not sure why my computer search did not see it. thanks.

No problem :D
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 118 guests