I am a new MySQL user on Unix-like systen. Where are my mysql/mariadb database and table files are stored in a UNIX or Linux operating systems? Where does MySQL stored the data in my harddisk? How do I find out the location?
[continue reading…]

How do I specify or run MySQL or MariaDB SQL queries on the UNIX or Linux command line?
[continue reading…]

How do I display a list of all databases under MySQL database server running on a Linux or Unix-like system?
[continue reading…]

Q. How do I start and stop mysql server under Debian / Ubuntu Linux system?

[continue reading…]

Q. I’m moving my server from local data center to another data center. I’ve new server up and running. My site is dynmic and I’d like to transfer MySQL database from old server to new server. How do I make transfer smooth and successful?

A. The best and secure way is to use ssh to transfer database to another server. You need to use following tools:

=> SSH client
=> SSH Server on remote box
=> mysqldump command
=> UNIX pipes

Let us say you would like to Transfer MySQL database called foo to remote box called bar, enter the following command at shell prompt:
$ mysqldump foo | ssh user@remote.box.bar.com mysql foo

You can just copy table called chocolate (from recipe database) to remote database called icecream using same syntax:
$ mysqldump recipe chocolate | ssh user@remote.box.com mysql icecream

How can I import a MySQL dumpfile into my database? I’m using CentOS Linux 5 server. My old hosting provider gave me a data.sql file and I do have access to my Unix / Linux server via ssh. So How do I restore my data using command line over the ssh session?
[continue reading…]