Posts Tagged ‘MySQL Database’

How to setup mysqldump without password in cronjob

mysql, mysql databaseIf you execute mysqldump manually, mysqldump will prompt you for password. If you setup mysqldump via cronjob, you need to find a solution to disable the password. I’ve setup mysqldump to backup my db via cronjob without password. All you need to do is just to add a file in your home directory and it will disable the mysqldump password prompting.

To setup mysqldump without password in Cronjob, follow the steps below:-

Continue reading How to setup mysqldump without password in cronjob »

How to restore MySQL database from sql dump file?

mysql, mysql database, sql database, sql, database server, server, sql database server, mysql database server
There are 2 ways to restore your MySQL database from sql dump file.

1st way to restore mysql database from sql dump file is using mysql web control panel – phpMyAdmin
- Log into phpMyAdmin.
- Select your preference database on the left database navigation drop down list.

Continue reading How to restore MySQL database from sql dump file? »