Random things about tech

MySQL database dump / upload

Filed under Uncategorized

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