import

From PmaWiki

Contents 1 Import formats 1.1 CSV 1.2 CSV using LOAD DATA 1.3 SQL 2 Import methods 2.1 Form based upload 2.2 Form based SQL Query 2.3 Using upload directory

[edit] Import formats

phpMyAdmin can import from several various commonly used formats.

[edit] CSV

Comma separated values format which is often used by spreadsheets or various other programs for export/import.

[edit] CSV using LOAD DATA

Similar to CSV, only using the internal MySQL parser and not the phpMyAdmin one.

[edit] SQL

SQL can be used to make any manipulation on data, it is also useful for restoring backed up data.

[edit] Import methods

[edit] Form based upload

Can be used with any supported format, also (b|g)zipped files, e.g., mydump.sql.gz .

[edit] Form based SQL Query

Can be used with valid SQL dumps.

[edit] Using upload directory

You can specify an upload directory on your web server where phpMyAdmin is installed, after uploading your file into this directory you can select this file in the import dialog of phpMyAdmin.

see $cfg['UploadDir']