This example uses the dbexport.sql filename for the exported database, but you can name the file whatever you want.ģ.Type your password at the Enter password prompt.Ĥ.The dbexport.sql file now contains all of the data for the dbname database. Mysqldump -routines -u username -p dbname > dbexport.sql Replace username with your username, and dbname with the name of the database that you want to export: If you have physical access to the computer, you can open a DOS or terminal window to access the command line.Ģ.Type the following command, and then press Enter. For example, if the database is on another web hosting account or with another web hosting provider, log in to the account using SSH. To do this, follow these steps:ġ.Access the command line on the computer where the database is stored. You can export a MySQL database from the command line using the mysqldump table/database program. Method #2: Use the mysqldump table program The export process runs.Ħ.Under Format, confirm that SQL is selected.Ĩ.In the Save File dialog box, type the filename and select the directory where you want to save the exported database on your local computer. Select the Save as file checkbox, and then click Go.In the Export section, click Select All.
If you are using an older version of phpMyAdmin that does not have the Quick option, follow these steps instead: The phpMyAdmin administration page appears in a new window.ģ.In the left pane of the phpMyAdmin page, click the database that you want to export.ĥ.Under Export method, confirm that Quick is selected. To do this, follow these steps:Ģ.In the DATABASES section of the cPanel home screen, click phpMyAdmin: You can export a MySQL database using the phpMyAdmin web interface. You can export a MySQL database to a file by using phpMyAdmin or the mysqldump table/database command line program. Importing a third-party MySQL database.Transferring a MySQL database from one web hosting account or provider to another.
You can import and export databases for a variety of scenarios, including:
This article describes how to import MySQL databases and export MySQL databases.