Results 1 to 10 of 10
Thread: Backing Up Database Problem
-
07-11-2002, 06:21 PM #1Junior 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
-
07-11-2002, 06:40 PM #2Web 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...
-
07-11-2002, 07:23 PM #3Linux Problems Solved.
- Join Date
- Dec 2001
- Location
- Los Angeles, CA
- Posts
- 1,337
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.
Ronny Fang
Linux Problems Solved. | Built for the Hosting Industry
Server Management. Node Management. Helpdesk Management.
( AcuNett, Est. 15 Years, RateLobby 5 Stars )
-
07-12-2002, 05:48 AM #4Web Hosting Master
- Join Date
- Feb 2002
- Posts
- 2,120
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).
-
07-12-2002, 10:57 AM #5Junior 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
-
07-12-2002, 11:44 AM #6Web Hosting Master
- Join Date
- Feb 2002
- Posts
- 2,120
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
-
07-12-2002, 11:52 AM #7Junior 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
-
07-12-2002, 12:20 PM #8Web Hosting Master
- Join Date
- Feb 2002
- Posts
- 2,120
Is mysql port open and can you connect to it from the remote location?
-
07-12-2002, 12:38 PM #9Web Hosting Master
- Join Date
- Apr 2002
- Posts
- 1,789
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.
-
07-12-2002, 02:43 PM #10Junior Guru Wannabe
- Join Date
- Mar 2002
- Posts
- 97
Originally posted by apollo
Is mysql port open and can you connect to it from the remote location?
Sparek, he is on a shared plan, he has no access to /tmp