MySQL database dump / upload

Another very useful thing I need all the time to backup / upload a database:

To dumb and save as a file:
mysqldump -h hostname -u user –password=password databasename > filename

To restore the database in the MySQL server:
mysql -h hostname -u user –password=password databasename < filename

where filename is for example 2010.sql

Blog

Sep13

Leave a Reply




*