Database larger than phpMyAdmin allows for import

  • Resolved searchen

    (@searchen)


    17 years, 4 months ago

    I am changing host. Have backed up my Database which is now 3MB zipped.

    phpMyAdmin says maximum file size is 2MB for upload.

    What can I do?

Viewing 3 replies - 1 through 3 (of 3 total)
  • ulfben

    (@ulfben)

    17 years, 4 months ago

    If you aren’t already: use the WordPress Database Backup-plugin and select ‘Exclude post revisions’

    Compress the dump using bzip2 if your phpMyAdmin supports that format, it’s more efficient than zip.

    If that doesn’t help you could (from phpMyAdmin) dump the database without content, and then each table by itself. Importing should be relatively straightforward.

    desiupdate

    (@desiupdate)

    17 years, 4 months ago

    If you have access to php.ini file look for “max_upload 2mb” in php.ini and change it to 4mb.

    Thread Starter searchen

    (@searchen)

    17 years, 4 months ago

    Great… thank you all for the suggestions!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database larger than phpMyAdmin allows for import’ is closed to new replies.