How To Export and import a mysql database via the command line
There are a few different ways to do it (all easy)
mysqldump -h host -u user -p database > dump_file
Second you need to import the sql and data to the database using mysql as follows from a prompt:
mysql -h host -u user -p database < dump_file
Or using phpMyAdmin if it is installed,
Leave a Reply
You must be logged in to post a comment.