hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Backing Up Database Problem
Reply

Forum Jump

Backing Up Database Problem

Reply Post New Thread In Hosting Security and Technology Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 07-11-2002, 06:21 PM
NetGeek NetGeek is offline
Junior Guru Wannabe
 
Join Date: Mar 2002
Posts: 97

Backing Up Database Problem


Hi

I want to back up a vBulletin MySQL database, but the problem is that I am almost full in term of diskspace so there is no enough space for the the backed up file. I need to back up in order to move over to another host.


Any idea ?


AA



Sponsored Links
  #2  
Old 07-11-2002, 06:40 PM
Lats Lats is offline
Web Hosting Master
 
Join Date: Jan 2002
Location: Melbourne, AU
Posts: 740
If your vB database is the most important thing you want to retain from your soon to be old host, dump everything else you have there.

If you're leaving under good terms though, perhaps your current host may give you some additional space for a short period of time.


Lats...

__________________
Lats...

  #3  
Old 07-11-2002, 07:23 PM
AcuNett AcuNett is offline
Peace of Mind ServerManagement
 
Join Date: Dec 2001
Location: Franklin, TN, USA
Posts: 1,312
Do you have a shell account? If so, you can just send the mysqldump to another server (granted you have a shell account there), without the dump ever being placed on your current server.

__________________
ServerSync, By AcuNett | RAID-6 Remote RSYNC Space
Are you ready for peace of mind?

Sit back. Relax. Leave everything to us.
( AcuNett 24x7 Always-On Server Management Est. 12 Years, BBB A+, RateLobby Reviews )


Sponsored Links
  #4  
Old 07-12-2002, 05:48 AM
apollo apollo is offline
Web Hosting Master
 
Join Date: Feb 2002
Posts: 2,104
check out /tmp dir free space. If it's enough, you can mysqdump it to /tmp dir, gzip it and download locally (you will need shell access for this).

  #5  
Old 07-12-2002, 10:57 AM
NetGeek NetGeek is offline
Junior Guru Wannabe
 
Join Date: Mar 2002
Posts: 97
Hi

Ronny, would you give me the exact syntax ?

Lats, all is in there is the vB database. I thought about the request for addtional soace. BTW, it is not my db or account I am tring to help a friend to move.


AA

  #6  
Old 07-12-2002, 11:44 AM
apollo apollo is offline
Web Hosting Master
 
Join Date: Feb 2002
Posts: 2,104
mysqldump -u USERNAME -pPASSWORD DBNAME > BACKUPFILENAME


USERNAME= your mysql db username
PASSWORD = password
DBNAME = your MYSQL db name
BACKUPFILENAME = backup file

[after, gzip -9 BACKUPFILENAME to compress it]

hope this helps

  #7  
Old 07-12-2002, 11:52 AM
NetGeek NetGeek is offline
Junior Guru Wannabe
 
Join Date: Mar 2002
Posts: 97
Thank you Apollo but this would help if I want to back it up on the same server/account but what I need id that it would dump the file on another server.

It would be either I work of the new account to pull the backup from different location, or I should work out of the old account (where the db is) and dump it some where else. Both Source and Target need to be in completely different locations (hope I explained that very well )


AA

  #8  
Old 07-12-2002, 12:20 PM
apollo apollo is offline
Web Hosting Master
 
Join Date: Feb 2002
Posts: 2,104
Is mysql port open and can you connect to it from the remote location?

  #9  
Old 07-12-2002, 12:38 PM
SPaReK SPaReK is offline
Web Hosting Master
 
Join Date: Apr 2002
Posts: 693
If you have shell access, you can use the tmp directory as apollo suggested:

cd /tmp
mysqldump -u USERNAME -pPASSWORD DBNAME > BACKUPFILENAME
gzip BACKUPFILE
cd ~
ln -s /tmp/BACKUPFILENAME.gz ./


Then you can log in through FTP and download the BACKUPFILENAME.gz file in your home directory.

  #10  
Old 07-12-2002, 02:43 PM
NetGeek NetGeek is offline
Junior Guru Wannabe
 
Join Date: Mar 2002
Posts: 97
Quote:
Originally posted by apollo
Is mysql port open and can you connect to it from the remote location?
I have to confirm that. But lets assume it is. Otherwise I can't imagin how it could be done.

Sparek, he is on a shared plan, he has no access to /tmp

Reply

Related posts from TheWhir.com
Title Type Date Posted


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?