LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 03-18-2008, 11:33 PM   #1
subnet_rx
Member
 
Registered: Oct 2001
Distribution: Ubuntu 9.10
Posts: 148

Rep: Reputation: 15
Large DB restore


I'm trying to restore a fairly large database in MySQL and am having some problems. Either my wireless connection drops or in the last instance, the session stayed logged in, and it gave me a message that i lost connection to the MySQL server(which was local). The restore file is on the server, and the command I'm using is just "mysql < localhost.sql", but after several attempts, I cannot get this to complete. Any advice?
 
Old 03-21-2008, 04:36 AM   #2
hob
Senior Member
 
Registered: Mar 2004
Location: Wales, UK
Distribution: Debian, Ubuntu
Posts: 1,075

Rep: Reputation: 45
Quote:
Originally Posted by subnet_rx View Post
Either my wireless connection drops or in the last instance, the session stayed logged in, and it gave me a message that i lost connection to the MySQL server(which was local). The restore file is on the server, and the command I'm using is just "mysql < localhost.sql", but after several attempts, I cannot get this to complete. Any advice?
If you are using SSH to connect to a remote server for a long process, use "screen" to make a session, and start the job inside the screen session. You can then "detach" from the screen session, without disrupting the process, disconnect and come back later.
 
  


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



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to restore files using the restore command ? SKYNAT Linux - Newbie 2 12-28-2007 10:26 PM
LXer: This week at LWN: Large pages, large blocks, and large problems LXer Syndicated Linux News 0 09-27-2007 11:40 AM
File too large (script is too large to execute) DeuceNegative Linux - General 1 05-09-2007 12:10 AM
Restore chris2pher_28 Linux - Newbie 1 09-04-2005 10:37 PM
Large drive- too much space lost by large block size? tome Linux - General 5 12-14-2001 01:32 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 12:42 PM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration