hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : Phpmyadmin Won't Dump File!
Reply

Forum Jump

Phpmyadmin Won't Dump File!

Reply Post New Thread In Programming Discussion Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 08-20-2002, 02:31 PM
dallassmith dallassmith is offline
WHT Addict
 
Join Date: May 2002
Posts: 110
Exclamation

Phpmyadmin Won't Dump File!


Hi, I went into a sql db and tryed to dump the data & structure or w/e and it acts like it is loading and just goes to a blank screen. When I try the same thing on my smaller db it does it fine, but since this one is 120mb is that why it is messing up? If so how do I fix it.

-Aaron-



Sponsored Links
  #2  
Old 08-20-2002, 02:33 PM
The Prohacker The Prohacker is offline
iNET Interactive
 
Join Date: May 2001
Location: Dayton, Ohio
Posts: 4,894
PHP has a timeout limit on scripts... Smaller databases won't timeout before the dump..

But with larger databaes, you need to dump those via shell...

__________________
-Mat

  #3  
Old 08-20-2002, 02:34 PM
dallassmith dallassmith is offline
WHT Addict
 
Join Date: May 2002
Posts: 110
Oh... I see :-) how do I go about doing that because I do have shell access.

Sponsored Links
  #4  
Old 08-20-2002, 02:35 PM
ffeingol ffeingol is offline
Community Guide
 
Join Date: Jun 2001
Location: Earth
Posts: 1,256
Unless you have control of the server (i.e. root) you'll never be able to load a 120m dump with phpmyadmin (and I would not try). You're going to run into two issues.

1: The default max upload size for php is 2 meg. This would need to be increased for your load to work.

2: The default execution time for a php script is 30 seconds. A 120 meg dump won't load in 30 seconds.

You can create a very simple php page to show all the info:

<?php phpinfo(); ?>

I'd suggest uploading the file to the server and loading with command line mysql:

mysqldump -u db-user -p database-name > dump-file

db-user = database user id
database-name = the database you are trying to load
dump-file = the dump file

[edit]sorry it was a dump not load[/edit]
Frank

__________________
Umbra Hosting
cPanel | Softaculous | CloudLinux | R1Soft | Ksplice
Web Hosting, Reseller Hosting, VPS, Dedicated Servers, Colocation
UmbraHosting.com

  #5  
Old 08-20-2002, 02:37 PM
The Prohacker The Prohacker is offline
iNET Interactive
 
Join Date: May 2001
Location: Dayton, Ohio
Posts: 4,894
And if you want to dump a database to file:

mysqldump -uUser -p database > /path/to/file.sql

__________________
-Mat

  #6  
Old 08-20-2002, 03:00 PM
Jim_UK Jim_UK is offline
Web Hosting Master
 
Join Date: May 2002
Location: UK
Posts: 1,616
You can segment the dump in phpMyAdmin - just select a few tables at once (rather than all of them) then put all the outputs into one file to keep them all together.

__________________
Clook Internet
UK based web hosting, reseller accounts and fully managed dedicated and virtual servers! In our 12th year and counting...


  #7  
Old 08-20-2002, 03:14 PM
interactive interactive is offline
Web Hosting Master
 
Join Date: Aug 2002
Location: Chandler, Arizona
Posts: 2,564
if you dont want to use a file you can just dump it with php select it all and copy and paste. ez as that IMHO

__________________
-Robert Norton
www.SophMedia.com

  #8  
Old 08-20-2002, 04:25 PM
MaB MaB is offline
Web Hosting Master
 
Join Date: Oct 2001
Posts: 1,246
Ill give you a perl script to run from the command line to do that if you want

__________________
Avi Brender
Reliable Web Hosting by Elite Hosts, Inc
CPANEL Reseller Hosting - Fantastico - Rvskins - ClientExec


  #9  
Old 08-20-2002, 08:23 PM
dallassmith dallassmith is offline
WHT Addict
 
Join Date: May 2002
Posts: 110
I would love that if you could give it to me send it to sales@silicon-edge.com

-Aaron-

  #10  
Old 08-20-2002, 09:24 PM
MaB MaB is offline
Web Hosting Master
 
Join Date: Oct 2001
Posts: 1,246
Watchin TV Ill send it off soon - hope you have DBI installed (most likely do)

__________________
Avi Brender
Reliable Web Hosting by Elite Hosts, Inc
CPANEL Reseller Hosting - Fantastico - Rvskins - ClientExec


  #11  
Old 08-22-2002, 10:20 PM
dreamrae.com dreamrae.com is offline
Web Hosting Master
 
Join Date: Aug 2002
Location: Baltimore, Maryland
Posts: 580
damn, no ssh access.. that sux...

  #12  
Old 08-22-2002, 10:29 PM
MaB MaB is offline
Web Hosting Master
 
Join Date: Oct 2001
Posts: 1,246
oh, well any web program dumping alot of data will time out as your host to run it for you?

__________________
Avi Brender
Reliable Web Hosting by Elite Hosts, Inc
CPANEL Reseller Hosting - Fantastico - Rvskins - ClientExec


  #13  
Old 08-23-2002, 01:21 AM
cerebus cerebus is offline
Newbie
 
Join Date: Aug 2002
Posts: 8
Iīve noticed some troubles with some PHPMyAdmin versions when it comes to downloading dumps. Try to write them to screen and copy paste into a text editor. If this also fails, itīs simply that you have to much data to do a web dump with the timeout setting you have.

Regards,
Clarence Eldefors
http://cerebustools.com

  #14  
Old 08-25-2002, 12:12 PM
MaB MaB is offline
Web Hosting Master
 
Join Date: Oct 2001
Posts: 1,246
Solution

Perl script:

#!/usr/bin/perl

print "content-type:text/html\n\n";

system("perl /path/to/dumpfile/i/sent/you.pl > out.txt &");

print "DONE";


RUn that script from a browser and it should execute the dump.pl file i sent you as if you were at the command prompt

__________________
Avi Brender
Reliable Web Hosting by Elite Hosts, Inc
CPANEL Reseller Hosting - Fantastico - Rvskins - ClientExec


Reply

Related posts from TheWhir.com
Title Type Date Posted
Dropbox Suffers Temporary Outage Impacting File Sharing and Synchronizing Web Hosting News 2014-03-14 12:11:46
AeroFS Launches Private File Sharing Software Web Hosting News 2013-11-22 17:00:53
Egnyte Launches Program to PRISM-Proof Enterprise Cloud File-sharing Web Hosting News 2013-09-27 13:45:48
Hackers Pack More Sophistication into Simple Scripts to Attack PHP Applications Web Hosting News 2013-09-09 11:52:48
Hacker Leaks Customer Data Belonging to 79 Banks in US, UK, and Canada Web Hosting News 2012-06-19 14:22:18


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?