Uploading sql database to site

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

Uploading sql database to site

Postby zacaj » 23. August 2011 18:24

Ive been developing a mysql based website on my computer using XAMPP, and now Ive moved the code to my server. I can move the database over by deleting the current database on the server, and then importing it using phpmyadmin, but I was hoping to be able to always write posts and edit the site locally, and easily update the server when im happy with the changes, which would also help with backup, etc. But I cant find any way simpler than deleting the tables and reimporting them every time
zacaj
 
Posts: 4
Joined: 23. August 2011 03:17

Re: Uploading sql database to site

Postby Altrea » 23. August 2011 19:02

That deeply depends on the application.
You are the developer, so you know the changes between two versions.
Write an upgrade script which brings the database up to date.
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: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Uploading sql database to site

Postby zacaj » 23. August 2011 19:25

Theres no automated way to do this?
zacaj
 
Posts: 4
Joined: 23. August 2011 03:17

Re: Uploading sql database to site

Postby JonB » 23. August 2011 19:33

Theres no automated way to do this?


You wrote the code as I understand it. So if there is an automated way to do it, then it would be in your code, right???

How is a database engine supposed to know when it suits your purpose to update a remote database?? :shock:

Good Luck
8)



ucf
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Uploading sql database to site

Postby zacaj » 23. August 2011 19:55

I mean like, some program/script that takes the ip+login for the two dbs, and goes through them looking for changes, and edits the second when it finds them.
zacaj
 
Posts: 4
Joined: 23. August 2011 03:17

Re: Uploading sql database to site

Postby JonB » 23. August 2011 21:25

I mean like, some program/script that takes the ip+login for the two dbs, and goes through them looking for changes, and edits the second when it finds them.


Yep that is exactly what is needed - and you are in charge - it has no way to know what databases, tables and columns to iterate. There are likely many fields you don't want updated from server to server (metadata).

(which is exactly what Altrea told you in the first place)

THERE IS such a thing as slaves and mirrors, but they are meant to be unconditional replicants. they are for redundancy/failover by design, not selective updating.'

Google this - "MySQL slaves mirrors"

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Uploading sql database to site

Postby Altrea » 23. August 2011 21:31

Another try for googling is for "mysql sync software".
There are some solutions, but i don't know a market-leading program for that.

I would use MySQL Workbench for this, if i would ever need it.
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: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Uploading sql database to site

Postby zacaj » 23. August 2011 21:57

It can just be a direct copy, there is no differences between the two databases. Ill look into those
zacaj
 
Posts: 4
Joined: 23. August 2011 03:17


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 68 guests