Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Senior Coder doubledee's Avatar
    Join Date
    Mar 2011
    Location
    Arizona
    Posts
    1,127
    Thanks
    27
    Thanked 0 Times in 0 Posts

    Importing DB is locking up phpMyAdmin

    About once a week - for the last two years - I have been using phpMyAdmin to "export" my current "doubledee" database as a means of backing it up.

    And so I have a folder full of files like this...
    Code:
    doubledee_backup_2013-12-08.sql

    Well, today I was trying to finally set up MAMP on my new MacBook Pro, and when I went to "import" my backup - via phpMyAdmin - things were hanging up and finally crashed.


    So now I created a test database (i.e. "doubledee_2"), and tried to "import" things into this local database. (My thinking is that this is the same version of MAMP, so there shouldn't be any issues.)


    Well, when I tried the "import", in the bottom of my browser window I see...

    Waiting on localhost...

    And after waiting for quite some time, I got this error...

    Code:
    Fatal error: Maximum execution time of 300 seconds exceeded in /Applications/MAMP/bin/phpMyAdmin/libraries/import/sql.php on line 121
    Call Stack
    #	Time	Memory	Function	Location
    1	0.0021	160428	{main}( )	../import.php:0
    2	0.0675	3199096	require( '/Applications/MAMP/bin/phpMyAdmin/libraries/import/sql.php' )	../import.php:358
    3	333.5607	4072804	stripos ( )	../sql.php:121

    I don't understand what the problem is?!


    My database is only 31 tables and the .sql file is only 1.4 MB - which to me is TINY!!

    I would expect this entire process to happen in the "blink of an eye"?!

    So currently I have no way to restore my current database, and I have no way to get it off this old MacBook and onto my new MacBook Pro...

    Help!!!

    Sincerely,


    Debbie
    Last edited by doubledee; 12-09-2013 at 02:22 AM.

  • #2
    New to the CF scene
    Join Date
    Dec 2013
    Posts
    7
    Thanks
    2
    Thanked 0 Times in 0 Posts
    back up through shell > mysqldump -u user -p database_name > database.sql < enter your passwd


  •  

    Posting Permissions

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