Results 1 to 4 of 4
  1. #1
    Join Date
    May 2008
    Location
    Near the water, somewhere...
    Posts
    126
    Plugin Contributions
    0

    Default phpMyAdmin v4.6.6 export instructions?

    Executive Summary: Where are a set of phpMyAdmin export instructions for phpMyAdmin version 4.6.6?

    This is not a rant. It's a summary of what I've done so far to attempt doing the research needed to properly export my SQL tables from my old host to my new host.

    Going to the FAQ, I find an appropriate help page:


    On that FAQ page, in step 3a, paying attention to the specified settings called out, as well as the bold, italicized text of mine noted below, it says:

    3. On your OLD host, Make a COMPLETE backup of your DATABASE and STORE.

    a. Use either the "Backup MySQL Database" contribution to do the backup of your database, or use phpMyAdmin to export your entire database ... include the "DROP" tables command, and under Data, choose "Complete Inserts" and "Extended Inserts".
    Save the SQL file to your PC for later. Click here for tips on using phpMyAdmin to export database.

    b. Download all your old site's files via FTP (or if you have the option, zip them up on the server and download the zip)

    So, making my list, I'm looking for

    DROP
    Complete Inserts
    Extended Inserts

    Okay. In addition, the hot text for the "Click here..." notice

    "Click here for tips on using phpMyAdmin to export database."

    brings up this page I'll call the 144 page:


    and when I compare the suggested steps for exporting using phpMyAdmin on the 144 page to the steps and the settings specified on the FAQ page that I just came from, the steps and the settings specified are different. Here's some of the 144 page content:

    Using phpMyAdmin v3.4 or higher:

    The ideal settings to do a backup via phpMyAdmin are shown below. Settings not mentioned can be left to their defaults.
    You will be presented with a choice of "Quick Backup" or "Custom", CHOOSE "Custom", and then make the following selections:
    - Output: - Save output to a file, leave all the other settings under Output as defaults, except maybe Compression:
    OPTIONAL: - Compression: "gzipped" (or whatever you prefer... gzip makes smaller files, but zip files are easier to read on Windows computers)
    - Format: - SQL
    - Format-specific options: - You ONLY need to check the "structure and data" option.
    - Object creation options: - check ALL the boxes in this section, except the "Add CREATE DATABASE / USE statement" option.
    - Data dump options: - choose "INSERT" from the pulldown, and check the "both of the above" option. The rest of the defaults are fine.

    First of all, I'm using 4.6.6, a major version above the v3.4 stated. That's obvious. I'm way ahead in time from when the 144 page was constructed.

    I understand that when an FAQ is written, its content gets locked in at the time they're written, and they rarely get updated, so I think this is the case here. The FAQ instructions are older than the 144 page post, so they won't match up. Meanwhile, I'm left with a phpMyAdmin version 4.6.6 staring me in the face and it doesn't have all the same options given in either the FAQ portion of the export instructions, nor the 144 page's version of the export instructions.

    Where are a set of phpMyAdmin export instructions for phpMyAdmin version 4.6.6?

  2. #2
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,571
    Plugin Contributions
    1

    Default Re: phpMyAdmin v4.6.6 export instructions?

    Try these steps in phpMyAdmin.

    Select your database, on the left-hand side.
    Click the 'Export' tab at page top.
    Click the 'Go' button on right-hand side.
    Save file on your computer.

    For future reference, in your 'Save' window, put today's date at the beginning of the file name.
    (ie. 170715 database_name.sql - helps you easily determine when you saved it)

  3. #3
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,402
    Plugin Contributions
    94

    Default Re: phpMyAdmin v4.6.6 export instructions?

    I usually use a couple more of the non-default settings:
    1. Select your database, click "Export".
    2. Choose Export Method: Custom
    3. In the Output section, under "Save output to a file" choose Compression: gzipped
    4. Under Object creation options, check the "DROP TABLE ..." selection; that way you can re-import into an existing database with the exported contents.
    5. Click "Go"
    6. As @Website Rob indicates, I then change the name of the exported file prior to save, adding the date (or comment) about the export to the filename.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,419
    Blog Entries
    7
    Plugin Contributions
    81

    Default Re: phpMyAdmin v4.6.6 export instructions?

    Article updated.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. v155 How to change phpmyadmin export format?
    By su35 in forum General Questions
    Replies: 6
    Last Post: 11 Sep 2016, 05:53 PM
  2. export / import Db using phpmyadmin
    By ttfan in forum General Questions
    Replies: 2
    Last Post: 24 Aug 2010, 01:31 PM
  3. Export/import in phpmyadmin
    By Unicorn in forum General Questions
    Replies: 4
    Last Post: 29 Jul 2010, 12:04 PM
  4. export data base from phpmyadmin
    By p7x1oayve61pnp2 in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 23 Jun 2010, 11:18 AM
  5. Export to excel using PHPMyAdmin?
    By chris parker in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 12 Mar 2008, 09:43 PM

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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR