Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #1014858

    Dear Kriesi,

    I am creating a website, which is not finished yet – but I wanted to test it on a live server already.
    Unfortunately I have great problems with importing the database in phpmyAdmin.
    The database size is quite big, I prepared it with Migrate DB but when I am trying to import There is an Error from phpAdmin
    “!Incorrect format paragraph”
    I found out that this could be because of too low memory limit etc. and as I was using a little shared hosting I thought this is the problem.
    So I asked the provider and they where willing to increase everything to:

    max_execution_time = 120sek.
    max_input_vars = 2000
    memory_limit = 128 MB
    post_max_size = 64 MB
    upload_max_filesize = 32 MB

    which didn’t help.

    So I tried with another provider and got this error

    SELECT comment
    FROM phpmyadmin.pma__column_info
    WHERE db_name = ‘web263_db2’
    AND table_name = ”
    AND column_name = ‘(db_comment)’
    MySQL meldet: Dokumentation

    #2006 – MySQL server has gone away

    Any ideas how I could manage this?

    Thank you very much,
    TanSmi

    #1014874

    Hey TanSmi,

    You can try to split your big sql dump with a script like: https://www.ozerov.de/bigdump/ to avoid the runtime limits.

    Best regards,
    Peter

    #1014989

    Hi Peter,

    thank you soooo much! I was spending the whole day searching for a solution – this is it!

    Kind regards,
    Tanja

    #1014999

    Hi,

    Great, glad I could help you :)

    Best regards,
    Peter

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.