How to Import/Export MySQL Databases with SSH

Started by cm27, May 11, 2014, 02:59:28 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

cm27

#1
May 11, 2014, 02:59:28 PM
For those that do not want to use a control panel here you go.



    To export a MySQL database, access your VPS via SSH and run:
Code Select

        # mysqldump -u username -p database_name > dumpfile.sql


    To import a MySQL Database, run:
Code Select

        # mysql -u username -p database_name < dumpfile.sql
Never fall to those that just sit there.. Always look for the way to the top even if you have to code it your self and mistakes and all... quote from BonZO...
Print
Go Up Pages1
User actions