Support » Localhost Installs » Exporting MAMP database, Failure to export all tables

  • Hi!

    I am using MAMP. I created a WordPress site on it, and I am now trying to move the database to the live host. I am having some issues exporting because not all of my tables are exporting. There should be 29 tables, but when I import the database… only 15 are showing up.

    These are the steps I am doing:

    1. Navigate to My PHP Admin on MAMP, select my database, select export.
    2. Select all tables
    3. Under Output: I select the compression gzipped.
    4. Format: SQL
    5. Format Specifications: check box for Display comments (includes info such as export timestamp, PHP version, and server version) and select box for Structure and DataOption creation options, selected following options:
    *Add DROP TABLE / VIEW / *PROCEDURE / FUNCTION / EVENT / TRIGGER statement
    *Add CREATE TABLE statement
    *Add CREATE VIEW statement
    *Add CREATE PROCEDURE / FUNCTION / EVENT statement
    *Add CREATE TRIGGER statement
    *CREATE TABLE options:
    *AUTO_INCREMENT
    *Enclose table and column names with backquotes (Protects column and table names formed with special characters or keywords)

    6. Data Creation Options I selected:
    *both of the above
    Example: INSERT INTO tbl_name (col_A,col_B,col_C) VALUES (1,2,3), (4,5,6), (7,8,9)
    Maximum length of created query: 5000
    *Dump binary columns in hexadecimal notation (for example, “abc” becomes 0x616263)
    *Dump TIMESTAMP columns in UTC (enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones)
    7. I then select Go

    Importing.

    1. I navigate to my host
    2. I select the database I want to import the file to.
    3. Select import and navigate to the my file
    4. Import, but only 15 tables are there

    What am I doing wrong? :/

Viewing 3 replies - 1 through 3 (of 3 total)
  • You are trying ‘too hard’ 🙂

    1. Navigate to My PHP Admin on MAMP, select my database, select export.

    2. Quick – display only the minimal options

    3. Go!

    This works for me first time, every time 🙂

    You may not be doing anything wrong. What is the size of the file you are importing? If it is larger than the maximum import file size allowed by phpMyAdmin (actually by PHP), then it is possible you will get a partial import. A partial import can also happen if the import process took longer than the PHP-imposed maximum execution time.

    If you are comfortable using a command-line interface, the best (and by far the fastest) way to export/import MySQL databases is by using the MySQL command-line utilities mysqldump and mysql. There are no file size or execution time limitations when using the command-line utilities.

    Hi saturngirl 3773. Did you ever get a solution to this? I am also seeing in my export file it only contains some of my tables…not all of them.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Exporting MAMP database, Failure to export all tables’ is closed to new replies.