Notes on MySQL

I’m plodding my way through the MySQL section to see if that will help me unravel clearly how to transfer a WordPress site set up in a subdomain to a new URL. This is where I am up to with notes.

What is MySQL?

MySQL is an open source database management software that helps users store, organize, and retrieve data. It is commonly loaded on to a web server and when you sign up for hosting services you need to know how many MySQL databases you have access to. You need a MySQL database if you are going to run a WordPress blog or website as that is how the content of the Content Management System (CMS) is stored. You don’t necessarily need to know the details of that database since when you set up WordPress on your host with the one-click method, the database is automatically set up for you. However, if you want to more your WordPress site to another URL or host then you may need to know something about the database.

It is also possible to install MySQL on your own computer. Here is a tutorial
https://www.digitalocean.com/community/tutorials/a-basic-mysql-tutorial

Video to watch (interesting ad for Rob’s course came up)

What is phpMyAdmin?

phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

Things you need to know

The “backtick” key is to the left of the number 1 on a UK PC keyboard. ” ` ”

IMAG0365

You need to use a backtick in MySQL to enclose “identifiers”: ie field, table and database names (lecture 195). Information on when to use single and double quotes and backticks here: http://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks

You use single quotes around VALUES, and double quotes around the whole query instruction eg

$query = "INSERT INTO `users`(`name`) VALUES ('Ian')";

MySQL Questions and Answers from Forum

1 Where exactly is this database on the server its not on the file manager, so where is it stored? just curious

Rob: The database is stored on its own server, though proxied through the web server so you can log into it using your web server’s hostname (or even your site’s domain name, assuming it’s registered and points to hosting with Eco Web Hosting. You can manage your databases from the MySQL Databases page in your control panel at http://cpanel.ecowebhosting.co.uk.)

You may also like...

Leave a Reply