• Skip to main content

Uly.me

cloud engineer

  • Home
  • About
  • Archives

MySQL Restore

April 26, 2020

Here’s how to restore a MySQL database from mysqldump.

mysql -u user -p
mysql> drop database databasename;
mysql> quit;
Bye
mysql -u user -p databasename < filename.sql

mysql -u user -p mysql> drop database databasename; mysql> quit; Bye mysql -u user -p databasename < filename.sql

Drop database first, then import the SQL file.

Filed Under: Linux Tagged With: import, mysql, restore, sql

Search This Website

Subscribe Via Email

  • Home
  • About
  • Archives

Copyright © 2023