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?
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)
Re: phpMyAdmin v4.6.6 export instructions?
I usually use a couple more of the non-default settings:
- Select your database, click "Export".
- Choose Export Method: Custom
- In the Output section, under "Save output to a file" choose Compression: gzipped
- Under Object creation options, check the "DROP TABLE ..." selection; that way you can re-import into an existing database with the exported contents.
- Click "Go"
- 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.
Re: phpMyAdmin v4.6.6 export instructions?