The fastest, and most reliable way to backup a MySQL database will always be the bulit-in mysqldump utility. This does require shell access to Your database server.
The command is simple.
mysqldump -u “username” -p “database to be backed up” > “backup file name”
What You would actually enter on the command line.
This will open mysql as my user, then ask for my password. As long as my user has the correct password and permissions, MySQL will backup the database named blue into my home directory, in a plain text file called blue.sql.
In the image below I have added “-v” to show exactly what is happening when You run the command.
The Output from “mysqldump -u -p blue > /home/dave/blue.sql”
*****NOTE: This file is a PLAIN TEXT Backup. That means anyone with access to the file will be able to be read anything in the database backup without the added security controls of MySQL. Do NOT leave these plain text backup files anywhere on Your database server. store them securely outside the database server.
If You have CLI access to MYSQL this is the Simplest, and Quickest Method Possible to create a MySQL database.
The whole thing consists of this —-> CREATE DATABASE ‘your_database_name’;
What you actually type out on the command line or “query window”.
CREATE DATABASE blue;
Simple Command for creating a MYSQL database using the command line aka CLI.
There, the database named blue has been created. The output should like like the image below.
Successful Output of “CREATE DATABASE blue;”
Now You can start adding tables to Your database.
Why do You need to Create a WordPress Child Theme ?
- Maintaining a complete theme can be a large job.
- Modifying core WordPress Templates is futile. Every update will overwrite your modifications, forcing You to re-implement all Your changes.
Continue reading →
Below are the Joomla 3.X System Requirements .
If Your system does not meet these minimum requirements, Joomla will either not install correctly, or be just plain buggy. Continue reading →
SDelete is a Vital utility to any Windows. Ironically, only about 1% of Microsoft Windows Users even know about SDelete. Continue reading →
Is Your virtual machine sluggish? Have Your disk images grown in size? Are Disk space errors like the one below popping up?
Continue reading →
Now that You Have decided to install Joomla, lets take a minute for a Quick Pre-install check. Continue reading →
Most People trying to run, The newer Joomla 3.x on an older server will most likely run into the message.
“Your host needs to use PHP 5.3.10 or higher to run this version of Joomla!” Continue reading →
Over the years there have been several issues with Joomla freezing during installation. In my Experience, almost all of the errors that include “freezing”, or “stalling” during installation, Continue reading →