LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 07-13-2006, 07:11 AM   #1
jenny1668
LQ Newbie
 
Registered: May 2006
Posts: 3

Rep: Reputation: 0
Question how can I download (back up) sql database on the linux server to my local computer?


Hi there

I am trying to download (backup ) sql database from the linux server to my local computer. (webmin) can anyone please give some advice how to do this?

regards
jenny
 
Old 07-13-2006, 07:12 AM   #2
b0uncer
Guru
 
Registered: Aug 2003
Distribution: CentOS, OS X
Posts: 5,131

Rep: Reputation: Disabled
Depends on what SQL you're using...if mysql, then read
Code:
man mysql
and make mysql dump the database intoa dump file, then move the dump to your local computer and read the dump into a database. But that works for mysql, if you're using some other SQL then that might not help..
 
Old 07-14-2006, 04:12 AM   #3
jenny1668
LQ Newbie
 
Registered: May 2006
Posts: 3

Original Poster
Rep: Reputation: 0
thanks for the advice and help, yes it is mysql.....but as I am quite new to linux, would you kindly to give me more precise sytax ??? for how and where to do so... pleaseee?

jenny
 
Old 07-14-2006, 06:17 AM   #4
jmeadows111
LQ Newbie
 
Registered: Oct 2004
Posts: 18

Rep: Reputation: 0
Quote:
Originally Posted by jenny1668
thanks for the advice and help, yes it is mysql.....but as I am quite new to linux, would you kindly to give me more precise sytax ??? for how and where to do so... pleaseee?

jenny
mysqldump -u username -ppassword database_name > backup.dmp
 
Old 07-15-2006, 12:34 AM   #5
novice06
Member
 
Registered: Mar 2006
Location: Singapore
Distribution: RHEL, CentOS
Posts: 132

Rep: Reputation: 23
hey,

if you are newbie, i recommend to use Navicat(Mysql).
www.navicat.com
1. connect to your sever.
2. Under Connection -> choose ur connection -> your db -> right click -> Dump SQL file

very powerful tool. Webmin also great. But webmin need to install on Server side.
You need more knowledge to install.

Try it good luck
novice06
 
Old 07-15-2006, 01:50 AM   #6
leandean
Member
 
Registered: Oct 2005
Location: Burley, WA
Distribution: Sabayon
Posts: 276

Rep: Reputation: Disabled
Yep, that graphical stuff is nice if you don't value security. I'm not saying it's inherently insecure ( maybe i am, 'sigh'), but you know what they say: 'The more moving parts, the greater the chance of something going wrong.'
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Linux, SQL Server drive database market: report LXer Syndicated Linux News 0 05-25-2006 03:21 AM
Restoring *.sql database from Linux Fedora's shell marciano Linux - Newbie 1 10-19-2005 06:05 PM
php trying to connect to local sql, error no such database feetyouwell Programming 11 02-08-2005 12:25 PM
Is there a database manager for linux that is compatable with M$ Access and SQL? enigma Z Linux - Software 2 08-27-2004 08:50 PM
How to create a SQL Database in Linux? Phonics3k Programming 4 08-16-2003 03:31 AM


All times are GMT -5. The time now is 01:08 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration