how restore mysql database from dump file
#mysql -uroot -p123456 <----- Entering into Mysql prompt
mysql>
mysql> create database my_new_database; <----- Creating database 'my_new_database'
#mysql -uroot -p123456 my_new_database < /root/batabase_dump.sql <------ Restoring database from dump file
No comments:
Post a Comment