| |

How can I BACKUP a MySQL database from the command line?

Performing a MySQL Database Dump From your SSH command prompt type … mysqldump -u {username} -p {password} {databasename} > {databasename.sql} Replace the parameters with the appropriate values {username} – this is your database username {password} – this is the password for your database {databasename} – the name of your database {databasename.sql} – the file to…

| |

How can I RESTORE a MySQL database from the command line?

Importing a MySQLDUMP From your SSH command prompt type … mysqladmin -u {username} -p {password} create {databasename} mysql -u {username} -p {password} < {databasename.sql} Replace the parameters with the appropriate values {username} – this is your database username {password} – this is the password for your database {databasename} – the name of your database {databasename.sql}…