Databases

MySQL > Administration > Commands > Manually Starting MySQL

Databases

Once in a while, you may need to start MySQL manually, forcing an override of the normal process.

Here's how you do that:

Read more...

 

MySQL > Administration > Commands > Setting Root Password

Databases

In MySQL you want to make sure you set your root user's password correctly.

Here's how you do that:

Read more...

 

How To Do A Proper MySQL Dump (a backup of a mysql database)

Databases

# HOW-TO DO A PROPER MYSQLDUMP of all the mysql databases on a MySQL 4.x and 5.x server:

This topic can also be called " The Easy Way How-To: Backup a copy of your live databases in MySQL "

For anyone who's ever banged their head against a wall trying to understand how to protect their MySQL databases with a live, active, dynamic copy that will not force you to shut down your MySQL server, this article is for you.

So here we go.

Read more...