If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ANSI SQL > SQL Query Question

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-31-04, 01:41
Justin171985 Justin171985 is offline
Registered User
 
Join Date: May 2004
Posts: 1
SQL Query Question

Hello,

I have a large Back Up Database of a Forum that I need to Restore onto another server and the file size is rather large (13.9MB) and I was wondering if there were any programs available to partition this sql file into multiple files of smaller size that I could upload one at a time or something.. cause phpMyAdmin times out everytime I try to upload it.

I would really appreciate your help, I can't figure out how I'm gonna ever get it moved over

Thanks,
Justin.
Reply With Quote
  #2 (permalink)  
Old 06-03-04, 08:36
suneel.kumar suneel.kumar is offline
Registered User
 
Join Date: Jan 2004
Location: Hyderabad, India
Posts: 37
Hi,

If you have to split a file and upload it, then the final user of the file has to merge the file.. There are lot of free file splitter softwares are available in the net. Probably you can download one and split the file. But after uploading all the splitted files, you need to upload the s/w also, so that end user will merge the splitted files using the same s/w.

If this is not your problem, please write more clearly about your problem. I could not understand whether this is anything related to sql..

Suneel
__________________
Regards
Suneel
Reply With Quote
  #3 (permalink)  
Old 06-03-04, 08:48
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
Quote:
Originally Posted by Justin171985
Hello,

I have a large Back Up Database of a Forum that I need to Restore onto another server and the file size is rather large (13.9MB) and I was wondering if there were any programs available to partition this sql file into multiple files of smaller size that I could upload one at a time or something.. cause phpMyAdmin times out everytime I try to upload it.

I would really appreciate your help, I can't figure out how I'm gonna ever get it moved over

Thanks,
Justin.
A 13 Mb file should typically load in seconds, rarely more than a minute even if the MySQL Server is under heavy load. I think that your problem is something other than the amount of data that you are trying to load.

-PatP
Reply With Quote
  #4 (permalink)  
Old 06-03-04, 08:52
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
Quote:
Originally Posted by suneel.kumar
If this is not your problem, please write more clearly about your problem. I could not understand whether this is anything related to sql..
I think that Justin is trying to move the data from one MySQL server to another (for example, changing forum hosts).

If that is the case, and the new host is having problems loading a 13 Mb file, then there are other problems. My first guess would be that the host is having troubles accessing the file (for example, the NFS access isn't behaving very well). If the server is actually hanging trying to load a 13 Mb file, I'd keep right on searching for a new host, that one is already badly overloaded or mis-tuned!

-PatP
Reply With Quote
  #5 (permalink)  
Old 06-04-04, 19:50
AceOmega AceOmega is offline
Registered User
 
Join Date: Apr 2004
Location: Arizona
Posts: 49
???

Which Database system are you using. If you are using a system like Informix or Oracle you may need to dimention your database. It may be smaller than 13M.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Trackbacks are On
Pingbacks are On
Refbacks are On