SEARCH

INFORMATION TECHNOLOGY ARTICLES

For this exercise, we will use the mysqldump utility the same as if we were backing up the entire database.

about 10 years ago - by  |  Comments (10)

There are many reasons you would want to restore a database from a backup file… But you should also test this on a test server just to make sure that your database backups are working correctly. Here’s the syntax:

about 10 years ago - by  |  Comments (8)

Backing up your database is a very important system administration task, and should generally be run from a cron job at scheduled intervals. We will use the mysqldump utility included with mysql to dump the contents of the database to a text file that can be easily re-imported.

about 10 years ago - by  |  Comments (3)

For every database, you should set the root or sa passwords to something other than the default, unless you want to get hacked. For mysql, the system administrator user is called root. You will use the mysqladmin utility from a command line to set the new password. Notice that there are two commands to be run.

about 10 years ago - by  |  Comments (12)

By default, MySQL only allows connections from the localhost address. The configuration file is usually found in /etc/mysql/my.cnf

about 10 years ago - by  |  Comments (0)
Page 16 of 16« First...« Prev910111213141516