: How do I replace a MySQL Database? I created a database on the host server using PHPMyAdmin. I exported the database for local development and have since added data and changed the schema

@Fox8124981

There is an alternative way to export and import the database if you have terminal access to the server.

Export the file via terminal
Execute the following command replacing the MySQL username, database name, and the filename you wish to create.

mysqldump -u <username> -p <dbname> > <filename>.sql


Import the file using terminal
After uploading the file to your server, you can browse to the location and execute the following command replacing the MySQL username, database name, and the filename you already have.

mysql -u <username> -p <dbname> < <filename>.sql

Vote Up Vote Down

@Shelley277

Yes you can. You just export your database as sql file and import it via phpmyadmin.

Export:



Import:

Note that if you have a very large sql file your host might not let you upload it via this wizard.

Vote Up Vote Down

@Shelley277

On your local machine you need to backup the database in .sql format. Once you do, access phpMyadmin from your cPanel. Click on the database and import the .sql file.

Vote Up Vote Down