Scripts
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Web Site Management > Scripts
Reload this Page

PHPmyAdmin Update Capabilities

Discuss PHPmyAdmin Update Capabilities in the Scripts forum on Dev Shed.
PHPmyAdmin Update Capabilities Scripts forum discussing topics including building, optimization, and implementation. Discuss which scripting language is best suited to your needs.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old August 27th, 2003, 05:24 PM
bradbrevet bradbrevet is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jul 2003
Posts: 276 bradbrevet User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 6 h 6 m 3 sec
Reputation Power: 6
PHPmyAdmin Update Capabilities
I like to keep the mySQL database on my home computer the same as teh one on my server but I don't know how to export from the server and then update on my home computer without dropping all the tables and then uploading the latest information. Is there any other way to do this so that I don't risk losing my entire database using PHPmyAdmin or any other means?
Reply With Quote
  #2  
Old August 27th, 2003, 05:32 PM
drgroove's Avatar
drgroove drgroove is offline
pushing envelopes, not pencils
Dev Shed God 2nd Plane (6000 - 6499 posts)
  
Join Date: Feb 2002
Posts: 6,225 drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 1 Day 4 h 44 m 44 sec
Reputation Power: 174
PHPMyAdmin has a feature that lets you save your database structure & data in a .sql or .php file.

Look around on the interface, or on the PHPMyAdmin support site for more info.

Once you have the file, PHPMyAdmin also provides a method for uploading it to your MySQL db.
__________________
Give a person code, and they'll hack for a day; Teach them how to code, and they'll hack forever.
Analyze twice; hack once.
The world's first existential ITIL question: If a change is released into production without a ticket to track it,
was it actually released?

About DrGroove: ITIL-Certified IT Process Engineer - Enterprise Application Architect -
Freelance IT Journalist - Devshed Moderator - Funk Bassist Extraordinaire
Reply With Quote
  #3  
Old August 27th, 2003, 05:33 PM
drgroove's Avatar
drgroove drgroove is offline
pushing envelopes, not pencils
Dev Shed God 2nd Plane (6000 - 6499 posts)
  
Join Date: Feb 2002
Posts: 6,225 drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 1 Day 4 h 44 m 44 sec
Reputation Power: 174
Moved to the Scripts forum from PHP
Reply With Quote
  #4  
Old August 27th, 2003, 05:39 PM
bradbrevet bradbrevet is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jul 2003
Posts: 276 bradbrevet User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 6 h 6 m 3 sec
Reputation Power: 6
Yeah, that is what I have been doing but as far as I know, in order to upload it you have to delete the current tables in the database. I don't like doing that, because of the risk of losing all the data if something goes wrong.

The dump is format as an insert .sql that inserts all the tables and then the corresponding data so I don't know if there is anyway to do it differently.

I do know that you have the option to just dump the data, could I use this to update the database?
Reply With Quote
  #5  
Old August 27th, 2003, 05:50 PM
drgroove's Avatar
drgroove drgroove is offline
pushing envelopes, not pencils
Dev Shed God 2nd Plane (6000 - 6499 posts)
  
Join Date: Feb 2002
Posts: 6,225 drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 1 Day 4 h 44 m 44 sec
Reputation Power: 174
Yes, but you would have to DELETE the data currently held by the DB in order to do it.
Reply With Quote
  #6  
Old August 27th, 2003, 05:52 PM
bradbrevet bradbrevet is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jul 2003
Posts: 276 bradbrevet User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 6 h 6 m 3 sec
Reputation Power: 6
Exactly, that is what i DON'T want to do. I only want to add any new records I created and update any that I may have changed.
Reply With Quote
  #7  
Old September 17th, 2006, 03:58 PM
Rahuldeshmukh10 Rahuldeshmukh10 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Sep 2006
Posts: 2 Rahuldeshmukh10 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 18 m 50 sec
Reputation Power: 0
Quote:
Originally Posted by bradbrevet
I like to keep the mySQL database on my home computer the same as teh one on my server but I don't know how to export from the server and then update on my home computer without dropping all the tables and then uploading the latest information. Is there any other way to do this so that I don't risk losing my entire database using PHPmyAdmin or any other means?

The Ldap has the provision of exporting the data base. U get it done from admin link and then go to export to LDIF choose the OS and get data converted in to .LDIF file format. Once u get it in this file u can port that data in the form u want to keep in ur home computer as backup.
Reply With Quote
Reply

Viewing: Dev Shed Forums > Web Site Management > Scripts > PHPmyAdmin Update Capabilities

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway.