Showing 2 Result(s)

Importing and Exporting of MYSQL Database with Command Line SSH

Importing MYSQL Database Syntax $ mysql -u username -p database_name < path_to_mysql_file_here Importing existing MYSQL database with filename "wordpress.sql" stored at directory "/home/nishant/", Username is "root", terminal will prompt for asking password. $ mysql -u root -p wordpress < /home/nishant/wordpress.sql Exporting MYSQL Database Syntax $ mysqldump -p -u username database_name > path_to_mysql_file_here Exporting MYSQL database …