Welcome to the JaguarPC Community
JaguarPC
Sales: (888) 338-5261
Support: (888)-551-3050
Page 1 of 2 12 LastLast
Results 1 to 15 of 16

This is a discussion on Importing SQL Files in the Shared & Semi-Dedicated forum
I'm trying to import my database backup through the phpmyadmin setup in the control panel, and the file is too large. If I setup my ...

  1. 11-21-2004, 05:19 PM #1
    Raven
    Raven is offline
    JPC Addict
    Join Date
    May 2003
    Location
    Canada
    Posts
    141

    Importing SQL Files

    I'm trying to import my database backup through the phpmyadmin setup in the control panel, and the file is too large. If I setup my own phpmyadmin location and configure it differently is the server still going to timeout after 300 seconds?
    Memento Mori
    Reply With Quote Reply With Quote
  2. 11-21-2004, 05:32 PM #2
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775
    Install phpMyAdmin in your own web space. End of problem...

    If you run your own install of phpMyAdmin, you can upload the dump to your web space and do it from there - no more timeouts!

    I've gone through this numerous times, on this web board and others. Somebody will come along and tell you how to chunk your dump file[s], and do it in pieces. Then, somebody else will provide you with a script that may or may not work.

    Take my word for it. Do the right thing and install phpMyAdmin. You can/will thank me later...
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
  3. 11-21-2004, 05:37 PM #3
    Raven
    Raven is offline
    JPC Addict
    Join Date
    May 2003
    Location
    Canada
    Posts
    141
    Frankly I'm too lazy to split up the SQL file anyhow! Thanks for the confirmation VinDSL.
    Memento Mori
    Reply With Quote Reply With Quote
  4. 11-28-2004, 05:36 PM #4
    Raven
    Raven is offline
    JPC Addict
    Join Date
    May 2003
    Location
    Canada
    Posts
    141
    I must be missing something... in the cpanel phpmy adming I see (Max: 51,200KB) but in my own install I see (Max: 2,048KB)... what gives?
    Memento Mori
    Reply With Quote Reply With Quote
  5. 11-28-2004, 06:40 PM #5
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775
    Quote Originally Posted by Raven
    I must be missing something... in the cpanel phpmy adming I see (Max: 51,200KB) but in my own install I see (Max: 2,048KB)... what gives?
    Cool!

    I was trying to figure out what you are referring to, and I noticed they have a new version out - phpMyAdmin 2.6.0-pl3. I'm installing it right now. I'm typing this as I'm uploading the files to the server...

    Can you restate your question, just in case I can't find it?
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
  6. 11-28-2004, 06:53 PM #6
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775
    Hrm...

    Nope, can't find it. The only thing I see that's 2048 is the range alloc block size.
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
  7. 11-28-2004, 06:57 PM #7
    jason
    jason is offline
    Community Leader jason's Avatar
    Join Date
    Sep 2001
    Location
    Rochester, NY
    Posts
    6,003
    It might be that your PHP file upload limit is set too low. Try adding this to your site's .htaccess file:

    php_value upload_max_filesize 51200

    --Jason
    Jason Pitoniak
    Interbrite Communications
    www.interbrite.com www.kodiakskorner.com
    Reply With Quote Reply With Quote
  8. 11-28-2004, 07:17 PM #8
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775
    Ah...

    BTW, you probably know this, Raven, but when you run your own install, you can specify a folder for saving your dumps, and one for restoring/importing them. I have a folder called 'save' and another one called 'upload'.

    I save my dumps to '/save', then use WinSCP to download them from the server to my local drive for safekeeping. Dittos for restoring/importing dumps. Just upload them from your local drive to '/upload', using WinSCP or FTP, and restore/import them from the server.
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
  9. 11-29-2004, 11:06 AM #9
    Raven
    Raven is offline
    JPC Addict
    Join Date
    May 2003
    Location
    Canada
    Posts
    141
    Thanks Jason! I was looking for that code high and low. I haven't tried imported the database yet but it looks like the limit is changed so I don't anticipate and further issues.

    That's not a bad suggestion VinDSL. I think I will definitely look into doing that. To set this up what do I have to do? I had a brief look through the config file and I didn't see anything that struck me. Well, one thing: $cfg['Export']['onserver']. But it seems like this is a true/false only.
    Memento Mori
    Reply With Quote Reply With Quote
  10. 11-29-2004, 12:35 PM #10
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775
    Quote Originally Posted by Raven
    That's not a bad suggestion VinDSL. I think I will definitely look into doing that. To set this up what do I have to do? I had a brief look through the config file and I didn't see anything that struck me. Well, one thing: $cfg['Export']['onserver']. But it seems like this is a true/false only.
    I'm short of time, right now...

    Check out this thread: http://jaguarpc.com/forums/showthread.php?t=11246
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
  11. 11-29-2004, 01:14 PM #11
    Raven
    Raven is offline
    JPC Addict
    Join Date
    May 2003
    Location
    Canada
    Posts
    141
    OK it looks like I've got the upload/save directories figured out ok. But I've got an error now. The only thing I modified in my config file was the upload dir, save dir, and temp dir.

    Warning: Cannot modify header information - headers already sent by (output started at /home/jschnike/public_html/phpmyadmin/config.inc.php:829) in /home/jschnike/public_html/phpmyadmin/libraries/ob.lib.php on line 61

    Warning: Cannot modify header information - headers already sent by (output started at /home/jschnike/public_html/phpmyadmin/config.inc.php:829) in /home/jschnike/public_html/phpmyadmin/libraries/header_http.inc.php on line 14

    Warning: Cannot modify header information - headers already sent by (output started at /home/jschnike/public_html/phpmyadmin/config.inc.php:829) in /home/jschnike/public_html/phpmyadmin/libraries/header_http.inc.php on line 15

    Warning: Cannot modify header information - headers already sent by (output started at /home/jschnike/public_html/phpmyadmin/config.inc.php:829) in /home/jschnike/public_html/phpmyadmin/libraries/header_http.inc.php on line 16

    Warning: Cannot modify header information - headers already sent by (output started at /home/jschnike/public_html/phpmyadmin/config.inc.php:829) in /home/jschnike/public_html/phpmyadmin/libraries/header_http.inc.php on line 17

    Warning: Cannot modify header information - headers already sent by (output started at /home/jschnike/public_html/phpmyadmin/config.inc.php:829) in /home/jschnike/public_html/phpmyadmin/libraries/header_http.inc.php on line 20
    Now I closed my phpmyadmin window and trying to access it again shows this.

    Warning: Cannot modify header information - headers already sent by (output started at /home/jschnike/public_html/phpmyadmin/config.inc.php:829) in /home/jschnike/public_html/phpmyadmin/libraries/select_theme.lib.php on line 104

    Warning: Cannot modify header information - headers already sent by (output started at /home/jschnike/public_html/phpmyadmin/config.inc.php:829) in /home/jschnike/public_html/phpmyadmin/index.php on line 55
    Odd... it seems that all of my other php scripts are also having "Cannot modify header information" errors.

    Reuploading the phpmyadmin files seemed to solve their problem.
    Last edited by Raven; 11-29-2004 at 02:25 PM.
    Memento Mori
    Reply With Quote Reply With Quote
  12. 11-30-2004, 03:11 AM #12
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775
    LoL! You are such a problem child!

    Do you ever get anything right on your own?
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
  13. 01-06-2005, 10:03 PM #13
    Mikalee
    Mikalee is offline
    JPC Addict
    Join Date
    Nov 2004
    Posts
    106
    I'm running into the same problem as I'm trying to transfer my site here. I was wondering if there is a maximum limit to the restore file size (assuming it's your own install of phpMyAdmin and you can set your own settings). I.e. Can it ever be TOO big regardless of settings?


    And, just to confirm your suggestion for my situation as well...I have a database that is about 500mb, and I am trying to transfer it here. Is the best solution to install my own version of phpMyAdmin?

    Thanks in advance for any help!

    Mike
    Reply With Quote Reply With Quote
  14. 01-06-2005, 10:38 PM #14
    Ron
    Ron is offline
    Loyal Client
    Join Date
    Aug 2002
    Posts
    7,306
    My best guess is that your best bet is to load it up into MySQL by command line via an interactive shell session. But then again, I'm just a dinosaur, and I've never loaded a 500 MB file into MySQL by either method.

    Wasn't I helpful?
    Reply With Quote Reply With Quote
  15. 01-07-2005, 12:48 AM #15
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775
    Heathen
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
Page 1 of 2 12 LastLast
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules