How to make Back Up and Restore from backup in MySQL Database.
In this tutorial i will show you easy ways to backup and restore the data in your MySQL database. Back up From the Command Line: Here is the proper syntax to backup in command> $ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql] Here: [uname] Your database username [pass] The password for your database (note there is no space between -p and the password) [dbname] The name of your database [backupfile.sql] The filename for your database backup [--opt] The mysqldump option For example, to backup a database named 'ranger' with the username 'root' and with password 'root' to a file ranger_backup.sql, using command: $ mysqldump -uroot -proot ranger > ranger_backup.sql Above command store your back file in home directory. If you want to backup in specific directory then go to your desired directory and execute the above command. With mysqldump command you can specify certain tables of ...