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.
Magento upgrade failing? Read on for 5 simple yet often overlooked tips to help take the pain out of Your Magento Community Edition upgrade.
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.
Need a virtual server? Linode is Great!
I have been using Linode for the past 5 years now. Why?
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.
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
Depending on Your needs, Joomla can be anything from Excellent to just plain Awful. At its Core Joomla has been designed to be extremely adaptable to fill just about any WebSite Owner’s needs.
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?
Now that You Have decided to install Joomla, lets take a minute for a Quick Pre-install check. Continue reading