Results 1 to 14 of 14
Thread: Phpmyadmin Won't Dump File!
-
08-20-2002, 02:31 PM #1WHT Addict
- Join Date
- May 2002
- Posts
- 110
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-
-
08-20-2002, 02:33 PM #2Web Hosting Master
- Join Date
- May 2001
- Location
- Dayton, Ohio
- Posts
- 4,977
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...
-
08-20-2002, 02:34 PM #3WHT Addict
- Join Date
- May 2002
- Posts
- 110
Oh... I see :-) how do I go about doing that because I do have shell access.
-
08-20-2002, 02:35 PM #4Web Hosting Master
- Join Date
- Jun 2001
- Location
- Earth
- Posts
- 1,259
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
-
08-20-2002, 02:37 PM #5Web Hosting Master
- Join Date
- May 2001
- Location
- Dayton, Ohio
- Posts
- 4,977
And if you want to dump a database to file:
mysqldump -uUser -p database > /path/to/file.sql
-
08-20-2002, 03:00 PM #6Web Hosting Master
- Join Date
- May 2002
- Location
- UK
- Posts
- 1,622
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.
Chief brew-maker at several hosting brands since 2002.
≡ FLXI | UK based, cPanel/WHM reseller hosting
≡ Pay-as-you-go billing, why pay for what you don't use?
-
08-20-2002, 03:14 PM #7Web 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
-
08-20-2002, 04:25 PM #8Web Hosting Master
- Join Date
- Oct 2001
- Posts
- 1,319
Ill give you a perl script to run from the command line to do that if you want
Avi B
-
08-20-2002, 08:23 PM #9WHT 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-
-
08-20-2002, 09:24 PM #10Web Hosting Master
- Join Date
- Oct 2001
- Posts
- 1,319
Watchin TV Ill send it off soon - hope you have DBI installed (most likely do)
Avi B
-
08-22-2002, 10:20 PM #11Web Hosting Master
- Join Date
- Aug 2002
- Location
- Baltimore, Maryland
- Posts
- 580
damn, no ssh access.. that sux...
-
08-22-2002, 10:29 PM #12Web Hosting Master
- Join Date
- Oct 2001
- Posts
- 1,319
oh, well any web program dumping alot of data will time out as your host to run it for you?
Avi B
-
08-23-2002, 01:21 AM #13Newbie
- 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
-
08-25-2002, 12:12 PM #14Web Hosting Master
- Join Date
- Oct 2001
- Posts
- 1,319
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 promptAvi B