Server Administration
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers Forums > Other Technologies > Server Administration
Reload this Page

gzip database

Discuss gzip database in the Server Administration forum on Codewalkers.
gzip database Topics in this forum should be about server administration on both *nix and Windows platforms. Discussion can include mail servers, web servers, DNS, shell scripting, etc.

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 Codewalkers Forums Sponsor:
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today!
  #1  
Old December 14th, 2004, 09:47 PM
Anonymous Anonymous is offline
Registered User
Codewalkers God 35th Plane (22000 - 22499 posts)
  
Join Date: Apr 2007
Posts: 22,309 Anonymous User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 24
gzip database
hello:

i am moving servers, can someone please tell me or show me how to use gzip to copy an entire database?

i have looked in the manual and i cant really figure it all out.

thanks
Reply With Quote
  #2  
Old December 15th, 2004, 07:07 AM
rehfeld_dot_us rehfeld_dot_us is offline
Codewalkers Novice (500 - 999 posts)
  
Join Date: Apr 2007
Posts: 825 rehfeld_dot_us User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: gzip database
the manual has plenty of examples. try some of them.

php Code:
Original - php Code 
  1.  
  2.  
  3. $data = 'i am some data';
  4.  
  5. $compressed = gzencode($data);
  6.  
  7. // now write it to a file or do whatever you want w/ it.
  8.  
  9. // to decompress
  10.  
  11. $decompressed = gzdecode($compressed);
  12.  
Reply With Quote
  #3  
Old December 15th, 2004, 08:04 AM
Anonymous Anonymous is offline
Registered User
Codewalkers God 35th Plane (22000 - 22499 posts)
  
Join Date: Apr 2007
Posts: 22,309 Anonymous User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 24
RE: gzip database
hi, i was thinking something alongs the line of mysqldump it to a gzip file. but i cant figure that out
Reply With Quote
  #4  
Old December 16th, 2004, 02:19 AM
rehfeld_dot_us rehfeld_dot_us is offline
Codewalkers Novice (500 - 999 posts)
  
Join Date: Apr 2007
Posts: 825 rehfeld_dot_us User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: gzip database
$data = mysqldumb();
Reply With Quote
  #5  
Old December 16th, 2004, 02:32 AM
bluephoenix's Avatar
bluephoenix bluephoenix is offline
Levelheaded Curmudgeon
Codewalkers Novice (500 - 999 posts)
  
Join Date: Apr 2007
Location: Syracuse, NY
Posts: 507 bluephoenix User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 7 h 13 m 2 sec
Reputation Power: 2
Send a message via AIM to bluephoenix
RE: gzip database
If you had access to the command line :

/mysql-dir/bin/mysqldump -u DBUSERNAME -pDBPASSWORD myDatabase > myDatabase.db

gzip -9 myDatabase.db

-Tim
Reply With Quote
Reply

Viewing: Codewalkers Forums > Other Technologies > Server Administration > gzip database

« 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 6 hosted by Hostway.